complete-excel-course
transparent
600
#12bece
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 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 | ||
Trend Analysis | ||
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)