MS EXCEL TRAINING

Come and experience the best Excel training on the planet through our Innovative Excel Training App

All of our Excel courses will be delivered through our proprietary Excel Training App that delivers pre-recorded and live classes inside your Excel Application itself without having to leave it.

Excel App features:

• Fully Integrated to Excel application

• Streaming video lessons

• Load Excel files for practice

• Downloadable resource files

• Quizzes

• Practice Tests

• Assignments

• Coding Exercises (VBA)

• + Much more

We offer pre-designed and bespoke corporate and personal virtual training courses. Our courses cater to the training needs of all users ranging from beginners to advanced. We will issue Certificates upon successful completion.

Training is provided by qualified and experienced trainers with many years of experience in the industry. Our Finance Excel and Financial Modelling courses are conducted by qualified accountants and Financial Analysts.

Job Specific Training

We have developed specialist training targeting particular industries focusing on the skills needed for that specific career. We offer virtual Excel courses for Banking and Finance, Accountants, Sales, Administrators and PAs, and Office Managers etc.

Virtual Classroom Excel Courses

We offer Virtual Classroom Courses in Excel. This enables companies to arrange corporate training for their employees through virtual classroom software. This means you will use a real live Excel tutor to deliver the training, just like a regular classroom course. This option is very popular for companies looking to train their employees without travel/accommodation costs, particularly during the COVID-19 crisis.

Bespoke and Corporate Excel Training

Our tutors are experts in their field and possess significant work experience as bankers, financial analysts and accountants in using Excel rather than just tutors. We have delivered bespoke Excel courses to Banks, Investment Banks, Accountancy Institutes, Accountancy firms, Marketing Institutes, Manufacturing Companies, HR Institutes and much more. This type of programme is ideal for making the learning relevant to your needs and can increase a company’s efficiency; please find out more about our Corporate Training. Whether you want to learn data analysis, financial modelling, excel for business, pivot tables, charts or just the basics, we have the right training course for you.

Courses Available:

• Beginners Excel

• Intermediate Excel

• Advanced Excel

• Excel for Finance

• Bespoke Excel Training

• Financial Modeling and Valuation

Why train with us?

• All training provided through our innovative Excel training App

• Personal one on one training

• Experienced trainers

• Competitive fees starting from £50 per hour

• Flexible hours

• Fully customized training (Starting from £250 p.p.)

• Virtual classroom training

• Group training for corporates and individuals (Starting from £250 p.p.)

• Certificate is awarded for successful completion

• Life time access to course videos and resource files on our the Excel Training App

  
  
  

Course Details:

1. Beginner Excel

Description

This is beginner Excel Course which is delivered online interactively. Microsoft Excel skills are very important when working in an office job. This critical piece of office software is vital for several roles within Admin, PA, Sales, Finance and Bookkeeping. This has led to many employers testing out their prospective new employees’ Excel skills, and not hiring those people who are unable to show at least a proficient level of Excel skills.

If you need to work on your Excel skills, then we have the proper training course for you.

Training Objective

Our training centre enables students to gain all the skills needed for everyday tasks. The Beginner Excel Training Course issues a certificate to participants after the course has finished if completed successfully.

The aim is to attain a good beginner level in Excel.

Course Format

The training is delivered online, by an experienced tutor. This is a very effective and up to date method of delivering interactive online training.

Excel Training Course Content

• Microsoft Excel Fundamentals

• Customizing Ribbon

• Entering and Editing Text and Formulas

• Absolute and Relative Cell Referencing

• Keyboard Shortcuts & Efficient Formula Entry

• Working with Basic Excel Functions Modifying an Excel Worksheet

• Formatting Data in an Excel Worksheet

• Inserting Images and Shapes into an Excel Worksheet

• Creating Basic Charts in Excel

• Printing an Excel Worksheet

• Working with Excel Templates

Dates and Duration

The course can be started and taken at any convenient times with pre-confirmation. Estimated live learning hours are 6-8 depending on aptitude

Course Requirements

There are no entry requirements for this course. It is aimed at beginners. If you are more advanced, you can start with the Intermediate Course.

Benefits

• Experienced Microsoft Trainers provide training.

• Live help with your tutor.

• Certificate issued on completion.

• A practical course that includes numerous exercises.

  
  Course Cost

  Please contact us for details of this.
  
  

2. Intermediate Excel

Description

Training in Microsoft Excel Intermediate is an in-depth program to gain professional knowledge which is much needed in any office.

Objective

To learn the most efficient way to use Excel; to gain a recognized Certificate at Proficient (Intermediate) level.

Course Format

The training is delivered online, by an experienced tutor. This is a very effective and up to date method of delivering interactive online training.

Course Content

• Keyboard Shortcuts & Efficient Formula Entry

• Excel Data Validation

• Importing and Exporting Data

• Working with Large Sets of Excel Data

• Range Names

• Lookup Functions 

• Text Functions

• Date Functions 

• IF Statements

• Tables 

• Using Pivot Tables and Slicers to Describe Data 

• The INDEX Function

• The MATCH Function 

• AVERAGE, MEDIAN, MIN, MAX, SMALL, LARGE, IFERROR and SUMPRODUCT Functions

• Creating subtotals

• Advanced Charts

Dates and Duration

The course can be started and taken at any convenient times with pre-confirmation. Estimated live learning hours are 7-8 depending on aptitude.

Benefits

