Instructor-led training - Excel Advanced Part 3 - For Power Users training course London and UK wide
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Microsoft Partner

Learning & Performance Institute - Accredited Training Provider

How to book

Live 12+ month schedule

On-site / Closed company:

60 second quote

Need help or advice?

Enter your name/number and we will call you back

We'll call during UK business hours

Name:
Number:

Excel Advanced Part 3 - For Power UsersExcel 2010 / 2007

Advanced Part 3 - For Power Users - London & UK wide

1 day from £150 List price £350

Instructor-led / Microsoft qualified trainers

Courses never cancelled: Guaranteed

Benefits

  • Discover new ways to analyse your data by using the Analysis ToolPak add-in program
  • Use Excel forms to improve data input, speed up data selection and navigation
  • Functional Macros that help you make global changes, return queries and improve security
  • Opportunity to discuss practical applications & revisions of tools used

926 Excel events in the next 12 months, live dates & pricing here


Who is this course for?

Advanced users of Excel with extensive knowledge & use of nesting functions. Those looking to share experiences and experiment in an interactive workshop format.

Prerequisites

Attendance or familiarity with of our Excel Advanced Part 2 course.

Objectives

  • Discover new ways to analyse your data by using the Analysis ToolPak add-in program
  • Use Excel forms to improve data input, speed up data selection and navigation
  • Functional Macros that help you make global changes, return queries and improve security
  • Opportunity to discuss practical applications & revisions of tools used

Course Syllabus

Analysing Data with the Analysis ToolPak

Correlation
Random number generation
Regression
Moving Averages
Histogram
Using regression techniques with Trend and Growth
Frequency distributions

Using Forms

Creating forms containing text box, command button, combo box, check box, option button, list box, scroll bar and spin button controls.

Creating Functional Macros

Creating macros to change case, add message boxes, display a form, protect worksheets.

Workshop Sessions

Practical application and revision of tools used.

Excel Advanced Part 3 1 day course Onsite/Closed Quote
Date Location Places
available
Book Next place rate (£) List
price
Pay by
Card
Pay by
Invoice
Fri 24 May 2013 Limehouse 0 FULL    £350
Fri 2 Aug 2013 Southwark 5 Book now £279 £290£350
Tue 24 Sep 2013 Bloomsbury 6 Book now £277 £287£350
Mon 28 Oct 2013 Southwark 6 Book now £276 £287£350
Fri 29 Nov 2013 Bloomsbury 7 Book now £167 £178£350
Fri 20 Dec 2013 Southwark 8 Book now £150 £160£350
Fri 24 Jan 2014 Southwark 7 Book now £167 £178£350
Mon 24 Feb 2014 Limehouse 8 Book now £150 £160£350
Thu 27 Mar 2014 Bloomsbury 8 Book now £150 £160£350
Tue 29 Apr 2014 Limehouse 8 Book now £150 £160£350
Fri 23 May 2014 Limehouse 8 Book now £150 £160£350
Mon 30 Jun 2014 Southwark 8 Book now £150 £160£350
Mon 28 Jul 2014 Limehouse 8 Book now £150 £160£350
Wed 27 Aug 2014 Bloomsbury 8 Book now £150 £160£350

What you get

Training room

Training is held in our modern, comfortable, air-conditioned suites

Modern-spec IT, fully networked with internet access

"What do I get on the day?"

Learning tools

Breaks and TimingsBreaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)

In-course handbookIn-course handbook

Contains unit objectives, exercises and space to write notes

RefreshmentsRefreshments

Available throughout the day:

  • Hot beverages
  • Clean, filtered water
  • Biscuits
Reference materialReference material

Available online. 100+ pages with step-by-step instructions

LunchLunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:

24 months forum access24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

Training Formats & Services

Testimonials

Civil Service Healthcare
Semior Business Analyst
Khan Gause
Excel Advanced Part 3
Very useful structure & presentation format. looking forward to my next vba course.

More testimonials

Some of our clients:

London 2012 Special Olympics Great Britain BBC
13 delegates 19 delegates 17 delegates
92% would
recommend us
100% would
recommend us
100% would
recommend us
Ricoh Europe plc Transport for London UK Sport
12 delegates 35 delegates 29 delegates
100% would
recommend us
85% would
recommend us
100% would
recommend us
Virgin Media Television Houses of Parliament Al Jazeera International Ltd
19 delegates 16 delegates 17 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
KPMG LLP (UK) Rabobank DHL
29 delegates 54 delegates 42 delegates
100% would
recommend us
100% would
recommend us
94% would
recommend us
Sony Europe IOM Accor Group
25 delegates 85 delegates 28 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
HM Treasury Johnson Controls Unilever
29 delegates 31 delegates 80 delegates
100% would
recommend us
97% would
recommend us
96% would
recommend us
The Roof Gardens Macmillan Publishers Ltd Mo Ibrahim Foundation
18 delegates 41 delegates 22 delegates
100% would
recommend us
98% would
recommend us
77% would
recommend us
Close Brothers Group plc City of Westminster National Lottery Commission
114 delegates 41 delegates 11 delegates
94% would
recommend us
91% would
recommend us
100% would
recommend us


Frontpage training London
Course rating:
5.0 stars - based on 56 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest