START
 

Advanced Excel

Wise Owl
Course summary
Length: 2 days
Location: Nationwide
Next available date: Enquire for details! - Nationwide

Course Description

Advanced Excel Training Course - London, Manchester, BirminghamLearn Advanced Skills in Microsoft Excel 2013 - 2-Day In-House Training in the UK

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 teams using Excel 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 teams who have an understanding of the excel programme, but feel that they could gain more benefit from the programme. 

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's content is customisable and typically covers:

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

This course can also be delivered on-site for groups, teams or companies. Enquire for details to receive a quote!

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)
Dace Fjodorova   |   20/11/2016
Excellent course!
          (5)
Charles Smith   |   19/11/2016
Very good all round - venue is great, the trainer was great, manual is great.
          (4)
Nidhi Bhola   |   19/02/2016
Great course, relevant. Trainer was really clear and helpful.
Take part & win £50 voucher

 
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

 
Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

 
Find more courses here