Student Skills Development

-

Tuesday, May 11, 2021

    • 10:00 am - 12:00 pm   Tues morning
    • 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.

Wednesday, May 12, 2021

    • 3:00 - 4:00 pm   Wed afternoon
    • 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.

Thursday, May 13, 2021

    • 10:00 am - 12:00 pm   Thurs morning
    • 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
    • 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.

Tuesday, May 18, 2021

    • 1:00 - 3:00 pm   Tues afternoon
    • 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.

Wednesday, May 19, 2021

    • 1:00 - 3:00 pm   Wed afternoon
    • 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.

Thursday, May 20, 2021

    • 10:00 am - 12:00 pm   Thurs. morning
    • 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.

Tuesday, May 25, 2021

    • 1:00 - 3:00 pm   Tues afternoon
    • 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.

Wednesday, May 26, 2021

    • 10:00 am - 12:00 pm   Wed morning
    • 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).

Thursday, May 27, 2021

    • 10:00 am - 12:00 pm   Thurs morning
    • 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
    • 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.