Learn a variety of topics essential for using a computer including navigation, using the basic funtions of a Windows operating system, creating and managing files and folders, and utilizing popular software applications. No prior knowledge of computers is required.

This workshop introduces the essentials of artificial intelligence and explores how it can be thoughtfully integrated into the workplace. Participants will gain a clear understanding of AI fundamentals, uncover practical ways it can enhance productivity, and learn how to build a strong foundation for future adoption. Designed for leaders and teams at every level, this session provides the tools and confidence needed to embrace the future of work with clarity and purpose.

About the Presenters:

Jon Ballard is the founder and CEO of Foremost Media, a digital marketing and web development agency with over 20 years of experience. He’s a hands-on leader focused on integrating AI into real-world business workflows to improve efficiency, creativity, and results. Jon is passionate about helping businesses adapt to AI and speaks regularly about its role in transforming marketing, development, and operations.

Kelsey Paasch is a dynamic business consultant and organizational expert renowned for her expertise in teaching the skills needed to effectively organize and optimize business operations. As the Founder of Contour Consulting, established in August 2022, and Forward Janesville’s 2025 Entrepreneur of the Year, she is driven by a mission to provide quality training services that empower and transform individuals and organizations.

Become more familiar with what Excel can do in this introductory course. Learn how to create an Excel workbook, select and move around in a workseet, format, work with simple formulas and fuctions, create tables and charts, and explore templates

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 basics of Microsoft Word, PowerPoint, and Excel. Explore how to effectively format documents in Word, create engaging presentations in PowerPoint and how to format and use simple formulas in Excel.

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

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.

Learn how to use tables, pivot tables, and pivot charts to manage and analayze your data more effectively. Explore different ways to sort, filter, and subtotal data, as well as how to use VLookUp to search for specific information in a table. Learn how to utilize database functions within an Excel table and how to import an Acess database into Excel.