Students will learn the skills and concepts necessary to create charts and to use the list-management capabilities of Excel.
Lesson 1: Managing workbooks and worksheets
Viewing large worksheets
Printing large worksheets
Working with multiple worksheets
Linking worksheets with 3D formulas
Using multiple workbooks
Lesson 2: Advanced formatting
Using special number formats
Using functions to format text
Working with styles
Working with themes
Other advanced formatting
Lesson 3: Outlining and subtotals
Outlining and consolidating data
Lesson 4: Cell and range names
Creating and using names
Sorting and filtering data
Working with tables
Lesson 6: Web and Internet features
Saving workbooks as Web pages
Lesson 7: Documenting and auditing
Comments in cells and workbooks
Lesson 8:Templates and settings
Creating and managing templates
Excel Level 1
or equivalent knowledge.
|Distance Learning price|
For other prices, please contact us.
Click here to see all our courses.