Registration Now Open!

MS Excel 2

When: Thursday, November 7, 2024 | 9:00 AM - 4:00 PM
Where: Virtual via Zoom
Price: $309 for Members and Non-Members

Course Description:

In partnership with CATAPULT Employers Association, CAGC Foundation is offering Microsoft Excel 2. This course will teach learners how to work with large worksheets in Microsoft Excel and efficiently use multiple worksheets and workbooks. It will show how to link information from different worksheets and workbooks and introduce more advanced formatting techniques, such as creating custom number formats. In addition, participants will learn how to create outlines and subtotals and create and apply cell names. They will sort, filter, consolidate, remove duplicate data, and create and format tables. Finally, they will learn how to audit worksheets for errors, and how to protect and share workbooks.

Prerequisites:

The course requires that you have successfully completed Excel 1 or had more than six months using Excel and are familiar with all Excel 1 materials.

Contents:

• Managing workbooks and worksheets
• Setting sheets up in a workbook
• Viewing large worksheets
• Printing large worksheets
• Working with multiple worksheets
• Cell and range names
• Linking worksheets
• Using multiple workbooks
• Custom number formatting
• Using and Creating special formats
• Transposing data
• Create and Modify Tables
• Creating Subtotals
• Summarizing large amounts of information
• Custom Sorting
• Filtering data
• Removing duplicate values
• Auditing features and error checking
• Comments and Notes
• Worksheet and Workbook Protection

Note: This course will be taught using the windows operating system environment.

Special Cancellation Policy:

• Cancellation 4 business days prior to start of class you are welcome to send a substitute that meets the prerequisites. No reschedules or refunds will be available.
• Any no-shows are charged the full rate.
• Only 1 participant per registration (no group-watching or forwarding links, etc. ).

Class Contact:

Caroline Brigmon, Training & Workforce Development Director

CAGC Education Refund & Cancellation Policy
a 50% refund of the original registration fee if cancellation is made 7 days prior to the event. Any cancellations less than 7 days or no shows receive no refund, substitutions are welcome. 

More Opportunities