Microsoft Excel Training: Introduction [a Cambridge Network Course]


The sessions are designed to focus on specific aspects of Microsoft Excel and will benefit anyone wanting a good understanding on these topics.

Dates Tuesday, September 8, 2020 - Download as vCalendar
Event Times: 09:15 to 15:00
Venue Online
Contact Name Sara Baxter
Email sara.baxter@cambridgenetwork.co.uk
Contact Phone 01223 746801
Website Event website

Event details:

This course is now part of our online training calendar. Book below!

 

Overview

These 90 minute bite-size sessions are designed to focus on specific aspects of Microsoft Excel and will benefit anyone wanting a good understanding on these topics.  Exercises are supplied and delegates will get a mix of watching and hands on activity.

 

Course Objectives

The objectives of the course are to:

  • Give you the knowledge to build, edit, format and print basic spreadsheets

  • Introduce the basic principles of creating and using formulae and functions

  • Teach users how to create and edit simple graphs

 

Course Structure:

Indiviudals can either book 1, 2 or all 3 of the sessions below. They will run on the same day, times are below. Price is per session and sessions must be booked separately. If you would prefer to pay via invoice please email us.

 

Session 1 – Basic Principles - 09:15-10:45

  • Cells – Enter/Edit data; Autofill

  • Using Sheets

  • Appearance - Formatting cells

  • Printing – Preview types; Headers & Footers; Adjustments

  • Working with large sheets – Split/Freeze

 

Session 2 – Excel Charts - 11:15-12:45

  • Sparklines

  • Rules for charts

  • Insert chart v Quick chart

  • Bar/Line/Pie charts

  • Enhancing charts

  • Moving charts

  • Adding/deleting data

 

Session 3 – Basic Formulae - 13:30-15:00

  • Understanding formula structure

  • Create/Edit Formulas

  • Autofill and Copy Formulas

  • BODMAS principle

  • Stats Functions – Autosum; Average, Count, Max, Min, CountA

  • Working with Percentages

  • Relative vs Absolute formulae

 

Duration: 90 minutes Credits: 0.3
Time:
Session 1: 9.15 - 10.45am
Session 2: 11.15 - 12.45pm
Session 3: 1.30 - 3.00pm
Costs are per session:

Member Cost:
£55.00+VAT
Max. Delegates: 8 Non-member Cost: £82.00+VAT

 

For full course content and to book click here

Session 1
Session 2
Session 3

Enliten IT specialises in delivering a wide portfolio of quality, tailored on-site, computer training courses at customer locations throughout the UK and Europe.