Course: Microsoft Excel: Data Reporting Tools

Microsoft Excel: Data Reporting Tools

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

This course will showcase some of the most useful tools used for not only bringing data together, but to turn that data into a professional report. You'll learn how to use tools such as Consolidate, Advanced Filtering for extraction and creating Pivot Tables and Charts.

There are no complicated formulas or difficult syntax, just a set of great tools to get Excel to do the hard work for you!

Who is the target audience?

  • Excel users who work with data but don't need to use formulas
  • Anyone who wants to improve their knowledge of Excel tools and features
Basic knowledge
  • You'll need Excel 2010, 2013 or 2016 installed and a desire to learn new skills
  • You should have a grasp of the basics of Excel as this is not a beginners course
What you will learn
  • You'll be able to use the most efficient tools for extracting and reporting on data
  • You'll learn about bringing data together using the Consolidate tool
  • Extract data with multiple criteria using Advanced Filtering
  • Create and build Pivot Table report to showcase your data
Number of Lectures: 11
Total Duration: 01:49:51
  • Introduction  
  • Consolidate Data from the same file  
  • Consolidate Data from multiple files  
Advanced Filtering
  • Advanced Filtering for Data Extraction  
Working with Tables
  • Creating a Table for Analysing and Subtotalling  
  • Creating Summaries from Tables  
Pivot Tables
  • Introduction to Pivot Tables  
  • Analysing Data  
  • Grouping Data  
  • Pivot Table Slicers  
  • Pivot Charts  
Reviews (0)