We may earn an affiliate commission when you visit our partners.

Charting Data with Excel

It is often difficult to read and understand complex data by looking at a big table of numbers. Using Excel's rich charting tools, you will learn how to transform data into compelling visuals and uncover the important insights.

Data is an increasingly important part of our organizations, and it's critical that you learn how to effectively communicate and visualize this information. In this course, Charting Data with Excel, you will gain the ability to work with several fundamental components of Excel's charting tools. First, you will learn how to create and change charts. Next, you will discover how to work with multiple data series. Finally, you will explore how to enhance your charts with features like trendlines and secondary axes. When you are finished with this course, you will have the skills and knowledge of Excel charts needed to build a dashboard full of interesting visuals for your data.

Enroll now

Or start your subscription today

And complete this course over a free trial

Here's a deal for you

We found an offer that may be relevant to this course.

Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

Valid for a limited time only

Future-proof your career

Access O'Reilly books, live events, courses, and more. Save with an annual subscription.

Take

15%

off

What's inside

Syllabus

Course Overview

Choosing, Creating, and Changing Chart Types

Enhancing the Column Chart with Data Series

Extracting Insights from the Line Chart

Exploring Specialized Visuals for Categorical Data

Exploring Specialized Visuals for Continuous Data

Continue Learning Excel

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Explores Excel's charting tools, which are standard in industry

Taught by Carlos Gutierrez, who are recognized for writing, training, and consulting in data, analytics, and visualizations

Develops skills and knowledge of Excel charts, which are core skills for analyzing data

Explores a variety of chart types and their appropriate use cases

Examines how to enhance charts with features like trendlines and secondary axes

Save this course

Save Charting Data with Excel to your list so you can find it easily later:

Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Charting Data with Excel with these activities:

Compile a collection of online resources on Excel charting

Show steps

Provides students with a centralized and curated collection of resources that they can refer to throughout the course and beyond, enhancing their learning experience.

Browse courses on Data Visualization Tools

Show steps

Search for high-quality online resources on Excel charting.
Organize the resources into a structured format, such as a document or spreadsheet.
Share the collection with other students or colleagues.

Review 'Excel Charts and Graphs for Dummies'

Show steps

Provides a solid foundation for understanding data visualization using Excel charts and graphs, and is aligned with concepts covered in this course.

View Excel 2019 Bible on Amazon

Show steps

Read Chapters 1-4 of the book to gain a comprehensive understanding of Excel's charting tools.
Complete the practice exercises at the end of each chapter to reinforce your understanding.

Mentor a peer or junior colleague in Excel charting

Show steps

Provides students with an opportunity to reinforce their knowledge by teaching others, while also contributing to the professional development of their peers.

Browse courses on Peer Support

Show steps

Identify a peer or junior colleague who could benefit from your guidance.
Offer your help and schedule a regular time to meet.
Review their work, provide constructive feedback, and guide them through the concepts of Excel charting.

One other activity

Expand to see all activities and additional details

Show all four activities

Create a dashboard with charts visualizing real-world data

Show steps

Challenges students to apply their knowledge of Excel charting to a practical project, solidifying their understanding and developing their analytical skills.

Show steps

Gather real-world data from a reliable source.
Clean and prepare the data for analysis.
Create appropriate charts to visualize the data and identify insights.
Organize the charts into a visually appealing and informative dashboard.

Career center

Learners who complete Charting Data with Excel will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts collect, clean, and analyze data, identifying patterns and trends to help businesses make informed decisions. This course, Charting Data with Excel, provides a solid foundation for aspiring Data Analysts, as it teaches how to transform complex data into compelling visuals, uncovering important insights. The ability to create and enhance charts is essential for Data Analysts, as it allows them to communicate their findings effectively to stakeholders.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts identify and solve business problems by analyzing data and recommending solutions. Excel charting skills are crucial for Business Analysts, as they need to present complex data in a clear and concise manner to stakeholders. This course provides a comprehensive overview of Excel's charting tools, enabling Business Analysts to create visually appealing charts that support their recommendations.

See salaries and explore the career path for Business Analyst

Financial Analyst

Financial Analysts use data to assess the financial health of companies and make investment recommendations. Excel charting is essential for Financial Analysts, as it allows them to visualize financial data, identify trends, and make informed decisions. This course provides a detailed understanding of how to create and enhance charts in Excel, giving Financial Analysts the skills they need to succeed in their role.

