Excel 2010 uncovered: 5 time-savers
Having got to grips with Excel 2010, lecturer David Ringstrom highlights five minor changes that have improved his efficiency in the new version. Look out for more tips next week.
1. Attention Ribbon-haters! As you may have already heard, Excel 2010 lets you tinker with the ribbon to your heart's content. Excel 2007 only allowed you to customise the Quick Access Toolbar, but if you put more than eight icons on it, you would start to wonder which icon did what. But with Excel 2010 you can change the Ribbon to include the commands you want. I was frustrated not to have a Pivot Table icon on the Data tab, but it was a simple matter to add one, as shown below.
Also covered in this introductory guide:
5. New Recover Unsaved Workbooks feature.
"Either you work Excel, or it works you!" says David Ringstrom CPA, the head of Atlanta-based software and database consultancy Accounting Advisors. He presents Excel training webcasts for AccountingWEB partner CPE Link and contributes articles on Excel to Microsoft Professional Accountant's Network newsletter. He can be reached by email at david[AT]acctadv.com.