Certificate in Mastering Excel (Online at your own pace)

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world.Begin with learning how an Excel worksheet is constructed, populated with content, and edited for delivery. Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks. Then, increase your efficiency by learning how to organize, display and calculate your data into useful information. Identify different types of data and how data can be best visually represented or formatted, by using different data tool techniques. Finally, you’ll learn a variety of Excel’s most powerful features to analyze data quickly and easily. This Certificate will help you discover how to attractively visualize your data into meaningful information with confidence.

Students must have Microsoft Excel installed to complete this certificate.

Courses must be taken in order:

  1. Mastering Microsoft Excel
  2. Intermediate Excel
  3. Advanced Excel   

Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ


Class Details:

Mastering Microsoft Excel
Unit 1: Excel From The Ground Up
    Why businesses use Excel for spreadsheet management
    Technical requirements to use Excel (and all Office modules)
    Launch Excel and create your first Excel worksheet
    Discover how to protect and save your document
    Set your document’s Properties and Attributes including Subject, Title and Author
Unit 2: Excel Document Creation
    Explore the different parts of the Excel worksheet and document navigation
    Understand cells and their makeup
    Learn how to populate, format and merge cells
    Create multiple worksheet “workbooks”
    Learn how to insert comments and check spelling
Unit 3: Advanced Features and Functionality
    Create and manage formulas and functions
    Filter and sort tables and data
    Create “live” connections between multiple worksheets
    Create effective and informative table and charts
Unit 4: Excel Management and Sharing
    Create meaningful file names and understand filing systems to manage Excel documents
    Organize your documents on your hard drive and learn how to copy and move documents
    Manage track changes when co-authoring documents
    Printing and PDF file creation including setting print areas
    Learn how to export Excel tables and charts to PowerPoint presentations and Word documents
    Use Outlook to send Excel worksheets and workbooks to other users
Intermediate Excel
Unit 1: Organizing Worksheet and Table Data
    Introduction to tables
    Formatting tables using table styles
    Using formulas in tables
    Sorting and Filtering table data
Unit 2: Understanding Popular Excel Functions
    Understanding Named Ranges
    Applying business functions
    Creating functions that handle text
    Performing basic lookup functions
    Creating functions that work with dates and times
Unit 3: Improving Worksheet Appearance
    Formatting cells in worksheets
    Correcting common function errors
    Creating and using templates
    Customizing Excel toolbar
Unit 4: Analyzing Data Using Data Validation and Pivot Tables
    Understanding how to convert text to columns
    Understanding how to analyze spreadsheet data
    Understanding the basic pivot table layout and key terms
    Creating and formatting simple pivot tables

Advanced Excel
Unit 1: Advanced Functions Used To Make Business Decisions
    Applying multiple criteria to functions
    Using And criteria
    Using Or criteria
    Using And and Or and Not criteria
    Advanced Logical functions
    Using If -Then control statements
    Implementing If functions with Aggregate functions
Unit 2: Functions Used to Make Financial Decisions
    Learning basic financial functions
    Applying functions to perform loan calculations
    Computing loan payments
    Computing interest rate
    Computing number of payment periods
    Computing present value of a loan
    Working with additional functions
Unit 3: Applying Different Scenarios Using Excel Data Tools
    Understanding Different What-If Analysis Tools
    Performing What-If Analysis to see how data changes outcomes in formulas
    Using Scenario Manager
    Using Data Tables
    Using Goal Seek
    Applying rules to manage cell data
    Implement validation rules to avoid invalid entries
    Entering validation rules
    Avoiding duplicate data entries
Unit 4: Powerful Tools Used to Complete Data Implementation and Analysis
    Exporting and Importing Data into Workbook
    Protecting a workbook
    Making improved business decisions using pivot tables
    Creating an Excel Dashboard to visually display relevant data

Elizabeth Flanagan
Elizabeth Flanagan

Instructor

View Elizabeth Flanagan's Other Courses

Elizabeth Flanagan co-founded WorkStrengths.com because she is passionate about helping individuals and companies leverage their talent to achieve their leadership potential, develop professional capabilities, and maximize effectiveness. She is results-oriented and pragmatic, drawing on 20+ years experience in executive positions within large Fortune 500 corporations and top-tier venture-funded startups – all of which gives her a broad perspective on the unique challenges workers and leaders face today.

