Introduction - Microsoft Excel Training Course:  

 

 

Synopsis:

The course is intended for new users of Microsoft Excel who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Excel is required.

Pre-Requisites:

No pre course work is required for this Microsoft Excel training course

Course Outline:

Microsoft Excel is the popular spreadsheet from Microsoft and part of the Microsoft Office XP suite. This training course is designed to let users get to grips with the main features of Microsoft Excel. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.

Course Content:

Microsoft Excel Introduction v2007/2010

Getting started

  • Spreadsheet terminology
  • Exploring the Excel window
  • Getting help
  • Navigating workbooks

Entering and editing data

  • Entering and editing text and values
  • Entering and editing formulas
  • Working with pictures
  • Saving and updating workbooks

Modifying a worksheet

  • Moving and copying data
  • Moving and copying formulas
  • Absolute and relative references
  • Inserting and deleting ranges, rows, and columns

Using functions

  • Entering functions
  • AutoSum
  • Other useful functions

Formatting worksheets

  • Formatting text
  • Formatting rows and columns
  • Formatting numbers
  • Conditional formatting
  • Copying formats and applying table formats

Printing

  • Preparing to print
  • Page Setup options
  • Printing worksheets

Creating charts

  • Chart basics
  • Modifying charts
  • Printing charts

Managing large workbooks

  • Viewing large worksheets
  • Printing large worksheets
  • Using multiple worksheets

Learning Outcomes;

By the end of this Microsoft Excel training you will know how to:

  • Understand the different sections of a spreadsheet
  • Enter and edit data
  • Modify an existing spreadsheet
  • Create a new spreadsheet
  • Use basic functions and formulae
  • Format worksheets effectively
  • Print documents, including large documents effectively
  • Create basic charts
  • Manage large spreadsheets

Duration:

1 Day

No of Delegates – The Total Number of delegates that can sit this is course is a maximum of 12 to uphold the quality of our training and to ensure the course is properly embedded to achieve the companies/individual goals.

Prices – £849 (ex VAT)  Per day for up to 12 delegates trained onsite

(An additional charge for travel will be applied at 40p per mile from Sequence HQ to your premises)