Jayne Wilkins & Associates Training Courses In Kent In London

01303 268357

jayne@jaynewilkins.co.uk

Microsoft Excel Courses - Introductory

Microsoft Excel Courses

Microsoft Excel Introductory

Our Microsoft Excel Introductory, Intermediate and Advanced training courses are very popular. You will find the standard course content for the Excel Introductory course below. Click the buttons on the right of the screen to view the content of the Excel Intermediate and Excel Advanced courses.

If you're not sure what Excel course to attend please contact us for a free copy of our Excel training needs analysis questionnaire.

This Microsoft® Excel Introductory course detailed below covers all the vital basics of Excel and is suitable for new and existing users who have not received any formal Excel training.

From: £325
Level: Introductory
Duration: 1 Day

What is Excel?

  • An overview: formulae, charts & lists
  • Using help
  • Creating a new workbook
  • Save, Close & Open a workbook

Inputting & Editing

  • Introducing the 3 vital mouse shapes
  • Selecting ranges
  • Working with sheets: deleting, moving, renaming
  • Typing in text & numbers
  • Typing in dates
  • Using AutoFill to produce text & numbers quickly
  • AutoComplete text
  • Inserting/deleting rows & columns
  • Changing columns widths & row heights
  • Editing/clearing cell contents
  • Undo and Redo
  • Cut, Copy and Paste, using Drag and Drop

Building Formulae

  • Adding up a column or row using AutoSum
  • Adding up a large area very quickly
  • Entering formulae: add, subtract, multiply & divide
  • Reading and understanding formulae
  • Copying a formula
  • Carrying a number forward (linking cells)
  • Using brackets in formulae (order of calculation)
  • Using the $ in formulae (absolute & relative references)
  • Using Excels built in functions to include:
  • Average, Min, Max, Count, Counta
  • Using the Insert Function dialog box
  • Practicing building formulae (time available for this)

Worksheet Formatting

  • Formatting text & numbers
  • Adding borders
  • Using Date formats
  • Removing formats
  • Using the Format Painter
  • Formatting with styles (from 2007)
  • Formatting as a table (from 2007)

Printing a Worksheet

  • Printing Selected Ranges
  • Using Print Preview
  • Printing in Landscape
  • Changing Margins/Scaling the Printout
  • Page Breaks
  • Inserting Headers/Footers/Page Numbers
  • Using Page Layout view (from 2007)

Introducing List Management

  • Rules for creating a List in Excel
  • Sorting, Filtering and Subtotaling a list

Introducing Graphs

  • Building a Graph Using the Wizard
  • Modifying & Formatting the Graph
  • Formatting the Chart
  • Adding Legends/Titles

Introducing Pivot Tables

  • What is a Pivot Table?
  • When to use a Pivot Table
  • A quick guide to creating a Pivot Table