Ms Excel Introduction Courses

Introduction Courses For Microsoft Excel

MS Excel – Introduction Training Course

1 Day Course | 1 delegate £195.00 plus VAT
*Book 2 or more delegates and receive significant discounts. Click here for information

Introduction

This one-day instructor led course is designed to give a thorough introduction to the basic skills needed to use Excel effectively. By the end of the course delegates will be able to create, modify and format Excel spreadsheets including designing basic formulas and charts.

Course Objectives

  • Understand the terminology used in Excel
  • Open, close, save and print Excel worksheets
  • Enter, edit and format data
  • Use formulas and functions to calculate in Excel
  • Create and format a simple chart

Pre-requisites

We recommend that all those who attend are able to:

  • Use the mouse to select and open menus and icons
  • Identify and use the Shift, Ctrl, TAB and Home keys on the keyboard

Course Content

Excel Basics

  • Exploring the Excel window
  • Spreadsheet terminology
  • Opening and Closing workbooks
  • Navigating around a worksheet
  • Keyboard Shortcuts and Menu Items

Entering and Editing Data

  • Creating a new Excel workbook
  • Entering and editing labels and values
  • Selecting cells and data ranges
  • Moving and copying data
  • Linking worksheets in a workbook
  • Saving and updating a workbook

Formulas and Functions

  • Creating new formulas
  • Using SUM function
  • Using AVERAGE, MIN, MAX and COUNT
  • Copying formulas and functions
  • Understanding Absolute and Relative references
  • Editing formulas and functions

Printing

  • Preparing to print
  • Page set up options

Formatting and Manipulating Worksheets

  • Formatting text
  • Formatting rows and columns
  • Formatting numbers
  • Inserting rows and columns
  • Deleting rows and columns
  • Freezing panes
  • Splitting the screen

Charts

  • Creating a simple chart using Chart Wizard
  • Formatting a chart