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