Note: For the best experience, we recommend using a dual-screen setup or two computers.

What to Expect

This is a hands-on, interactive workshop designed for true beginners—no prior Excel experience required. Instead of watching passive lectures, you will build clean, functional spreadsheets from scratch alongside your instructor. Step-by-step, you’ll learn how to format professional worksheets, automate basic calculations, use core functions like SUM and AVERAGE, set up dropdown menus, and quickly sort and filter data to complete real-world office tasks.

Level 1 – Introduction – Learn Basics

• Format, Layout & Design New Spreadsheets
• Merged Cells
• Basic Conditional Formatting
• Build Basic Dropdown Selections in Cells
• Basic Formulas
• Percent Calculations
• The FILL Handle
• Calculations: Formulas and Functions (SUM, AVERAGE, COUNT, COUNTA, MAX, MIN)
• Sorting & Filtering Data

Prerequisites

• Basic computer skills, including saving and locating files, and proficiency with a basic calculator

About the Session

• Software Used: Microsoft Excel 365
• Course Materials: We do not provide physical manuals, but you are welcome to keep all practice files to use as an excellent refresher after class.