Quick Reference clips for Word, Excel, Outlook and PowerPoint.
Welcome Guest (.|.)
Excel 2016 Beginner Course

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 3.5: Basic Formulas

 

 

  1. Add top to bottom
  2. Add left to right
  3. Add random numbers
  4. Add subtotals
  5. Subtract top to bottom
  6. Subtract left to right
  7. Subtract randomly
  8. Subtract subtotals
  9. Multiply top to bottom
  10. Multiply left to right
  11. Multiply randomly
  12. Multiply the subtotals
  13. Divide top to bottom
  14. Divide left to right
  15. Divide numbers randomly
  16. Divide using the subtotals

 

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: Your Workbook

 

 

  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

 

 

Lesson 5.5: Headers / Footers

 

 

  1. Header - insert header
  2. Header - delete header
  3. Headers - use the Microsoft created
  4. File name and path in header
  5. Insert filename in header
  6. Insert picture in your header
  7. Insert sheet name in header
  8. Insert current time in header
  9. Insert date in your header
  10. Insert page number in your header
  11. Insert page x of y in header
  12. Insert file name and path into footer
  13. Insert page x of y in footer
  14. Insert customized footer
  15. Insert Microsoft created footers
  16. Different header footer first page

 

 

Lesson 6: Printing / Importing / Scenario Manager

 

 

  1. Print - how to set up repeating columns
  2. Print - how to set up repeating rows
  3. Remove print titles (repeating rows)
  4. Remove repeating columns
  5. Print problem #1 solved
  6. Print area set
  7. Print area clear
  8. Print area set #2
  9. Print area clear #2
  10. Print selection
  11. Print multiple copies
  12. Print problem #2 solved
  13. Print active sheet
  14. Print entire workbook
  15. Print page one only
  16. Import txt file into Excel
  17. Import a CSV into Excel
  18. Scenario Manager

 

 

Lesson 7: Advanced Formulas

 

 

  1. Multiple worksheet formula
  2. Multiple workbook formula
  3. Insert Function box explained
  4. Insert Function box
  5. Average
  6. Minimum
  7. IF formula
  8. AND formula
  9. Tip and Trick
  10. OR Formula
  11. SUMIF Formula
  12. COUNTIF Formula
  13. NOW TODAY Formula
  14. AVERAGEIF
  15. IFERROR
  16. SUMIFS
  17. COUNTIFS
  18. AVERAGEIFS

 

 

Lesson 8: Named Ranges / Pivot Table with Chart

 

 

  1. Named Ranges -explained
  2. Name a range - #1
  3. Name a range - #2
  4. Use a range in a formula - #1
  5. Use a range in a formula - #2
  6. Named range - how to rename your named range (s)
  7. Named range - how to modify or change a named rang
  8. Named range - how to delete a named range
  9. Pivot Table - how to create
  10. Pivot table chart - how to create
  11. Pivot Table Slicers - how to create and use slicer

 

 

Lesson 9: Tables

 

 

  1. Table - how to insert and create a table
  2. Table tab
  3. Table drop down arrow
  4. Table filter arrows
  5. Table banded row
  6. Table header row
  7. Table quick styles
  8. Table total row
  9. Sharepoint -export table to
  10. Table filter arrows disabled
  11. Table to no table
  12. Table create table
  13. Table insert row column
  14. Table filtering
  15. Table turn off filtering
  16. Table sort your data
  17. Table top 10 answers
  18. Table filters off
  19. Table multiple columns

top