Elizabeth holds an AB from Harvard University, cum laude, and an MBA from University of Virginia. In addition, she is a frequent speaker on the topic of Leadership Development and Gallup's CliftonStrengths (StrengthsFinder).
Amy Klous
Amy Klous

Instructor

Amy Klous completed a BA in Entrepreneurship and an MBA. She has nearly 20 years experience in marketing and the majority of that time was spent working for corporations using Excel to analyze sales and industry data. Her Excel students appreciate the hands-on learning and Amy’s patient teaching style. Amy runs a marketing advising + training business where she helps overwhelmed small businesses feel comfortable and understand how to market their business effectively.

John Rutledge
John Rutledge

Instructor

With over 25 years’ experience in the IT field, John Rutledge has a BA in Psychology and a Diploma in Computer Programming as well as having received numerous certifications and awards. He holds a Microsoft Office Master Certification and has a globally-recognized ICDL (International Computer Driver’s License) certification as well. John was the Manager of a Technical Support Desk for a multinational for several years. Prior to that, he held roles as Project Lead on a national software implementation project, Systems Analyst and Programmer Analyst. Currently the owner of an IT Consultancy firm, John works regularly with businesses of all sizes to assist them in understanding and managing their data.

OE-62110d-ugc
Online registration is over
12:01 - 11:59 AM
Su
M
Tu
W
Th
F
Sa
Online
Price: $495.00 Min Age 18 yr.
Enroll Now
Instructors:
  • Elizabeth Flanagan
  • Amy Klous
  • John Rutledge
