How well can you useοΏ½Microsoft ExcelοΏ½to analyze data for decision-making? Give yourself the gift of knowledge and master spreadsheets. Register today for a 5-day highly practical and vibrant Advanced Excel Training.
In this Live training, you will learn concepts such as Using Lookup Formulas and Formula Auditing, Sharing and Protecting Workbooks, Automating Workbook Functionality, Creating Spark lines and Mapping Data, Forecasting Data among many others
Who is this course for? (Target Audience)
The Advanced MS Excel training courses is for anyone who:
Wants to learn practical tools and techniques to assist in reducing the time spent in Excel. We can train from beginner to intermediate to advanced, and cover topics like Data Visualization, Financial Modelling, Pivot Tables and Excel fundamentals.
What can you achieve by taking this course?
Apply advanced formulas to lay data in readiness for analysis
Use advanced techniques for report visualizations
Leverage on various methodologies of summarizing data
Understand and apply basic principles of laying out Excel models for decision making
Objectives of the course
To teach participants the advanced formulas as well as how to use which formula for which occasion.
To equip participants with the knowledge on how to debug and audit the advanced formulas.
To explore the magic of analyzing data using Advanced Excel.
Certification of the Advance Excel Course
Wants to learn practical tools and techniques to assist in reducing the time spent in Excel. We can train from beginner to intermediate to advanced, and cover topics like Data Visualization, Financial Modelling, Pivot Tables and Excel fundamentals.
Course Requirement
Interested organizations/institutions/individuals are expected to have laptop(s) while attending the classes and should at least have some background in using Excel.
Duration and Venue
2-3 Weeks, 3 days each week (Mon-Wed)
Live ZOOM/KENET/Google Meet classes from 8:00pm to 9.30pm EAT.
Course Outline
Working with multiple Worksheets and Workbooks
Using Lookup Formulas and Formula Auditing
Sharing and Protecting Workbooks
Automating Workbook Functionality
Creating Spark lines and Mapping Data
Forecasting Data