Course Description
THis 1-day Excel 2010 Intermediate training course is intended for students who are already familiar with Excel 2010.
While the course specifically references Excel 2010, it is also suitable for students who are using earlier or later versions of Excel.
After completing this course, students will know how to:
- Link worksheets by using 3-D formulas; add a Watch window; create and manage links between workbooks; and create a workspace.
- Apply special and custom number formats; control the display of zero values; use functions to format text; create, apply, and modify styles; apply and modify themes; merge and split cells; change the orientation of data in cells; transpose data; use Paste Special operations, and add a background color and a watermark.
- Create an outline and consolidate data; create subtotals in a list; use multiple subtotal functions; and create custom views to save different sets of worksheet display and print settings.
- Define and apply cell and range names; use names in formulas; and define and apply 3-D names.
- Sort data by columns; filter data based on complex criteria and copy filtered results to another range; create, format, and name a table, and add rows and columns; and use structured references.
- Save and publish a worksheet as a Web page; insert and edit hyperlinks; publish a worksheet; and send a worksheet as an e-mail attachment.
- Format data points in charts; create combination charts and trendlines; insert sparklines; use chart templates; and add and modify drawing objects, shapes, and images.
- Use auditing features; add comments to cells and workbooks; protect a worksheet or part of a worksheet; protect the workbook structure; share, merge, and track changes in a workbook; find and remove hidden and personal data in a workbook; and mark a workbook as final.
- Change Excel’s default application settings and customize the Ribbon; work with Excel templates; and create and manage templates.
- Create a PivotTable for analyzing and comparing large amounts of data; modify the PivotTable view by using slicers to filter data and by rearranging fields; improve the appearance of a PivotTable by changing its field settings and applying a style; and create a PivotChart to graphically display data from a PivotTable.
- This course will help students prepare for the Microsoft Office Specialist exam for Excel 2010 (exam 77-882). For comprehensive certification training, students should complete the Introduction, Intermediate, and Advanced courses for Excel 2010.
Pre-requisites
Attendance at our Excel 2010 Introduction training course or equivalent experience.
Who is this course for?
For Excel users who already possess basic skills in working with any version of Excel.
Further Training
The next training course in our Excel 2010 series is Excel 2010 Advanced.
Course content
Using multiple worksheets and workbooks
Using multiple workbooks
Linking worksheets with 3-D formulas
Linking workbooks
Managing workbooks
Linking worksheets with 3-D formulas
Linking workbooks
Managing workbooks
Advanced formatting
Using special number formats
Using functions to format text
Working with styles
Working with themes
Other advanced formatting
Using functions to format text
Working with styles
Working with themes
Other advanced formatting
Outlining and subtotals
Outlining and consolidating data
Creating subtotals
Cell and range names
Creating and using names
Managing names
Creating subtotals
Cell and range names
Creating and using names
Managing names
Tables
Sorting and filtering data
Advanced filtering
Working with tables
Advanced filtering
Working with tables
Web & Sharing Features
Saving workbooks as Web pages
Using hyperlinks
Sharing workbooks
Using hyperlinks
Sharing workbooks
Advanced Charting
Chart formatting options
Combination charts
Graphical elements
Combination charts
Graphical elements
Documenting & Auditing
Auditing features
Comments in cells and workbooks
Protection
Workgroup collaboration
Comments in cells and workbooks
Protection
Workgroup collaboration
Templates & Settings
Changing application settings
Using built-in templates
Creating and managing templates
Using built-in templates
Creating and managing templates
PivotTables & PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
Using PivotChart
Rearranging PivotTables
Formatting PivotTables
Using PivotChart