Course Description
This Module teaches you essential MS Excel skills for efficient data management and reporting. Learn key functions, data cleaning, lookup tools (VLOOKUP, HLOOKUP), conditional formatting, Pivot Tables, and Smart Charts. Enhance productivity with shortcuts, logical operators, and advanced formatting techniques. This module equips you with everything needed to excel in Excel!
Lectures
Each lecture focuses on key MS Excel tools like VLOOKUP, HLOOKUP, Pivot Tables, and Smart Charts, along with data management, shortcuts, and advanced formatting. Attend the demo lecture to get an idea and gain practical skills for real-world business tasks efficiently.
Resources Overview
Access free downloadable PDFs that include book summaries, recommendations, practical reports, and shortcut guides for both Windows and Mac. These resources are designed to enhance your learning experience and boost productivity across all modules.
Demo Lectures
1. Advance Excel
Topic 1. Introduction
Introduction-1
Topic 2. Mathematical Function Part1
Mathematical Function Part1-1
Topic 3. Mathematical Function Part2
Mathematical Function Part2-1
Topic 4. Conditional Formatting
Conditional Formatting-1
Topic 5. Absolute and Relative Reference
Absolute and Relative Reference-1
Topic 6.
Other Functions-1
Format Copy Paste-1
7 seconds | 7 shortcuts-1
Shortcut to G-Apps-1
Sequence Shortcut-1
Alt Shortcut-1
Module Overview
Category Functions/Features Mathematical Sum, Sumproduct, Average, Averagea, Min, Mina, Max, Maxa, Small, Large, Abs, Count, Countblank, Counta, Aggregate, Mod, Rank, Absolute and Relative Referencing Paste Special Value, Format, Transpose, Link, Add, Subtract, Product and Many Useful Features Rounding Functions Round, Roundup, Rounddown (Also to nearest Tens, Hundreds and Thousands), Ceiling, Floor and Mround Date Day, Date, Month, Year, Now, Today, Cleaning and Formatting Text Functions Trim, Concatenate, ‘&’, Lower, Proper, Upper and Value. Advance Text Left, Right, Mid, Replace, Substitute, Find, Len, Working With ‘*’ For Data Cleaning, Text To Column & Other Advance Data Cleaning Techniques Shortcuts Smart Editing Techniques, Learning Useful Shortcuts The Easy Way and Formatting Lookup Functions Vlookup, Hlookup & Automation Of The Same Logical Operators If, Nested If, And, Or, Isna, Iserror, Iserr, Isblank, Istext, Isformula & XOR Conditional Formatting Basic Conditional Formatting (Formatting using Formulas covered in next Module) Array Functions Array formulas, Array constant, Create one dimensional and two dimensional constants, Dynamic Transpose
| Category | Functions/Features |
|---|---|
| Mathematical | Sum, Sumproduct, Average, Averagea, Min, Mina, Max, Maxa, Small, Large, Abs, Count, Countblank, Counta, Aggregate, Mod, Rank, Absolute and Relative Referencing |
| Paste Special | Value, Format, Transpose, Link, Add, Subtract, Product and Many Useful Features |
| Rounding Functions | Round, Roundup, Rounddown (Also to nearest Tens, Hundreds and Thousands), Ceiling, Floor and Mround |
| Date | Day, Date, Month, Year, Now, Today, Cleaning and Formatting |
| Text Functions | Trim, Concatenate, ‘&’, Lower, Proper, Upper and Value. |
| Advance Text | Left, Right, Mid, Replace, Substitute, Find, Len, Working With ‘*’ For Data Cleaning, Text To Column & Other Advance Data Cleaning Techniques |
| Shortcuts | Smart Editing Techniques, Learning Useful Shortcuts The Easy Way and Formatting |
| Lookup Functions | Vlookup, Hlookup & Automation Of The Same |
| Logical Operators | If, Nested If, And, Or, Isna, Iserror, Iserr, Isblank, Istext, Isformula & XOR |
| Conditional Formatting | Basic Conditional Formatting (Formatting using Formulas covered in next Module) |
| Array Functions | Array formulas, Array constant, Create one dimensional and two dimensional constants, Dynamic Transpose |
Still have questions or need further clarification? Feel free to connect with us!
Know More
Courses
Subscribe to Our Website
Stay updated with announcements & mentor guidance!