Excel 2013 - Level 2
E-Learning
Description
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.
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.
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.
This course is for students to gain a farther understanding of Excel 2013.
| Lesson Id | Title | Description |
|---|---|---|
| 1 | Managing workbooks and worksheets |
Viewing large worksheets Printing large worksheets Working with multiple worksheets Linking worksheets with 3-D formulas Using multiple workbooks Linking workbooks |
| 2 | Advanced formatting |
Using special number formats Working with themes Other advanced formatting |
| 3 | Outlining and subtotals |
Outlining and consolidating data Creating subtotals |
| 4 | Cell and range names |
Creating and using names Managing names |
| 5 | Data structure and tables |
Sorting and filtering data Working with tables |
| 6 | Web and sharing features |
Saving workbooks as Web pages Using hyperlinks Sharing workbooks |
| 7 | Documenting and auditing |
Auditing features Comments in cells and workbooks Protection Workgroup collaboration |
| 8 | Application settings and templates |
Application settings Working with templates |
Self-Paced
Free
This course includes: :
Full lifetime access