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

Are you getting all you can out of Excel? Excel has plenty of features, shortcuts, and tools that can save you time, improve the integrity of your workbooks, and simplify data analysis. Here are some ...

Up-to-date information can be critical; these 4 tips will add flexibility and increase efficiency when refreshing pivot tables. Image: Getty Images/iStockphoto PivotTable objects are only as good as ...

1. Apply percentage formatting. To quickly format a number as a percentage in Excel, highlight a cell (or cells), and press Ctrl+Shift+5. 2. Beginner tutorial. For any novice Excel user you might ...