Advanced Microsoft Excel

Excel With Business

Course

Online

£ 59 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Online

  • Class hours

    16h

  • Duration

    Flexible

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

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 Advanced Excel course. It’s split into five clear sections to get the results you want right away. Your teacher is Simon Hurst, an Excel expert and trainer for 20+ years; whose experienced instruction will transform your Excel skills in under a week with none of the usual frustration.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

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!
Available in Versions: 2007,2010,2013, 2016, 2016/365 and 2019 PC

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
  • Microsoft excel training
  • MS Excel
  • Reducing
  • Reducing Risk
  • Increasing Efficiency
  • Techniques
  • SuperPowers
  • Tables

Course programme

Syllabus:

Section 1: Introduction
  • Unit 1.1 - What's New in Excel 2019?
Section 2: Efficiency and Risk
  • Unit 2.1 - Templates
  • Unit 2.2 - Increasing Efficiency and Reducing Risk
  • Unit 2.3 - Data Validation
Section 3: Advanced Techniques
  • Unit 3.1 - Functions with Superpowers
  • Unit 3.2 - Array Formulae
  • Unit 3.3 - Tables
  • Unit 3.4 - Advanced Range Names
  • Unit 3.5 - WhatIf Analysis
  • Unit 3.6 - Problem Solving
Section 4: Excel Interactivity
  • Unit 4.1 - Form Controls
  • Unit 4.2 - Visual Basic and Macros
Section 5: Spreadsheet Impact
  • Unit 5.1 - Conditional Formatting
  • Unit 5.2 - Charts that Inspire
  • Unit 5.3 - Sparklines
  • Unit 5.4 - Graphics Tricks and Techniques
Section 6: Turning Data into Decisions
  • Unit 6.1 - Working with External Data
  • Unit 6.2 - Advanced Uses of PivotTables
  • Unit 6.3 - Power Pivot
  • Unit 6.4 - Reporting with Power Pivot
Section 7: Course Plenary
  • Unit 7.1 - Course Plenary

See related categories

Advanced Microsoft Excel

£ 59 VAT inc.

The best Excel courses

See all

See all