Excel 301: Advanced Functions and Automation
About This Course
Working with complex data doesn’t have to feel overwhelming. In this module, you’ll learn how to transform large, unwieldy spreadsheets into dynamic, automated tools that save time and elevate the accuracy of your work.
Topics covered in this course will include:
- Text, Date, & Nested Functions
- Index + Match
- Analysis & Data Tools (IF and SUMIF)
- Automation & Macros
By the end of this course, you’ll know how to leverage Excel’s advanced capabilities to create faster, cleaner, and more effective workflows.
Estimated Duration: 30-45 minutes
*This course does NOT qualify, nor meet the National Standard for NASBA accreditation.
CPE & Accreditation
This course qualifies for 0.25 SHRM, 0.25 ASA. Your certificate and transcript are available immediately upon completion.
View accreditation details Hide accreditation details
ASA (American Staffing Association)
This program may qualify for $hours continuing education hour(s) towards maintaining your ASA credential. Please contact ASA for more information at certification@americanstaffing.net. Please retain proof of attendance in the event your CE record is audited.
Requesting CE:
Upon completion of this course, please email
creditrequest@nogginguru.com
to obtain a CE certificate.
SHRM (Society for Human Resource Management)
BankersHub/Noggin Guru Inc. is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM. This program is valid for the PDC(s) listed to the right of this page for the SHRM-CP or SHRM-SCP.
Requesting CE:
Upon completion of this course, please email
creditrequest@nogginguru.com
to obtain a CE certificate.
This course is covered under team memberships.
See Team Memberships