Home Events Microsoft Excel Intermediate Training with Olas IT

Microsoft Excel Intermediate Training with Olas IT

The objective of our Microsoft Excel Intermediate training course is to develop a good working knowledge of Excel to include features such as functions and formulae, sorting and filtering data, working with charts and pivot tables.

This event is brought to you courtesy of Olas Software Training & Development

Event Details

Organisation
Olas Software Training & Development
Dates
16 November 2021
Venue
Olas Virtual Live Classroom Training
Website
Contact Email

More Information

TARGET AUDIENCE
The Microsoft Excel Intermediate course is aimed at users who have basic experience with Excel and want to build on their current knowledge to set up their own spreadsheets and manipulate existing ones.

PREREQUISITES
Participants should be existing users of Microsoft Excel who can create, edit, format and print a spreadsheet. They should also be able to create basic formulae and, ideally, should have completed the Excel Introduction training programme.

GOALS AND OBJECTIVES
Having completed this course, participants will be able to:

Create complex formulae incorporating relative and absolute cell addressing
Use a wide range of Excel functions such as Sumif, Countif, IF, Or, And, Lookups, ISError and many more
Build and apply Conditional Formatting
Link Sheets and Files
Manipulate Data – Sorting, Filtering, Validation
Create Pivot Tables
Create a wide range of Charts

Special Offers

Re-Opening Early Bird Special from Narra Thai

We’re back open for indoor dining and looking forward to welcoming you again! To celebrate, we’re offering a supremely tasty Early Bird Special.

20% Off Recruitment Services!

As we slowly make our way back into our offices, upgrade our work-from-home stations or finalise agreements on hybrid working; we can agree that this October will feel different than any one previous.