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
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:
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 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
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
For information and to book any of these courses call us on 020 8203 1774