Corporate Training By Zack Academy - Excel 2007/2010 - Intermediate

Why Should You Take This Excel 2007/2010: Intermediate Course?

This ILT Series course builds on the skills and concepts taught in Excel 2007/2010 - Basic. Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Please note that this course in not appropriate for those students using Mac computers running the Mac version of Microsoft Office. This course is only appropriate for those using PCs running the Windows version of Microsoft Office.

The Following Topics Will Be Covered:

1. Using Multiple Worksheets and Workbooks:

• Using multiple workbooks
• Linking worksheets with 3-D formulas
• Linking workbooks
• Managing workbooks 

2. Advanced Formatting:

• Using special number formats
• Using functions to format text
• Working with styles
• 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. Tables: 

• Sorting and filtering data
• Advanced filtering
• Working with tables 

6. Web and Sharing Features:

• Saving workbooks as Web pages
• Using hyperlinks
• Sharing workbooks

7. Advanced Charting: 

• Chart formatting options
• Combination charts
• Graphical elements 

8. Documenting and Auditing:

• Auditing features
• Comments in cells and workbooks
• Protection
• Workgroup collaboration

9. Templates and Settings:

• Application settings
• Built-in templates
• Creating and managing templates

Please Note: This course is only appropriate for those using PCs running the Windows version of Microsoft Office.

Syllabus

Unit 1: Using Multiple Worksheets and Workbooks:

• Topic A: Using multiple workbooks
• Topic B: Linking worksheets with 3-D formulas
• Topic C: Linking workbooks
• Topic D: Managing workbooks

Unit 2: Advanced Formatting:

• Topic A: Using special number formats
• Topic B: Using functions to format text
• Topic C: Working with styles
• Topic D: Working with themes
• Topic E: Other advanced formatting

Unit 3: Outlining and Subtotals:

• Topic A: Outlining and consolidating data
• Topic B: Creating subtotals

Unit 4: Cell and Range Names:

• Topic A: Creating and using names
• Topic B: Managing names

Unit 5: Tables:

• Topic A: Sorting and filtering data
• Topic B: Advanced filtering
• Topic C: Working with tables

Unit 6: Web and Sharing Features:

• Topic A: Saving workbooks as Web pages
• Topic B: Using hyperlinks
• Topic C: Sharing workbooks

Unit 7: Advanced Charting:

• Topic A: Chart formatting options
• Topic B: Combination charts
• Topic C: Graphical elements

Unit 8: Documenting and Auditing:

• Topic A: Auditing features
• Topic B: Comments in cells and workbooks
• Topic C: Protection
• Topic D: Workgroup collaboration

Unit 9: Templates and Settings:

• Topic A: Application settings
• Topic B: Built-in templates
• Topic C: Creating and managing templates