Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.
SUMIFS Function in Excel
Posted by Chris Menard on 08/25/2019
The SUMIFS function will sum numbers based on one or more criteria. It is superior to the SUMIF function.
Getting Started with IF functions in Excel
Posted by Chris Menard on 04/23/2019
The IF function is one of the most useful and popular functions in Excel. We will use IF with absolute cell reference in this exercise.
Covert date to fiscal quarter in Excel
Posted by Chris Menard on 01/27/2019
In Excel, to calculate the fiscal quarter that starts with a month other than January, use the CHOOSE function.
We will look at fiscal years starting in July, October, and then April in this exercise.
COUNTIF Function in Excel
Posted by Chris Menard on 12/17/2018
One of the most powerful functions in Excel is the COUNTIF function. It counts the cells that meet a certain criteria.
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.