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

Course details
Fee £115
Days 1
Code EX2

There are currently no dates scheduled for this course.

However it can still be provided on a closed-company basis – or we may schedule it on demand. Please contact us for further information.

e-mail us
or call us on
0845 650 6500

Excel Intermediate

The Excel 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

  • This course helps prepare delegates for the ECDL Module 4 - Spreadsheets examination and the Microsoft Office Specialist Excel Proficient examination

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 - Working with Comments

  • Creating Comments
  • Using the Reviewing Toolbar
  • Responding to Discussion Comments

Module 2 - Multiple Worksheets

  • Navigating between Worksheets
  • Selecting Worksheets
  • Renaming Worksheets
  • Colouring Worksheets
  • Inserting Worksheets

Module 3 - Managing Worksheets

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

Module 4 - Using Range Names

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

Module 5 - Working with Outlines

  • Applying an Outline
  • Modifying the Setting
  • Using Auto Outline

Module 6 - Using HTML Files

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

Module 7 - Working with Labels in Formulas

  • Using Labels to Define a Range
  • Multiple Stacked Headings

Module 8 - Using Multiple Workbooks

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

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
  • Exploding a Pie Chart
  • Adjusting 3D View

Module 11 - Advanced Charting

  • Adding and Removing Gridlines
  • Adding data - Different Worksheets
  • Scaling
  • Trendlines
  • User Defines Charts

Module 12 - Managing Data

  • Sorting Lists
  • Finding/ Replacing

Module 13 - Working with Databases

  • Creating a Database
  • Sorting on Multiple Fields
  • Data Validation
  • Creating a Custom Error Message
  • Creating/ Removing Sub Totals

Module 14 - Working with the Data Form

  • Viewing Data Form Records
  • Adding Data Form Records
  • Defining Search Criteria

Module 15 - Using AutoFilter

  • Enabling AutoFilter
  • Creating a Custom AutoFilter
  • Disabling AutoFilter

Module 16 - Working with Advanced Filters

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

Module 17 - Drawing an Object

  • Drawing Enclosed Objects
  • Adding Text to an Object
  • Changing and Removing the fill Colour

Module 18 - Using Additional Effects and Objects

  • Adding a 3D Effect
  • Drawing Arrows and Lines
  • Inserting a Picture
  • Formatting Graphics

Module 19 - Using AutoShapes and Diagrams

  • Drawing a Callout
  • Basic Shapes
  • Connectors
  • Inserting Diagrams