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

Course Outline

Excel for Beginners

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:

 Conditional Processing

  • 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

Course Outline

Formula and Functions

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

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.