Professional Development Courses 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
MICROSOFT EXCEL 2019: LEVEL 3
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.
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.
3983
PCTR 16-001
3985
PCTR 17-001
Wednesday, October 6 9 a.m. to 5 p.m. 1 Session University Center of Lake County, 311 $205 S. Bajt
Wednesday, October 20 9 a.m. to 5 p.m. 1 Session University Center of Lake County, 311 $205 S. Bajt
3984
PCTR 16-002
3986
Friday, December 3 9 a.m. to 5 p.m. 1 Session Southlake Campus, TBA $205 S. Bajt
PCTR 17-002
Friday, November 12 9 a.m. to 5 p.m. 1 Session Southlake Campus, TBA $205 S. Bajt
SPECIALIZED TRAINING IN MICROSOFT EXCEL PIVOTTABLES
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.
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 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.
PCTR 27-001
Wednesday, November 3 9 a.m. to 1 p.m. 1 Session University Center of Lake County, 311 $115 S. Bajt
3
