Skip to main content
 
advanced search options ›
Last Viewed

Certificate in Mastering Excel

ID : 19463   
« back to classes page
This certificate consists of three consecutive four-week courses. Completion of the course includes required discussion board participation each week and other requirements indicated at the start of the class. This is a non-credit course. Students may earn CEU, PD, CE or Certificate of Completion at the end of the course.

Microsoft Excel software is not included in the course. The student will need to have or purchase Excel prior to starting the course. There are no additional textbook costs for this course. Course materials will be included within the online classroom. 

MASTERING MICROSOFT EXCEL
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. Stay current with this class, as it is always up-to-date and will change as the features of Excel change over time.

Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. You will leave class with a set of skills that are in high demand and will be a deciding factor in your future success.
 
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
This course will help you increase your efficiency by learning how to organize, display and calculate your data into useful information. Find out how you can consolidate your data proficiently into readable rows and columns using different table designs and styles. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Learn from the trainer on how beneficial it is to become more productive in generating different everyday business functions. Discover how easily pivot tables can be created to quickly summarize large amounts of data. Through this course, these tasks will make your work outstanding and unique in what you do.

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
We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence. 

Unit 1 Advanced Functions Used to Make Business Decisions
· Applying multiple criteria to functions
· Using And criteria
· Using Or criteria
· Using 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

Participate When You Want
You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week. There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week.

What You Will Do
For each Unit, you will:
· Access the online readings
· Listen to the audio presentation for the Unit and view the slides
· Take a self-quiz to see how much you have learned
· Engage in written online discussion with your instructor and other participants

For best learning, you should make one or more comments at 2-3 different times each day. The content (readings, audio lectures, slides) and self-quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.

Discussion
The Discussion for each Unit lasts one week. All comments are made in writing and can be made at any time of the day or night. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.

Completing the Course
Completion of class participation requirements is required to earn the Certificate of Completion, CEU and/or PD Hours at the end of the course.

Add To Cart » Send to Friend »

Class Details

Session(s)
Online 24/7

Location
NA - Online

CEUs : 4.8

 

Notice

Please read:  This course qualifies for a 50% discount through the Noncredit Workforce Grant. Call 815-224-0427 for details.

Tuition: 

$495.00

Registration Closes On
Friday, May 2, 2025 @ 11:59 PM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
2/3/2025 - 5/2/2025 Online 24/7 12:00 AM - 12:00 AM N/A - Online

Other Class Offerings

Certificate in Mastering Excel
ID: 19464

04/07/25 - 06/27/25
Online 24/7

Location
 

Instructor
John Rutledge

Add To Cart »
Send to Friend »
Certificate in Mastering Excel
ID: 21478

06/02/25 - 08/29/25
Online 24/7

Location
 

Instructor
John Rutledge

Add To Cart »
Send to Friend »

Featured Classes

You may also be interested in these classes

Recommended Classes

IVCC Continuing Education & Business Services
continuingeducation@ivcc.edu | (815) 224-0427
815 N. Orlando Smith Road
Oglesby, IL 61348
Disclaimer | Privacy Statement | Consumer Information | Copyright