• Certificate

• Added qualification to boost your CV and job options

• Being prepared for any assessment at a job interview

• Confidence in the use of Excel effectively at work

• Work quickly because of this additional knowledge

• Flexible training

  Course Cost

  Please contact us for details of this.
  
  

3. Advanced Excel

Description

Advanced Excel Course delivered online for Excel users who want to perfect their skills.

If you work within an office, then there is a good chance that you will need to use Microsoft Excel daily. This is particularly true if your role has elements of finance, accounts or bookkeeping involved. The more financial aspects your role entails, the more skills you will require in Excel, with many companies asking their workers to show Advanced skills. Your ability in Excel will often be tested at the interview stage, with applicants unable to master the software not being considered for the role.

Objective

The main objective of this course is to enable students to gain advanced-level skills in Excel. As a reputed Academy, offering advanced excel classes online, you can be sure that all the training, knowledge and skills that you receive are state of the art and your training will be delivered to the highest level. The Advanced Excel Training Course students will be provided with a certificate after completion. The course format is ideal for anyone looking to learn advanced excel online.

Course Format

The training is delivered online, by an experienced tutor. This is a very effective and up to date method of delivering interactive online training.

Course Content

• Keyboard Shortcuts & Efficient Formula Entry

• Mixed Cell referencing

• Excel Database Functions

• Advanced Lookup Functions

• Working with Excel's Conditional Functions

• Mastering Excel's "What If?" Tools

• The Goal Seek Command 

• Introduction to Power Query

• Consolidating Data 

• Introduction to Power Pivot

• Array Formulas and Functions 

• 3-D Formulas

• Sensitivity Analysis with Data Tables 

• The Auditing Tool 

• Sparklines

• The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions 

• The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions 

• CHOOSE Function

• Macro Recorder 

• Advanced Charts

Dates and Duration
The course can be started and taken at any convenient times with pre-confirmation. Estimated live learning hours are 7-8 depending on aptitude.

Advanced Excel Course Requirements

You should have Proficient Level skills in order to be able to take the Advanced Course and gain an advanced excel certification online.

Benefits

• Training is written by senior experienced Trainers

• Certificate issued on successful completion

• The training is highly practical, with numerous exercises for hands-on learning.

• As a reputed Excel training provider we can guarantee that we offer the best advanced excel course online.

  Course Cost

  Please contact us for details of this.
  
  

4. Excel for Finance

Description

This Excel for Finance Course is ideally designed to ensure that you have the Excel skills needed to work in Finance. We specialises in finance, banking and Microsoft Office Training. Our training staff have delivered training to major financial institutions and we can deliver training to accountancy businesses and financial consultants too. We have used our expertise to develop an accessible and affordable Excel Training Course designed to fit the specific needs of people in finance, banking or accountancy. It can also benefit those who work with large amounts of data and are responsible for manipulating and analysing this information.

Objective

This particular course set out to provide targeted levels of MS Excel Tuition aimed at those working with a financial career. It focuses on the essential requirements that you may see in the average job description within this industry and is both an excellent way to prepare for job interviews and for those who want to develop their Excel skills.

Excel Training Course Format

The training is delivered online, by an experienced tutor. This is a very effective and up to date method of delivering interactive online training.

Course Content

The course syllabus focuses on the most commonly required Excel tasks in finance, banking and accountancy jobs.

Here is an outline of the course:

• Keyboard Shortcuts & Efficient Formula Entry

• Mixed Cell referencing

• Best practices in Financial Modelling 

• Range Names

• Evaluating Investments by Using Net Present Value Criteria

• Internal Rate of Return & Payback Period

• More Excel Financial Functions

• Depreciation Functions 

• Using Solver, Goal Seek and Scenario Manager

• Advanced Lookup Functions

• Introduction to Power Query

• Introduction to Power Pivot

• Sensitivity Analysis with Data Tables 

• The Auditing Tool 

• The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions 

• The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions 

• Using Solver, Goal Seek and Scenario Manager

• Macro Recorder 

Dates and Duration
The course can be started and taken at any convenient times with pre-confirmation. Estimated live learning hours are 7-8 depending on aptitude.

Advanced Excel Course Requirements

You should have Proficient Level skills in Excel and Financial concepts in order to be able to take the course and gain an advanced excel certification online.

Course Benefits

• Achieve Certification in Excel for Banking and Finance

• A recognized qualification that will boost your CV and enhance your job options

• Learn all the Excel skills needed to succeed in banking and finance

• The comprehensive nature of the course gives you a solid basis to build your career

• Gain confidence in using Excel in the workplace

• A greater level of efficiency in the workplace

Course Cost

Please contact us for details of this.

5. Bespoke Excel Training

Our Bespoke Excel Course will greatly improve your skills and use of this incredibly important piece of software.

We provide bespoke Excel training to a range of clients from large multinationals, to small organisations and private individuals.

• We can design a course which covers aspects for beginners up to advanced levels.

• If your business has specific requirements relating to job roles, then we can create a bespoke syllabus that relates to a variety of different Excel processes.

• You can, if desired, use your own data as a focus for the training. Enabling your staff to find more effective ways of working, using Excel as a tool.

• We will also work with existing company spreadsheets, integrating and streamlining processes to make them smoother.

• We can also provide a more cost-effective method for spreadsheet design consultancy.

Course Cost

Please contact us for details of this.