# Microsoft Excel

At The IT Training Surgery, we understand that making time for training can be a challenge, so we have developed a series of  Microsoft Excel half-day courses.

Courses can be run online using video communication software e.g. Zoom or at your premises on your computers.

Select from the following courses.

## Excel for Beginners

By the end of this half-day course, you will be able to create and manipulate a spreadsheet with basic formulae that calculate your figures.

### In particular, you will learn:

• The Ribbon and Quick Access Toolbar
• Finding your way around a workbook
• Adding text and numbers to cells
• Formatting including number formats
• Creating a simple formula
• Making a column add up
• Use Autofill to generate a list
• Use Autofill to copy a formula
• Use absolute references to fix part of a formula
• Add headers and footers
• Borders and shading
• Printing

### Course Outline

#### Excel for Beginners

Click here to download the course outline

## Formula and Functions

By the end of this half-day course, you will be able to use a variety of functions to calculate your data

In particular, you will learn:

• If statement
• Hlookup
• Vlookup
• SumIf
• SumIfs
• Countif
• Countifs
• Averageif
• Averageifs

### Text functions

• Concatenate – combine cell values to make a new value
• Trim – remove leading spaces and apostrophes when cleaning up data imported from elsewhere
• Left – find x number of characters from the left of a string
• Right – find x number of characters from the right of a string
• Upper – force to upper case
• Substitute – substitute one thing for something else
• Paste Special – use Paste Special to change a formula to values or apply other options

### Course Outline

#### Formula and Functions

Click here to download the course outline

## Manage your Data in Excel

By the end of this half-day course, you will be able to sort and filter data so that you can focus on the information you wish to get out of Excel

In particular, you will learn:

• The Ribbon and Quick Access Toolbar
• Setting up the spreadsheet for data
• What is a list?
• Sorting and filtering
• Format as a table
• Calculated fields
• Conditional formatting
• Subtotals
• Introduction to Pivot Tables

### Course Outline

#### Manage your Data in Excel

Click here to download the course outline

For information and to book any of these courses for your organisation, call us on 020 8203 1774.