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).
OneDrive - Share a Folder as Read Only | Set Expiration Date and Password
Posted by Chris Menard on 08/17/2022
One of my favorite OneDrive features is sharing a folder with Read Only permissions. This allows me to add files and folders so students or co-workers, or even clients can download the files, but they can't delete or edit the files. I can even set an expiration date and add a password.
How to SORT Data in Excel | 7 Tips
Posted by Chris Menard on 08/03/2022
Excel has a powerful SORTING engine. SORT is the most popular function in Excel, and it can sort by many types of data, many attributes, and even custom sorting configurations.
Teams Online Couse - New material added
Posted by Chris Menard on 07/31/2022
Chris Menard's Teams Online Training Course has been updated with new sections. A 50% coupon is enclosed. Master Teams - 2.5 hours of online video.
Excel - Data from Picture - Microsoft 365 New Feature
Posted by Chris Menard on 07/15/2022
Have you ever had a printed page and needed to put the data in Excel? Typing the data in can be a pain. Excel now allows you to put the data in Excel using Data from Picture.
Teams - 5 Tips for Recorded Meetings
Posted by Chris Menard on 07/06/2022
Recorded Meetings in Teams are stored in OneDrive for Work or School. The one exception is Channel Meetings are stored in SharePoint.
Excel - 3 Methods to Shade Every Other Row
Posted by Chris Menard on 07/05/2022
Highlighting or shading every other row in Excel is a great way to make your data easier to read. I'll show three methods for applying color to alternate rows.