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 7 Easy Tips Everyone Should Know
Posted by Chris Menard on 12/15/2022
Here are 7 amazing, time-saving tips or functions you need to use if you're moving from an Excel beginner to a more advanced level. I walk you through 7 ways to move data, Autosum, Autofill, ways to create tables, and more super-useful functions
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.
Liquidity Ratio using Excel
Posted by Chris Menard on 08/21/2022
Liquidity ratios determine how quickly a company can covert assets to use them to pay short-term obligations.
Excel COUNTIF Function With Wildcard Search and Cell Reference
Posted by Chris Menard on 08/18/2022
The COUNTIF function in Excel allows you to only count the number of cells that meet certain criteria. For example, the number of cells that the HR department appears in. With COUNTIF, you can do a wildcard search by using * (asterisk).