START
 

Advanced Excel

Wise Owl
Course summary
Length: 2 days
Price: 525 - 650 GBP excl. VAT
Provider: Wise Owl plus
Course type: Open / Scheduled
Next available date: 12/09/2017 - Manchester
Course Dates
Manchester
12/09/2017  
525 GBP
16/11/2017  
525 GBP
London
05/10/2017  
650 GBP
07/12/2017  
650 GBP

Course Description

Advanced Excel Training Course - London, Manchester, BirminghamLearn Advanced Skills in Microsoft Excel 2013 - 2-Day Course in London, Manchester &, Birmingham

When it comes to Microsoft Excel 2013, the possibilities are endless. This 2-day training course is designed to provide delegates with the advanced skill set required to take their excel sheets and presentations to the highest level. 

This course is targetted to excel users who are familiar with the program, but suspect that they could make better and broader use of the programme. Delegates of this course will work through exercises and practical activities to learn a new set of sophisticated and limitless excel functions. 

Suitability - Who should attend?

This intermediate / advanced training course is suitable for individuals who have an understanding of the excel programme, but feel that they could gain more benefit from the programme. 

In order to make the most of each delegate's experience, class sizes are kept to a maximum of 6-8 delegates. 

Outcome / Qualification etc.

Advanced Excel Training CourseUpon completion of this advanced course, delegates will become able to apply and manipulate the Microsoft Excel programme more effectively and efficiently.

Training Course Content

This training course will cover the intermediate and advanced functions of excel, including:

Formatting numbers and dates

  • Standard number formats
  • Creating custom formats
  • Dates and times
  • Scaling, colours and underscores

Conditional formatting

  • Creating/using cell rules
  • Data bars and colour sets

Styles (if time)

  • Using the default styles
  • Creating custom styles
  • Using styles with protection

Cell comments

  • Adding comments
  • Printing comments

Validation

  • Setting validation rules
  • Input messages (a bad idea)
  • Highlighting validated cells
  • Single-cell dropdown lists

Protection

  • Unlocking cells
  • Protecting worksheets
  • Protecting workbooks
  • Very hidden worksheets

Grouping and outlining

  • Grouping rows/columns
  • Moving the outline symbols

Range names and absolute references

  • Fixing cell references ($)
  • Fixing rows/columns only
  • Range names
  • Labelling ranges

IF functions

  • The IF function
  • Nesting Ifs (and why not to)

Lookup functions

  • Exact-match lookup formulae
  • Continuous value lookups
  • Intercepting and handling errors

Multiple worksheets

  • Moving and copying sheets
  • Group editing
  • Consolidation across sheets

Basic tables

  • Creating and naming tables
  • Sorting tables
  • Filtering table data
  • Table styles and formatting

Advanced Tables

  • Removing duplicates
  • Advanced filters
  • Creating table styles
  • Subtotals

Pivot tables

  • Creating pivot tables
  • Swapping rows, columns and pages
  • Grouping fields
  • Drill-down

Slicers (if time)

  • Pivot table slicers
  • Changing slicer properties

Charts

  • Selecting data
  • Quick ways to create charts
  • Formatting your chart
  • Chart templates

Advanced charts

  • Combination charts
  • Picture charts
  • Regression and trendlines
  • Specialist charts

Sparklines (if time)

  • Creating sparklines
  • Changing chart types
  • Formatting sparklines

Recording Macros

  • Absolute/relative recording
  • Where macros are stored
  • Assigning macros to buttons

Expenses

The cost of this course is £525 + VAT per delegate for most venues and £650 + VAT for London. Lunch at a local restaurant is included in course fees as well as a USB stick with course files.

In-House Option

This course can also be delivered on-site for groups, teams or companies. 

Provider: Wise Owl

Wise Owl - Specialist Microsoft Training in London, Birmingham, Manchester and more

The Wise Owl team has made a name for itself delivering specialist Microsoft training for software enthusiasts, by software enthusiasts. With a team of five dedicated full-time trainers, Wise Owl have the knowledge, resources and enthusiasm to deliver Microsoft training...


Read more and show all courses with Provider: Wise Owl

Contact information for Wise Owl

Wise Owl



Barlow House
Minshull Street
M1 3DZ Manchester

 Show phone number
www.wiseowl.co.uk

Reviews by course attendees

          (5)
Hannah Elliot   |   02/11/2016
Amazing course, very beneficial, I learnt a lot. Fabulous course leader, easy to learn from.
          (5)
Donna Stonehouse   |   05/12/2015
I felt I learnt a lot on the course.
          (4)
Colin McGarry   |   03/12/2015
Excellent course - relevant and eye opening at times! Very good presentation.
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here