Microsoft Excel 2010 Intermediate Training Course

Course details

This training course for Microsoft Excel 2010 Essentials teaches participants the fundamentals of editing and deleting hyperlinks, transposing data, switching and linking workbooks, creating a workspace and 3D formulas, linking workbooks and worksheets and much more.

This Microsoft Excel 2010 Essentials training course can be delivered at your premises anywhere in Singapore by one of our expert local or international trainers.

Outcomes

After completing this course participants will be able to:

• Switch between workbooks
• Create 3-D formulas linking worksheets & workbooks
• Add a Watch window
• Create a workspace
• Use functions to format text
• Transpose data
• Add backgrounds & watermarks
• Name cells & ranges
• Sort & filter data
• Create, format and modify tables
• Use structured references in table formulas
• Calculate SUM, AVERAGE and COUNT values in filtered tables
• Insert, edit and delete hyperlinks
• Send worksheets via e-mail
• Create combination charts & trendlines
• Insert sparklines
• Use audit features
• Protect a worksheet
• Customize the Ribbon
• Download templates
• Create PivotCharts

Foreword:

• This second part in the three-part Excel 2010 training series shows the functions and features that make Excel 2010 the widely-used spreadsheet software. Participants who attend this course must have successfully completed the Excel 2010 Introduction training or have an equivalent experience on the topics of the first course.
• This Excel 2010 Intermediate training course running in Singapore wide, is rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Excel 2010: Introduction. Participants 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.
• Participants 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. Finally, participants will learn to work with PivotTables and PivotCharts.
• This course will help participants prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888). For comprehensive certification training, participants should complete the Introduction, Intermediate, and Advanced courses for Excel 2010.

Prerequisites:

• Excel 2010: Introduction or equivalent experience.

MODULES

Lesson 1 
Using multiple worksheets and workbooks

• Using multiple workbooks
• Linking worksheets with 3-D formulas
• Linking workbooks
• Managing 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
• Creating subtotals

Lesson 4 
Cell and range names

• Creating and using names
• Managing names

Lesson 5 
Tables

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

Lesson 6 
Web and sharing features

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

Lesson 7 
Advanced charting

• Chart formatting options
• Combination charts
• Graphical elements

Lesson 8 
Documenting and auditing

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

Lesson 9 
Templates and settings

• Changing application settings
• Using built-in templates
• Creating and managing templates

Lesson 10 
PivotTables and PivotCharts

• Working with PivotTables
• Rearranging PivotTables
• Formatting PivotTables
• Using PivotCharts