What You'll Learn
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.
Accreditations
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.
You Might Also Like
On-Demand Course
Illinois Mandatory Anti-Sexual Harassment Training for Supervisors
On-Demand Course
In June of 2022, Chicago amended the Chicago Human Rights Ordinance to require that all employers in Chicago provide two hours of supervisor/management and one hour of employee sexual harassment training annually for all its employees. This change is in conjunction with the Illinois Human Rights ...
Instructor: Julie A. Proscia
299.00
Order Today
Role: HR & Business Skills
299.00
Order Today
On-Demand Course
Project Management Best Practices
On-Demand Course
Let’s face it - we are all managing projects every day! They may be simple or complicated, but undoubtedly you are managing projects within your role. You don’t need to be a project manager to learn how to manage your projects effectively and efficiently. This Course will provide some of the best...
Instructor: Cheryl Grazier
299.00
Order Today
Role: HR & Business Skills
Credits: 1.0 SHRM, 1.0 HR Certification Institute
299.00
Order Today
On-Demand Course
Advanced Microsoft® Excel® Formulas and Functions
On-Demand Course
Functions in Excel® are pre-defined formulas that perform specific calculations or actions on data. They serve as building blocks for creating dynamic and efficient formulas to manipulate and analyze your data. With hundreds of built-in functions available, Excel® offers a wide range of capabilit...
Instructor: Mike Thomas
299.00
Order Today
Role: HR & Business Skills
299.00
Order Today
Interactive
Avoiding Breakdowns in Communication
Interactive
Course Overview: Strong workplace communication is more than just exchanging information—it’s the foundation of productivity, collaboration, and trust. Poor communication, on the other hand, can lead to confusion, frustration, and costly mistakes. By honing communication skills, teams work smarte...
89.00
Order Today
Role: HR & Business Skills
Credits: 1.0 CPE/NASBA, 0.75 SHRM, 0.75 HR Certification Institute
89.00
Order Today