- UCAR Home
- About Us
- For Staff
Below you will find the January offerings of classes, seminars and training available - details and registration information at: EOD Training Catalog: https://www.fin.ucar.edu/hrisConnect/employee.
EXCEL 2010 CHARTS & PIVOT TABLES: Tips/Techniques/Shortcuts January 19, 2012 8:00 am – 12:00 pm; CG2-CTTC Facilitator: New Horizons Instructor 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.
EXCEL 2010 FORMULAS & FUNCTIONS January 19, 2012 1:00 pm – 5:00 pm; CG2-CTTC Facilitator: New Horizons Instructor 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.
INTERVIEWING SKILLS FOR HIRING SUPERVISORS January 24, 2012 1:30 pm – 3:30 pm; ML-Damon Room Facilitator: Michelle Darveau Learn tools, skills and strategies 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.
ACCESS 2010 LEVEL 1 (2 day) January 25 & 26, 2012 9:00 am – 4:00 pm; CG2-CTTC Facilitator: New Horizons Instructor Learn the basic functions & features of Access to create and modify relational databases. EXPLORING THE ACCESS 2010 ENVIRONMENT: Concepts, User Interface and Ribbon, Customizing; DESIGNING A DATABASE: Process & Purpose, Review Data, Grouping, Relationships; BUILDING A DATABASE: Create/Manage Databases &Tables; Relationships, MANAGING DATA: Modify/Sort Table Data & Subdatasheets; QUERIES & FILTERS; DESIGNING/MODIFYING FORMS; GENERATING REPORTS: Create/Customize/Format/Print Reports; CONTROLLING DATA: Field Properties; JOINING TABLES: Query Joins, Unrelated Tables; FORM DESIGN/LAYOUT: Appearance, Restrictions, Command Buttons, SubForms; CUSTOMIZING REPORTS: Organize, Format; SHARING DATA: Export, Analyze, Merge with other applications.
DRUPAL FOR WEB DEVELOPERS January 31, 2012 9:00 am – 4:00 pm; CG2-CTTC Facilitator: Carl Wiedemann Learn to use the Drupal Content Managing System (CMS) to build dynamic, interactive websites. A CMS requires you to think differently about how you build a website. In this full-day class, participants will dive into the tools Drupal provides to web developers to build the design, structure, and functionality of a website as well as how it enables content creation for a broader variety of non-technical staff. Drupal is highly extensible via a vast offering of modules and participants will practice using some of the most useful ones on their own Drupal server, with hands-on experience creating content types, views, menus, blocks, sections, as well as customizing a theme. At the end of this class, participants will have the knowledge needed to begin building a vibrant, dynamic website in Drupal!
SUPERVISORY SKILLS: THE BASICS January 31, 2012 9:00 am – 4:00 pm; CG1 - South Auditorium Facilitator: Jennifer York Learn important skills and tools to help your staff strive for continued improvement and achieve results. Topics include: Reviewing UCAR supervisor/manager competencies; Maximizing employee performance; Exploring models for task and priority management; Motivating a diverse workforce; Setting and communicating expectations; Defining and practicing effective feedback strategies; Recognizing work-style differences among employees; Capitalizing on employee engagement; Enhancing listening skills for mutual understanding; Managing effectively through difficult situations; Identifying strategies to support, and develop employees.