| 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 MS Office 2007 Excel Level 4 Performance-Based Objectives Upon successful completion of this course, students will be able to: forecast data using functions. analyze data using the data analysis tools in Microsoft Office Excel 2007. make investment decisions using the financial functions in Microsoft Office Excel 2007. examine data using math functions in Microsoft Office Excel 2007. manipulate data using text and information functions in Microsoft Office Excel 2007. create templates and work with the advanced chart options. manage data in Excel workbooks. Course Content Lesson 1: Manipulating Data Using Statistical and Lookup Functions Topic 1A: Forecast GDP Using Statistical Functions Topic 1B: Evaluate Sales Data Using Statistical Functions Topic 1C: Analyze Stock Data Using Statistical Functions Topic 1D: Mine Data Using the Lookup and Reference Functions Lesson 2: Analyzing Data Using Data Analysis Tools Topic 2A: Analyze Sales Data Using Descriptive Statistics Topic 2B: Analyze Time Series Data Using Exponential Smoothing Topic 2C: Analyze Data Using Regression Topic 2D: Identify Beta Value of a Security Topic 2E: Analyze Sector Data Using Correlation and Covariance Matrix Topic 2F: Optimize Stock Portfolio Using Solver Lesson 3: Working with Data Using Financial Functions Topic 3A: Develop an Investment Schedule Using Financial Functions Topic 3B: Make Investment Decisions Using Financial Functions Lesson 4: Examining Data Using Math Functions Topic 4A: Analyze Sales Data Using Math Functions Topic 4B: Calculate Stock Returns Using Math Functions Topic 4C: Aggregate GDP Data Using Math Functions Lesson 5: Manipulating Data Using Text and Information Functions Topic 5A: Manipulate Data Using Text Functions Topic 5B: Validate Data Using Information Functions Lesson 6: Working with Templates and Charts Topic 6A: Create Advanced Templates Topic 6B: Create Advanced Charts Lesson 7: Managing Data in Workbooks Topic 7A: Retrieve and Paste Data Topic 7B: Determine the Conditional Sum Topic 7C: Identify Specific Data Using the Lookup Wizard Topic 7D: Clean Data in Workbooks |
| 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."
 |
| |
 |
| |
 |
| |
 |
| |
 |
