Computer Classes   

Knowledge of Introduction to Microsoft Excel (CE9099) recommended. Topics focus on review of conditional functions to process information, Pivot tables for report creation, charts to visualize data, and conditional formatting to identify trends in data sets based on user-defined rules. Various data sets will be used. ONE DAY WORKSHOP. Bring lunch.

Knowledge of Intermediate Microsoft Excel (CE9138) recommended. Topics cover the match and retrieve 'vlookup' function, name ranges to label and access data sets, macros to automate steps, and nested 'IF' functions to leverage more complex function usage. Various examples and data sets will be used. ONE DAY WORKSHOP. Bring lunch.

Participants should have knowledge of MS Excel or have taken Formulas and Charts I (CED9 572). Create more advanced formulas in Excel, including the 'If' function, applying absolute referencing to cells that will remain constant, grouping worksheets together, creating formulas for all grouped worksheets, and creating and filtering data lists. Creating and editing charts and linking Microsoft Excel to other Microsoft applications will also be discussed. ONE-DAY WORKSHOP.

This workshop will teach the background and usage of generative Artificial Intelligence. Overview of generative AI, installing AI on own computer, knowing the usage of prompts, and some advantages and disadvantages of having this type of AI. A great way to seek answers without being monitored by anyone but yourself giving privacy in your own home. Topics will be covered on both the Windows and Macbook Pro systems. What better way to get into and understand the workings of AI if you haven't yet. This workshop is a lecture/demonstration only delivered via Zoom. ONE DAY WORKSHOP.