Excel Formulas & Functions

This course is all about using formulas & functions to transform basic Excel worksheets into dynamic and powerful analytics tools.

We'll cover 75+ core functions, using hands-on demos designed to showcase why they are important and how they can be applied in a variety of ways. This isn't about memorizing syntax; it's about learning how to THINK like Excel.

By the end of the course, you'll have the skills to build interactive models and dashboards, automate tedious and time-consuming tasks, and explore raw data using text functions, logical operators, time intelligence, dynamic arrays, and much, much more.

Whether you're looking to brush up on the basics or develop expert-level formula skills, you've come to the right place.

COURSE CONTENTS:

• 9.5 hours on-demand video (16.0 CPE credits)

• 9 quizzes

• 9 homework assignments

• 2 skills assessments (1 benchmark, 1 final)

COURSE CURRICULUM:

WHO SHOULD TAKE THIS COURSE?

• Analysts looking to extract insight from raw data, and develop expert-level formula skills

• Excel users who want to build interactive models or dashboards (forecasts, financial models, scenario tests, etc)

• Anyone seeking to improve productivity and work more efficiently with data

WHAT ARE THE COURSE REQUIREMENTS?

• Microsoft Excel 2013+ (ideally Office 365)

• No advance preparation is required (basic familiarity with Excel formulas recommended, but not required)

WHAT ARE THE COURSE OBJECTIVES?

• Identify basic Excel formula syntax and functionality, including reference types, errors, shortcuts, and auditing tools

• Identify and interpret logical operators and conditional statements, including the IF, AND, OR, NOT, and IFERROR functions

• Identify and interpret examples of statistical calculations, including the MAX/MIN, RANK, RAND, SUMIFS/COUNTIFS/AVERAGEIFS, and SUMPRODUCT functions

• Identify and interpret examples of joining and extracting data using lookup functions, including VLOOKUP, INDEX, MATCH, XLOOKUP, CHOOSE, and OFFSET

• Identify and interpret examples of wrangling text data using formulas, including the TEXT, LEFT/MID/RIGHT, SEARCH, TRIM, and LEN functions

• Identify and interpret examples of Excel's date handling, including the TODAY/NOW, DATEDIF, YEARFRAC, EOMONTH, WEEKDAY/WORKDAY/NETWORKDAYS functions

• Identify Excel's dynamic array functionality, including compatibility, spilled range properties, growing source data, and differences with legacy Excel

• Identify and interpret examples of dynamic array formulas, including SORT, SORTBY, FILTER, UNIQUE, SEQUENCE, RANDARRAY, FREQUENCY, TRANSPOSE, and LET

CPE ACCREDITATION DETAILS:

• CPE Credits: 16.0

• Field of Study: Information Technology

• Delivery Method: QAS Self Study

Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.

*Last Updated: December 1, 2021