Information Technology
Excel 2013 – Level 2
How to work with large worksheets and advanced formatting techniques. How to create outlines and subtotals. Sort and filter data. Create and format tables. Audit worksheets for errors, protect work-sheets, share and merge and track changes in a workbook.
1 Day
8 Hrs
8 Lessons
Course Objectives
Upon successful completion of this course, students will be able to create and manage more advanced techniques with Excel 2013 by using Microsoft Office Excel 2013.
Agenda
- Viewing large worksheets
- Printing large worksheets
- Working with multiple worksheets
- Linking worksheets with 3-D formulas
- Using multiple workbooks
- Linking workbooks
- Using special number formats
- Working with themes
- Other advanced formatting
- Outlining and consolidating data
- Creating subtotals
- Creating and using names
- Managing names
- Sorting and filtering data
- Working with tables
- Saving workbooks as Web pages
- Using hyperlinks
- Sharing workbooks
- Auditing features
- Comments in cells and workbooks
- Protection
- Workgroup collaboration
- Application settings
- Working with templates
FREE
Interested in course?
Course Type: Instructor Led