An organisation development specialistLinked In

Excel Introduction 2013 / 2010 / 2007

Duration 1 day

Designed for

Those who have little or no knowledge of using a computerised spreadsheet program.

Pre-requisites

Delegates should have used a mouse and have knowledge of Microsoft Windows

A pre-course questionnaire is available for delegates to confirm their existing knowledge before attending this programme.

Course Aims

By the end of this course delegates will be able to create, edit, print and improve the appearance of spreadsheets. Delegates 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.

Course Contents

  • 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

Content will vary slightly depending on version being used

More