The syllabus
-
1
Chapter 1 Excel Basics
- Welcome Free preview
-
(Included in full purchase)
The Survival Guide Course Workbook
-
(Included in full purchase)
1. Ribbon basics
-
(Included in full purchase)
2. Cell reference and cell address
-
(Included in full purchase)
3. Making it look pretty with formatting
-
2
Chapter 2 Order Management
-
(Included in full purchase)
1. Custom number format
-
(Included in full purchase)
2. Math functions
-
(Included in full purchase)
3. Data validation drop downs and list
-
(Included in full purchase)
4. Conditional formatting
-
(Included in full purchase)
5. Sort and custom sort
-
(Included in full purchase)
6. Filter
-
(Included in full purchase)
7. Moving columns and other options
-
(Included in full purchase)
8. PivotTables
-
(Included in full purchase)
9. VLOOKUP and XLOOKUP
-
(Included in full purchase)
10. Tables
-
(Included in full purchase)
11. Sumif
-
(Included in full purchase)
12. Join cells
- 13. IF, OR, AND statements Free preview
-
(Included in full purchase)
14. Freeze panes
-
(Included in full purchase)
15. Slicers
-
(Included in full purchase)
Chapter 2 Supplemental Reading
-
(Included in full purchase)
-
3
Chapter 3 Budget
-
(Included in full purchase)
1. Fill right and down
-
(Included in full purchase)
2. Alignment
-
(Included in full purchase)
3. Date and number formatting
-
(Included in full purchase)
4. More math functions
-
(Included in full purchase)
5. Sparklines
-
(Included in full purchase)
6. Rounding and decimals
-
(Included in full purchase)
7. Duplicates
-
(Included in full purchase)
8. IFERROR
-
(Included in full purchase)
9. Macros
-
(Included in full purchase)
Chapter 3 Supplemental Reading
-
(Included in full purchase)
-
4
Chapter 4 Projects
-
(Included in full purchase)
1. Checkboxes and countif
-
(Included in full purchase)
2. Progress bar and COUNTA
-
(Included in full purchase)
3. Conditional formatting continued
-
(Included in full purchase)
4. Pie Chart
-
(Included in full purchase)
5. Charts
-
(Included in full purchase)
6. Merge and center vs. center across selection
-
(Included in full purchase)
7. Protect
-
(Included in full purchase)
8. Removing blank rows
-
(Included in full purchase)
Chapter 4 Supplemental Reading
-
(Included in full purchase)
-
5
Chapter 5 Fun Extras for Work
-
(Included in full purchase)
Work day calendar list
-
(Included in full purchase)
Excel form
-
(Included in full purchase)
Chart types
-
(Included in full purchase)
Excel Survival Guide Final Quiz
-
(Included in full purchase)