MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MrExcel Offers Data Analytics Video Course in Conjunction with IMA


July 30, 2018 - by Bill Jelen

MrExcel Offers Data Analytics Video Course in Conjunction with IMA

In partnership with the Institute of Manageral Accountants, Bill Jelen and MrExcel have developed an online course: Data Analytics: Leveraging Excel. People can earn 3.5 hours of NASBA CPE credit by taking the course.

The two-hour course is self-study. It includes video lessons and practice spreadsheets where you can replicate functionality and test your new data analytics skills.

The course covers pivot tables, graphing, customer segnentation, what-if, regression and forecasting.

To order the course, visit: IMAnet.org.

IMA Data Analytics Leveraging Excel



Title Photo: rawpixel on Unsplash


Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.