Learn Excel Dashboards Using Charts & Pivot Tables

Learn How To Create A Functional Excel Dashboards Using Charts And Pivot Tables

In this online training session, you will learn how to create charts in Microsoft Excel to analyse sales data of a sample company. You will learn how to create Pivot-Tables to assess different aspects of the sales information, and represent the information from the tables as line, bar, and pie charts. When creating the charts, you will learn how to format them so they are easily interpreted and you will then assemble the charts in a dashboard to provide a global picture of the sales data.

Requirements To Join Online Training
Basic knowledge of Excel spreadsheets. This course is targeted to individuals that know to do simple calculations in Excel and want to now know how to create charts and pivot tables. Also, how to create a nice visual report - i.e. dashboard - similar to the image above.

Skills you will develop from this Excel Training

• Line chart
• Pie Chart
• Bar Charts
• Pivot Table
• Data Analysis (presented in a dashboard)

## Learn step-by-step

In this online training session, the instructor will walk you through these steps:

• Create Pivot Tables in Microsoft Excel
• Create and format a Line Chart in Microsoft Excel to represent sales profits by month
• Create and format a Bar Chart in Microsoft Excel to represent sales profits by Salesperson
• Create and format Pie Charts in Microsoft Excel to represent sales percentages by product category and city
• Create a Dashboard in Microsoft Excel containing charts and tables

This training session is intermediate level.

Your instructor is an Excel Expert and has been training many individuals to help them become more productive in their workplace through Microsoft Excel.

For more mini- Excel courses that are online and taught by an Excel Expert, see
https://excelmadesimple.odoo.com/prices

Feel free to contact me with any questions you may have.