Microsoft Excel

INFORMATION: (847) 543-2990 www.clcillinois.edu/professional professionalworkshops@clcillinois.edu

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!

MICROSOFT EXCEL 2019: LEVEL 1

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.

Learn to perform calculations, modify the appearance of data within a worksheet, manage Excel workbooks and print the contents. Required virtual orientation dates are at 4 p.m. on Wednesday, February 8, Wednesday, April 12 and Monday, June 12, respectively.

7704 PCTR 15-001

Thursday, February 9 9 a.m. to 5 p.m. 1 Session Virtual Live $205 S. Bajt

7705 PCTR 15-002

Thursday, April 13 9 a.m. to 5 p.m. 1 Session Virtual Live $205 S. Bajt ®SUMMER 2023

9599 PCTR 15-001

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

MICROSOFT EXCEL 2019: LEVEL 2

Learn how to 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. Required virtual orientation dates for students who did not take Microsoft Excel: Level 1 are at 4 p.m. on Wednesday, February 22, Wednesday, April 26 and Monday, June 26, respectively.

7706 PCTR 16-001

Thursday, February 23 9 a.m. to 5 p.m. 1 Session Virtual Live $205 S. Bajt

7707 PCTR 16-002

Thursday, April 27 9 a.m. to 5 p.m. 1 Session Virtual Live $205 S. Bajt ®SUMMER 2023

9600 PCTR 16-001

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

Interested in IT? Visit https://bit.ly/ITbootcamps to learn about new IT bootcamps.

Summer class registration opens March 9!

MICROSOFT EXCEL 2019: LEVEL 3

Learn to troubleshoot complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct Excel functions and use those functions to perform rigorous analysis of extensive datasets. Prerequisite: Microsoft Excel: Level 2 or equivalent knowledge. Required virtual orientation dates for students who did not take Microsoft Excel: Level 1 or 2 are at 4 p.m. on Wednesday, March 8, Wednesday, May 10 and Monday, July 10, respectively.

7708 PCTR 17-001

Thursday, March 9 9 a.m. to 5 p.m. 1 Session Virtual Live $205 S. Bajt

7709 PCTR 17-002

Thursday, May 11 9 a.m. to 5 p.m. 1 Session Virtual Live $205 S. Bajt ®SUMMER 2023

9601 PCTR 17-001

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

MICROSOFT EXCEL PIVOTTABLES

In this half-day class, students will learn how to use PivotTables to selectively summarize and analyze large amounts of data. This analysis allows users to answer common business questions about their data. Suggested prerequisite: Microsoft Excel: Level 2

®SUMMER 2023 9602 PCTR 27-001

Tuesday, July 18 9 a.m. to 1 p.m. 1 Session Virtual Live $115 S. Bajt