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, ...

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, ...

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 ...

Freeze Panes in Excel solves this problem completely. It locks specific rows and columns in place so they remain visible no matter where you scroll. To set it up, go to the View t ...

Business managers and owners group worksheets in Excel so that changes made to one worksheet apply automatically to all connected worksheets. When you group worksheets together, the tabs at the bottom ...

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 ...