# EOD - Employee & Organizational Development (formerly Staff Development) NOVEMBER Classes and Workshops

Following you will find the EOD classes for the remainder of November, 2010

• EXCEL 2007 CHARTS & PIVOT TABLES: Tips, Techniques & Shortcuts November 17, 2010 8:30 a.m.-12:00 p.m. CG2-CTTC New Horizons Trainer OVERVIEW:  Learn to better analyze and visually display your data using Excel Pivot Tables and Charts. This course covers extensive techniques, tips and shortcuts for using these powerful, but underutilized, Excel tools.  Outline - PIVOT TABLES: Creating, Sorting and Filtering data, Formatting Styles, Numbers, and Layouts, Grouping Data, Comparison and Total Options, Calculated Fields and Items, Combining Multiple Data Sources, Conditional Formatting PivotCharts. CHARTS: Creating, Modifying Design, Layout and Format, Creating Charts from Non-Consecutive Data, Drop-lines, Axis Formatting, Replacing Chart Series with Pictures or Shapes, Analysis Tools, Trending Tools, Using Secondary Axis, Highlighting Relationships Differences with Charts, and Combining Two Charts into One.
• EXCEL 2007 FORMULAS & FUNCTIONS: Tips, Techniques & Shortcuts November 17, 2010 1:00-5:00 p.m. CG2-CTTC New Horizons Trainer OVERVIEW: Formulas and Functions are the most powerful and useful features of Excel.  There are literally hundreds of different kinds of formulas and functions to use in Excel – this class will focus on some of the more cross-functional ones that can be used across all types of business to improve spreadsheet performance and business productivity. Users of both Office 2003 and Office 2007 will benefit from this class.  What are some of the best applications for Excel formulas/functions?  Date & time, mathematical, text, database, financial, informational, statistical, logic, lookup, reference functions, and nesting IF statements.
• SAFETY TRAINING FOR SUPERVISORS OF LAB/SHOP/MAINTENANCE WORKERS November 17, 2010 10:00 a.m.-12:00 p.m. FL2-1003 Facilitator: Milenda Powers, SaSS OVERVIEW: Without the benefit of safety training and oversight, well meaning individuals can find themselves in dangerous situations!  This session provides supervisors with tools and strategies for creating safe, healthy work environments.  Learn how to identify risky conditions and behaviors, develop systems and processes for managing those risks, and how to respond appropriately to accidents/injuries.
• MSOFFICE 2007 TRANSITION FROM 2003 November 18, 2010 9:00 a.m.-4:00 p.m. CG2-CTTC New Horizons Trainer OVERVIEW:  Are you new to MSOffice 2007 and struggling to locate some of the basic functions/features of Excel, Word, PowerPoint, Access, etc.? The changes from MSOffice 2003 to Office 2007 are significant to the every day user.  This session will review the various upgrade features across all the MSOffice suite of applications. Topics: GETTING STARTED: WORD-Explore the User Interface, Enhance/Save Files; Create Professional-Looking Documents, Apply a Cover Page, Add Building Blocks, Compare Reviewed Documents; EXCEL: Enhance Your Spreadsheets, Organize Data, Formatting, Formulas, Present Data; POWERPOINT: Create Dynamic Presentations, Custom Slide Layouts, Enhance Presentations with Graphic Effects, Customize Slide Shows, ACCESS: Create a TableDesign, a Form Layout, Query a Database, Generate Reports, Work with External Data, OUTLOOK: Quick review of Outlook 2007 updated functions features. More indepth information available by attending specific application classes available in the EOD Training Catalog.
• JAVASCRIPT: Enhancing Web Pages November 30, 2010 8:30 a.m.-4:30 p.m. CG2-CTTC New Horizons Trainer OVERVIEW: Learn to add various JavaScript tools to enhance your web site designs. Topics Include: JavaScript: The What, Where, and How, Investigating JavaScript, Effects, Entering JavaScript into a Web Page, Handling Errors. JavaScript Basics: JavaScript’s Built-in Objects, Event Handling, Functions and Variables. Object References, Control Structures, Code Formatting, and Web Page Navigation with the Select Object. Interactive Images: Swapping Images in Response to onClick Event, Image Rollovers, Automating Dynamic Image Swapping. Dynamic Styles and Positioning: Dealing with Browser Differences, Changing Styles. Dynamic Styles & Positioning: Dynamic Positioning¾Another Way. Windows and Frames: Creating Frames, Changing Contents of a Frame, Loading pages into New Windows.Form Data Verification: Processing Form Elements: An Overview Validating Data with Functions, Calculating Numeric Values, Scripting onSubmit and onReset Events.
• INTERVIEWING SKILLS FOR SUPERVISORS November 30, 2010 10:00 a.m.-12:00 p.m. FL2-1003 Facilitator: Michelle Darveau, HR OVERVIEW: Learn tools and skills to conduct successful interviews. Topics include: UCAR's Hiring Process; Goals of the interview; Tone of the interview; Appropriate questions; Behavioral questions; Probing questions; Effective listening skills;  Documentation; Group or team interviews; Following-up.

To register, and for more information, visit the EOD Training Catalog via Connect: https://www.fin.ucar.edu/hrisConnect/employee.

Will this event be webcast to the public by NCAR|UCAR?:
No
Announcement Timing:
November 4, 2010 to November 6, 2010