Excel Charts vs PivotCharts | Comparison | Which is Best?
Posted by Chris Menard on 04/08/2022
Which is best in Excel? Classic CHARTS or PIVOTCHARTS? In today's Excel video, I show you both ways of creating charts in Excel, show you step by step what's involved in each method and which one is the most flexible, powerful and which one I prefer.
Excel Distinct Count with a PivotTable
Posted on 03/31/2022
PivotTables in Excel can create a Distinct Count. An example of a distinct count is we had five orders in one day, but three orders were placed by the same customer. I want to know we have five orders from three customers.
Excel Five Great Tips for Filtering Data
Posted by Chris Menard on 12/06/2021
Five great filtering tips for Excel. Filter by selected cells value, copy and paste filtered data, delete filtered data, auto-calculate works with filtered data, and search for filtered data.
Excel - Create a custom list to sort data
Posted by Chris Menard on 12/03/2021
Excel makes it easy to sort using built-in custom lists, you can sort data—either by days of the week or months of the year. I'll demonstrate how to create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically.
How To Show Percentages In Stacked Column Chart In Excel
Posted by Chris Menard on 11/21/2021
With a stacked column chart in Excel, you can view partial numbers, but what do you do when you want to show percentages? Excel's pie charts show percentages, but stacked column charts do not. We are going to use a mixed reference to create a column chart with percentages.
Subtotal Command in Excel - automatically calculate subtotals and grand totals
Posted by Chris Menard on 11/03/2021
The Subtotals Command will automatically calculate subtotals and grand totals in a list for a column. Subtotals come with an automatic outline in Excel. The outline will show 1, 2, and 3 to the left of column A. I have three rules I follow before I use Subtotals - 1) Save 2) Sort and 3) Subtotal. You can also do multiple Subtotals.
Excel NOW Function | Excel One Minute Quick Reference
Posted by Chris Menard on 10/31/2021
The NOW function in Excel returns the current date and time. The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.