Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel - Visualizing data with Excel Charts & Pivot Tables
Rating: 4.5 out of 5(4 ratings)
1,005 students

Excel - Visualizing data with Excel Charts & Pivot Tables

Master Excel Charts and Pivot Tables in 2 Hours
Created byAhmed Oyelowo
Last updated 3/2025
English
English [Auto],

What you'll learn

  • Master the Basics of Excel Charts - Learn how to create, format, and customize various Excel charts, including bar, line, pie, and combination charts.
  • Understand Pivot Tables from Scratch-Gain a solid understanding of what pivot tables are, how they work, & why they are essential for data analysis & reporting
  • Create Interactive Dashboards - Develop dynamic dashboards using pivot tables, slicers, and charts to make data analysis more engaging and actionable.
  • Build Confidence in Using Excel for Business Reporting Develop the skills to confidently apply Excel charts and pivot tables

Course content

3 sections • 35 lectures • 1h 54m total length

  • Introduction & Pre-requisites1:53

    Learn to create and format charts to visualize data in Excel, configure pivot tables for reporting, and build dashboards, using Excel 2013+ on Windows with basic formula skills.

  • Creating Excel Charts with Alt + F1 Keyboard shortcut3:25

    Highlight the desired data in Excel and press Alt+F1 to create a chart, choosing country, sales, or profit; ensure equal ranges and use Fn if needed.

  • Updating data source range for Excel charts4:38

    Select the chart, open chart design, choose select data, and update the range (e.g., b:c to d) to include new records. Alternatively, copy and paste data into the chart.

  • Using data tables as chart source data for automatic data updates2:47

    Store data as a table in Excel with headers, then create a chart that updates automatically as you add rows, using Ctrl+T and Alt+F1.

  • Creating charts from un-summarized dataset4:03

    Learn to create charts by summarizing data into unique categories and measures, then visualize totals like profits by product or sales by country with clean category lists.

  • Creating charts from un-summarized dataset (part 2)3:00

    Prepare data from an un-summarized dataset for visualization by using the sumif function to compute total profit per product, lock ranges with F4, and create a chart with alt F1.

  • Editing Chart Axes3:49

    Turn years into categories and keep sales as values to fix an Excel chart, using select data, edit categories, and correct the chart legend.

  • Changing chart types2:36

    Learn how to switch a sales by month chart from column to line using the change chart type option, via the chart design tab or by right-clicking the chart.

  • Introduction to Chart Elements3:25

    Explore how to format chart elements in Excel, including titles, axes, gridlines, data labels, legend, and an optional data table, using the chart's plus icon to add or remove elements.

  • Introduction to formatting Chart Elements in Excel2:25

    Explore formatting chart elements in Excel by selecting an element and using right-click formatting, with the chart design and formatting tabs guiding data editing, chart types, and axis formatting.

  • Changing chart area fill colors and text colors3:23

    Select chart area to open format panel, adjust fill color with a solid fill and transparency, and use text options to recolor chart title and axis text.

  • Formatting Lines on Excel Charts2:25

    Select the line in a chart, then use format data series to adjust fill, line color, and markers. Enable smooth lines to transform jagged lines into a clean, plain line.

  • Changing Number Display Units and Formatting3:43

    Learn to format Excel chart axes by changing y-axis units, adjusting text options, applying display units to millions, and using a custom format to append an M suffix.

  • Using Combo charts and formatting chart column widths4:08

    Learn to create Excel combo charts that compare actual sales to targets by combining column and line series, and format column widths with legend and series options.

  • Formatting Titles, gridlines and legends2:08

    Add a chart title, edit the text box to 'sales versus target', place the legend, and minimize gridlines using the home tab formatting, including fill and font color.

  • Formatting Data Labels and Pie Charts3:41

    Format pie and donut charts in Excel by adding data labels, legends, and leader lines, and learn to avoid 3D charts while highlighting percentage shares.

Requirements

  • Basic Knowledge of Microsoft Excel - Students should have a foundational understanding of Excel, such as opening files, navigating the interface, and performing basic data entry.
  • Access to Microsoft Excel (2016 or later) - A working version of Excel is essential, preferably Excel 2016 or later, to access the latest charting and pivot table features. Excel 365 is also highly recommended.
  • No Prior Expertise in Charts or Pivot Tables Required - This course is beginner-friendly and will teach all necessary skills from scratch.
  • A Laptop or Windows Desktop Computer The course is designed for Excel on Windows . While some features may work on mobile or web versions, a full-featured desktop application is ideal.
  • Willingness to Learn and Practice - Students should be ready to dedicate time to learn and practice the concepts taught in the course.
  • No Coding or Programming Skills Required - This is a completely code-free course focused on leveraging Excel’s built-in tools.
  • Motivation to Improve Reporting and Data Visualization Skills - A desire to enhance their professional capabilities in data presentation is a plus.

Description

Excel: Visualizing data with Excel Charts & Pivot Tables:


Unlock the Power of Excel to Transform Your Data into Clear, Actionable Insights!

Are you ready to take your Excel skills to the next level and become a data visualization expert? Whether you're a beginner or an intermediate user, this course is your ultimate guide to mastering Excel Charts and Pivot Tables for professional reporting and data analysis.

Why This Course?
In today’s data-driven world, the ability to present information clearly and effectively is a game-changer. This course is designed to teach you exactly that — how to transform raw data into visually compelling charts and interactive reports that drive impactful decisions.

What You’ll Achieve

By the end of this course, you will:

  • Build and customize Excel charts (Bar, Line, Pie, and more)

  • Create and master Pivot Tables to analyze large datasets with ease.

  • Develop professional dashboards with interactive features like slicers and filters.

What Makes This Course Unique?

  • Hands-On Learning – Apply concepts immediately with step-by-step guide demonstrated in the course.

  • Beginner-Friendly – No coding or prior expertise required; everything is explained clearly.

  • Professional Skills – Gain tools to create impressive reports for work, clients, or personal projects.

Course Highlights

  • Lifetime access to content and updates.

  • Easy-to-follow video tutorials and downloadable resources.

Don’t let data overwhelm you — learn how to turn it into your superpower! Enroll today and unlock your potential with Visualization and Reporting with Excel Charts and Pivot Tables.

Start your journey to becoming a data visualization pro — Enroll Now and begin today!

Who this course is for:

  • Business Professionals - Individuals in business roles who need to create visually compelling reports and dashboards to communicate data-driven insights.
  • Financial Analysts - Professionals looking to enhance their skills in presenting financial data through impactful charts and pivot tables.
  • Data Analysts - Analysts aiming to improve their proficiency in Excel for advanced data visualization and reporting tasks.
  • Students and Recent Graduates - Students or recent graduates in business, finance, or data-related fields seeking to build practical skills for their resumes
  • Managers and Team Leads - Supervisors who need to track, analyze, and present team or project performance metrics.
  • Small Business Owners - Entrepreneurs who want to analyze sales, inventory, and performance data efficiently using Excel.
  • HR Professionals - HR managers and recruiters interested in visualizing employee performance, retention, and other HR metrics.
  • Marketing Analysts - Marketing professionals who analyze campaign performance data and need to present clear, actionable insights.
  • Non-Technical Professionals - Individuals with little to no technical background who want to learn how to summarize and visualize data using Excel
  • Freelancers and Consultants - Freelancers or consultants looking to expand their service offerings by mastering Excel-based reporting for clients.

Report abuse