Microsoft Excel - Level 02

Phillip Burton

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
36 Lessons (2h 37m)
    • 1. Searching for data within a workbook

      5:26
    • 2. Hyperlinks

      4:43
    • 3. Using Go To and Using Name Box

      5:23
    • 4. Hot Keys

      3:55
    • 5. Changing worksheet tab colour

      5:25
    • 6. Inserting and deleting columns and rows

      7:44
    • 7. Undo and Redo

      4:09
    • 8. File Management tips

      4:24
    • 9. Adjusting row height and column width

      4:43
    • 10. Hiding columns and rows

      3:39
    • 11. Selecting multiple ranges

      3:42
    • 12. Hiding worksheets

      3:31
    • 13. Customising the Quick Access toolbar

      3:25
    • 14. Customising the Ribbon

      5:08
    • 15. Assigning shortcut keys

      2:49
    • 16. Recording simple macros

      4:53
    • 17. Managing macro security

      7:55
    • 18. Changing workbook views

      4:13
    • 19. Using zoom

      3:00
    • 20. Adding values to workbook properties

      5:23
    • 21. Displaying formulas

      2:32
    • 22. Freezing panes

      4:35
    • 23. Splitting the window

      3:09
    • 24. Printing individual worksheets

      2:55
    • 25. Printing an entire workbook and printing a selection

      2:22
    • 26. Setting a print area

      4:10
    • 27. Page setup, Part 1 (first two tabs)

      5:34
    • 28. Page setup, Part 2 (Repeating headers and footers)

      2:40
    • 29. Adding dynamic text to headers and footers

      3:29
    • 30. Inserting watermarks

      2:58
    • 31. Page setup, Part 3 (Headings etc.)

      6:59
    • 32. Configuring workbooks to print

      2:53
    • 33. Inspecting your workbook prior to distribution

      4:27
    • 34. Copying and pasting basics, and Utilising references (relative, mixed, absolute)

      8:55
    • 35. Practice Activity - multiplication table

      2:33
    • 36. Answer - multiplication table

      3:07