Microsoft Excel

Duration: 1 days Cost: £150 + VAT
concessions available
Next Course : TBA enquire here Times: 10am - 5pm

At the end of this course you will have a good understanding of the basic features and functions of Excel. You will feel confident using Excel, and be able to create a spreadsheet from scratch. Understanding and using some of the built-in calculation and formula functionality will allow you to be more productive in your work and at home.

Suitable for:
Our Microsoft Excel introduction course is designed to accommodate complete beginners to Microsoft Excel

Prerequisites:

  • A basic understanding of the windows environment .
  • A basic level of numeracy and literacy is required.

book a course now by calling 0845 686 2888 or complete the online enquiries form

Course outline:

Getting Started

  • Spreadsheet terminology
  • Exploring the Excel window
  • Getting help
  • Opening and navigating
  • workbooks
  • Closing workbooks

Entering and Editing data

  • Creating workbooks
  • Entering and editing labels and values
  • Entering and editing formulas
  • Saving and updating workbooks

Modifying a Worksheet

  • Moving and copying data
  • Moving and copying formulas
  • Using absolute references
  • Inserting and deleting ranges

Using Functions

  • Entering functions
  • Using AutoSum
  • Using AVERAGE, MIN, and MAX
  • Formatting Worksheets

Formatting text

  • Formatting rows and columns
  • Number formatting
  • Using Format Painter and AutoFormat

Printing

  • Preparing to print
  • Page Setup options
  • Printing worksheets

Creating Charts

  • Chart basics
  • Modifying charts
  • Printing charts

List Management

  • Working with lists
  • Sorting and filtering lists
  • Advanced filtering

Using Templates

  • Built-in templates
  • Creating and managing templates

download course outline

book a course now by calling 0845 686 2888 or complete the online enquiries form