Microsoft Excel: Introduction

Loading Events

« All Events

  • This event has passed.

Microsoft Excel: Introduction

23rd January 2019 at 9:00 am - 5:00 pm

|Recurring Event (See all)

One event on 16th October 2023 at 9:00 am

One event on 6th November 2023 at 9:00 am

One event on 4th December 2023 at 9:00 am

One event on 9th January 2024 at 9:00 am

One event on 23rd January 2024 at 9:00 am

One event on 5th February 2024 at 9:00 am

One event on 27th February 2024 at 9:00 am

One event on 5th March 2024 at 9:00 am

One event on 25th March 2024 at 9:00 am

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

 

A 1 day Introduction Course, aimed to give users the confidence and knowledge to create and use Excel spreadsheets. By the end of the day, users will be able to create, amend and manipulate their own spreadsheets.

 

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

  • Menu bar
  • Ribbon
  • Status bar

 

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

  • Creating new documents
  • Saving spreadsheets
  • Closing Excel

 

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

  • Sorting Data
  • Subtotalling Data
  • Using Filters
  • Freezing Panes

 

Formatting Excel

Changing the look and feel of spreadsheets.

  • Selecting cells, columns and rows
  • Displaying data as currency (£)
  • Displaying figures as percentages (%)
  • Changing cell, text and border colour

 

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

  • Understanding simple formulas
  • Using AutoSum
  • Understanding Absolute Cell References
  • Using AutoFill tools

 

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

  • Trace Precedents
  • Trace Dependents
  • Evaluating formulas
  • Tracing errors
  • Using the Watch Window

 

Charts

How to use your data in various chart types.

  • Using the Chart Wizard
  • Select appropriate chart types
  • Specifying the data source
  • Customising your charts

 

Details

Date:
23rd January 2019
Time:
9:00 am - 5:00 pm
Event Categories:
, , , ,

Organiser

Chamber Skills Solutions
Phone
01709 386200
Email
training@brchamber.co.uk

Other

Enquiry Only
Is Inquirable

Venue

Rotherham
South Yorkshire United Kingdom

Book this training course