DateTimeLocation
Tue, Sep 2nd 2025 12:01 - 11:59 AM Online
Wed, Sep 3rd 2025 12:01 - 11:59 AM Online
Thu, Sep 4th 2025 12:01 - 11:59 AM Online
Fri, Sep 5th 2025 12:01 - 11:59 AM Online
Sat, Sep 6th 2025 12:01 - 11:59 AM Online
Sun, Sep 7th 2025 12:01 - 11:59 AM Online
Mon, Sep 8th 2025 12:01 - 11:59 AM Online
Tue, Sep 9th 2025 12:01 - 11:59 AM Online
Wed, Sep 10th 2025 12:01 - 11:59 AM Online
Thu, Sep 11th 2025 12:01 - 11:59 AM Online
Fri, Sep 12th 2025 12:01 - 11:59 AM Online
Sat, Sep 13th 2025 12:01 - 11:59 AM Online
Sun, Sep 14th 2025 12:01 - 11:59 AM Online
Mon, Sep 15th 2025 12:01 - 11:59 AM Online
Tue, Sep 16th 2025 12:01 - 11:59 AM Online
Wed, Sep 17th 2025 12:01 - 11:59 AM Online
Thu, Sep 18th 2025 12:01 - 11:59 AM Online
Fri, Sep 19th 2025 12:01 - 11:59 AM Online
Sat, Sep 20th 2025 12:01 - 11:59 AM Online
Sun, Sep 21st 2025 12:01 - 11:59 AM Online
Mon, Sep 22nd 2025 12:01 - 11:59 AM Online
Tue, Sep 23rd 2025 12:01 - 11:59 AM Online
Wed, Sep 24th 2025 12:01 - 11:59 AM Online
Thu, Sep 25th 2025 12:01 - 11:59 AM Online
Fri, Sep 26th 2025 12:01 - 11:59 AM Online
Sat, Sep 27th 2025 12:01 - 11:59 AM Online
Sun, Sep 28th 2025 12:01 - 11:59 AM Online
Mon, Sep 29th 2025 12:01 - 11:59 AM Online
Tue, Sep 30th 2025 12:01 - 11:59 AM Online
Wed, Oct 1st 2025 12:01 - 11:59 AM Online
Thu, Oct 2nd 2025 12:01 - 11:59 AM Online
Fri, Oct 3rd 2025 12:01 - 11:59 AM Online
Sat, Oct 4th 2025 12:01 - 11:59 AM Online
Sun, Oct 5th 2025 12:01 - 11:59 AM Online
Mon, Oct 6th 2025 12:01 - 11:59 AM Online
Tue, Oct 7th 2025 12:01 - 11:59 AM Online
Wed, Oct 8th 2025 12:01 - 11:59 AM Online
Thu, Oct 9th 2025 12:01 - 11:59 AM Online
Fri, Oct 10th 2025 12:01 - 11:59 AM Online
Sat, Oct 11th 2025 12:01 - 11:59 AM Online
Sun, Oct 12th 2025 12:01 - 11:59 AM Online
Mon, Oct 13th 2025 12:01 - 11:59 AM Online
Tue, Oct 14th 2025 12:01 - 11:59 AM Online
Wed, Oct 15th 2025 12:01 - 11:59 AM Online
Thu, Oct 16th 2025 12:01 - 11:59 AM Online
Fri, Oct 17th 2025 12:01 - 11:59 AM Online
Sat, Oct 18th 2025 12:01 - 11:59 AM Online
Sun, Oct 19th 2025 12:01 - 11:59 AM Online
Mon, Oct 20th 2025 12:01 - 11:59 AM Online
Tue, Oct 21st 2025 12:01 - 11:59 AM Online
Wed, Oct 22nd 2025 12:01 - 11:59 AM Online
Thu, Oct 23rd 2025 12:01 - 11:59 AM Online
Fri, Oct 24th 2025 12:01 - 11:59 AM Online
Sat, Oct 25th 2025 12:01 - 11:59 AM Online
Sun, Oct 26th 2025 12:01 - 11:59 AM Online
Mon, Oct 27th 2025 12:01 - 11:59 AM Online
Tue, Oct 28th 2025 12:01 - 11:59 AM Online
Wed, Oct 29th 2025 12:01 - 11:59 AM Online
Thu, Oct 30th 2025 12:01 - 11:59 AM Online
Fri, Oct 31st 2025 12:01 - 11:59 AM Online
Sat, Nov 1st 2025 12:01 - 11:59 AM Online
Sun, Nov 2nd 2025 12:01 - 11:59 AM Online
Mon, Nov 3rd 2025 12:01 - 11:59 AM Online
Tue, Nov 4th 2025 12:01 - 11:59 AM Online
Wed, Nov 5th 2025 12:01 - 11:59 AM Online
Thu, Nov 6th 2025 12:01 - 11:59 AM Online
Fri, Nov 7th 2025 12:01 - 11:59 AM Online
Sat, Nov 8th 2025 12:01 - 11:59 AM Online
Sun, Nov 9th 2025 12:01 - 11:59 AM Online
Mon, Nov 10th 2025 12:01 - 11:59 AM Online
Tue, Nov 11th 2025 12:01 - 11:59 AM Online
Wed, Nov 12th 2025 12:01 - 11:59 AM Online
Thu, Nov 13th 2025 12:01 - 11:59 AM Online
Fri, Nov 14th 2025 12:01 - 11:59 AM Online
Sat, Nov 15th 2025 12:01 - 11:59 AM Online
Sun, Nov 16th 2025 12:01 - 11:59 AM Online
Mon, Nov 17th 2025 12:01 - 11:59 AM Online
Tue, Nov 18th 2025 12:01 - 11:59 AM Online
Wed, Nov 19th 2025 12:01 - 11:59 AM Online
Thu, Nov 20th 2025 12:01 - 11:59 AM Online
Fri, Nov 21st 2025 12:01 - 11:59 AM Online
Sat, Nov 22nd 2025 12:01 - 11:59 AM Online
Sun, Nov 23rd 2025 12:01 - 11:59 AM Online
Mon, Nov 24th 2025 12:01 - 11:59 AM Online
Tue, Nov 25th 2025 12:01 - 11:59 AM Online
Wed, Nov 26th 2025 12:01 - 11:59 AM Online
Thu, Nov 27th 2025 12:01 - 11:59 AM Online
Fri, Nov 28th 2025 12:01 - 11:59 AM Online
OE-62110b-ugc
Online registration is over
12:01 - 11:59 AM
Su
M
Tu
W
Th
F
Sa
Online
Price: $495.00 Min Age 18 yr.
Enroll Now
Instructors:
  • Elizabeth Flanagan
  • Amy Klous
  • John Rutledge
