Basic to Advanced Excel Course
What will I learn?
Boost your Business Intelligence skills with our Basic to Advanced Excel Course. Master essential Excel formulas and functions, including logical and lookup functions, to streamline your data management. Learn to handle missing data, import techniques, and data cleaning methods. Enhance your analysis with pivot tables, filtering, and key metrics calculation. Dive into forecasting with trendlines and scenario analysis. Gain insights through analytical reporting and data visualisation, using line, bar, and column charts. Transform data into actionable insights efficiently.
Apoia's Differentials
Develop skills
Strengthen the development of the practical skills listed below
Master Excel formulas: Enhance data analysis with logical and lookup functions.
Efficient data management: Clean, import, and handle missing data seamlessly.
Advanced data analysis: Utilize pivot tables and calculate key metrics effectively.
Forecasting skills: Apply trendlines and scenario analysis for predictive insights.
Data visualisation expertise: Create and customise impactful charts and reports.
Suggested summary
Workload: between 4 and 360 hours
Before starting, you can change the chapters and the workload.
- Choose which chapter to start with
- Add or remove chapters
- Increase or decrease the course workload
Examples of chapters you can add
You will be able to generate more chapters like the examples below
This is a free course, focused on personal and professional development. It is not equivalent to a technical, undergraduate, or postgraduate course, but offers practical and relevant knowledge for your professional journey.