Microsoft Excel 2016 Beginner Course

Click a link below to get started

(click to go back)

 

Lesson 1: The Basics

1. Excel 2016 - open Excel
2. Ribbon - show / hide
3. Excel - basics explained
4. Excel - type text
5. Excel - Enter vs. Tab key
6. Excel - saving for the 1st time
7. Excel - new / pre-created file
8. Excel - Columns wider
9. Excel - type numbers
10. Excel - add numbers
11. Excel - add numbers (#2)
12. Excel - add numbers left to right
13. Excel - subtract numbers
14. Excel - multiply numbers
15. Excel - divide numbers
16. Excel - insert / rename tabs / sheets
17. Excel - save information

 

Lesson 2: Format Your Spreadsheet

1. Bold Italics Underline
2. Quick Access Toolbar - move below ribbon
3. Quick Access Toolbar - add /remove icons
4. Borders - add borders to your data
5. Select and highlight your data
6. Font - change the
7. Font - change color
8. Font - change size
9. Underline your data
10. Strike through your data
11. Copy and paste
12. Move data / cut and paste
13. Normal vs Page Layout view
14. Printing - fix it with page break preview
15. Print preview before printing

 

Lesson 3: Advanced Formatting

 

1. Dollar signs - apply to your data
2. Percentage signs - apply to your data
3. Commas - apply to your data
4. Decimal points - remove them
5. Text alignment
6. Vertical text alignment
7. Text - angle your text
8. Merge cells into one cell
9. Merge your title
10. Text wrap in a cell
11. Text - many lines in one cell
12. Columns - insert / delete
13. Rows - insert / delete
14. Date - change how it looks
15. Time - change how it looks
16. Currency vs. Accounting format

 

Lesson 4: Formulas

 

1. Formulas explained
2. Formulas - using them
3. Addition
4. Addition WARNING
5. SUM - explained
6. Addition Subtraction Multiplication Division
7. Order of operations
8. Auto sum
9. Average
10. Now
11. Today
12. Auto name
13. Function Library
14. Insert Function box
15. Insert Function box #2
16. Copy a formula
17. Concatenation
18. Text to columns
19. Relative cell reference
20. Absolute cell reference
21. Evaluate a Formula
22. Export Excel to a Text File
23. Goal Seek
24. Group Outline Structure

Lesson 5: Format Your Workbook / Import Text File or CSV File

 

 

1. Rename a worksheet in your Excel workbook
2. Delete a worksheet from your Excel Worksheet
3. Insert a new worksheet
4. Tab color
5. Move worksheet
6. Move worksheet #2
7. Copy a worksheet
8. Copy worksheet to new book
9. Move worksheet to new book
10. Switch open windows
11. Arrange multiple workbooks
12. Hide a worksheet
13. Zoom into an area
14. Zoom #2
15. Hide formula bar
16. Hide row headings
17. Hide or show the gridlines
18. Freeze row (pane)
19. Freeze columns
20. Change margins
21. Page orientation change
22. Margins change
23. Paper change size
24. Picture insert background pic
25. Import txt file into Excel
26. Import a CSV into Excel
27. Scenario Manager

top