AGC Construction Education & Safety Training - January-June 2017

Software Training MICROSOFT EXCEL® 2013, BEGINNER Recommended for anyone who hasn’t worked with formulas or charts before, or those with little to no experience with Excel. It’s also a great refresher course for those who haven’t used Excel in a while. Learn how to navigate the Excel user interface (Tabs, Ribbons, & Quick Access Toolbar). Learn keyboard shortcuts to speed up various tasks. Create, Open, Close, Save, Preview, and Print a spreadsheet. Use AutoSum to add numbers. Understand cell references in formulas, and how to perform basic calculations. Use formulas to add, subtract, multiply, and divide numbers, calculate percentages. Learn how to AutoFill (copy) Formulas. Much of the class will be devoted to creating formulas. DATE JANUARY 17, 2017 MARCH 14, 2017 MAY 9, 2017 TIME 9:00 AM - 3:00 PM 9:00 AM - 3:00 PM 9:00 AM - 3:00 PM MEMBER $175 $175 $175 JUP $0 $0 $0 NON MEMBER INSTRUCTOR $275 DOUGLAS BUSH $275 DOUGLAS BUSH $275 DOUGLAS BUSH MICROSOFT EXCEL® 2013, INTERMEDIATE Create more complex formulas using Absolute Cell References (address that won’t change when you copy the formula), and the Order of Operations. Combine data from different sheets located within the same workbook (file). Link data from different workbooks (files). Use Validation to improve speed and accuracy of data entry, set limits on what can be entered, add drop-down lists and pop-up explanation boxes. Use Pivot Tables and Pivot Charts to analyze large spreadsheets. Use Conditional Formatting to make critical data stand out by changing the appearance of values (negative numbers turn red) or cell background colors (background of cells with highest numbers turn green). DATE JANUARY 24, 2017 MARCH 21, 2017 MAY 16, 2017 TIME 9:00 AM - 3:00 PM 9:00 AM - 3:00 PM 9:00 AM - 3:00 PM MEMBER $175 $175 $175 JUP $0 $0 $0 NON MEMBER $275 $275 $275 INSTRUCTOR DOUGLAS BUSH DOUGLAS BUSH DOUGLAS BUSH COURSE SERIES: BEGINNER & INTERMEDIATE MICROSOFT EXCEL® 2013 DATE TIME JANUARY 17 & 24, 2017 9:00 AM - 3:00 PM MARCH 14 & 21, 2017 9:00 AM - 3:00 PM MAY 9 & 16, 2017 9:00 AM - 3:00 PM MEMBER $325 $325 $325 JUP $0 $0 $0 NON MEMBER $425 $425 $425 INSTRUCTOR DOUGLAS BUSH DOUGLAS BUSH DOUGLAS BUSH PREREQUISITE: Basic knowledge of the windows environment, basic keyboard skills LOCATION: AGC SAN DIEGO TRAINING FACILITY The Associated General Contractors of America, San Diego Chapter, Inc. 25

AGC Construction Education & Safety Training - January-June 2017 | Page 25