Advanced Microsoft Excel

Learn and apply advanced Microsoft Excel skills

Our Course

We understand what a daunting and lonely place you can find yourself when starting (or thinking of starting) a new business venture. We have expert knowledge of the various different elements that need to be considered and actioned when setting a business up for a successful launch and a sustained operation. Through not only our experiences but industry proven techniques and methodologies, we have put together a course that will define what steps you will need to take, what knowledge you will need to garner and tools, methodologies and techniques that you can use, to keep you the best possibility to succeed in your endeavour. that you will have an enjoyable and profitable experience.

Target Group
Virtually anyone who is thinking of starting a business, irrespective of the industry. It is also a beneficial course for those business owners that are looking to refresh their operations

Delegates Pre-requisites 
No pre-requisites are required to undertake this course. 

Aims and Objectives
The aim of the programme is to equip the delegate with the theory and practical skills to either start up their own enterprise or run their existing business start up better. 

Course Content


What is excel 
Basic math
Understanding formulas 
Cell referencing 
Excel functions 
Basic statistics 
Logic functions 
Working with dates and times 
Intermediate formulas 
Conditional maths 
Temporal functions 
Other lookup methodology - HLOOKUP, INDEX, MATCH 
working with data 
Data sorting 
Contiguous data 
Naming Ranges 
Excel tables 
Pivot tables 
What if analysis 
Cell formatting 
Custom number formats 
Conditional formatting 
Working with charts
Data validation 
How to use data validation 
Data validation lists 
Preparation for business utilization 
Custom views
Page setup options 
Document and data protection