What You'll Learn
Course Overview: Unlock the power of Excel with this skill-building course designed to enhance your efficiency, accuracy, and confidence. Excel 201 — Essential Functions & Formatting takes you beyond the basics and into the practical, real-world tools that transform large datasets into meaningful insights. With short, focused lessons and a downloadable spreadsheet to follow along, you’ll learn how to work smarter—not harder—using some of Excel’s most valuable intermediate features.
Whether you need a refresher or are learning these functions for the first time, you’ll gain hands-on experience with lookup formulas, text functions, date and time calculations, conditional formatting, pivot tables, and data protection techniques. Each topic includes step-by-step demonstrations that show you exactly how to apply these tools so you can streamline your workflow and elevate your everyday Excel tasks.
Topics Covered:
- VLOOKUP and lookup formulas
- CONCAT and text functions
- Date and time calculations
- Conditional formatting
Estimated duration: 30 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