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

Microsoft Excel 2010 Beginner Course

Click a link below to get started

(click to go back)

Lesson 1: Start Here

 

 

  1. Open Excel from Win 7 Vista
  2. Open Excel from Win XP
  3. Screen explanation
  4. Enter text
  5. Type numbers
  6. Open new book
  7. Create basic workbook
  8. Delete information
  9. Help
  10. File menu - explained
  11. Save backwards compatible
  12. All backwards compatible
  13. Open previous file
  14. Open previous file 2
  15. Recent workbooks
  16. Recent places
  17. Recent workbooks removed
  18. Recent workbooks

 

 

Lesson 2: Formulas: Basics

 

 

  1. Formula - addition
  2. Formula - subtraction
  3. Formula - multiplication
  4. Formula - division

 

 

Lesson 3: Saving

 

 

  1. Scroll bars
  2. Save vs. Save as
  3. Save information
  4. Save changes
  5. Row insert
  6. Row delete
  7. Microsoft templates
  8. Microsoft templates (more)
  9. Microsoft templates (more)
  10. Microsoft Templates 4
  11. Templates on your PC
  12. Quick Access Toolbar
  13. QAT - remove icons
  14. Ribbon
  15. Select range
  16. Spell check
  17. Subtraction
  18. Text box insert
  19. Undo

 

Lesson 4: Format Your Worksheet

 

 

  1. Merge and center your title across the worksheet
  2. Merge and center your title across the worksheet 2
  3. Currency Dollar vs. Account Dollar Formatting
  4. Dollar signs
  5. Auto fill
  6. Auto fill months days
  7. Bold italics underline
  8. Border
  9. Change text angle
  10. Color your sheet
  11. Column hide / unhide
  12. Columns wider
  13. Font dialog box
  14. Font dialog box 2
  15. Font style
  16. Row hide
  17. Row adjust height
  18. Months repeat
  19. Days repeat
  20. Days sequential
  21. Years sequential`
  22. Numbers sequential

 

Lesson 5:

Worksheet customize it / Remove duplicates

 

 

  1. Add new sheet
  2. Delete sheets
  3. Move sheet
  4. Move sheet different
  5. New sheet add
  6. Page orientation
  7. Hide sheet
  8. Rename sheet
  9. Tab colors
  10. Freeze rows
  11. Unfreeze rows
  12. Freeze first column
  13. Freeze first column turn off
  14. SharePoint
  15. Copy sheet
  16. Copy sheet to other
  17. Insert function explained
  18. Workspace
  19. Budget create
  20. Time sheet create
  21. Find Duplicates - same column
  22. Find Duplicates - different sheets
  23. Find Duplicates - different workbooks
  24. Find Duplicates - multiple columns
  25. Duplicates remove

 

Lesson 6: Formatting

 

 

  1. Columns - widen columns when you get #### s
  2. Columns - how to insert columns in your sheet
  3. Columns - how to delete columns from your sheet
  4. Months - make months repeat automatically
  5. Days - make the days repeat automatically
  6. Sequential numbering - automatically apply sequenc
  7. Auto fill
  8. Copy data
  9. Go to cell
  10. Move data
  11. QAT add icons
  12. Navigate
  13. Dictionary add
  14. Find a word or phrase
  15. Find and replace
  16. Text alignment
  17. Wrap text
  18. Inspect document

 

 

Lesson 7: Charts and Graphs

 

 

  1. Chart - create a chart by selecting your data
  2. Create - create a chart with the shorcut key F11
  3. Chart - add labels so your audience can know what
  4. Chart - put the chart and data on same sheet
  5. Axis = add titles to your x and y axis
  6. Colors - change chart colors
  7. Chart change type
  8. Colors change chart
  9. Context tabs chart
  10. Font chart color change
  11. Title - give a chart a
  12. Title chart horizontal
  13. Chart move chart to new page
  14. Legend move legend from one area to another

 

 

Lesson 8: Formulas

 

  1. Formulas - why use them
  2. SUM
  3. Multiplication
  4. DIVISION
  5. AutoSum
  6. Add numbers to find total
  7. Addition
  8. Formula complex
  9. NOW
  10. Function Library
  11. Function Library 2
  12. Formula bar explained
  13. Absolute cell reference
  14. Formulas hide
  15. Unhide formulas
  16. # of work days in month
  17. Subtotal while filtering
  18. DDB
  19. ISPMT
  20. PMT (Payments)
  21. PMT (2nd example)
  22. VDB
  23. Average
  24. Largest number
  25. RIGHT
  26. Alt+=
  27. Separate text into multiple columns
  28. MATCH (with Text using zero)

 

Lesson 9: Printing / Solve printing problems

 

 

  1. Do not print gridlines
  2. Print the gridlines
  3. Print the active sheet
  4. Choose which printer
  5. Print entire workbook
  6. Print more than one copy
  7. Set the print area
  8. Clear print area
  9. Printing problems solved
  10. Print only the selected data
  11. Repeat columns
  12. Remove repeat rows

 

 

Lesson 10: Header / Footer / Macros / Hyperlinks

 

 

  1. Header_and_footer
  2. Insert file name and path
  3. Header_and_footer remove
  4. Date: format it differently
  5. Date: format it differently (2)
  6. Time: format it differently
  7. Margins: change them
  8. Repeat titles -
  9. Switch between open sheets
  10. View multiple workbooks
  11. Creating a workspace
  12. Macros: create a macro
  13. Permission to run a macro
  14. Run a macro
  15. Assign a button to your macro
  16. Delete a macro
  17. Hyperlink - create to the Internet
  18. Hyperlink - to a different sheet
  19. Hyperlink - create to an email
  20. Change your hyperlink
  21. Delete your hyperlink