Have you found this content useful? Use the button above to save it to your profile. David Carter's series of Five Minute Tips aims to develop your skill at using Excel pivot tables. To test these ...

I have a pivot table in Excel 2003, which contains a dropdown list in the table header that is based on a column of dates. If the underlying table of dates is first populated out of order then the ...

As we are all aware excel is widely used for accounting and financial purposes. In the past they were used only to perform basic moths, such as adding, multiplying, subtracting and dividing. Today’s ...

If you want to be a true spreadsheet power user, you need to learn about the Power Query and Power Pivot features in Excel. While you can get a lot done with Excel alone, using these built-in “Power” ...

Excel’s pivot tables are powerful tools for data analysis, but their true potential is unleashed when you combine data from multiple sheets. By harnessing the power of Excel’s advanced features, you ...

(Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she’s learned ...