Microsoft Excel 2010

Excel 2010: Level 1

Course Outline

 

  • Lesson 1: Getting Started with Excel
    • Identify the Elements of the Excel Interface
    • Navigate and Select Cells in Worksheets
    • Customize the Excel Interface
    • Create a Basic Worksheet
  • Lesson 2: Performing Calculations in an Excel Worksheet
    • Create Formulas in a Worksheet
    • Insert Functions in a Worksheet
    • Reuse Formulas
  • Lesson 3: Modifying an Excel Worksheet
    • Edit Worksheet Data
    • Find and Replace Data
    • Manipulate Worksheet Elements
  • Lesson 4: Modifying the Appearance of a Worksheet
    • Apply Font Properties
    • Add Borders and Culors to Cells
    • Align Content in a Cell
    • Apply Number Formatting
    • Apply Cell Styles
  • Lesson 5: Managing an Excel Workbook
    • Manage Worksheets
    • View Worksheets and Workbooks
  • Lesson 6: Printing Excel Workbooks
    • Define the Page Layout
    • Print a Workbook

 
Duration: 8 Hours
Course Fee: INR. 5,000 + Tax

Excel 2010: Level 2

Course Outline

 

  • Lesson 1: Calculating Data with Advanced Formulas
    • Apply Cell and Range Names
    • Calculate Data Across Worksheets
    • Use Specialized Functions
    • Analyze Data with Logical and Lookup Functions
  • Lesson 2: Organizing Worksheet and Table Data
    • Create and Modify Tables
    • Format Tables
    • Sort or Filter Data
    • Use Functions to Calculate Data
  • Lesson 3: Presenting Data Using Charts
    • Create a Chart
    • Modify Charts
    • Format Charts
  • Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
    • Create a PivotTable Report
    • Filter Data Using Slicers
    • Analyze Data Using PivotCharts
  • Lesson 5: Inserting Graphic Objects
    • Insert and Modify Pictures and ClipArt
    • Draw and Modify Shapes
    • Illustrate Workflow Using SmartArt Graphics
    • Layer and Group Graphic Objects
  • Lesson 6: Customizing and Enhancing the Excel Environment
    • Customize the Excel Environment
    • Customize Workbooks
    • Manage Themes
    • Create and Use Templates

 
Duration: 8 Hours
Course Fee: INR. 6,000 + Tax

Excel 2010: Level 3

Course Outline

 

  • 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: Cullaborating 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 ToulPak
  • Lesson 5: Working with Multiple Workbooks
    • Topic 5A: Create a Workspace
    • Topic 5B: Consulidate 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
  • 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
  • Lesson 8: Structuring Workbooks with XML
    • Topic 8A: Develop XML Maps
    • Topic 8B: Import and Export XML Data

 
Duration: 8 Hours
Course Fee: INR. 7,000 + Tax