MS Excel Level 2

Register Now →

Course Details

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. In addition, participants will learn how to create outlines and subtotals and create and apply cell names. They will sort, filter, remove duplicate data, and create and format tables. Finally, they will learn how to protect and share workbooks.  

Prerequisites: The course requires that you have successfully completed Excel I or had more than six months using Excel and are familiar with all Excel I 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.
• Custom Sorting
• Filtering data
• Removing Duplicate values
• Comments and Notes
• Worksheet and Workbook Protection

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

Ready to Advance Your Career?

Join professionals across the Carolinas who trust Catapult for professional development.

Register Now →