arrow_back
Introduction to Microsoft Excel
Introduction to Microsoft Excel
Key Terminologies Used in the Microsoft Excel
Main Functions of the Microsoft Excel's Ribbon
Data Entry and Most Frequently Used Shortcut Keys
Data Entry & Analysis
Most Frequently Used Shortcut Keys
Most Frequently Used Formulae
Meaning of Fomulae & Steps to Apply Formulae
Most Frequently Used Formulae
VLOOKUP - Syntax & Rules
VLOOKUP - Practical Example
Pivot Tables & Charts
Basics of Pivot Tables
Pivot Tables - Practical Example
Charts
Special Functionalities Available in the Microsoft Excel
Special Functionalities - File Extensions
Special Functionalities - Home Tab
Special Functionalities - Insert Tab
Special Functionalities - Page Layout Tab
Special Functionalities - Formulas Tab
Special Functionalities - Data Tab
Special Functionalities - Review Tab
Special Functionalities - View Tab
Special Functionalities - Help Tab
Special Functionalities - File Extensions
Advanced Functionalities available in Microsoft Excel
Advanced Functionalities - Consolidate Button
Advanced Functionalities - Relationships & Power Pivot
Advanced Functionalities - What-if Analysis
Advanced Functionalities - Forecast Sheet & Outline Section
Advanced Functionalities - Advanced Formulae & Cell Referencing
Advanced Functionalities - Microsoft Excel Templates
POWER QUERY - Text Functions
POWER QUERY - Date Functions
POWER QUERY - Merge Tables or VLOOKUP
POWER QUERY - Merge Queries From Different Workbooks
POWER QUERY - Find Only Working Days
Advanced Functionalities - Printing the Workbook
Course Wrap Up & Next Steps
Course Wrap Up