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