As an Excel pro, I could use the old Excel 2003 menus with my eyes closed. I knew where commands were located. I knew the Alt shortcut keys for the commands that I used frequently. Alt+E+S+V was Edit, ...

Constants: This is the fastest way to audit a spreadsheet for errors. It finds every cell that contains a manually typed ...

Do you like menus? Menus tend to be overlooked in the desire to show every possible option at once in a toolbar or palette, but the nice thing about a menu is that its there when you need it and out ...

The new Analysis ToolPak is designed for complex statistical and engineering work. However, it’s not turned on by default so you need to activate it yourself when you want to use it. Go to the main ...

Have you heard of Power Query in Microsoft Excel but always thought that it's only intended for Excel experts? Let me stop you there because, actually, Power Query is designed to be user-friendly and, ...

If you work with a lot of superscripts and subscripts in Office (both the 2004 or 2008 versions of the suite), you can make your job easier by adding the superscript and subscript buttons to the ...

Overview: Microsoft's update to Excel intends to improve the way this spreadsheet app analyzes the numbers it crunches. Like the rest of the Office 12 system, Excel 12 places a host of functions ...

Shortcut keys can allow you to work more quickly and efficiently in the Microsoft Excel program, allowing you to type quick keyboard combinations to perform tasks. The Excel program allows you to ...