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:

• 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
• Printing

1 file(s) 393 KB

## 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

1 file(s) 389 KB

## 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:

• 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

### Manage your Data in Excel

1 file(s) 388 KB

For information and to book any of these courses call us on 020 8203 1774