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 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.
- 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