Data Analytics for Finance Professionals & Auditors
Skill Level
Advanced
18 hrs
Duration
Language
English
Overview
This course aims to supercharge your MS Excel prowess for data manipulation, analysis and presentation to management. Learn to solve common business problems through completing real world exercises in Excel.
Completing this course will help you:
- Emerging MS Excel and Power BI technologies for business analytics.
- Advanced analytical skills to shape, manipulate and visualize business data.
- How to create a dynamic Excel dashboard from raw data.
Course Prerequisites
The ideal candidate need to have strong data analysis skills and MUST be good with Excel at an Advanced level.
Learning Path
- Compare two lists of data.
- Extract a number of characters from a text using Text functions.
- Retrieving data from a database lookups.
- Combine data from multiple sheets using INDIRECT function.
- Functions to analyze a company’s business performance.
- Build dynamic data tables for sensitivity and scenario analysis for Budgets.
- Prepare final accounts from a TB.
- Guide to choose the right; Creating and customizing charts.
- Advanced chart concepts dual axis charts.
- Creating dynamic scrolling charts.
- Conditional formatting of charts.
- Non standard charts and their usage.
- Creating and editing conditional formatting.
- Customer number formats
- Create interactivity.
- Enhancing the feel and look of dashboards using shapes.
- The Camera tool and/or Linked Pictures.
- Guidelines/Considerations of dashboard design.
- Working with multiple sources of data.
- Automating common data shaping tasks using Power Query.
- A sneak preview of the Power BI.
What people are saying
“I was looking for a Social Media Course to expand my career horizon. A friend of mine suggested to learn from Steve’s online courses and it really worked for me.”
“A fantastic and very engaging course. All of the information offered by Steve was completely practical, relevant and presented in an easy, digestible and interesting way.”
“This course was a breakthrough in my knowledge of digital marketing. The content is comprehensive and of great quality, engaging and interactive.”
Previous
Next