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

Introduction 

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