DateTimeLocation
Mon, Apr 7th 2025 12:01 - 11:59 AM Online
Tue, Apr 8th 2025 12:01 - 11:59 AM Online
Wed, Apr 9th 2025 12:01 - 11:59 AM Online
Thu, Apr 10th 2025 12:01 - 11:59 AM Online
Fri, Apr 11th 2025 12:01 - 11:59 AM Online
Sat, Apr 12th 2025 12:01 - 11:59 AM Online
Sun, Apr 13th 2025 12:01 - 11:59 AM Online
Mon, Apr 14th 2025 12:01 - 11:59 AM Online
Tue, Apr 15th 2025 12:01 - 11:59 AM Online
Wed, Apr 16th 2025 12:01 - 11:59 AM Online
Thu, Apr 17th 2025 12:01 - 11:59 AM Online
Fri, Apr 18th 2025 12:01 - 11:59 AM Online
Sat, Apr 19th 2025 12:01 - 11:59 AM Online
Sun, Apr 20th 2025 12:01 - 11:59 AM Online
Mon, Apr 21st 2025 12:01 - 11:59 AM Online
Tue, Apr 22nd 2025 12:01 - 11:59 AM Online
Wed, Apr 23rd 2025 12:01 - 11:59 AM Online
Thu, Apr 24th 2025 12:01 - 11:59 AM Online
Fri, Apr 25th 2025 12:01 - 11:59 AM Online
Sat, Apr 26th 2025 12:01 - 11:59 AM Online
Sun, Apr 27th 2025 12:01 - 11:59 AM Online
Mon, Apr 28th 2025 12:01 - 11:59 AM Online
Tue, Apr 29th 2025 12:01 - 11:59 AM Online
Wed, Apr 30th 2025 12:01 - 11:59 AM Online
Thu, May 1st 2025 12:01 - 11:59 AM Online
Fri, May 2nd 2025 12:01 - 11:59 AM Online
Sat, May 3rd 2025 12:01 - 11:59 AM Online
Sun, May 4th 2025 12:01 - 11:59 AM Online
Mon, May 5th 2025 12:01 - 11:59 AM Online
Tue, May 6th 2025 12:01 - 11:59 AM Online
Wed, May 7th 2025 12:01 - 11:59 AM Online
Thu, May 8th 2025 12:01 - 11:59 AM Online
Fri, May 9th 2025 12:01 - 11:59 AM Online
Sat, May 10th 2025 12:01 - 11:59 AM Online
Sun, May 11th 2025 12:01 - 11:59 AM Online
Mon, May 12th 2025 12:01 - 11:59 AM Online
Tue, May 13th 2025 12:01 - 11:59 AM Online
Wed, May 14th 2025 12:01 - 11:59 AM Online
Thu, May 15th 2025 12:01 - 11:59 AM Online
Fri, May 16th 2025 12:01 - 11:59 AM Online
Sat, May 17th 2025 12:01 - 11:59 AM Online
Sun, May 18th 2025 12:01 - 11:59 AM Online
Mon, May 19th 2025 12:01 - 11:59 AM Online
Tue, May 20th 2025 12:01 - 11:59 AM Online
Wed, May 21st 2025 12:01 - 11:59 AM Online
Thu, May 22nd 2025 12:01 - 11:59 AM Online
Fri, May 23rd 2025 12:01 - 11:59 AM Online
Sat, May 24th 2025 12:01 - 11:59 AM Online
Sun, May 25th 2025 12:01 - 11:59 AM Online
Mon, May 26th 2025 12:01 - 11:59 AM Online
Tue, May 27th 2025 12:01 - 11:59 AM Online
Wed, May 28th 2025 12:01 - 11:59 AM Online
Thu, May 29th 2025 12:01 - 11:59 AM Online
Fri, May 30th 2025 12:01 - 11:59 AM Online
Sat, May 31st 2025 12:01 - 11:59 AM Online
Sun, Jun 1st 2025 12:01 - 11:59 AM Online
Mon, Jun 2nd 2025 12:01 - 11:59 AM Online
Tue, Jun 3rd 2025 12:01 - 11:59 AM Online
Wed, Jun 4th 2025 12:01 - 11:59 AM Online
Thu, Jun 5th 2025 12:01 - 11:59 AM Online
Fri, Jun 6th 2025 12:01 - 11:59 AM Online
Sat, Jun 7th 2025 12:01 - 11:59 AM Online
Sun, Jun 8th 2025 12:01 - 11:59 AM Online
Mon, Jun 9th 2025 12:01 - 11:59 AM Online
Tue, Jun 10th 2025 12:01 - 11:59 AM Online
Wed, Jun 11th 2025 12:01 - 11:59 AM Online
Thu, Jun 12th 2025 12:01 - 11:59 AM Online
Fri, Jun 13th 2025 12:01 - 11:59 AM Online
Sat, Jun 14th 2025 12:01 - 11:59 AM Online
Sun, Jun 15th 2025 12:01 - 11:59 AM Online
Mon, Jun 16th 2025 12:01 - 11:59 AM Online
Tue, Jun 17th 2025 12:01 - 11:59 AM Online
Wed, Jun 18th 2025 12:01 - 11:59 AM Online
Thu, Jun 19th 2025 12:01 - 11:59 AM Online
Fri, Jun 20th 2025 12:01 - 11:59 AM Online
Sat, Jun 21st 2025 12:01 - 11:59 AM Online
Sun, Jun 22nd 2025 12:01 - 11:59 AM Online
Mon, Jun 23rd 2025 12:01 - 11:59 AM Online
Tue, Jun 24th 2025 12:01 - 11:59 AM Online
Wed, Jun 25th 2025 12:01 - 11:59 AM Online
Thu, Jun 26th 2025 12:01 - 11:59 AM Online
Fri, Jun 27th 2025 12:01 - 11:59 AM Online
OE-62110a-ugc
Online registration is over
12:01 - 11:59 AM
Su
M
Tu
W
Th
F
Sa
Online
Price: $495.00 Min Age 18 yr.
Enroll Now
Instructors:
  • Elizabeth Flanagan
  • Amy Klous
  • John Rutledge
