Microsoft Excel Data Analysis and Dashboard Reporting

Build Dynamic, Interactive Microsoft Excel Dashboards (Excel 2010, 2013, 2016) with a Best Selling Excel Instructor

Created by: Kyle Pew
Microsoft Certified Trainer - 1.8 Million+ Students

Created by: Office Newb
Software Trainer

What Will I Learn?

• Understand and Identify the principles of data analysis
• Effectively summarize and present data clearly
• Use effective design principles when creating and presenting data
• Take full advantage of the built in tools Microsoft Excel offers in order to analyze and build dashboard reports
• Build interactive dashboard reports
• Analyze Excel data using Excels TEXT based Functions
• Data Mine using Excels Array Functions
• Build Interactive Dashboard Reports with Buttons and Drop Down Menus
• Streamline and Analyze Data with Excel PivotTables and Pivot Charts

Requirements

• Experience working with Microsoft Excel on a Windows system
• Videos were recorded using Excel 2016, but concepts and features will also work with Excel 2010, Excel 2013

Target audience

• Experienced Microsoft Excel users who are looking to efficiently analyze large data sets and create dynamic dashboard reports