30 DAYS EXCEL EXPERT
- Curriculum
30 DAYS EXCEL EXPERT
-
1
INTRODUCTION -
2
introduction sheet -
3
Data Entry & Basic Formulas in Excel
-
4
Data-Entry-Basic-Functions
-
5
Sorting Data in Excel
-
6
Sorting Data in Excel PRACTICE SHEET
Sorting Data in Excel
-
7
Filter Data in Excel
-
8
Filter Data in Excel
-
9
Advanced Filter in Excel with Macro
-
10
Advanced Filter in Excel with Macro Practice
-
11
Data Validation in Excel
-
12
Data Validation in Excel Practice Sheet
-
13
Conditional Formatting in Excel
-
14
Conditional Formatting in Excel practice sheet
-
15
Text to Columns &Flash Fill
-
16
Text to Columns & Flash Fill practice sheet
-
17
Remove Duplicates & Unique Formula
-
18
Remove Duplicates & Unique Formula
-
19
Paste Special in Excel
Paste Special in Excel
-
20
Paste Special in Excel practice sheet
30 DAYS EXCEL EXPERT PART 2
-
21
IF Formula in Excel
IF Formula in Excel
-
22
IF with AND Formula in Excel
IF with AND Formula in Excel
-
23
If with OR Formula in Excel
If with OR Formula in Excel
-
24
Nested If Formula in Excel
Nested If Formula in Excel
-
25
Sumif and Countif
Sumif and countif
-
26
SumIFS and CountIFS Formula
SumIFS and CountIFS Formula
-
27
V lookup and H lookup Formula
V lookup and H lookup Formula
-
28
Text Formulas in Excel
Text Formulas in Excel
-
29
Date Formulas in Excel
Date Formulas in Excel
-
30
Pivot-Table-in-Excel
Pivot-Table-in-Excel
-
31
Pivot-Chart-in-Excel
Pivot-Chart-in-Excel
-
32
Pivot-Table-Slicer
Pivot-Table-Slicer
-
33
Time-Line-and-Pivot-Table-Options
Time-Line-and-Pivot-Table-Options
-
34
Sort and Filter Formula
-
35
Financial-Function-PMT-PPMT-IPMT
Financial-Function-PMT-PPMT-IPMT
-
36
Xlookup-Formula-in-Excel
Xlookup-Formula-in-Excel
-
37
Macros and Add ins in Excel
Macros and Add ins in Excel
-
38
Printing Tips in Excel
Printing Tips in Excel