2018 User Group Info

31st Annual PCS User Group Meeting
June 4-7, 2018

PCS is excited to announce that Spindustry will be providing Microsoft Excel training at the 31st Annual User Group Meeting. Spindustry is the leading provider of comprehensive Microsoft training services. In this one-day focused training, Spindustry will be providing instructor-led hands-on training for Microsoft Excel.  Excel is used commonly across the business world and will benefit any participant.   The training will be broken into two sessions.  The morning session will be a beginner’s session for those new to Excel or just wanting to learn a few tricks.  The afternoon session will be for the more advanced users.  Each session will be hands-on, and each participant will need to provide a laptop with Office 7 or higher. The classes will be held at the Boulders Conference Center in Denison.  

The cost for the class will be $200 per participant whether you attend one or both sessions.

Excel Beginning - Tips & Tricks to Create a Spreadsheet

Monday, June 4th 9:00 am – 12:00 pm

This class has something for everyone. If you are new to Excel or looking for Tips & Tricks! 

  • Customize the Quick Access Toolbar, Pin documents, become familiar with the Ribbon
  • Create, Save, Open and Print workbooks
  • Learn tips to modify, navigate and edit a worksheet
  • Work with formatting features to wrap text in a cell, center cells across a selection and clear formatting from cells
  • Use the AutoFill Feature and the AutoFill SmartTags
  • Work with multiple worksheets to insert, delete, rename and copy worksheets
  • Work with large worksheets to keep the column headings always visible, print the column headings on multiple pages, sort a list of data
  • Build a basic formula using cell references and create formulas using functions

12:00 pm – 1:00 pm         Lunch on your own

Excel Intermediate – Working with Formulas, Tables and Charts

Class to be held at 1:00 pm, Monday, June 4, 2018

  • Formulas and Basic Functions
    • Building Formulas
    • Understanding the Order of Operation
    • Building Functions using AutoSum, Average, Max, Min
    • Absolute vs Relative Cell References
  • Intermediate Formulas-
    • Naming Ranges
    • Using Logical Functions – IF statement
    • Using Lookup Functions – VLOOKUP, MATCH
  • Analyze data in a List
    • Sort, Filter and Subtotal
  • Work with the Table Feature
    • build, sort and filter lists of information using the Table feature
    • Add data to a Table
    • Use the Total button
  • Work with Pivot Tables
    • create a PivotTable report
    • Set Number Formats
    • Update a PivotTable
    • Add Slicers to a PivotTable