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
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

1 of 1 students recommend this class