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

Microsoft Excel 2010 Intermediate Course

Click a link below to get started

(click to go back)

Lesson 1: Clip Art / Pictures / Smart Art

 

 

  1. Clip Art - insert into your worksheet
  2. Clip Art - adjust the size of your
  3. Clip art change color
  4. Clip Art crop
  5. Clip Art dark / light
  6. Clip art - put a frame around it
  7. Clip art move
  8. Clip art - rotate your clip art
  9. Clip art close pane
  10. Clip Art - rese (remove all changes you have creat
  11. Clip art delete
  12. Picture - insert a picture into your spreadsheet
  13. Picture resize your picture (smaller / larger)
  14. Picture delete
  15. Delete image
  16. Shape insert
  17. Shape - change the color of a shape
  18. Smart Art
  19. Smart Art add shape
  20. Smart Art delete
  21. Organizational Chart insert
  22. Find unique value
  23. Separate text into multiple columns
  24. Paste as a value

 

Lesson 2: Tables and Other Stuff

 

 

  1. Table create
  2. Table filter on
  3. Table filter more
  4. Table filter custom
  5. Table filter custom
  6. Table multiple filter
  7. Table banded columns
  8. Table banded rows
  9. Table filter off
  10. Table filter off
  11. Top 4 results
  12. Total row
  13. Table sort
  14. Remove filter arrows
  15. Clear plain table
  16. CTRL+;
  17. Transpose
  18. Arrange multiple workbooks
  19. Switch between windows
  20. Zoom selection
  21. Wheel makes it bigger
  22. Custom lists
  23. Show / hide ribbon
  24. Add icons to quick access toolbar
  25. List drop down

 

 

Lesson 3: Conditional Formatting / Pivot Table

 

 

  1. Conditional formatting with text
  2. Conditional formatting with numbers
  3. Conditional formatting - modify it
  4. Conditional formatting remove it
  5. Conditional formatting remove it
  6. Conditional formatting Top Ten
  7. Conditional formatting remove all
  8. Pivot Table - create
  9. Pivot table - chart
  10. Pivot table - slicers
  11. Comments - insert a
  12. Comments show them
  13. Comments - change / edit
  14. Comments - hide them
  15. Comments - inspect for comments
  16. Comments - delete
  17. Call out - insert
  18. Photo - insert
  19. Picture - resize it

 

 

Lesson 4: Vlookup / Hlookup / Import / Export /

 

 

  1. Vlookup - False
  2. Vlookup - False Example #2
  3. Vlookup - False Example #3
  4. Vlookup - False Example #4
  5. Vlookup - True - Example #1
  6. Hlookup - False
  7. Hlookup - False #2
  8. Hlookup - False #3
  9. Hlookup - True
  10. Data Validation - example 1
  11. Data Validation - remove it
  12. Data Validation - example 2
  13. Data Validation - remove it
  14. Drop down list
  15. Drop down list - remove
  16. Export data to a CSV
  17. Export data to a comma delimited
  18. Import a CSV
  19. Index formula
  20. MATCH formula

 

Lesson 5: Rounding / Average / Error Messages

 

 

  1. Round - rounding to the nearest dollar amount
  2. Round up - how to round your numbers up
  3. Round - problem
  4. Round - problem #2
  5. Round - down - how to round your numbers down
  6. Round - stop rounding
  7. Average if
  8. Average if(s)
  9. Average if(s) #2
  10. Minimum - find it
  11. Maximum - find it
  12. Error Message - Division
  13. Error Message - #### signs
  14. Error Message - reference message
  15. Error Message - value error
  16. Error Message - name error message
  17. Add / Remove decimal points
  18. Decimal point shows incorrect number
  19. Amortization table the easy way
  20. IFERROR- make your own error message

 

Lesson 6: Formulas - Text

 

 

  1. Join 2 columns - join 2 columns of text with no sp
  2. LEFT formula - separate characters from the left
  3. RIGHT - formula - separate characters from the rig
  4. MID - formula - separate characters from the middl
  5. LEN - formula shows you how many characters are in
  6. FIND
  7. SUBSTITUTE - replace existing text with new text
  8. TRIM - remove empty spaces from before words
  9. Text to columns - last first
  10. Text to columns - first last
  11. Join 2 columns - with a space
  12. Text to columns - / slash
  13. Text to columns - @
  14. LOWER case
  15. UPPER case
  16. PROPER case
  17. EXACT
  18. CLEAN or TRIM
  19. CONCATENATE with space
  20. CONCATENATE no space

 

Lesson 7: Formulas - Financial

 

 

  1. PMT - find pmt of a loan
  2. PPMT - find principal of a loan
  3. IPMT - find interest of a loan
  4. Balance - find balance of loan
  5. RATE - find rate of interest
  6. PV - Present value
  7. NPER - total # of payments
  8. Investment - find future value
  9. Annuity - present value
  10. Total Paid on Loan
  11. Loan Amortization Table
  12. Compound Interest
  13. Loan Payments - diff. durations
  14. NPV - net present value
  15. IRR - Internal rate of return
  16. Future value (2nd example)
  17. FV - future value
  18. Percentage - school grades
  19. Price with percentage discount
  20. Earnings difference in percent
  21. Array Formula