Bootcamp Overview
Dive into our detailed 3-day Excel Bootcamp structure to confidently enhance your skills and readiness for future data challenges.
1
Day One: Foundations in Excel
Begin with essential Excel techniques, setting a solid base for advanced learning and hands-on practice throughout the bootcamp.
Highlights:
- Dynamic tables: do’s and don’t do’s
- Pivot table techniques
- Named ranges
- Smart conditional formatting
- Array functions intro
- Game changing shortcuts
- Best practices
2
Day Two: Skill Application
Apply your knowledge in practical exercises, mastering formulas, data analysis, and preparing for real-world Excel challenges.
Highlights:
- Data cleaning using Flash Fill
- Power Query techniques
- Power Pivot: data modelling + DAX
- Build and use charts the smart way
- Discover the most modern Excel functions
- Nesting array functions
3
Day Three: Mastery and Beyond
Conclude with advanced topics, ensuring you complete the bootcamp ready to leverage Excel efficiently and explore Power BI opportunities.
Highlights:
- Formatting tips & tricks
- Visualization techniques
- Automate Excel processes
- Build compact dashboards
- Excel and Power BI, better together
- Q & A to be future ready!