A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you've ...

When editing a formula in a dialog box in Microsoft Excel, you might go to use the Arrow keys to move the blinking cursor to a different position. However, frustratingly and confusingly, doing this ...

Microsoft Excel is arguably the greatest spreadsheet application from Redmond, and there’s a good reason so many number crunchers use it for all of their number crunching needs. While using Microsoft ...

If you are a regular Microsoft Excel user but not quite familiar with Power Query Add-in for Excel, then this post will acquaint you and help you get started with it. Any advanced Excel user faces the ...

"We are excited to announce support for PivotTable creation and editing on iPad. PivotTables allow you to calculate, summarize, and analyze data. We have tailored this powerful tool for the iPad's ...

Although getting into the habit of naming tables in Excel can take some time if it's not something you usually do, here's why today's the day to start. First, if you're working with a large workbook ...