# Half Day Excel Courses

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

Courses are run in your organisation on your own computers.

Select from the following Courses.

# Excel for Beginners

By the end of the course you will be able to create and manipulate a simple spreadsheet with basic formulae that calculate your data.

### In particular you will learn:

• ​The Ribbon and Quick Access Toolbar
• Finding your way around a workbook
• Adding text and numbers
• Formatting and Number formats and why they are so important
• 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
• Borers and Shading
• Printing

Click Here to download the course outline.

# Formula and Functions

By the end of the 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 apostrphes 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 and

Click Here to download the course outline

# Manage your Data in Excel

By the end of the 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
• Filtering
• Format as a table
• Calculated fields
• Conditional Formatting
• SubtotalsIntroducing Pivot Tables

Click Here to download the course outline

## Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.