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 Prerequisites
No prerequisites 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
Course Methodology
This course is an instructor led classroom based environment, always guaranteed to be taught by an expert. The classes will be conducted over 2 days. The course consists of a blend of lectures, application, individualistic and team based exercises. All other materials will be provided to the attendees in the classroom environment. At the conclusion of the course, a certification can be obtained.