EXCEL BASICS

1. Rows, Columns, Cells
2. Scroll Bar
3. Tabs
4. Ribbon
5. Quick Access Toolbar
6. Formular bar
7. Zoom
8. Sheets
9. Filename

COPYING & FILLING

1. Copy
2. Paste
3. Paste Special
4. Copying Cells
5. Copying To Different Worksheets
6. Using Fill For Quick Copying

FORMULAE

1. Add/Subtract/Multiply/
   Divide
2. BODMAS

EXCEL FORMATTING

1. Excel Formatting
2. Excel Format Colors
3. Excel Format Fonts
4. Excel Format Borders
5. Excel Format Numbers
6. Excel Format Grids
7. Excel Format Settings

FILL SERIES

1. Filling a series with formatting
2. Filling a series without formatting
3. Filling a weekdays
4. Fill Days

ADVANCED FILL

1. Fill Drag Numbers
2. Fill Drag Months
3. Fill Drag days
4. Fill Down, Right, Left Up
5. Flash Fill

CELL REFERRENCE

1. Relative Reference
2. Absolute Reference
3. Mixed Reference

TEXT FUNCTIONS

1. TRIM
2. PROPER
3. UPPER
4. LOWER
5. LEN
6. LEFT
7. RIGHT
8. MID
9. CONCATENATE
10. CONCAT
11. FIND
12. SEARCH
13. REPLACE
14. SUBSTITUTE

MATH & TRIG FUNCTIONS

1. SUMPRODUCT
2. MROUND
3. FLOOR
4. CEILING
5. MOD
6. QUOTIENT

LOGICAL FUNCTIONS

1. IF
2. IFERROR
3. NESTED IF
4. AND
5. OR
6. NOT

CONDITIONAL FUNCTIONS

1. SUM
2. SUMIF
3. SUMIFS
4. AVERAGE
5. AVERAGEIF
6. AVERAGEIFS
7. COUNT
8. COUNTIF
9. COUNTI

COUNT FUNCTIONS

1. COUNTA
2. COUNTBLANK

DATA SORTING & FILTERING

1. Basic Sorting
2. Filtering Data
3. Advance Fitering
4. Basic Table
5. Advance Table

DATA VALIDATION

1. Whole Numbers
2. Text Length
3. Date
4. Drop Down List
5. Input Messages
6. Error Messages
7. Stop
8. Warning
9. Information
10. Circle Invalid Data
11. Clear Validation Circles

CONDITIONAL FORMATTING

1. Highlight Cell Rules
2. Top Bottom Rules
3. Data Bars
4. Color Scales
5. Icon Sets
6. Clear Rules

DATE FUNCTIONS

1. TODAY()
2. NOW()
3. DAY()
4. MONTH()
5. YEAR()
6. DATE()
7. EDATE()
8. NETWORKDAYS()
9. NETWORKDAYS.INTL()
10. DATEDIF()

LOOKUP

1. VLOOKUP
2. VLOOKIP Approximate Match
3. VLookup rules
4. H-LOOKUP
5. LOOKUP FUNCTION
6. LOOKUP FULL RECORD
7. INDEX FUNCTION
8. MATCH FUNCTION

PIVOT TABLE

1. Columns
2. Rows
3. Filters
4. Values
5. Pivot table slice
6. Pivot table timeline

CHART

1. Column Chart
2. Pie Chart
3. Bar Chart
4. Line Chart
5. XY Scatter Chart
6. Spark Line Chart
7. Pivot Chart