Microsoft Excel

Note: These virtual live Excel courses require a personal laptop or desktop computer and students should be prepared to complete coursework in an online learning lab. Email professionalworkshops@clcillinois.edu or call (847) 543-2990 to discuss if your intended technology will work!

Unsure which Microsoft level is right for you? Call (847) 543-2990 or email professionalworkshops@clcillinois.edu for help! Note: A textbook is required for each Excel class (except when noted) and may be purchased in the CLC Bookstore prior to class. Visit www.clcillinois.edu/bookstore for hours and information.

MICROSOFT EXCEL 2019: LEVEL 1

Learn to create a basic worksheet and modify the contents and appearance. You will perform calculations, modify the appearance of data within a worksheet, manage Excel workbooks and print the contents.

9010 PCTR 15-001

Monday, June 13 9 a.m. to 5 p.m. 1 Session Virtual Live $205 S. Bajt

MICROSOFT EXCEL 2019: LEVEL 2

Learn how to work faster and more productively by using many of Excel’s powerful features. Organize worksheet and table data using various techniques. Create and modify charts, work with graphic objects, calculate with advanced formulas, sort and filter data and analyze data using PivotTables, Slicers and PivotCharts. Prerequisite: Microsoft Excel Level 1 or equivalent knowledge and use of advanced formulas.

9011 PCTR 16-001

Monday, June 27 9 a.m. to 5 p.m. 1 Session Virtual Live $205 S. Bajt

Interested in IT? Check out the inside back cover to learn more about new IT bootcamps! MICROSOFT EXCEL 2019: LEVEL 3

Upon successful completion of this course, students will be able to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions and use those functions to perform rigorous analysis of extensive, complex datasets using conditional logic to construct and apply elaborate formulas. Prerequisite: Microsoft Excel Level 2 or equivalent knowledge.

9012 PCTR 17-001

Monday, July 11 9 a.m. to 5 p.m. 1 Session Virtual Live $205 S. Bajt

SPECIALIZED TRAINING IN MICROSOFT EXCEL PIVOTTABLES

In this half-day class, students will learn how to use PivotTables to selectively summarize and analyze large amounts of data. They will learn how to interact with the PivotTable data by filtering, sorting and manipulating report formats. Students will learn how use sophisticated slicers to further analyze data. They will also see how to create a chart from a PivotTable, modify the PivotTable and use a variety of options to adapt to their information needs. This analysis allows users to to answer common business questions about their data. Suggested Prerequisite: Excel 2019 Level 2

9046 PCTR 27-001

Monday, August 8 9 a.m. to 1 p.m. 1 Session Virtual Live $115 S. Bajt