T: 01473 414414

select courses

we have a wide range of courses proven to be effective
select
courses

We have a wide range of diverse courses proven to be effective

explore
create your own
courses

Partnering with you to develop your solutions

explore
public sector
courses

We have a wide range of courses to suit you. Explore our full range here

explore

Free Download

Please complete this form to instantly receive your FREE PDF by email


Excel - Introduction

1 Day

Introduction

Designed for those who have little or no knowledge of using a computerised spreadsheet program.

Pre-requisites
Participants should have used a mouse and have knowledge of Microsoft Windows. A pre-course questionnaire is available for participants to confirm their existing knowledge before attending

Benefits
Time efficient and effective manipulation, creation and reporting of data to support decisions

Programme Objectives

Participants will be able to create, edit, print and improve the appearance of spreadsheets.  Participants will also have learned how to construct formulae and different calculation types that are available.  The course finishes with instruction in graphically representing your data and the various graph types that are available.
 

Programme Content

  • Ribbons
  • Quick Access Toolbar
  • Moving Around
  • Entering & Editing Data
  • Help
  • Saving/Opening Files
  • Using OneDrive (Office 365 only)
  • Sharing Documents
  • Using AutoFill
  • Printing and Print Preview
  • Changing Column Widths & Row Heights
  • Enhancing Worksheets Presentation using Borders, Colours, Patterns and Font Enhancements
  • Entering Formulas & Mathematical Priorities
  • Basic Functions
  • Function Wizard
  • Naming Cells
  • Absolute and Relative Addressing
  • Recommended Charts
  • Using quick analysis to create charts
  • Creating 2D & 3D Charts using Chart Quick Key and Chart Wizard
  • Creating Picture Charts