Information Technology

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

Business and Information Technology

The business world is always improving with new software, systems and ways to be more effective. These courses will help give you cutting edge skills to make a positive impact on your current and future organizations.

Information Technology

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.

3964 PCTR 15-001

Wednesday, September 22 9 a.m. to 5 p.m. 1 Session University Center of Lake County, 311 $205 S. Bajt

3965 PCTR 15-002

Friday, October 29 9 a.m. to 5 p.m. 1 Session Southlake Campus, TBA $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.

3983 PCTR 16-001

Wednesday, October 6 9 a.m. to 5 p.m. 1 Session University Center of Lake County, 311 $205 S. Bajt

3984 PCTR 16-002

Friday, November 12 9 a.m. to 5 p.m. 1 Session Southlake Campus, TBA $205 S. Bajt

Featured Online Course Fundamentals of Supervision and Management

Master the basics of business by learning the language of management. Develop skills in time management, delegation, team motivation, problem-solving and conflict resolution so you can accomplish your job more effectively. http://bit.ly/SupervisionAndManagement

Questions regarding online classes? Turn to page 46 for a list of FAQs.

Interested in IT? Contact CLC’s Career and Job Placement Center at cjpc@clcillinois.edu to learn more about the IT pre-apprenticeship bridge program where you could participate in a paid learning experience. 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.

3985 PCTR 17-001

Wednesday, October 20 9 a.m. to 5 p.m. 1 Session University Center of Lake County, 311 $205 S. Bajt

3986 PCTR 17-002

Friday, December 3 9 a.m. to 5 p.m. 1 Session Southlake Campus, TBA $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 to 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 answer common business questions about their data. A textbook is required and may be purchased in the CLC bookstore prior to class.

4040 PCTR 27-001

Wednesday, November 3 9 a.m. to 1 p.m. 1 Session University Center of Lake County, 311 $115 S. Bajt