Duration: 2 days | 12 hours
Available delivery methods:
Classroom
Connect, Integrate, Analyze and Visualize data like a pro!
Course Information
This is the last course of Microsoft Excel specialization. You will build on the strong foundations of the two Microsoft Excel courses: Microsoft Excel -Essentials and Microsoft Excel – Intermediate. In the Advanced course, we will equip you to become a power user of Excel – this is your last step and from this point, your specializing at a professional level would be well underway. You will be challenged to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for our big finale, where you will learn how to build professional dashboards in Excel. This course is targeted towards middle level to senior managers/executives willing to learn advanced techniques to convert data into actionable information.
Key areas covered on the course include:
Advanced Data Manipulation Techniques
- Avoid typing a column index number in VLOOKUP by combining VLOOKUP + MATCH functions.
- Say good-bye to VLOOKUP and hello to INDEX + MATCH for two-way (matrix) lookups, as well as a right- to-left lookup
Methods of Summarizing Data
- Data Consolidation by position
- Working with INDIRECT to consolidate data from multiple worksheets.
- Conditional aggregation with multiple criteria (SUMIFS, COUNTIFS & AVERAGEIFS
Sensitivity Analysis & Modeling in Excel
- Sensitivity (“What-if”) analysis on models using Data Tables, Goal Seek
- Laying out a model in Excel
Methods of Summarizing Data
- Maximizing on the power of PIVOT-TABLES
Visual Reporting & Interaction
- Make reports more insightful with formula-driven Conditional Formatting
- Spark lines to show trends
- Combine SUMIFS with pick lists, for data slicing and creating interactive charts
- Introduction to form controls (option buttons for report interaction)
Prerequisites
There are no formal prerequisites, but you should have Essential Excel skills.
What is Microsoft Excel?
Microsoft Excel is a spreadsheet program originally developed by Microsoft in the late 1980s. The industry standard spreadsheet for businesses all over the world, Excel allows the collection, processing and manipulation of data in a tabular format. Excel forms part of the Microsoft Office suite of software.
What’s included in this course?
2 days’ worth of Instructor-led, practical and interactive training, a course pack including all presentation slides, and a certificate.
Learners taking this course are:
- Financial Analysts
- Controllers
- Accountants
- Economists
- Process Analysts
What key skills will I gain in this course?
- Financial modelling
- Data cleansing
- Microsoft Excel
Do you offer In-house corporate training?
We offer corporate trainings for a minimum number of 6 participant at your preferred venue.
Find out more
Or call us now
+254 20 222 95 66
+254 716 56 88 99
+254 732 56 88 99
Interested in our training courses?
Get 20% off!
...on select training bundles.
Our Best Selling Courses
Microsoft Excel - Essentials
Become more effective in your reporting processes. Gain useful data manipulation skills!
Advanced Analysis & Visualization in Excel
Make the process of “Data to Decisions” efficient and cost effective.
Analytics for Finance Professionals in Excel
Drive productivity, efficiency, transparency and lower risk as a Finance professional.
Advanced PowerPoint
For professional, engaging in presentations that yield results.
Microsoft Excel - Intermediate
Become more effective in your reporting processes. Gain useful data manipulation skills!
Report Automation with Excel VBA/Macros
Get ahead of others! Automate the mundane tasks and create stunning reports with greater flexibility.
Microsoft Power BI
Connect, Integrate, Model and Visualize Business Data Reliably!
Microsoft Excel - Advanced
Connect, Integrate, Analyze and Visualize data like a pro!
Advanced Excel + Financial Modelling & Forecasting in Excel
Efficiently build an effective and robust financial model based on real-world financial modelling challenges.
Data Analysis & Visualization in Power BI
Connect, Integrate, Model and Visualize Business Data Reliably!
R for Data Science
Python for Data Science
