Microsoft Excel - Level 01 | Phillip Burton | Skillshare

Microsoft Excel - Level 01

Phillip Burton

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
20 Lessons (1h 50m)
    • 1. Creating new blank workbooks

      4:09
    • 2. Entering data

      9:02
    • 3. An introduction to fonts and highlighting

      4:23
    • 4. Saving and closing your workbook

      4:59
    • 5. Practice Activity Number 1 - The Solution

      2:27
    • 6. Creating new workbooks using templates

      6:07
    • 7. Menus and toolbars

      7:16
    • 8. Managing multiple workbooks - Excel 2013 and 2016

      4:27
    • 9. Managing multiple workbooks - Excel 2007 and 2010

      7:05
    • 10. Importing files and Opening non-native files directly in Excel

      7:59
    • 11. Adding worksheets to existing workbooks

      3:38
    • 12. Copying and moving worksheets, and changing spreadsheet order

      5:23
    • 13. Saving workbooks in alternate file formats

      6:56
    • 14. Maintaining backward compatibility

      5:41
    • 15. Saving files to remote locations

      3:15
    • 16. Using basic operators

      6:02
    • 17. Order of operations

      5:51
    • 18. How to enter numbers and dates

      3:25
    • 19. Referencing cell ranges in formulas

      10:29
    • 20. Practice Activity Number 2 - Solution

      1:26

Project Description

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

PRACTICE ACTIVITY 1

Now it's time for you to practice what you have just learned.

Here is your first Practice Activity.

Can you please do the following:

  • Create a brand new workbook.
  • Enter the following data in different cells: 3    10     40
  • Highlight the number 10 in yellow.
  • Color the number 40 in red.
  • Save the spreadsheet as My Practice Workbook.
  • Then close the workbook

Good luck.

PRACTICE ACTIVITY 2

Let's practice what you have just learned.

  • Create a new workbook, using an Invoice template.
  • Attached to these instructions as a Resource is the MusicList.txt file. Open this in Excel. You will now have two workbooks open.
  • Display both of them on the screen at the same time.
  • Add a new spreadsheet to the MusicList workbook.
  • Move this new spreadsheet tab to before the MusicList spreadsheet tab.
  • In this blank spreadsheet, enter the following values in cells A1, B1 and C1:   4     10    30
  • In cell A2, enter a formula which returns a value which is A1 to the power of 2.
  • In cell B2, enter a formula which returns a value which is double the value of cell B1.
  • In cell C2, enter a formula which subtracts 2 from the value in cell C1, then divides by 2. The answer should be 14.
  • In cell D1, enter the date the 1st of January 2019 as a date instead of as text (hint: use the / character to separate the date from the month, and the month from the year).
  • Save the workbook in Binary form (.xlsb) as My Second Practice Activity.

Student Projects