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

Microsoft Excel 2013 Beginner Course

Click a link below to get started

(click to go back)

 

 

Lesson 1: Start Here

 

 

  1. Open Excel with Windows 7
  2. Open Excel from Windows 8
  3. Workbook explained
  4. Ribbon explained
  5. File menu - explained
  6. Quick Access Toolbar
  7. Small screen larger
  8. Scroll bars
  9. QAT - add icons
  10. Excel help
  11. QAT - remove icons
  12. Open new blank worksheet
  13. Close a worksheet
  14. Data entry
  15. Close a worksheet
  16. Open a worksheet
  17. Create a basic worksheet
  18. Columns widen
  19. Save worksheet new name
  20. Save Excel file to your SkyDrive/OneDrive
  21. Open Excel file from SkyDrive/OneDrive
  22. Range select a range
  23. Tab new worksheet

 

Lesson 2: Add / Subtract Numbers - Insert columns

 

 

  1. Type text on worksheet
  2. Numbers enter
  3. Add numbers
  4. Subtract numbers
  5. Delete data
  6. Column insert
  7. Row insert
  8. Row delete
  9. Column delete
  10. Save changes
  11. Spelling check
  12. Dictionary add a word
  13. Column - widen manually
  14. Column - widen automatically
  15. Column - widen all at the same time
  16. Columns - all are the same width
  17. Row - adjust height
  18. Row - adjust height 2nd way
  19. Row - all at once height adjust
  20. Row - same height all rows

 

Lesson 3: Format Your Spreadsheet

 

 

  1. Make your text larger or smaller
  2. Column wide - make your columns wide
  3. Font change the size of your font larger or smalle
  4. Bold Italics Underline - turn on / enable
  5. Bold Italics Underline - turn off / disable
  6. Borders - add borders to your data
  7. Borders remove
  8. Font color change
  9. Yellow highlight
  10. Yellow highlight remove
  11. Fill color
  12. Fill color remove
  13. Underline double
  14. Underline double remove
  15. Merge and center
  16. Text center vertically
  17. Row adjust height - taller or more narrow
  18. Merge and center remove
  19. Column adjust width

 

 

Lesson 4: Formatting Your Worksheet

 

 

  1. Auto fill
  2. Auto fill #2
  3. Auto fill to the right
  4. Auto fill months days
  5. Find
  6. Find and replace
  7. Go to a cell
  8. Text wrap
  9. Text wrap #2
  10. Column hide
  11. Column un-hide
  12. Row hide
  13. Row un-hide
  14. Currency vs. Accounting
  15. Dollar signs
  16. Format date
  17. Format time
  18. Decimal points remove
  19. Dollar signs remove
  20. Currency - insert symbols
  21. Indent
  22. Text - align text vertically in the cell
  23. Text - angle text in the cell

 

 

Lesson 5: 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 6: Format 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 7: Printing / Importing / Scenario Manager

 

 

  1. Print repeating columns
  2. Print 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 8: 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 9: Named Ranges / Pivot Table with Chart

 

 

  1. Named Ranges -What are they and why use them?
  2. Name a range - first way to name a range
  3. Name a range - second way to name a range
  4. Use a range in a formula - first way to do this
  5. Use a range in a formula - second way to do this
  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