Skip to main content

Microsoft Excel 2007: Intermediate

TRAINING COURSE

Microsoft Excel 2007: Intermediate

COURSE TRAINERS

Carl Spies

Mark Badham

This course is currently not active. Feel free to submit an enquiry.

Details

You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Delivery Methods

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.

Audience

The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web

Pre-Requisites

Microsoft Office Excel 2007: Basic

Course Outline / Curriculum

  • Lesson 1: Calculating Data with Advanced Formulas
    • Topic 1A: Manage Cell and Range Names
    • Topic 1B: Calculate Data Across Worksheets
    • Topic 1C: Use Specialised Functions
    • Topic 1D: Analyse 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 Worksheet or Table Data
    • Topic 2D: Calculate Data in a Table or Worksheet
  • 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 and PivotCharts
    • Topic 4A: Create a PivotTable Report
    • Topic 4B: 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: Customising and Enhancing Workbooks and the Excel Environment
    • Topic 6A: Customise the Excel Environment
    • Topic 6B: Customise Workbooks
    • Topic 6C: Manage Themes
    • Topic 6D: Create and Use Templates