Data Analysis & Dashboard Reporting
Introduction
Microsoft Excel is one of the most powerful and popular data analysis desktop application in the market today. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you will gain the widely sought after skills necessary to effectively analyse large sets of data. Once the data has been analysed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report.
The Excel Analysis and Dashboard Reporting course covers some of the most popular data analysis Excel functions and Dashboard tools, including;
- VLOOKUP() Function for Looking up Information
- INDEX()/MATCH() Functions a Powerful Alternative to VLOOKUP
- TEXT() Function for Formatting
- CHOOSE() for Ultimate Flexibility in Presenting Data
- Advanced Filtering
- Summarising Data with PivotTables and Pivot Charts
- Interactive Features to Create User Friendly Reports
and more…
Course Objectives
By the end of this course, you will be able to:
- Understand and identify the principles of data analysis
- Effectively summarise 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 analyse and build dashboard reports
- Build interactive dashboard reports
- Analyse Excel data using Excels TEXT based Functions
Methodology
REREQUISITE
- Experience working with Microsoft Excel on a Windows system
- Concepts and features will also work with Excel 2016 (Professional), Office365, 2019
Who Should Attend?
Experienced Microsoft Excel users who are looking to efficiently analyse large data sets and create dynamic dashboard reports.
Training Delivery
- Face to Face Training
or
- Remote Training via Zoom Platform
- Day One
- Day Two
Day One
MODULE 1: MANAGING RAW DATA
MODULE 2: WORKING WITH A SINGLE DATASET
MODULE 3: WORKING WITH DATA ANALYSIS
MODULE 4: OUR ROLE AS A COUNSELLOR
Day Two
MODULE 5: DESIGN INTERACTIVE POWER BI REPORTS
MODULE 6: PREPARING DATA MODELLING IN EXCEL
MODULE 7: CREATING INTERACTIVE DASHBOARD
MODULE 8: PREPARE AND DISTRIBUTE REPORTS USING MACRO
You May Also Be Interested In
Be Updated on the latest HR & Training Best Practices
0
Stay Updated to the Latest HR News & Training Trend
Subscribe to Our Newsletter
By providing your information above, you consent to receive marketing emails from PM Resources Sdn Bhd, which will include the latest news and updates related to our businesses. Our privacy policy contains information how we store and process your data.
