Excel Intermediate

Date: November 12, 2019
Time: 09:30 to 16:00
Venue: Kings Hill
Package: Excel

Email to book this course

Pre-requisites

Delegates should be competent using the keyboard and mouse, and be familiar with working in the Windows environment.  Attendance of the Microsoft Excel Introduction course or thorough equivalent experience is essential.

Course Objectives

  • To create and print charts
  • To create more complex spreadsheets
  • To create template spreadsheets
  • To use Excel as a simple database

Course Contents

Formulae

  • Formulae – revision  and practice
  • Autosum
  • AVERAGE, MIN, MAX
  • Relative and absolute cell references

Creating Charts

  • Creating column, line and bar charts
  • Creating charts on different sheets
  • Formatting Charts
  • Printing Charts

Working with Multiple Sheets

  • Inserting, Deleting, Moving and Copying Sheets
  • Renaming Sheets
  • Grouping Sheets
  • Creating Linking and 3-D Formulas

Linking Workbooks

  • Linking Formulas across Workbooks
  • Updating Links

Further Formatting

  • Conditional Formatting

Databases

  • Terminology
  • Creating a Database
  • Using the Data Form
  • Sorting
  • Filtering

Copyright © 2015-2019 Vue IT TrainingWeb Design by fairly marvellous Kent