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

Project Description

Please find attached the spreadsheets that you need for this level.

PRACTICE ACTIVITY 3

Let's see how much you remember from the last two sections:

  • Open the “Practice File 0202” workbook, which is attached as a resource to this Practice Test.
  • Use the find function to search for the word vanity
  • Add a hyperlink in that cell, so that when someone clicks it, the cursor goes to cell B15.
  • Use to Go To box to go to cell C15.
  • Insert a new row before row 15.
  • Delete column D.
  • Undo the deletion of column D.
  • Color the tab of the spreadsheet blue.
  • Select cells B6 and B10.
  • Color these words red.

PRACTICE ACTIVITY 4

How much do you remember about this section?

  • Open the “Practice File 0203” workbook, which is attached as a resource to this Practice Test.
  • Hide the spreadsheet “Invoice 2”.
  • Record a macro that changes the highlighting in cell C4 from blue to yellow.
  • Change the zoom of the spreadsheet to 150%.
  • Add the “Spelling” button to the Quick Access toolbar.
  • Assign the keyboard shortcut Alt+5 to this new button.
  • Show the formulas, so you can in the spreadsheet itself the formula in cell D9.
  • Freeze the panes so that the top 7 rows are hidden and row number 8 is always displayed.
  • Go to the workbook properties and add the word “invoice” to the Categories properties.
  • Go back to the “Invoice 1” spreadsheet and change the view to Page Break Preview.
  • Split the window into two.

PRACTICE ACTIVITY 5

OK - let's see what you can now do... :-)

  • Open the “Practice File 0204” workbook, which is attached as a resource to this Practice Test.
  • Change the print area to cells from B9 to E10.
  • Change the print scale so that it will be print at 80%.
  • Change the margins so that the printout will be in the middle of the page, both horizontally and vertically.
  • Change the footer so that the date and time are included in the bottom right of the page.
  • Change the print titles so that row 8 will be repeated at the top of every page.
  • Look at the Print Preview of this page.

Student Projects