Interactive

Excel 201: Essential Functions and Formatting

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. 

0.25 SHRM, 0.25 ASA 30 minutes
Included with Team Membership

About This Course

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. 

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.

Training your team?

This course is covered under team memberships.

See Team Memberships
Buying for yourself?
$ 89
Included with Team Membership
Training your team?

This course is covered under team memberships.

See Team Memberships
$ 89
per attendee