Microsoft Excel Introduction

Training

Online

£ 155 + VAT

Description

  • Type

    Training

  • Level

    Beginner

  • Methodology

    Online

  • Duration

    1 Day

  • Start date

    Different dates available

This one day course provides a new user or user with basic experience of Microsoft Excel, the confidence to use a wide range of features.
Understand and write formulae, build common functions, apply formatting, sorting, filtering and generate charts in Excel spreadsheets. You will also learn valuable shortcuts enabling you to work efficiently.

Important information

Documents

  • microsoft-excel-introduction.pdf

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Basics and Formatting
Tour the Microsoft Excel Environment
Customise the Quick Access Toolbar
Enter and edit data
Adjust Column widths
Move and copy data
Use AutoFill
Format a worksheet
Copy and clear formatting
Prepare a worksheet for printing
Save a worksheet as a PDF
Learn keyboard shortcuts

Formulas and Functions
Understand and write Formulae
Learn the construction of a Function
Use the SUM function
Use AutoFill to copy a formula
Further Functions
Use Functions AVERAGE, MIN, MAX and COUNT
Calculate percentages
Learn how to use relative and absolute cell referencing

Work with Data Lists
Use Freeze Panes
Sort data
Filter Information

Charts and Graphs
Create bar, column, line and pie charts
Explore and change chart properties

Anyone who wants to learn Microsoft Excel to a good level including formulas, common functions and how the software works. Aimed at business users who want the most from a one day course.

Must be comfortable with using a computer.
Microsoft Excel must be installed on your computer as its hands on training delivered live online.

Certificate of attendance

Engaging delivery live online by qualified trainers
A maximum of 4 delegates on a public course
1 year's after course support included

Once we know when you you'd like to attend, we'll send you course joining instructions, post out your course materials and give you a link to join the course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Microsoft Excel
  • Microsoft excel training
  • MS Excel
  • Microsoft Excel training course
  • MS Excel course
  • Introduction to Excel
  • Training in Excel
  • Excel Basics
  • Excel Formulas

Teachers and trainers (1)

Qualified Trainer

Qualified Trainer

Senior trainer

Course programme

  • Understand and write formulae - add, minus, multiply, divide
  • build common functions - sum, minimum, maximum, average, count
  • apply formatting
  • sorting
  • filtering
  • generate charts
  • lean valuable shortcuts

The course takes a user with no knowledge of the application, through to be able to using it to calculate values / database work in a business environment.

Additional information

http://www.tcstraining.co.uk/microsoft-excel-office-training-southampton

Microsoft Excel Introduction

£ 155 + VAT