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:

Mastering Microsoft Excel
Intermediate Excel
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 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 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

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.

Sections

OE-62110b-ugc-S26

Starts Mon, Apr 6th 2026 12:01 AM - 11:59 PM

Online

Price: $495.00 Min Age 18 yr.

Enroll Now