Staff Training

-

17 matches found

    • 10:00 am - 12:00 pm   Tues. morning
      5/4/2021
    • online

    In this 2 hr online workshop, participants will learn how to create and work with Access tables. We will create a table using application parts and also from scratch.  We will create a primary key and start entering data. We will work with fields in a table from adding, deleting, re-arranging to setting field properties. Finish up using lookup fields and calculated fields

    • 1:00 - 3:00 pm   Tue afternoon
      5/4/2021
    • online, link will be sent if registered by 8am

    Register for this session to learn about specific features and tips for using Outlook more productively, followed by Q&A of specific scenarios. 

    • 1:00 - 3:00 pm   Tue afternoon
      5/5/2021
    • UIUC -- location to be announced

    This 2 hour Outlook Calendar live workshop, participants will learn to schedule & edit appointments; work with calendar labels and tasks displayed on the Calendar. We will schedule with the Scheduling Assistant, practice scheduling a conference room, and discuss scheduling Online Meetings, and discuss calendar permissions.

    • 1:00 - 3:00 pm   Wed afternoon
      5/5/2021
    • online

    In this short online course you will learn how to use some of the data analysis features and tools in Excel 2016. Topics will include learning the basics of PivotTables; using subtotals in a list of data; setting up data validation rules; using Goal Seek, Solver, and Scenarios.

    • 10:00 am - 12:00 pm   Th morning
      5/6/2021
    • UIUC -- location to be announced

    • 10:00 am - 12:00 pm   F morning
      5/7/2021
    • UIUC -- location to be announced

    • 10:00 am - 12:00 pm   Tues morning
      5/11/2021
    • online

    In this 2-hour short online course, you will become familiar with the Excel 2016 interface. Topics will also include entering, editing, and formatting data in a worksheet, performing basic formulas, printing and using Help.

    • 3:00 - 4:00 pm   Wed afternoon
      5/12/2021
    • online

    Join us in a one-hour online session to learn about the basic features of Zoom. This session is aimed for first time or beginner users.

    • 10:00 am - 12:00 pm   Thurs morning
      5/13/2021
    • online

    A properly designed database makes it easier to work with up-to-date, accurate information. Investing the time required to learn the principles of good relational database design ensures that you will end up with a database that meets your needs and can easily accommodate change. This online workshop provides guidelines for planning an Access database.

    • 1:00 - 3:00 pm   Th afternoon
      5/13/2021
    • UIUC -- online

    Microsoft Teams is a communications tool available through MS Office 365. During this two-hour online workshop, we will learn how to navigate the Teams environment and communicate with others in Teams. We will practice participating in online Teams meetings, and discuss sharing screens and files during meetings. We will create a team and channels.

    • 1:00 - 3:00 pm   Tues afternoon
      5/18/2021
    • online

    In this 2-hour online course learn how to create and work with Access forms. Create a new form using the form wizard and explore layout and design view. Add and modify form controls including a calculated control and lookup control.

    • 1:00 - 3:00 pm   Wed afternoon
      5/19/2021
    • online

    In this 2-hour short course you will learn how to add, divide, multiply, and subtract by entering formulas into Excel 2016 worksheets. Other topics will include an exploration of just a few of the hundreds of functions available in Excel. We will learn how to find a specific function, as well as how to get help while entering arguments.

    • 10:00 am - 12:00 pm   Thurs. morning
      5/20/2021
    • online

    This 2-hour online class introduces the Access query object.  Topics include working in design view; creating a simple query by adding and removing fields and adding criterion. We will create multi-table queries; calculated fields and set field properties; explore a totals query, parameter query, and action queries.

    • 1:00 - 3:00 pm   Tues afternoon
      5/25/2021
    • online

    In this 2-hour online workshop we will explore the whole set of features for managing information in tables in Excel 2016. These features make all the typical tabular manipulations—sorting, filtering, analyzing, and formatting, easier than ever.

    • 10:00 am - 12:00 pm   Wed morning
      5/26/2021
    • online

    In this 2-hour online class, learn how to create a basic Access report, and explore layout and design view.  In design view add controls and set properties for those controls; learn about calculated controls, apply sort & group feature to report data, finish up with graphics (themes and conditional formatting).

    • 10:00 am - 12:00 pm   Thurs morning
      5/27/2021
    • online

    In this 2-hour online workshop, you will learn how to select data in a worksheet and work with Chart tools to customize the chart type, chart layout, and chart style that best represents the selected data. Once the chart is exactly the way you want it, we will learn how to save it as a template to use again.

    • 2:00 - 3:00 pm   Thurs afternoon
      5/27/2021
    • online

    In this new 1-hour online course, you will learn about conditional formatting of data in Excel 2016. Topics will also include applying special formatting to numbers.