Unit 1 - Conditional formatting / Data Validation

1.    Conditional formats text

2.    Conditional formats numbers

3.    Conditional formats modify

4.    Conditional formats - delete

5.    Conditional formats - top 5

6.    Conditional formats - remove

7.    Conditional formats databars

8.    Conditional formats - icons

9.    Data Validation - explained

10.Data validation stop

11.Data validation warning

12.Data validation information

13.Data validation numbers

14.Data validation characters

15.Data validation - control date

16.Data validation - remove

17.Data validation - remove #2

18.Data validation list

19.Custom list

20.Drop down list remove it

21.Custom list create #2

22.Custom list edit it

23.Custom list remove

Unit 2 - Comments / Watermarks / Templates

1.    Comments insert

2.    Comment show one

3.    Comments show all

4.    Ink - show it

5.    Comment find next comment

6.    Comment delete a

7.    Hyperlink - to a webpage

8.    Hyperlink to a file

9.    Hyperlink to a named range

10.Hyperlink to an email address

11.Grid lines show / hide

12.Grid lines - print

13.Column headings show / hide

14.Grid lines - print / no print #2

15.Watermark - insert

16.Watermark - remove

17.Templates by Microsoft

18.Templates by Microsoft

19.Save a template

20.Open a saved template

21.Microsoft templates (more)

22.Excel - change personal information

Unit 3 - More Excel Fun #2

1.    ctrl+; is todays date

2.    NOW TODAY

3.    Trace Precedents

4.    Transpose

5.    Arrange multiple workbooks

6.    Watch Window

7.    Switch between workbooks

8.    Zoom to selection

9.    Large Mouse Wheel

10.Custom lists

11.Show Hide Ribbon

12.Add Icons to the Quick Access Toolbar

13.Drop Down List

14.Golden Rule

15.Format Painter

16.Shortcut Keys

17.Go To Shortcuts

18.Navigate Arrow Shortcuts

19.Separate text into multiple columns

20.Max (largest number)

21.Min (smallest number)

22.Average

Unit 4 - Sort / Filter / Find Duplicates

1.    Sort data (no table)

2.    Filter data (no table)

3.    Months Repeat

4.    Days Repeat

5.    Years Repeat

6.    Days Sequential

7.    Numbers Sequential

8.    Budget - create one

9.    Time Sheet - create one

10.Find Duplicates (1)

11.Find Duplicates (2)

12.Find Duplicates (3)

13.Find Duplicates (4)

14.Find Duplicates (5)

15.Remove Duplicates

16.Separate text into multiple columns

17.Paste as a value

18.alt+=

19.Multiple lines of text in one cell

20.Copy a worksheet

21.Create a chart = F11

22.Copy / Paste to Add to a Chart

23.F12 = save as

Unit 5 - Formulas # 3 of 4

1.    INDEX

2.    LOOKUP

3.    MATCH

4.    NETWORKDAYS

5.    Subtotal while filtering

6.    ROUND

7.    ROUNDUP

8.    ROUND Prob #1

9.    ROUND Prob #2

10.ROUND -stop rounding

11.ROUNDDOWN

12.ISERROR

13.LEFT

14.RIGHT

15.Payments

16.Max (largest number)

17.Min (smallest number)

18.Average

19.# of days between 2 dates

20.UPPER

21.PROPER

22.LOWER

23.TRIM

24.Join two columns

25.Join two columns (example 2)

Unit 6 - Formulas #4 of 4

1.    VLookup False

2.    VLookup False (2)

3.    VLookup False (3)

4.    VLookup False (4)

5.    VLookup True (1)

6.    HLookup False (1)

7.    HLookup False (2)

8.    HLookup False (3)

9.    HLookup True (1)

10.NPV

11.IRR

12.FV

13.FV (2nd example)

14.PV

15.DDB

16.ISPMT

17.PMT

18.PMT(example 2)

19.VDB

20.NPER

21.RATE

22.PPMT

23.IPMT

24.ACCRINT