DateTimeLocation
Mon, Feb 3rd 2025 12:01 - 11:59 AM Online
Tue, Feb 4th 2025 12:01 - 11:59 AM Online
Wed, Feb 5th 2025 12:01 - 11:59 AM Online
Thu, Feb 6th 2025 12:01 - 11:59 AM Online
Fri, Feb 7th 2025 12:01 - 11:59 AM Online
Sat, Feb 8th 2025 12:01 - 11:59 AM Online
Sun, Feb 9th 2025 12:01 - 11:59 AM Online
Mon, Feb 10th 2025 12:01 - 11:59 AM Online
Tue, Feb 11th 2025 12:01 - 11:59 AM Online
Wed, Feb 12th 2025 12:01 - 11:59 AM Online
Thu, Feb 13th 2025 12:01 - 11:59 AM Online
Fri, Feb 14th 2025 12:01 - 11:59 AM Online
Sat, Feb 15th 2025 12:01 - 11:59 AM Online
Sun, Feb 16th 2025 12:01 - 11:59 AM Online
Mon, Feb 17th 2025 12:01 - 11:59 AM Online
Tue, Feb 18th 2025 12:01 - 11:59 AM Online
Wed, Feb 19th 2025 12:01 - 11:59 AM Online
Thu, Feb 20th 2025 12:01 - 11:59 AM Online
Fri, Feb 21st 2025 12:01 - 11:59 AM Online
Sat, Feb 22nd 2025 12:01 - 11:59 AM Online
Sun, Feb 23rd 2025 12:01 - 11:59 AM Online
Mon, Feb 24th 2025 12:01 - 11:59 AM Online
Tue, Feb 25th 2025 12:01 - 11:59 AM Online
Wed, Feb 26th 2025 12:01 - 11:59 AM Online
Thu, Feb 27th 2025 12:01 - 11:59 AM Online
Fri, Feb 28th 2025 12:01 - 11:59 AM Online
Sat, Mar 1st 2025 12:01 - 11:59 AM Online
Sun, Mar 2nd 2025 12:01 - 11:59 AM Online
Mon, Mar 3rd 2025 12:01 - 11:59 AM Online
Tue, Mar 4th 2025 12:01 - 11:59 AM Online
Wed, Mar 5th 2025 12:01 - 11:59 AM Online
Thu, Mar 6th 2025 12:01 - 11:59 AM Online
Fri, Mar 7th 2025 12:01 - 11:59 AM Online
Sat, Mar 8th 2025 12:01 - 11:59 AM Online
Sun, Mar 9th 2025 12:01 - 11:59 AM Online
Mon, Mar 10th 2025 12:01 - 11:59 AM Online
Tue, Mar 11th 2025 12:01 - 11:59 AM Online
Wed, Mar 12th 2025 12:01 - 11:59 AM Online
Thu, Mar 13th 2025 12:01 - 11:59 AM Online
Fri, Mar 14th 2025 12:01 - 11:59 AM Online
Sat, Mar 15th 2025 12:01 - 11:59 AM Online
Sun, Mar 16th 2025 12:01 - 11:59 AM Online
Mon, Mar 17th 2025 12:01 - 11:59 AM Online
Tue, Mar 18th 2025 12:01 - 11:59 AM Online
Wed, Mar 19th 2025 12:01 - 11:59 AM Online
Thu, Mar 20th 2025 12:01 - 11:59 AM Online
Fri, Mar 21st 2025 12:01 - 11:59 AM Online
Sat, Mar 22nd 2025 12:01 - 11:59 AM Online
Sun, Mar 23rd 2025 12:01 - 11:59 AM Online
Mon, Mar 24th 2025 12:01 - 11:59 AM Online
Tue, Mar 25th 2025 12:01 - 11:59 AM Online
Wed, Mar 26th 2025 12:01 - 11:59 AM Online
Thu, Mar 27th 2025 12:01 - 11:59 AM Online
Fri, Mar 28th 2025 12:01 - 11:59 AM Online
Sat, Mar 29th 2025 12:01 - 11:59 AM Online
Sun, Mar 30th 2025 12:01 - 11:59 AM Online
Mon, Mar 31st 2025 12:01 - 11:59 AM Online
Tue, Apr 1st 2025 12:01 - 11:59 AM Online
Wed, Apr 2nd 2025 12:01 - 11:59 AM Online
Thu, Apr 3rd 2025 12:01 - 11:59 AM Online
Fri, Apr 4th 2025 12:01 - 11:59 AM Online
Sat, Apr 5th 2025 12:01 - 11:59 AM Online
Sun, Apr 6th 2025 12:01 - 11:59 AM Online
Mon, Apr 7th 2025 12:01 - 11:59 AM Online
Tue, Apr 8th 2025 12:01 - 11:59 AM Online
Wed, Apr 9th 2025 12:01 - 11:59 AM Online
Thu, Apr 10th 2025 12:01 - 11:59 AM Online
Fri, Apr 11th 2025 12:01 - 11:59 AM Online
Sat, Apr 12th 2025 12:01 - 11:59 AM Online
Sun, Apr 13th 2025 12:01 - 11:59 AM Online
Mon, Apr 14th 2025 12:01 - 11:59 AM Online
Tue, Apr 15th 2025 12:01 - 11:59 AM Online
Wed, Apr 16th 2025 12:01 - 11:59 AM Online
Thu, Apr 17th 2025 12:01 - 11:59 AM Online
Fri, Apr 18th 2025 12:01 - 11:59 AM Online
Sat, Apr 19th 2025 12:01 - 11:59 AM Online
Sun, Apr 20th 2025 12:01 - 11:59 AM Online
Mon, Apr 21st 2025 12:01 - 11:59 AM Online
Tue, Apr 22nd 2025 12:01 - 11:59 AM Online
Wed, Apr 23rd 2025 12:01 - 11:59 AM Online
Thu, Apr 24th 2025 12:01 - 11:59 AM Online
Fri, Apr 25th 2025 12:01 - 11:59 AM Online
Sat, Apr 26th 2025 12:01 - 11:59 AM Online
Sun, Apr 27th 2025 12:01 - 11:59 AM Online
Mon, Apr 28th 2025 12:01 - 11:59 AM Online
Tue, Apr 29th 2025 12:01 - 11:59 AM Online
Wed, Apr 30th 2025 12:01 - 11:59 AM Online
Thu, May 1st 2025 12:01 - 11:59 AM Online
Fri, May 2nd 2025 12:01 - 11:59 AM Online