Microsoft Excel Introduction Courses

Introduction Courses For Microsoft Excel

Excel Introduction Training Course

Microsoft Excel Training COurseOur Excel Introduction course is perfect for both beginners and those who are self-taught in Microsoft Excel and looking to learn skills that will transform how they work.

 

Our experienced trainers will guide you through hands-on exercises and real-world examples, so you’ll be able to apply what you’ve learned immediately in the workplace.

Our fee for a standard onsite Excel course £545 + VAT
Includes up to 4 people onsite. Additional attendees: £35 + VAT per person.

  • Instructor-led Excel training (non-tailored)
  • Delivered onsite at your location (up to 4 people)
  • Printed reference materials for each attendee
  • Trainer travel is included

Perfect for: Small teams who want a focused, hands-on Excel course on the key skills used within the workplace.

This equates to about £75.00 plus vat per person (assuming 10 people attend), with each person receiving a supporting reference manual and course attendance certificate.

 

Keys Training also delivered regular scheduled Excel Introduction courses at our premises.

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

Scheduled public courses are held at Preston, Liverpool, Manchester & London.

Meet Aedan, a member of the Marketing Team…

Enquire About Training

Introduction

This one-day instructor led Excel Introduction 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