Server & Tools

Advanced Microsoft Excel Dashboards and Reports

MOS: Microsoft Office Excel 2016 Expert

Course Outline

Name:
Advanced Microsoft Excel Dashboards and Reports
Code:
EXC167
Duration:
3 Days
Format:
Instructor Led

About Course

Business Intelligence (BI) is what you get when you analyse raw data and turn that information into actionable knowledge. BI can help an organization identify cost cutting opportunities, uncover new business opportunities, recognize changing business environments, identify data anomalies and create widely accessible reports. In this course we show you how you can turn Excel into your own personal BI tool. With a few fundamentals and some of the new BI functionality Microsoft has included in this latest version of Excel, you can go from reporting data with simple tables, to creating meaningful dashboards sure to wow everyone.

Course Prerequisites

Some experience working with data and familiarity with the basic concepts of data analysis such as working with tables, aggregating data, and performing calculations. Experience using Excel with a strong grasp of concepts such as table structures, filtering, sorting, and using formulas.

At Course Completion

After completing this course, students will be able to:

  • Analyse large amounts of data and report those results in a meaningful way
  • Get better visibility into data from different perspectives
  • Add interactive controls to show various views
  • Automate repetitive tasks and processes
  • Create eye-catching visualizations
  • Create impressive dashboards and What-If analyses
  • Access external data sources to expand your message

Download Fact Sheet

To Download course fact sheet, click on the button below to view a extensive overview and breakdown of course requirements, duration and examinations.

Schedule & Booking

To view all upcoming events for the current course, please view the list below. If you would like to attend any of the training schedules, please click the Book Now button and complete the form to register.

The list below shows all the upcoming course training dates in the same category:

23 October 2018
Microsoft Excel 2016 Level 3
BOOK NOW
04 February 2019
MS Excel 2016: Data Analysis with Pivot Tables
BOOK NOW
05 February 2019
MS Excel 2016: Data Analysis with Power Pivot
BOOK NOW
05 February 2019
MS Excel 2016 Level 3
BOOK NOW
26 February 2019
MS Excel 2016 Level 3
BOOK NOW
01 April 2019
MS Excel 2016: Data Analysis with Pivot Tables
BOOK NOW
02 April 2019
MS Excel 2016: Data Analysis with Power Pivot
BOOK NOW
09 April 2019
MS Excel 2016 Level 3
BOOK NOW
30 April 2019
MS Excel 2016 Level 3
BOOK NOW
14 May 2019
MS Excel 2016 Level 3
BOOK NOW
03 June 2019
MS Excel 2016: Data Analysis with Pivot Tables
BOOK NOW
04 June 2019
MS Excel 2016: Data Analysis with Power Pivot
BOOK NOW
04 June 2019
MS Excel 2016 Level 3
BOOK NOW
25 June 2019
MS Excel 2016 Level 3
BOOK NOW
16 July 2019
MS Excel 2016 Level 3
BOOK NOW
12 August 2019
MS Excel 2016: Data Analysis with Pivot Tables
BOOK NOW
13 August 2019
MS Excel 2016: Data Analysis with Power Pivot
BOOK NOW
17 September 2019
MS Excel 2016 Level 3
BOOK NOW
07 October 2019
MS Excel 2016: Data Analysis with Pivot Tables
BOOK NOW
08 October 2019
MS Excel 2016: Data Analysis with Power Pivot
BOOK NOW
08 October 2019
MS Excel 2016 Level 3
BOOK NOW
29 October 2019
MS Excel 2016 Level 3
BOOK NOW
19 November 2019
MS Excel 2016 Level 3
BOOK NOW
02 December 2019
MS Excel 2016: Data Analysis with Pivot Tables
BOOK NOW
10 December 2019
MS Excel 2016 Level 3
BOOK NOW