Lecture 1
: Flash Fill & Data Validation
Lecture 2
: Advanced Conditional Formatting
Lecture 3
: ASAP Utilities
Lecture 4
: Lookup Functions
Lecture 5
: Match & Index
Lecture 6
: Dynamic Viookup
Lecture 7
: Data Table
Lecture 8
: Solver
Lecture 9
: Financial Functions
Lecture 10
: Sort & Filter
Lecture 11
: PowerPivot
Lecture 12
: Dashboard Creation
Lecture 13
: Power Map & Power Query
Lecture 14
: Macro
Lecture 15
: Array Functions
Lecture 16
: Google Drive
Lecture 17
: Mail Merge
Module Benefit
Module Benefits:
By understanding Advanced MS Excel Course, students will have the ability to use more sophisticated functions, which will allow them to analyse complex and large volume of data to present meaningful information helping in decision making.
Sufal Ghosh
This course gave a solid foundation in MIS and analytics. Some topics were challenging at first, but the step-by-step guidance helped. More real-life case studies would be nice, but overall, it’s a great start for beginners in data analysis.