| S No. | Module | Topic |
| 1 | Excel Interface | Going through |
| 2 | Worksheet Basics | Add/ Remove/ Delete/ Color a Worksheet, Copy & Move, Hide |
| 3 | Excel Basics Beginning | Font, Text Color, Background Color, Size, Bold, Italic, Underline, Merge, Wrap, Alignment, Comment, Hyperlink |
| Cut, Copy, Paste, Format Painter | ||
|
Borders, Add/ Remove rows & columns
|
||
| Sort, Filter | ||
| 4 | Paste Special | As Values |
| As Link | ||
| As Formula | ||
| As Transpose | ||
| 5 | Data Cleaning Techniques | Find/ Find All |
| Replace/ Replace All | ||
| Format | ||
| Group/ Ungroup | ||
| Custom Filter | ||
| Remove Duplicates | ||
| 6 | Named Range | Named Range |
| 7 | Maths Functions | Count, Sum, Average, Max, Min, Large, Small |
| 8 | Text Functions | Len, Left, Right |
| 9 | File Tab | Overview |
| 10 | Quiz (20 MCQs) | Test Your Knowledge |
| 11 | Functions | Excel Functions |
| Text Functions | ||
| Date & Time Functions | ||
| If Function, AND & OR Operators | ||
| Informational Functions | ||
| 12 | Go To Special | Data Fixing |
| 13 | Relative, Mixed & Absolute Referencing | Relative, Mixed & Absolute |
| 14 | Data Validation | List |
| Typed List | ||
| Mobile Number Validation | ||
| Employee Feedback Validation | ||
| Only Text Values | ||
| Only Upper Case Values | ||
| Prevent Future Dates | ||
| List with Named Range | ||
| Restrict Text Length | ||
| Dynamic List | ||
| Dependent Drop Down List | ||
| 15 | Goal Seek | Two Examples |
| 16 | SUMIF, IFS, COUNTIF, IFS | SUMIF, IFS, COUNTIF, IFS |
| 17 | Table | Format as Table & Add on Capabilities |
| 18 | Array | Array with Sum & Max Functions |
| 19 | Conditional Formatting | Inbuilt Conditional Formatting |
| Custom Conditional Formatting | ||
| Dynamic Search & Highlight | ||
| Partial Match | ||
| 20 | Auto-fill, Flash Fill & Custom Lists | Auto Fill |
| Flash Fill | ||
| Custom Lists | ||
| 21 | Vlookup/ Hlookup/ Xlookup | Vlookup Basic |
| Vlookup with Array | ||
| Vlookup with Multiple Criteria | ||
| Vlookup with Range | ||
|
Vlookup with Named Range & Benefits
|
||
| Vlookup with Match Function | ||
| Vlookup with Column Reference | ||
| Vlookup with Table | ||
| Vlookup with Dropdown | ||
| Two-Way Lookup | ||
| Partial Vlookup | ||
| Vlookup to the left side | ||
| Case Sensitive Lookup | ||
| Vlookup with Trim Function | ||
| Vlookup if IFERROR | ||
|
Vlookup with Multiple Column Search
|
||
| Vlookup with Two Tables | ||
| Vlookup with Duplicate Values | ||
| Bonus: Hlookup & Xlookup | ||
|
Quiz - Test Your Knowledge - 20 MCQs
|
||
| 22 | Offset Function | Offset - Basic |
| Offset with Sum - Horizontal | ||
| Offset with Sum - Vertical | ||
| Offset with Match | ||
| Offset with Average | ||
| Offset with Countif | ||
| 23 | Index & Match Function | Index Function Basic |
| Index Function with Area Number | ||
| Match Function Basic | ||
|
Index & Match Functions as a replacement to Vlookup Function
|
||
|
Index & Match Functions with Drop Down
|
||
| 24 | Pivot Table & Chart | Interface |
|
Data Introduction: Super Store Data
|
||
| Create Your First Pivot Table | ||
|
How To Make Pivot Table Dynamic
|
||
| Slicer & Timeline | ||
| Group & Ungroup Dates | ||
| Conditional Formatting In Pivot | ||
| Create Your First Chart | ||
|
How To Make Pivot Chart Dynamic
|
||
| Chart Gap | ||
| Top 10 Customers | ||
|
Compare One sub-category Against Others
|
||
| Profit & Sales Correlation | ||
| 25 | Power Pivot | Introduction: How Is Power Pivot Different From Pivot Table |
| Avoid Vlookup Using Data Model | ||
| 26 | Designing Dashboard | Create Your Dashboard |
| 27 | Power Query | Introduction: Why Power Query |
| Data From Web | ||
|
Combine Files From Folder In 1 click
|
||
| 28 | Protection | Protect Sheet |
| Protect Workbook | ||
| Make Your Workbook Read Only | ||
| 29 | Test Your Knowledge | 40 MCQs |
| 30 | New Functions of Excel 2019 | Concat |
| TEXTJOIN Function | ||
| MINIFS And MAXIFS Function | ||
| IFS Function | ||
| SWITCH Function | ||
| 31 | Dynamic Array Functions | Filter |
| Unique | ||
| Sort | ||
| Sortby | ||
| Sequence | ||
| Randarray |
Practical Learning
Practice Sheets
Recording
Assignment
Evaluation & Certification by Edu4Sure
Any Payment Method (Please pay as per discussion with the team for the required course)
1) Net Banking
TestFormula Education Pvt. Ltd.
Account Number: 33729473635
State Bank of India, Delhi
IFSC: SBIN0001573
2) Pay through Payment Gateway (International transactions acceptable)