See salaries and explore the career path for Financial Analyst

Market Researcher

Market Researchers gather and analyze data to understand market trends and consumer behavior. Excel charting skills are crucial for Market Researchers, as they need to present their findings in a way that is easy to understand and actionable. This course provides a comprehensive overview of Excel's charting tools, enabling Market Researchers to create visually appealing charts that support their research.

See salaries and explore the career path for Market Researcher

Operations Research Analyst

Operations Research Analysts use data to improve the efficiency of business operations. Excel charting skills are essential for Operations Research Analysts, as they need to visualize complex data to identify inefficiencies and develop solutions. This course provides a detailed understanding of how to create and enhance charts in Excel, giving Operations Research Analysts the skills they need to succeed in their role.

See salaries and explore the career path for Operations Research Analyst

Statistician

Statisticians collect, analyze, and interpret data to draw conclusions about populations. Excel charting skills are helpful for Statisticians, as it allows them to visualize data and identify patterns more easily. This course provides a basic understanding of Excel's charting tools, helping Statisticians to develop the skills they need to succeed in their role.

See salaries and explore the career path for Statistician

Actuary

Actuaries use data to assess risk and make financial decisions. Excel charting skills are helpful for Actuaries, as it allows them to visualize data and identify patterns more easily. This course provides a basic understanding of Excel's charting tools, helping Actuaries to develop the skills they need to succeed in their role.

See salaries and explore the career path for Actuary

Data Scientist

Data Scientists use data to build models and make predictions. Excel charting skills are helpful for Data Scientists, as it allows them to visualize data and identify patterns more easily. This course provides a basic understanding of Excel's charting tools, helping Data Scientists to develop the skills they need to succeed in their role.

See salaries and explore the career path for Data Scientist

Web Developer

Web Developers design and develop websites and web applications. Excel charting skills are helpful for Web Developers, as it allows them to visualize data and identify patterns more easily. This course provides a basic understanding of Excel's charting tools, helping Web Developers to develop the skills they need to succeed in their role.

See salaries and explore the career path for Web Developer

Software Engineer

Software Engineers design, develop, and maintain software systems. Excel charting skills are helpful for Software Engineers, as it allows them to visualize data and identify patterns more easily. This course provides a basic understanding of Excel's charting tools, helping Software Engineers to develop the skills they need to succeed in their role.

See salaries and explore the career path for Software Engineer

Database Administrator

Database Administrators manage and maintain databases. Excel charting skills are helpful for Database Administrators, as it allows them to visualize data and identify patterns more easily. This course provides a basic understanding of Excel's charting tools, helping Database Administrators to develop the skills they need to succeed in their role.

See salaries and explore the career path for Database Administrator

Business Intelligence Analyst

Business Intelligence Analysts collect, analyze, and interpret data to help businesses make informed decisions. Excel charting skills are helpful for Business Intelligence Analysts, as it allows them to visualize data and identify patterns more easily. This course provides a basic understanding of Excel's charting tools, helping Business Intelligence Analysts to develop the skills they need to succeed in their role.

See salaries and explore the career path for Business Intelligence Analyst

Customer Service Representative

Customer Service Representatives provide support to customers. Excel charting skills are helpful for Customer Service Representatives, as it allows them to visualize data and identify trends more easily. This course provides a basic understanding of Excel's charting tools, helping Customer Service Representatives to develop the skills they need to succeed in their role.

See salaries and explore the career path for Customer Service Representative

Data Entry Clerk

Data Entry Clerks enter data into computer systems. Excel charting skills are helpful for Data Entry Clerks, as it allows them to visualize data and identify errors more easily. This course provides a basic understanding of Excel's charting tools, helping Data Entry Clerks to develop the skills they need to succeed in their role.

See salaries and explore the career path for Data Entry Clerk

Office Administrator

Office Administrators provide administrative support to businesses. Excel charting skills are helpful for Office Administrators, as it allows them to visualize data and identify patterns more easily. This course provides a basic understanding of Excel's charting tools, helping Office Administrators to develop the skills they need to succeed in their role.

See salaries and explore the career path for Office Administrator

Reading list

We've selected 11 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Charting Data with Excel.

Data Visualisation

Save

Comprehensive guide to data visualization best practices and techniques, covering topics such as visual perception, data exploration, and creating effective visualizations for different audiences.

Charting Data with Excel

Here's a deal for you

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses