Ultimate Microsoft Excel Bootcamp

Excel With Business

Course

Online

£ 199 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Class hours

    65h

  • Duration

    Flexible

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Hone your skills in one of the most important, universal areas in the modern knowledge workers day to day job, and become indispensable.

However, we know Excel can be mystifying and intimidating to many people.

This bundle is perfect for beginners all the way through to data and financial analysts interested in solving complex business problems. We’ve established ourselves as the Excel experts in the last 9 years, and you won’t find better, or more thorough content anywhere else.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit.

We also know how difficult it is to find quality instruction that is:

Easy to follow
Gets you the results you want
Teaches you advanced methods that you can quickly put into practice
That’s why we developed our online Excel courses. In addition, our Business Analysis course will enable you to apply your newfound Excel skills to real-life business scenarios, turning buckets of data into actionable insight.

CPD UK

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Excel
  • Microsoft Excel
  • PC
  • PC training
  • Financial
  • Financial Training
  • MS Excel
  • Microsoft excel training
  • Spreadsheet
  • Navigate

Course programme

The courses this bundle will cover:

Microsoft Excel (Now Includes 2019):

  • How Excel works, how to navigate and design a spreadsheet
  • The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
  • To use PivotTables, Pivot Charts and Basic Macros
  • To create beautiful looking graphs and charts
  • Formatting, including; conditional, cell and number formatting
  • How to print what you want

Microsoft Excel is available in versions: 2003 PC, 2007 PC, 2010 PC, 2016 PC, 2013 PC, 2019 PC, 2011 MAC, 2016 MAC

Advanced Microsoft Excel (Now Includes 2019 Version):

  • Use advanced graphs in minutes instead of wasting hours trying to figure them out
  • Increase interactivity by automating your spreadsheets with macros and VBA
  • Solve complex problems with superpower functions
  • Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.
  • And more!

Advanced Microsoft Excel is available in versions: 2007 PC, 2010 PC, 2013 PC, 2016 PC, 2019 PC

Microsoft PivotTable:

  • The primary uses of pivot tables
  • How to identify the best and worst data sets
  • To filter, sort and group PivotTable™ data to maximise its usefulness
  • How to present your data clearly using PivotCharts and Conditional Formatting

PivotTable is available in versions: 2007 PC, 2010 PC, 2013 PC

Business Analysis:

  • How to turn buckets of data into sound business decisions
  • Financial modelling theory
  • Essential Excel analysis techniques such as Dynamic Ranges, and Advanced Charts
  • How to effectively and clearly present your findings to relevant stakeholders
  • Different forecasting techniques, including Moving Averages and Regression

See related categories

Ultimate Microsoft Excel Bootcamp

£ 199 VAT inc.

The best Excel courses

See all

See all