Excel Reporting Expert Certificate Program (CERE) – Self-Study Online Course

There are no required prerequisites to take this course. However, we recommend beginning with the introductory course, the Excel Specialist in Accounting Certificate Program, especially if your rudimentary Excel skills need some brushing up. 

Lesson 1: Sales Manager (nominal)
Lesson 2: Travel Expenses for CFO (ranking, part-to-whole)
Lesson 3: Year-End Sales Promotion (time-series)
Lesson 4: Actual vs. Budget Presentation (deviation)
Lesson 5: We Collect 4U (distribution)
Lesson 6: Employee Surveys (correlation)
Lesson 7: Donor State Map (geospatial)
Lesson 8: Dashboard- Get and keep clients

Table/Graphic Topics include: Display type: selecting a table or graph, Chart design practices, How to feature key relationships graphically, Nominal (order not important), Ranking (order matters), Part-to-whole (contributions to whole), Time series (over time), Distribution (distributed over range), Deviation (difference), Correlation (vary in relation to each other), Geospatial (locations)

Power Query and Power Pivot Topics include: Get external data, Various transformations, including unpivot, Load to data model and table, Chain queries, Merge queries, Relationships, Measures (implicit / explicit), Various DAX functions, Date (calendar) table, Data vs lookup tables

Power BI Topics include: Getting external data, Modeling data and writing measures, Various visuals (matrix, table, column, bar, line, scatter, map), Power BI (desktop, service, mobile app), Slicers (and sync slicers)

Access to the course lasts for one year after date of purchase. Since it is self-study, learners can move at their own pace, but IOFM recommends a timeline of about 3 months to move through the material. Total learning hours for this course are estimated at 19 hours.

The self-study program (accessed via the IOFM.com E-Learning Center) is eight lessons. Each lesson is composed of a series of video lectures, Exercise Workbooks (which are Excel workbooks with hands-on exercises) and short quizzes. There is a final exam (97 questions in 90 minutes). Learners have three attempts on the final exam.

A digital PDF copy of M is for (Data) Monkey by Ken Puls and Miguel Escobar is included in the course. You can download the e-book to keep as a permanent reference.

None.

IOFM does not offer CEUs for Certification classes. We know that earning your Certification takes a lot of time! However, the nature of continuing education is that it is additional training you do after you are certified in order to keep up with the standards set by the program. Therefore, earning your credentials does not count towards your CEU requirement. If you already hold an IOFM Certification, you may count subsequent live Certification classes for 6 CEUs towards that previously-held Certification. 

Most updated version of Google Chrome, a desktop/laptop computer with a functioning speakers and a strong Internet connection. If accessing from a work computer, some companies' VPN/security settings can impede course performance (visit the Help Center for resolutions). 

Presented with Excel O365 and Power BI for Windows.

Notes: Excel for Windows O365 is the recommended version for taking this course, however, these tools are also available for legacy versions of Excel starting with Excel for Windows (2010+). Excel for Mac is not supported.

There is no continuing education requirement for this course.