| MS Office 2007 Excel Level 1 1: Creating a Basic Worksheet 1A: Explore the User Interface and the Ribbon 1B: Navigate and Select in Excel 1C: Obtain Help 1D: Enter Data and Save a Workbook 1E: Customize the Quick Access Toolbar 2: Performing Calculations 2A: Create Basic Formulas 2B: Calculate with Functions 2C: Copy Formulas and Functions 3: Modifying a Worksheet 3A: Manipulate Data 3B: Insert and Delete Cells, Columns, and Rows 3C: Search for Data in a Worksheet 3D: Spell Check a Worksheet 4: Formatting a Worksheet 4A: Modify Fonts 4B: Add Borders and Color to Cells 4C: Change Column Width and Row Height 4D: Apply Number Formats 4E: Position Cell Contents 4F: Apply Cell Styles 5: Printing Workbook Contents 5A: Print Workbook Contents Using Default Print Options 5B: Set Print Options 5C: Set Page Breaks 6: Managing Large Workbooks 6A: Format Worksheet Tabs 6B: Manage Worksheets in a Workbook 6C: Manage the View of Large Worksheets MS Office 2007 Excel Level 2 1: Calculating Data with Advanced Formulas 1A: Manage Cell and Range Names 1B: Calculate Data Across Worksheets 1C: Use Specialized Functions 1D: Analyze Data with Logical and Lookup Functions 2: Organizing Worksheet and Table Data 2A: Create and Modify Tables 2B: Format Tables 2C: Sort or Filter Worksheet or Table Data 2D: Calculate Data in a Table or Worksheet 3: Presenting Data Using Charts 3A: Create a Chart 3B: Modify Charts 3C: Format Charts 4: Analyzing Data Using PivotTables and PivotCharts 4A: Create a PivotTable Report 4B: Analyze Data Using PivotCharts 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 6: Customizing and Enhancing Workbooks and the Excel Environment 6A: Customize the Excel Environment 6B: Customize Workbooks 6C: Manage Themes 6D: Create and Use Templates MS Office 2007 Excel Level 3 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 |
| 1994-2008 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."
 |
| |
 |
| |
 |
| |
 |
| |
 |
