Introduction to Microsoft Excel

Duration: 1 Day

Objectives

This course is designed for anyone who needs to understand the fundamental features and uses of Excel, and how to create simple spreadsheets, charts and databases. For a full introduction, it is suggested that this course is taken in conjunction with the Intermediate course.

Pre-requisites

None other than a working knowledge of Windows or Macintosh OS.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

File management and basics

  • Launching Excel
  • Understanding the interface
  • Starting a new workbook
  • Opening an existing workbook
  • Closing a workbook
  • The size of a worksheet
  • Entering data in cells
  • Quick ways to navigate a document
  • Working with Ribbons (Galleries) and Toolbars

Selecting and editing data

  • Selecting single cells, whole rows and whole columns
  • In-cell editing
  • Overtyping the contents of cells
  • Moving and copying data; cut and paste, drag and drop
  • Zooming
  • Working in different views

Formatting cells

  • Formatting fonts, borders and patterns
  • Applying styles e.g. bold, italic etc.
  • Changing column widths and row heights
  • Number formatting (currency, percentages, dates etc).
  • Using the Format Painter
  • Using Conditional formatting

Printing

  • Using Print Preview
  • Options in page setup, such as headers and footers, gridlines etc.

Structuring formulae

  • Understanding spreadsheet cell references
  • Using arithmetic and understanding the order in which Excel processes calculations (BODMAS)
  • Copying formulae using AutoFill
  • Use of simple functions eg. SUM(), AVERAGE(), MIN() & MAX()
  • Understanding the difference between absolute and relative cell references

Data filtering and sorting

  • The concept (and limitations) of a database or list in Excel
  • Entering and editing data through a Data Form
  • Sorting a list using one or more keys
  • Using the AutoFilter Smart Tags
  • Filtering values in a range
  • Using the Sub-total command

Creating charts

  • Selecting data in rows and columns correctly
  • Using the Chart Wizard
  • Choosing from bar, line, scatter, pie and other chart types
  • Amending data on the fly
  • Saving a chart by itself or attached to a worksheet
  • Adding data series

This course is available as a private or customised course. Contact us for further information and to customise this course to your exact requirements:

Phone us: 0208 269 4260Book Now

Related Courses


"I am writing to say thank you for organising my FileMaker training day; I learned so much with my trainer, Nick, and have come away with such a great database. It delighted both the Director and my job share partner. I feel I have left with a great amount of knowledge that can help the business immensely. I learned more than I thought I would and would like to thank Transmedia for being so helpful!"

Lucie Mills

"Absolutely top quality training and facilities."

National Museum of Wales

"Staff were helpful and the course was relevant to my needs. A great course!"

VCCP



 

 

© Transmedia . 277 Greenwich High Road London SE10 8NB  UK . 0208 269 4260
Designed by Transmedia's Web Team