Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.
Excel - Convert Seconds to Minutes and Seconds - Watch Chris Work!
Posted by Chris Menard on 01/14/2023
Frequently we have data in one format but need to convert it to another. Today's example is I have a column on seconds for the length of videos. I want to show minutes and seconds with a colon in between the minutes and seconds.
TOP 5 Excel Features Released in 2022
Posted by Chris Menard on 01/12/2023
Microsoft keeps rolling out awesome new features for M365 users. Many of the new features hit Excel in 2022. This video covers my top five favorite features in Excel from 2022.
Excel - Turn on Multiple Filters in a PivotTable
Posted on 11/21/2022
Filter in PivotTables only allows one filter by default. To filter by more than one field, you need to turn on the PivotTable Option - Totals and Filters tab and check Allow multiple filters per field.
PivotTables - 3 Annoying Things FIXED!
Posted by Chris Menard on 11/16/2022
PivotTables are one of the best features in Excel. PivotTables allow you to summarize, analyze and chart complex data. There are 3 annoying things in PivotTables that users always ask me about.
Excel Chart Maps used with the Geography Data Type
Posted by Chris Menard on 11/13/2022
Combine the Geography Data type with a Chart Map. The Geography Data type is located on the Data tab, and Chart Map is on the Insert tab with the other chart types.
Excel Images - Two New Features - IMAGE function and Data from Image
Posted by Chris Menard on 10/28/2022
Excel has two new image-related features coming out. In this video, a preview of my teaching session at ASAP (American Society of Administrative Professionals) Virtual Event in November, I walk you through these two new Excel functions.
Excel Image Function
Posted by Chris Menard on 10/04/2022
The new Excel IMAGE function enables you to insert images into cells with a formula. This great function allows you to sort, filter, and rearrange images.