Official CourseAim

bit.ly/3OsHqOn

7. Day 7 ERROR checking and calculating FORMULAS
7. Day 7 ERROR checking and calculating FORMULAS
6. Day 6 FUNCTIONS SUM, AVERAGE, COUNT and COUNTA
6. Day 6 FUNCTIONS SUM, AVERAGE, COUNT and COUNTA
5. Day 5 ABSOLUTE CELL REFERENCE
5. Day 5 ABSOLUTE CELL REFERENCE
4. Day 4 ABSOLUTE and RELATIVE
4. Day 4 ABSOLUTE and RELATIVE
3. Day 3 BASIC DIVIDE FORMULAS
3. Day 3 BASIC DIVIDE FORMULAS
2. Day 2 SUM and SUMIF formulas
2. Day 2 SUM and SUMIF formulas
1. Day 1 FORMULAS and OPERATORS
1. Day 1 FORMULAS and OPERATORS
8. DAY 8 Named ranges and Table
8. DAY 8 Named ranges and Table
7. DAY 7 Import data from the web
7. DAY 7 Import data from the web
6. DAY 6 HOW TO TRANSPOSE
6. DAY 6 HOW TO TRANSPOSE
5. DAY 5 EXCEL DROP DOWN LIST
5. DAY 5 EXCEL DROP DOWN LIST
4 DAY 4 FLASH FILL
4 DAY 4 FLASH FILL
3. DAY 3 AUTOFILL and inputting data
3. DAY 3 AUTOFILL and inputting data
2. DAY 2 WORKSHEETS
2. DAY 2 WORKSHEETS
1. DAY 1 PRINTING EXCEL
1. DAY 1 PRINTING EXCEL
7. Day 7 SORTING and FORMATTING
7. Day 7 SORTING and FORMATTING
6. Day 6 Cell FORMATTING
6. Day 6 Cell FORMATTING
5. Day 5 FORMATTING
5. Day 5 FORMATTING
4. Day 4 CELL ALIGNMENT
4. Day 4 CELL ALIGNMENT
3. Day 3 NUMBER FORMATTING
3. Day 3 NUMBER FORMATTING
2. Day 2 FONT FORMATTING
2. Day 2 FONT FORMATTING
1. Day 1 RESIZING rows and columns
1. Day 1 RESIZING rows and columns
7. DAY 7 USEFUL KEYBOARD SHORTCUTS
7. DAY 7 USEFUL KEYBOARD SHORTCUTS
6. Day 6 KEYBOARD NAVIGATION
6. Day 6 KEYBOARD NAVIGATION
5. DAY 5 FIND AND REPLACE IN EXCEL
5. DAY 5 FIND AND REPLACE IN EXCEL
4 DAY 4 CLICKBOARD BASIC COPY AND PASTE
4 DAY 4 CLICKBOARD BASIC COPY AND PASTE
3. DAY 3 UNDO AND REDO IN EXCEL
3. DAY 3 UNDO AND REDO IN EXCEL
2. DAY 2 EXPLORING THE RIBBON
2. DAY 2 EXPLORING THE RIBBON
1. DAY 1 INTRODUCTION TO EXCEL
1. DAY 1 INTRODUCTION TO EXCEL