ADVANCED MICROSOFT EXCEL

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.