Gain confidence in creating basic formulas and functions with relative and absolute references. Understand operator precedence and how it affects formulas. Learn about the different parts of a function and how to create arguments to calculate values and cell references. Excel includes common functions that can be used to quickly find the sum, average, count, maximum and minimum value for a range of cells

Learn the fundamentals of Microsoft Word in this beginner-friendly course. Explore key features including formatting text, creating documents, inserting images, and using templates. Perfect for those looking to build confidence and essential skills for personal or professional use.

Discover how Artificial Intelligence and ChatGPT can become a useful everyday tool in this hands-on introductory class. Learn how to set up an account, write effective prompts, brainstorm ideas, write and improve emails and documents, summarize information, and get help with everyday tasks. Through demonstrations and guided activities, you’ll practice using ChatGPT and learn how to refine responses, recognize its limitations, and verify information. No previous AI experience is required.

Develop your understanding of how Excel uses logic with functions like AND, OR, COUNTIF, IF, and Nested IF. Perform calculations with SUMIF, AVERAGEIF, OR COUNTIF when a specific condition is met. Use VLOOKUP and XLOOKUP to search for specific information in a table. Find out how to name cells and ranges, and then use them in formulas. Learn how to link cells within worksheets and workbooks, and how to create 3D formulas across worksheets and workbooks. Locate errors by utilizing Auditing to find precedents and dependents related to a function. Enable the Watch Window to view out of sight cells. Use Data Validation to limit the type of data that can be entered into a cell and to create a drop-down list.

Take your Microsoft Word skills to the next level in this intermediate course designed for users who are comfortable with the basics and ready to work more efficiently. Participants will explore advanced formatting techniques, styles and themes, tables, headers and footers, and document layout tools. The course will also introduce features such as track changes, comments, basic mail merge, and working with longer documents. Ideal for individuals looking to improve productivity and create more polished, professional documents for work or personal projects.

Discover how Artificial Intelligence and ChatGPT can become a useful everyday tool in this hands-on introductory class. Learn how to set up an account, write effective prompts, brainstorm ideas, write and improve emails and documents, summarize information, and get help with everyday tasks. Through demonstrations and guided activities, you’ll practice using ChatGPT and learn how to refine responses, recognize its limitations, and verify information. No previous AI experience is required.

Take your ChatGPT skills to the next level in this hands-on intermediate course. Build on the basics of prompting and explore more advanced ways to use ChatGPT for work, communication, research, and everyday productivity. Learn how to create more effective prompts, refine and improve AI-generated content, analyze and organize information, brainstorm and solve problems, and use ChatGPT to support multi-step tasks. Through demonstrations and guided activities, you’ll practice techniques for getting more accurate, useful, and tailored responses while learning how to provide context, evaluate results, and identify when additional verification is needed. Prior experience with ChatGPT or completion of an introductory AI course is recommended. 

Discover how Microsoft Copilot can become a useful everyday tool for work, learning, and productivity in this hands-on introductory class. Learn how to use Copilot to brainstorm ideas, draft and improve emails and documents, summarize information, organize tasks, and find helpful information. Through demonstrations and guided activities, you’ll practice writing effective prompts, refining responses, and using Copilot to support common workplace tasks. You’ll also learn about Copilot’s limitations, responsible AI use, and the importance of reviewing and verifying AI-generated information. No previous AI experience is required.