Intermediate Excel 2016 – English


Download Curriculum Here

*For those using FireFox, Full Screen option may not work.

Please click on the link to the video you wish to see…

Tables of Contents
1. Intro to Intermediate Microsoft Excel
2. Math Formulas
3. Functions
4. Comments
5. Using the fill handle
6. Right click shortcuts
7. Format painter
8. Absolute cell address
9. Using =IF & Nested =IF
10. Using Sum =IF
11. Formatting Cells
12. Formatting Dates
13. Creating Charts
14. Formatting Charts
15. HLOOKUP
16. VLOOKUP

Intro to Intermediate Microsoft Excel

_______________________________________________

Math Formulas

_______________________________________________

Function

_______________________________________________

Comments

_______________________________________________

Using the fill handle

_______________________________________________

Right click shortcuts

_______________________________________________

Format painter

_______________________________________________

Absolute cell address

_______________________________________________

Using =IF & Nested =IF

_______________________________________________

Using Sum =IF

______________________________________________

Formatting Cells

_______________________________________________

Formatting Dates

_______________________________________________

Creating Charts

_______________________________________________

Formatting Charts

_______________________________________________

HLOOKUP

_______________________________________________

VLOOKUP

_______________________________________________