Save content
Have you found this content useful? Use the button above to save it to your profile.
AIA

David Carter's 2-minute Excel tips - index

by
17th Jul 2007
Save content
Have you found this content useful? Use the button above to save it to your profile.

Following the success of his popular Five Minute Pivot Table Tips, AccountingWEB consultant editor David Carter has expanded his remit to cover simple, time-saving Excel techniques that you can pick up in just a couple of minutes. If you would like to boost your spreadsheet skills, add this page to your browser favourites and drop by whenever you have a few spare moments.

2min Excel tips
Tip 1: Sort data with the =RIGHT function
Tip 2: Use & to combine two columns into one
Tip 3: Create a run-time filter when importing into Excel
Tip 4: Filter faster with the AutoFilter and Show All icons
Tip 5: How to print just a part of your worksheet
Tip 6: Add up rows and columns quickly with AutoSum
Tip 7: How to remove error messages such as #DIV/0!
Tip 8: Moving quickly through a range of cells
Tip 9: How to replace zeroes with dashes
See also:
ExcelZone's Five Minute Pivot Table Tips - Index

Subscribe to the ExcelZone newswire
To ensure you don't miss any of David Carter's handy Excel tips, click the button below to subscribe to the free fortnightly ExcelZone newswire. The subscribe function will take you back to the AccountingWEB home page after it adds your name to the subscription list.

Tags:

Replies (0)

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.