Issue link: http://georgiancollege.uberflip.com/i/423911
117 OL = ontaRioleaRn = online couRse = online leaRning exPeRt GeorgianCollege.ca/con-ed Professional courses 117 Excel Charts and Pivot Tables Learn how to boost output by creating charts and pivot tables to display your data visually. Charts present information in a graphic format making it easier to see patterns trends and relationships. PivotTables and PivotCharts let you summarize large quantities of data in a compact layout. Explore the relationships within your data and display your findings in an easy-to-understand format. cMpS 0012 | 6 HRS $143 loc date day time BA MAR. 2 – MAR. 9 MON 7 – 10 P.M. MI APR. 11 SAT 9 – 3:30 P.M. BA JUNE 22 MON 9 – 4 P.M. Excel Customization and Macros Learn tools and options that allow you to customize your environment and help you work as efficiently as possible including customizing the ribbons. Create validation rules and templates to ensure accuracy for data entry. Automate your worksheet by creating macros that perform frequently, use tasks rapidly and save you a great deal of time. View and analyze Visual Basic for Applications (VBA) code to understand how macros are created. cMpS 0310 | 6 HRS $143 loc date day time BA APR. 13 – APR. 20 MON 7 – 10 P.M. BA JULY 6 – JULY 13 MON 7 – 10 P.M. Excel Intermediate Create more sophisticated spreadsheets using special features such as comments, protecting cell/worksheet/workbook, manipulating multiple worksheets and workbooks using 3-D reference, and integrating with other programs. Use pictures, shapes and graphics to enhance the appearance of your workbooks. cMpS 0011 | 6 HRS $143 loc date day time BA FEB. 2 – FEB. 9 MON 7 – 10 P.M. OS FEB. 7 SAT 9 – 4 P.M. SG MAR. 27 FRI 9 – 3:30 P.M. MI APR. 4 SAT 9 – 3:30 P.M. BA JUNE 1 – JUNE 8 MON 7 – 10 P.M. SG JUNE 18 – JUNE 25 THU 6 – 9 P.M. Excel Introduction This course provides an understanding of spreadsheet essentials. Create powerful worksheets that allow you to manipulate your data. Enhance the appearance by utilizing styles and themes or apply conditional formatting based on the data displayed in the cells. Insert headers and footers before preparing to print your workbook. cMpS 0010 | 6 HRS $143 loc date day time BA JAN. 12 – JAN. 19 MON 7 – 10 P.M. BA FEB. 23 MON 9 – 4 P.M. SG MAR. 6 FRI 9 – 3:30 P.M. MI MAR. 28 SAT 9 – 3:30 P.M. MU APR. 22 – APR. 29 THU 6:30 – 9:30 P.M. BA MAY 4 – MAY 11 MON 7 – 10 P.M. SG MAY 28 – JUNE 4 THU 6 – 9 P.M. Excel Tables and Databases Control large volumes of data in an Excel table by sorting, filtering, and subtotaling. Use lookup functions to locate table entries, and apply database functions to summarize table data that meet specific criteria. cMpS 0311 | 6 HRS $143 loc date day time BA MAY 4 – MAY 11 MON 7 – 10 P.M. BA JULY 20 – JULY 27 MON 7 – 10 P.M. Microsoft Word 2010 Designed to give you the finest document formatting tools, Word 2010 not only helps you write with more efficiency, but it also helps you easily organize your documents and stay within reach so you can capture your best ideas whenever and wherever they occur. LearnKey™ expert Mandi Fiddle Bergenfeld walks you through the steps of creating professional quality documents, easier ways to work together with people, and almost anywhere access to your files. LKEY 0015 | ONLINE $181.24 Object Oriented Design Essentials This course will build skills in creating programs that use object oriented programming concepts. Throughout the course, proper program documentation using class diagrams and comments will be stressed. cMpS 0312 | 6 HRS $149 loc date day time BA APR. 14 – APR. 16 TUE – THU 6 – 9 P.M. Office Overview Microsoft Office is a set of powerful software applications. This course will show students how to use Office to create great- looking documents with Word, prepare spreadsheets and charts with Excel and keep track of data with Access. cMpS 0021 | 18 HRS $180 loc date day time SG FEB. 4 – MAR. 11 WED 6 – 9 P.M. MI FEB. 7 – FEB. 21 SAT 9 – 3:30 P.M. BA JUNE 17 – JUNE 24 WED 7 – 10 P.M. BA JULY 8 – JULY 29 WED 7 – 10 P.M. Outlook 2010 Are you a student who needs to communicate with classmates on projects and assignments? Are you an office worker who needs to keep track of project tasks and schedule events? If you answered yes to either of these questions or you have just purchased a new computer and it came with Office 2010 pre-installed then this is the course for you. The Outlook 2010 course will teach everything that you need to know to become proficient and efficient with Outlook. Learn all of the new features of Outlook and get fascinating tips and tricks that will save you time and energy when working in Outlook. Through interactive video learning, Michael Meskers brings his "plain English" approach to Outlook and we are sure you're going to love his speed keys tips. LKEY 0044 | ONLINE $181.43 COMPuTER AND INFORMATION TEChNOLOGY COuRSES (CONT.)