# 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: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

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.
• 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.

33 KB

258 bytes

226 KB