Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.
Webinar on Excel Functions on 12/04/2018
Posted by Chris Menard on 12/03/2018
Webinar on Excel function on Tuesday, December 4, 2018. Functions covered will include trim, count, average, median, large, countblank, and many other functions.
Merge and Center
Posted by Chris Menard on 10/14/2018
Merge & Center in Excel is evil. I recommend you never use it. Merge & Center causes issues with sorting, removing duplicates, and selecting.
Sunburst Chart in Microsoft Excel
Posted by Chris Menard on 06/09/2018
The sunburst chart or multi-level pie chart is ideal for displaying hierarchical data. This short tutorial shows you how to create one.