Advanced Excel Course
Microsoft Excel: Advanced Data Analysis and Visualisation – FutureLearn
Course Overview:
This course, part of the Applied Data Analysis ExpertTrack, delves into advanced Excel functionalities for data analysis and visualisation.
Key Topics:
Data import and cleaning techniques
Advanced PivotTables and PivotCharts
DAX calculations and data modelling
Power BI integration for enhanced visualisation
Duration:
3 weeks (5 hours per week)
Cost:
$39/month (free 2-day trial available)
Link:
Microsoft Excel 2021/365 Masterclass: Advanced Excel Course – Udemy
Course Overview:
A comprehensive course designed to elevate your Excel skills to an expert level, covering the latest features in Excel 2021 and Microsoft 365.
Key Topics:
Dynamic array functions and LET/LAMBDA formulas
Advanced lookup techniques with XLOOKUP and INDEX/MATCH
Power Query for data transformation
Dashboard creation and automation with macros
Duration:
Approximately 10 hours
Cost:
Varies (often discounted)
Link:
Excel Skills for Business: Advanced – Coursera (Macquarie University)
Course Overview:
This course is part of the Excel Skills for Business Specialization and focuses on advanced Excel techniques for business applications.
Key Topics:
Spreadsheet design and documentation
Advanced formula techniques, including array formulas
Data cleaning and preparation methods
Financial functions and working with dates
Building professional dashboards
Duration:
Approximately 15 hours
Cost:
Free to audit; certificate available for a fee
Link:
Advanced Excel Functions – Udemy
Course Overview:
This course focuses on advanced Excel functions tailored for professionals in business, finance, and analytics.
Instructor:
Ashish Agarwal, former McKinsey & Co. and BlackRock professional.
Key Topics:
Data analysis and manipulation techniques.
Building dynamic and flexible models.
Data aggregation and synthesis methods.
Duration:
Approximately 6 hours.
Cost:
Varies (often discounted)
Link:
Advanced Microsoft Excel Training Course – 365 Data Science
Course Overview:
A structured course offering in-depth training on advanced Excel features, suitable for professionals seeking to enhance their data analysis capabilities.
Key Topics:
Advanced Excel functions like INDEX, MATCH, and OFFSET
Data formatting and professional presentation techniques
Building scalable data analysis models
Utilising shortcuts and efficient navigation methods
Duration:
Self-paced
Cost:
Varies (often discounted)
Link: