e-academy – IT training excellence in Cardiff, Newport, Bristol and South Wales

Course details
Fee £115
Days 1
Code EX072
Course dates
Feb 
Mar 
Apr2
May 
Jun 
Jul 

Click on a course date to book
e-mail us
or call us on
0845 650 6500

Excel 2007 Intermediate

The Excel 2007 Intermediate training course is available at our Cardiff training centre in Wales, which is also within easy reach of Newport, Bristol and South WalesMicrosoft Certified Gold Partner for Learning Solutions

Overview

This course introduces the skills necessary for using multiple worksheets and using Excel as a database. It includes tasks to create a database, sort data, and work with the data form. Students will also learn how to use AutoFilter, advanced filters, and database function formulas. This course also covers the charting features of Excel and students will learn how to generate graphs from data held in their worksheets. Students will also learn how to use some of the additional features in Excel 2003. The student will also learn how to use the HTML features of the package

Examination information

  • There is currently no examination associated with this course

Prerequisites

Before attending this course, students must have:

  • Attended the Excel Introduction course or have a working knowledge of the subject

Course outline

Module 1: Using Multiple Worksheets

  • Navigating Between Worksheets
  • Selecting Worksheets
  • Renaming Worksheets
  • Colouring Worksheets
  • Inserting Worksheets

Module 2: Managing Worksheets

  • Copying/Moving Worksheets
  • Grouping Worksheets
  • Creating 3D Formulas

Module 3: Using Range Names

  • Assigning Names
  • Jumping to Named Ranges
  • Using Range Names in Formulas

Module 4: Managing Data

  • Sorting Lists
  • Finding and Replacing Data
  • Using Range Name in Formulas

Module 5: Using Multiple Workbooks

  • Opening Multiple Workbooks
  • Timing Open Workbooks
  • Saving a Workspace
  • Linking Multiple Workbooks

Module 6: Using AutoFilter

  • Enabling AutoFilter
  • Creating a Custom AutoFilter
  • Disabling AutoFilter

Module 7: Working with Advanced Filter

  • Creating a Criteria Range
  • Using Comprising Criteria
  • Using Database Functions

Module 8: Managing Files

  • Workbook Properties
  • Document Recovery
  • Marking a Document as Final
  • Saving in PDF Format

Module 9: Creating Charts

  • Creating Charts using the Wizard
  • Changing the Chart Type
  • Modifying Chart Objects

Module 10: Formatting Charts

  • Adding Chart Titles and Labels
  • Exploring a Pie Chart
  • Adjusting 3D View

Module 11: Advanced Charting Features

  • Adding and Removing Gridlines
  • Adding Data- Different Worksheets
  • Scaling
  • Trendlines
  • User Defined Charts
  • Using a Secondary Axis

Module 12: Using HTML Files

  • Preview a Web Page
  • Creating a Hyperlink
  • Saving a Web page

Module 13: Working with Comments

  • Creating Comments
  • Viewing Comments
  • Printing Comments

Module 14: Working with Outlines

  • Applying an Outline
  • Modifying Settings
  • Creating Subtotals
  • Clearing an Outline

Module 15: Using Shapes and Smart Art

  • Drawing Flowcharts
  • Drawing Shapes
  • Adding SmartArt