Simple column charts can hide the truth of your data, but box plots tell the full story.

When I learned how to use tables in Microsoft Excel, it totally transformed how I work with data. Even if you think you already know everything there is to know about Excel tables, hopefully, you'll ...

Office Q&A: An advanced Excel filter to match multiple values and a PowerPoint picture timesaver Your email has been sent This month, Susan Harkins introduces an Excel user to advanced filtering and ...

If you use Microsoft Excel on a daily basis as a data analyst or number cruncher, learning how to use Excel’s advanced spreadsheet tools can significantly boost your productivity and efficiency in ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. Once you select the portion of your spreadsheet that contains the target data, then define it as a ...

Excel created pivot tables to improve upon its convoluted, weak reporting features (which are still available). The pivot table is actually a collection of tools that Excel uses to help you create ...

Office Q&A: Excel referencing, Word field codes, and a table trick Your email has been sent It’s been a month of easy answers for the most part. The problems seem big, but as usual, there’s an easy ...