Excel 2013 Module 2 : Editing & Formatting a Worksheet Instructor : Williams , Vicki Columbia Area Career Center , Rm 135 4 / 12 / 17 - 4 / 12 / 17 We 8:00 AM - 12:00 PM $ 79 , B390.17W
Prerequisite : Module 1 or equivalent experience . Once you understand the fundamentals of Excel 2013 , increase your sophistication by creating professional looking spreadsheets . This class explains how to use several functions , including : cut , copy , paste , insert , delete , undo and spell check . Explore the use of charts , how to customize and enhance charts to fit your needs . Learn to make your worksheet easier to read with formatting options . ( 4 Hours )
Excel 2013 Module 3 : Formulas & Managing Your Workbook Instructor : Wise , Patti Columbia Area Career Center , Rm 135 4 / 17 / 17 - 4 / 19 / 17 Mo We 5:30 PM - 8:30 PM $ 79 , B391.17W
Prerequisite : Modules 1 , 2 or equivalent experience . Formulas are the heart and soul of Excel 2013 and they offer much more than just adding and subtracting . Use complex statistical , financial and scientific calculations including “ whatif ” analysis . Practice also developing formulas that reference information from several different worksheets . This will help you work with and manage several workbooks at a time . ( 2 Sessions )
Excel 2013 Module 4 : Lists , Charts & Pivot Tables Instructor : Wise , Patti Columbia Area Career Center , Rm 135 4 / 25 / 17 - 4 / 27 / 17 Tu Th 5:30 PM - 8:30 PM $ 79 , B392.17W
Prerequisite : Modules 1 , 2 , 3 or equivalent experience . Excel 2013 ’ s many useful features allow you to create lists or databases which can then be displayed through filter commands . If this isn ’ t enough , you will learn to convert table or spreadsheet numbers into dynamic charts or pivot tables that will make a picture worth a thousand words . ( 2 Sessions )
Access 2013 Module 1 : Fundamentals Instructor : Wise , Patti Columbia Area Career Center , Rm 135 5 / 2 / 17 - 5 / 2 / 17 Tu 5:30 PM - 8:30 PM $ 49 , B356.17W
Prerequisite : “ Intro to Windows ” or equivalent experience . Databases can store names , addresses and almost any other type of information you can imagine . Learn to use the database , table , form , label and report wizards to create and modify the major database objects . Practice performing simple database tasks including adding and deleting records and compacting and converting databases . ( 3 Hours )
Access 2013 Module 2 : Tables & Relational Databases Instructor : Wise , Patti Columbia Area Career Center , Rm 135 5 / 9 / 17 - 5 / 9 / 17 Tu 5:30 PM - 8:30 PM $ 49 , B357.17W
Prerequisite : Module 1 or equivalent experience . Databases are most useful when you know the strategies to find and filter information . Well-structured tables help you effectively organize information . Learn to format fields and set indexes and primary keys . Create relational databases by linking two or more tables . ( 3 Hours )
12 Page • 573-214-3803 • www . career-center . org / pce