| 1994-2010 ConnecTotal All rights reserved. |
What our customers say...
"Makes me comfortable
when questioning
everything!!"
"Very on track with pace of
class."
"Fantastic class. I like the
small group and hands on."
"Very patient and clear
instruction."
"This class has been a
great help in furthering my
knowledge."
"I learned a lot and
refreshed what I already
knew."
"Makes me comfortable
when questioning
everything!!"
"Very on track with pace of
class."
"Fantastic class. I like the
small group and hands on."
"Very patient and clear
instruction."
"This class has been a
great help in furthering my
knowledge."
"I learned a lot and
refreshed what I already
knew."
 |
| |
 |
| |
 |
Microsoft® Office 2010 Excel® Level 1
Upon successful completion of this course, students will be able to:
• Create basic Excel 2010 worksheets
• Perform calculations in a worksheet.
• Modify an Excel worksheet.
• Format a worksheet.
• Print the content of an Excel workbook.
• Manage an Excel workbook.
Lesson 1 Creating a Basic Excel Worksheet
1A Identify the Elements of the User Interface
1B Customize the Excel Interface
1C Work with Cells
1D Enter Data in an Excel Workbook
1E Obtain Help in Excel
Lesson 2 Performing Calculations in an Excel Worksheet
2A Create Basic Formulas
2B Calculate Cell Values with Functions
2C Copy Formulas and Functions
Lesson 3 Modifying an Excel Worksheet
3A Manipulate Data
3B Modify the Worksheet Elements
3C Search for Data in a Worksheet
3D Modify Rows and Columns
Lesson 4 Formatting an Excel Worksheet
4A Modify Fonts
4B Check for Spelling Errors
4C Apply Number Formatting
4D Add Borders and Colors to Cells
4E Align the Content in a Cell
4F Apply Cell Styles
Lesson 5 Printing Excel Workbooks
5A Set the Page Layout Options
5B Set Page Breaks
5C Print a Workbook
Lesson 6 Managing an Excel Workbook
6A Format Worksheet Tabs
6B Manage Worksheets
6C View Worksheets and Workbooks
Microsoft Office 2010 Excel Level 2
Upon successful completion of this course, students will be able to
• Use advanced formulas.
• Organize worksheet and table data using various techniques.
• Create and modify charts.
• Analyze data using PivotTables, Slicers, and PivotCharts.
• Insert and modify graphic objects in a worksheet.
• Customize and enhance workbooks and the Microsoft Office
Excel environment.
Lesson 1 Calculating Data with Advanced Formulas
1A Apply Cell and Range Names
1B Calculate Data Across Worksheets
1C Use Specialized Functions
1D Analyze Data with Logical and Lookup Functions
Lesson 2 Organizing Worksheet and Table Data
2A Create and Modify Tables
2B Format Tables
2C Sort or Filter Data
2D Use Functions to Calculate Data
Lesson 3 Presenting Data Using Charts
3A Create a Chart
3B Modify Charts
3C Format Charts
Lesson 4 Analyzing Data Using PivotTables, Slicers, and
PivotCharts
4A Create a PivotTable Report
4B Filter Data Using Slicers
4C Analyze Data Using PivotCharts
Lesson 5 Inserting Graphic Objects
5A Insert and Modify Pictures and ClipArt
5B Draw and Modify Shapes
5C Illustrate Workflow Using SmartArt Graphics
5D Layer and Group Graphic Objects
Lesson 6 Customizing and Enhancing the Excel Environment
6A Customize the Excel Environment
6B Customize Workbooks
6C Manage Themes
6D Create and Use Templates
Microsoft Office 2010 Excel Level 3
Upon successful completion of this course, students will be able to:
• Increase productivity and improve efficiency by streamlining
your workflow.
• Collaborate with others using workbooks.
• Audit worksheets.
• Analyze data.
• Work with multiple workbooks.
• Import and export data.
• Use Excel with the web.
• Structure workbooks with XML.
1 Streamlining Workflow
1A Create a Macro
1B Edit a Macro
1C Apply Conditional Formatting
1D Add Data Validation Criteria
1E Update a Workbook's Properties
1F Modify Excel's Default Settings
2 Collaborating with Others
2A Protect Files
2B Share a Workbook
2C Set Revision Tracking
2D Review Tracked Revisions
2E Merge Workbooks
2F Administer Digital Signatures
2G Restrict Document Access
3 Auditing Worksheets
3A Trace Cells
3B Troubleshoot Errors in Formulas
3C Troubleshoot Invalid Data and Formulas
3D Watch and Evaluate Formulas
3E Create a Data List Outline
4 Analyzing Data
4A Create a Trendline
4B Create Scenarios
4C Perform What-If Analysis
4D Perform Statistical Analysis with the Analysis ToolPak
5 Working with Multiple Workbooks
5A Create a Workspace
5B Consolidate Data
5C Link Cells in Different Workbooks
5D Edit Links
6 Importing and Exporting Data
6A Export Excel Data
6B Import a Delimited Text File
7 Using Excel with the Web
7A Publish a Worksheet to the Web
7B Import Data from the Web
7C Create a Web Query
8 Structuring Workbooks with XML
8A Develop XML Maps
8B Import and Export XML Data
Appendix A Microsoft Office Specialist Program
Upon successful completion of this course, students will be able to:
• Create basic Excel 2010 worksheets
• Perform calculations in a worksheet.
• Modify an Excel worksheet.
• Format a worksheet.
• Print the content of an Excel workbook.
• Manage an Excel workbook.
Lesson 1 Creating a Basic Excel Worksheet
1A Identify the Elements of the User Interface
1B Customize the Excel Interface
1C Work with Cells
1D Enter Data in an Excel Workbook
1E Obtain Help in Excel
Lesson 2 Performing Calculations in an Excel Worksheet
2A Create Basic Formulas
2B Calculate Cell Values with Functions
2C Copy Formulas and Functions
Lesson 3 Modifying an Excel Worksheet
3A Manipulate Data
3B Modify the Worksheet Elements
3C Search for Data in a Worksheet
3D Modify Rows and Columns
Lesson 4 Formatting an Excel Worksheet
4A Modify Fonts
4B Check for Spelling Errors
4C Apply Number Formatting
4D Add Borders and Colors to Cells
4E Align the Content in a Cell
4F Apply Cell Styles
Lesson 5 Printing Excel Workbooks
5A Set the Page Layout Options
5B Set Page Breaks
5C Print a Workbook
Lesson 6 Managing an Excel Workbook
6A Format Worksheet Tabs
6B Manage Worksheets
6C View Worksheets and Workbooks
Microsoft Office 2010 Excel Level 2
Upon successful completion of this course, students will be able to
• Use advanced formulas.
• Organize worksheet and table data using various techniques.
• Create and modify charts.
• Analyze data using PivotTables, Slicers, and PivotCharts.
• Insert and modify graphic objects in a worksheet.
• Customize and enhance workbooks and the Microsoft Office
Excel environment.
Lesson 1 Calculating Data with Advanced Formulas
1A Apply Cell and Range Names
1B Calculate Data Across Worksheets
1C Use Specialized Functions
1D Analyze Data with Logical and Lookup Functions
Lesson 2 Organizing Worksheet and Table Data
2A Create and Modify Tables
2B Format Tables
2C Sort or Filter Data
2D Use Functions to Calculate Data
Lesson 3 Presenting Data Using Charts
3A Create a Chart
3B Modify Charts
3C Format Charts
Lesson 4 Analyzing Data Using PivotTables, Slicers, and
PivotCharts
4A Create a PivotTable Report
4B Filter Data Using Slicers
4C Analyze Data Using PivotCharts
Lesson 5 Inserting Graphic Objects
5A Insert and Modify Pictures and ClipArt
5B Draw and Modify Shapes
5C Illustrate Workflow Using SmartArt Graphics
5D Layer and Group Graphic Objects
Lesson 6 Customizing and Enhancing the Excel Environment
6A Customize the Excel Environment
6B Customize Workbooks
6C Manage Themes
6D Create and Use Templates
Microsoft Office 2010 Excel Level 3
Upon successful completion of this course, students will be able to:
• Increase productivity and improve efficiency by streamlining
your workflow.
• Collaborate with others using workbooks.
• Audit worksheets.
• Analyze data.
• Work with multiple workbooks.
• Import and export data.
• Use Excel with the web.
• Structure workbooks with XML.
1 Streamlining Workflow
1A Create a Macro
1B Edit a Macro
1C Apply Conditional Formatting
1D Add Data Validation Criteria
1E Update a Workbook's Properties
1F Modify Excel's Default Settings
2 Collaborating with Others
2A Protect Files
2B Share a Workbook
2C Set Revision Tracking
2D Review Tracked Revisions
2E Merge Workbooks
2F Administer Digital Signatures
2G Restrict Document Access
3 Auditing Worksheets
3A Trace Cells
3B Troubleshoot Errors in Formulas
3C Troubleshoot Invalid Data and Formulas
3D Watch and Evaluate Formulas
3E Create a Data List Outline
4 Analyzing Data
4A Create a Trendline
4B Create Scenarios
4C Perform What-If Analysis
4D Perform Statistical Analysis with the Analysis ToolPak
5 Working with Multiple Workbooks
5A Create a Workspace
5B Consolidate Data
5C Link Cells in Different Workbooks
5D Edit Links
6 Importing and Exporting Data
6A Export Excel Data
6B Import a Delimited Text File
7 Using Excel with the Web
7A Publish a Worksheet to the Web
7B Import Data from the Web
7C Create a Web Query
8 Structuring Workbooks with XML
8A Develop XML Maps
8B Import and Export XML Data
Appendix A Microsoft Office Specialist Program
Division of ConnecTotal