This virtual seminar will explore how to freeze and unfreeze cells, conditional formatting, protecting a worksheet, and many functions.  Some of these functions are commonly used and others are infrequently used. This course is designed to give you experience using different functions. We will explore how to create a multiple-sheet workbook and link the formulas between the sheets. You will learn the difference between Relative and Absolute cell referencing, Pivot Tables and Charts, and a review of Protecting a worksheet.  We will review how to use the IF and VLookup functions, as well as other reference functions.

Questions?
Contact Elaine Brown, Program Coordinator, at 508-375-5017 or ebrown@capecod.edu. 

This beginner-friendly seminar is designed to introduce students to the fundamentals of Microsoft Excel. Participants will explore the Tabs and Ribbons to become familiar with the layout and location of key commands. The course will also cover essential keyboard shortcuts and basic tools used for formatting spreadsheets. Students will learn how to create simple formulas using the Order of Operations, build basic worksheets, and generate charts to visually represent data.

No prior experience with Excel is required—just a willingness to learn and explore!

Questions?
Contact Elaine Brown, Program Coordinator, at 508-375-5017 or ebrown@capecod.edu. 

This virtual, interactive, and hands-on course is designed for users ready to deepen their Excel skills. Ideal for those who need to customize worksheets, create long-range spreadsheets, or present data visually, this session focuses on expanding your knowledge of formulas and functions, as well as working with multiple sheets and advanced data tools.

Topics will include:

• Advanced Functions in Excel
• Understanding Absolute vs. Relative Cell Referencing
• Creating and Linking Multiple Sheets in a Workbook
• Building and Customizing Charts
• Sorting and Filtering Data
• Inserting and Using Pivot Tables

Attendees are encouraged to bring current spreadsheet projects to work on in real-time with private support from the instructor.

Note: To get the most out of this Zoom-based session, it is recommended that participants use a second monitor, iPad, or tablet to view the training while working hands-on on their own computer.

Questions?
Contact Elaine Brown, Program Coordinator, at 508-375-5017 or ebrown@capecod.edu. 

Join us mid-day for a quick and practical overview of Microsoft Excel!

Designed for beginners or anyone needing a quick refresher, this 1-hour lunchtime session will guide you through the basics of creating spreadsheets and introduce a few essential keyboard commands to boost your efficiency.

Whether you prefer to watch or follow along, you'll pick up helpful tips to get started with confidence. Stick around after the session for a brief Q&A—perfect for getting your questions answered in real-time.

Questions?
Contact Elaine Brown, Program Coordinator, at 508-375-5017 or ebrown@capecod.edu. 

This beginner-friendly seminar is designed to introduce students to the fundamentals of Microsoft Excel. Participants will explore the Tabs and Ribbons to become familiar with the layout and location of key commands. The course will also cover essential keyboard shortcuts and basic tools used for formatting spreadsheets. Students will learn how to create simple formulas using the Order of Operations, build basic worksheets, and generate charts to visually represent data.

No prior experience with Excel is required—just a willingness to learn and explore!

New to Microsoft Office or need a refresher?

Microsoft Mash Basics is a beginner-friendly course designed to walk you through the essential functions of Word, Excel, and PowerPoint. You’ll learn how to navigate each program, perform common tasks, and build a solid foundation that helps you work more confidently and efficiently. Whether you're starting from scratch or brushing up on basic skills, this course will give you the tools you need to succeed.

Questions?
Contact Elaine Brown, Program Coordinator, at 508-375-5017 or ebrown@capecod.edu. 

Join us mid-day for a quick and focused overview of Microsoft Excel formulas!

In this 1-hour lunchtime session, you'll learn how to effectively and efficiently use formulas to calculate and manage numerical data. Designed for beginners and those looking to refresh their skills, this session will cover the most commonly used formulas in Excel and how to apply them in everyday work scenarios.

Whether you're watching or following along, you'll walk away with practical knowledge you can use right away. A Q&A session will follow the presentation—bring your questions!

Questions?
Contact Elaine Brown, Program Coordinator, at 508-375-5017 or ebrown@capecod.edu. 

This virtual, interactive, and hands-on course is designed for users ready to deepen their Excel skills. Ideal for those who need to customize worksheets, create long-range spreadsheets, or present data visually, this session focuses on expanding your knowledge of formulas and functions, as well as working with multiple sheets and advanced data tools.

Topics will include:

• Advanced Functions in Excel
• Understanding Absolute vs. Relative Cell Referencing
• Creating and Linking Multiple Sheets in a Workbook
• Building and Customizing Charts
• Sorting and Filtering Data
• Inserting and Using Pivot Tables

Attendees are encouraged to bring current spreadsheet projects to work on in real-time with private support from the instructor.

Note: To get the most out of this Zoom-based session, it is recommended that participants use a second monitor, iPad, or tablet to view the training while working hands-on on their own computer.

Questions?
Contact Elaine Brown, Program Coordinator, at 508-375-5017 or ebrown@capecod.edu.