Advanced Microsoft Excel Dashboards and Reports
MOS: Microsoft Office Excel 2016 Expert
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.
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: