Excel Tips & Tricks

---

About CPASelfStudy.com
	The Excel tips and tricks are grouped by subject as well as by topic to make them easier to find. I also have tips on my blog that are not yet included here.
E-Book
Video Clips
Contact
Home

By Subject Category
What's New In Excel 2007	Excel   Tips for	Have an Excel question?
	Selecting / Navigating/Copy/Move
	Formatting
	Formulas and Functions
	Charts and Pivot Tables
	What-If Analysis
	Everything that doesn't fit into the categories above

---

By Topic

• Sorting months chronologically

• Formatting Time
• Time - Functions
  

• Change display of a negative number to red with parentheses

• Round financial statements to nearest thousand

• Paste Leading Zeroes when you can't copy formulas

• Keyboard Shortcut CTRL + End

• Create a Nested Subtotal

• Create a Quick and Dirty Chart

• Selecting large areas of data at once
• Selecting non-contiguous data

• What-If Analysis with Goal Seek
• Goal Seek (video)

• Grouping Sheets Together

• IFERROR function - Excel 2007 Only
• Use If_Error - a cool new Excel feature (video)

• AND,OR,NOT function

• Lookup Wizard

• Use Functions to see if Balance Sheet In Balance

• Use the Watch Window to view changing totals

• Finding Your Way around Excel 2007

• Sort by Color- Excel 2007 only

• Remove Duplicates in Excel 2007
  sorry... I got lazy- this link takes you to Youtube to see the video there

Updated: 4/5/2010

Back
CPASelfStudy.com