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

Learn how to use pivot tables in Excel! You will also learn basic techniques for analyzing data in Excel. This is an in-person workshop sponsored by the MaxxSouth Digital Media.

If you record daily sales data in Excel, it may be impossible to explain variances from day to day. Instead, it may make more sense to summarize the data by week to spot trends and explain variations.

What are the differences between Excel Tables vs Normal Ranges? Why use tables in analytics? How do you remove duplicates from a dataset? How would you clean messy data (extra spaces, text to columns, ...

The general ledger is a vast historical data archive of your company’s financial activities, including revenue, expenses, adjustments, account balances, and often much more. The detailed transactions ...