MS Office: Excel (all levels)

MS Office: Excel (all levels)
Print Friendly, PDF & Email

This series of Excel courses will prepare you for MOS Excel Exam 77-882 and Expert 77-888

MOS Certification

These courses are part of  a series of  courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products.  The courses are designed for the everyday user who wants to learn all the tips, tricks and functions of Microsoft Excel.

  • Microsoft® Office Excel® 2010: Level 1

    Course Specifications

    Course length: 1.0 day(s)
    Certification: MOS: Microsoft Office Excel 2010 Exam 77–882, MOS: Microsoft Office Excel 2010 Expert Exam 77–888
    Course Description

    Course Objective: You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.

    Target Student: This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.

    This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products.

    Each computer requires the following software:

    Upon successful completion of this course, students will be able to:

    create a basic worksheet by using Microsoft Excel 2010.
    perform calculations in an Excel worksheet.
    modify an Excel worksheet.
    modify the appearance of data within a worksheet.
    manage Excel workbooks.
    print the content of an Excel worksheet.
    Course Content

    Lesson 1: Getting Started with Excel

    Topic 1A: Identify the Elements of the Excel Interface
    Topic 1B: Navigate and Select Cells in Worksheets
    Topic 1C: Customize the Excel Interface
    Topic 1D: Create a Basic Worksheet
    Lesson 2: Performing Calculations in an Excel Worksheet

    Topic 2A: Create Formulas in a Worksheet
    Topic 2B: Insert Functions in a Worksheet
    Topic 2C: Reuse Formulas
    Lesson 3: Modifying an Excel Worksheet

    Topic 3A: Edit Worksheet Data
    Topic 3B: Find and Replace Data
    Topic 3C: Manipulate Worksheet Elements
    Lesson 4: Modifying the Appearance of a Worksheet

    Topic 4A: Apply Font Properties
    Topic 4B: Add Borders and Colors to Cells
    Topic 4C: Align Content in a Cell
    Topic 4D: Apply Number Formatting
    Topic 4E: Apply Cell Styles
    Lesson 5: Managing an Excel Workbook

    Topic 5A: Manage Worksheets
    Topic 5B: View Worksheets and Workbooks
    Lesson 6: Printing Excel Workbooks

    Topic 6A: Define the Page Layout
    Topic 6B: Print a Workbook
    Appendix A: Microsoft Office Excel 2010 Exam 77–882
    Appendix B: Microsoft Office Excel 2010 Expert Exam 77–888

  • Microsoft® Office Excel® 2010: Level 2

    Course Specifications

    Course length: 1.0 day(s)
    Certification: MOS: Microsoft Office Excel 2010 Exam 77–882, MOS: Microsoft Office Excel 2010 Expert Exam 77–888
    Course Description

    Course Objective: You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

    Target Student: This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

    Prerequisites: Before starting this course, students are recommended to take the following Element K course or have equivalent knowledge: Microsoft® Office Excel® 2010: Level 1.
    Certification

    This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products.

    Software Requirements

    Each computer requires the following software:

    Microsoft® Office Professional Plus 2010 Edition
    Microsoft® Windows® XP Professional with Service Pack 2
    Course Objectives

    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.
    Course Content

    Lesson 1: Calculating Data with Advanced Formulas

    Topic 1A: Apply Cell and Range Names
    Topic 1B: Calculate Data Across Worksheets
    Topic 1C: Use Specialized Functions
    Topic 1D: Analyze Data with Logical and Lookup Functions
    Lesson 2: Organizing Worksheet and Table Data

    Topic 2A: Create and Modify Tables
    Topic 2B: Format Tables
    Topic 2C: Sort or Filter Data
    Topic 2D: Use Functions to Calculate Data
    Lesson 3: Presenting Data Using Charts

    Topic 3A: Create a Chart
    Topic 3B: Modify Charts
    Topic 3C: Format Charts
    Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

    Topic 4A: Create a PivotTable Report
    Topic 4B: Filter Data Using Slicers
    Topic 4C: Analyze Data Using PivotCharts
    Lesson 5: Inserting Graphic Objects

    Topic 5A: Insert and Modify Pictures and ClipArt
    Topic 5B: Draw and Modify Shapes
    Topic 5C: Illustrate Workflow Using SmartArt Graphics
    Topic 5D: Layer and Group Graphic Objects
    Lesson 6: Customizing and Enhancing the Excel Environment

    Topic 6A: Customize the Excel Environment
    Topic 6B: Customize Workbooks
    Topic 6C: Manage Themes
    Topic 6D: Create and Use Templates
    Appendix A: Microsoft Office Excel 2010 Exam 77–882
    Appendix B: Microsoft Office Excel 2010 Expert Exam 77–888

  • Microsoft® Office Excel® 2010: Level 3

    Course Specifications

    Course length: 1.0 day(s)
    Certification: MOS: Microsoft Office Excel 2010 Exam 77–882, MOS: Microsoft Office Excel 2010 Expert Exam 77–888
    Course Description

    Course Objective: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

    Target Student: This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

    Certification

    This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products.
    Hardware Requirements
    Software Requirements

    Each computer requires the following software:

    Microsoft® Office Professional Plus 2010 Edition
    Microsoft® Windows® XP Professional with Service Pack 3
    Windows Rights Management Services (RMS) Client with Service Pack 2.
    Course Objectives

    Upon successful completion of this course, students will be able to:
    enhance productivity and efficiency by streamlining the workflow.
    collaborate with other workbook users.
    audit worksheets.
    analyze data.
    work with multiple workbooks.
    import and export data.
    integrate Excel data with the web.
    Course Content

    Lesson 1: Streamlining Workflow

    Topic 1A: Update Workbook Properties
    Topic 1B: Create a Macro
    Topic 1C: Edit a Macro
    Topic 1D: Apply Conditional Formatting
    Topic 1E: Add Data Validation Criteria
    Lesson 2: Collaborating with Other Users

    Topic 2A: Protect Files
    Topic 2B: Share a Workbook
    Topic 2C: Set Revision Tracking
    Topic 2D: Review Tracked Revisions
    Topic 2E: Merge Workbooks
    Topic 2F: Administer Digital Signatures
    Topic 2G: Restrict Document Access
    Lesson 3: Auditing Worksheets

    Topic 3A: Trace Cells
    Topic 3B: Troubleshoot Invalid Data and Formula Errors
    Topic 3C: Watch and Evaluate Formulas
    Topic 3D: Create a Data List Outline
    Lesson 4: Analyzing Data

    Topic 4A: Create a Trendline
    Topic 4B: Create Sparklines
    Topic 4C: Create Scenarios
    Topic 4D: Perform a What-If Analysis
    Topic 4E: Perform a Statistical Analysis with the Analysis ToolPak
    Lesson 5: Working with Multiple Workbooks

    Topic 5A: Create a Workspace
    Topic 5B: Consolidate Data
    Topic 5C: Link Cells in Different Workbooks
    Topic 5D: Edit Links
    Lesson 6: Importing and Exporting Data

    Topic 6A: Export Excel Data
    Topic 6B: Import a Delimited Text File
    Topic 6C: Import and Export XML Data
    Lesson 7: Integrating Excel Data with the Web

    Topic 7A: Publish a Worksheet to the Web
    Topic 7B: Import Data from the Web
    Topic 7C: Create a Web Query
    Appendix A: Creating Excel Forms
    Appendix B: Microsoft Office Excel 2010 Exam 77–882
    Appendix C: Microsoft Office Excel 2010 Expert Exam 77–888

  • Microsoft® Office Excel® 2010: Level 4

    Course Specifications

    Course length: 1.0 day(s)
    Certification: MOS: Microsoft Office Excel 2010 Exam 77–882, MOS: Microsoft Office Excel Expert 2010 Exam 77–888
    Course Description

    Course Objective: You will use the advanced features of Microsoft® Office Excel® 2010 to attain proficiency as an Excel power user.

    Target Student: This course is designed for advanced Microsoft Office Excel professionals who may work or be interested in the domain of finance, statistics, project analysis, and market analysis including the fields of micro- and macro-economics.

    Certification

    This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products.

    Software Requirements

    Each computer requires the following software:

    Microsoft® Office Professional Plus 2010 Edition.
    Microsoft® Windows® XP Professional with Service Pack 3
    Course Objectives

    Upon successful completion of this course, students will be able to:
    manipulate data using statistical and lookup functions.
    analyze data using the data analysis tools in Microsoft Excel 2010.
    make investment decisions using the financial functions in Excel 2010.
    examine data using math functions in Excel 2010.
    manipulate data using text and information functions in Excel.
    create templates and work with Excel’s 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 the Beta Value of a Security
    Topic 2E: Analyze Sector Data Using Correlation and Covariance Matrices
    Topic 2F: Optimize a 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: Clean Data in Workbooks
    Appendix A: Commonly Used Excel Functions
    Appendix B: Microsoft Office Excel 2010 Exam 77–882
    Appendix C: Microsoft Office Excel Expert 2010 Exam 77–888

Share Post
Share This

About the author

Computer trainer, tech support, webmaster, book keeper and janitor all rolled into one.

View all articles by Admin