Ten reasons to use Tables in Excel
Posted by Chris Menard on 01/10/2018
There are over 10 reasons to use Tables in Excel instead of a data range. Here are five reasons along with a training video. There is part of the free course I created for the GSCPAs.
Excel Functions for HR Professionals
Posted by Chris Menard on 10/31/2017
HR Professionals have a lot going on. Recruitment, benefits, compensation, and retention just to name a few. Here are Excel functions you should know. SHRM
Five examples of using named ranges in Excel
Posted by Chris Menard on 07/08/2017
You can use named ranges in formulas in Excel, to create a bookmark to a worksheet, and use for data validation in Excel. Chris Menard shows five examples.
Create your own custom sort in Excel
Posted by Chris Menard on 03/22/2017
Excel already has built-in custom lists for sorting, but you can create your own custom sort list in case you don't want to sort alphabetically or A to Z.