Advanced Microsoft Excel
Elevate your proficiency in data manipulation, analysis, and automation using Excel’s powerful features and your capabilities in handling complex datasets, performing advanced calculations, and automating repetitive tasks.
This course is designed for experienced Excel users who want to take their skills to the next level.
Through a combination of lectures, demonstrations, and hands-on exercises, participants will gain practical skills that can be immediately applied in their professional roles.
Whether you’re a business analyst, financial professional, or data enthusiast, this course will empower you to unlock the full potential of Microsoft Excel for advanced data analysis and automation.
Pricing Plans
There is a plan for everybody
- 30 Day Access - NGN16,125.00
- 90 Day Access - NGN18,812.50
- 180 Day Access - NGN21,500.00
Course Features:
Length
Approximately 40.5 hours of streamed multimedia content.
Course Structure
100% online, self-paced.
6 Parts | 12 Modules | 33 Topics.
Interactive and Responsive
Reinforce your learning with 33 practice questions.
Study on the go! [PC | Tablet | Mobile]
Course Community
Collaborate and engage with other students and your instructor.
Key Learning Objectives:
Dynamic Array Functions
Enhance your data manipulation capabilities with the new dynamic array functions in Excel.
Advanced Lookup Formulas
Develop proficiency in creating advanced and flexible lookup formulas, enabling you to efficiently retrieve and analyze data from large datasets.
Statistical Analysis and Ranking
Utilize statistical functions for ranking data, as well as calculating measures such as the median and mode, facilitating deeper data analysis.
Financial Data Manipulation
Work with financial data accurately by employing mathematical functions tailored for financial analysis, ensuring precision in financial calculations and reporting.
Advanced Data Analysis Techniques
Perform complex data analyses efficiently with advanced techniques, including the creation of variables and functions using LET and LAMBDA.
Automation and Customization
Automate repetitive tasks by recording and running macros, as well as incorporating interactivity into reports and dashboards using form controls.
