Microsoft Office training -  Advanced Excel 2013

Excel Training

Advanced Excel 2013 (2 days)

£525 + VAT for most venues (£650 + VAT for London)

We call this our advanced Excel course, but perhaps it should be called intermediate-to-advanced. This two-day course is aimed squarely at those who have already learnt to use (and love?) Excel, but who suspect that it can do much more than they currently use it for. We'll aim to show you that your suspicions are correct! 

Course details

  • Locations for Advanced Excel 2013 coursesLocations:Manchester, London
  • Next Advanced Excel 2013 course locationNext course:Tue 28 June 2016
  • Advanced Excel 2013 course timesTime:09.30-16.30

Course Contents

Formatting numbers and dates

  • Training topicStandard number formats
  • Training topicCreating custom formats
  • Training topicDates and times
  • Training topicScaling, colours and underscores

Conditional formatting

  • Training topicCreating/using cell rules
  • Training topicData bars and colour sets

Covered if time allows If time

Styles

  • Training topicUsing the default styles
  • Training topicCreating custom styles
  • Training topicUsing styles with protection

Cell comments

  • Training topicAdding comments
  • Training topicPrinting comments

Validation

  • Training topicSetting validation rules
  • Training topicInput messages (a bad idea)
  • Training topicHighlighting validated cells
  • Training topicSingle-cell dropdown lists

Protection

  • Training topicUnlocking cells
  • Training topicProtecting worksheets
  • Training topicProtecting workbooks
  • Training topicVery hidden worksheets

Grouping and outlining

  • Training topicGrouping rows/columns
  • Training topicMoving the outline symbols

Range names and absolute references

  • Training topicFixing cell references ($)
  • Training topicFixing rows/columns only
  • Training topicRange names
  • Training topicLabelling ranges

IF functions

  • Training topicThe IF function
  • Training topicNesting Ifs (and why not to)

Lookup functions

  • Training topicExact-match lookup formulae
  • Training topicContinuous value lookups
  • Training topicIntercepting and handling errors

Multiple worksheets

  • Training topicMoving and copying sheets
  • Training topicGroup editing
  • Training topicConsolidation across sheets

Basic tables

  • Training topicCreating and naming tables
  • Training topicSorting tables
  • Training topicFiltering table data
  • Training topicTable styles and formatting

Advanced Tables

  • Training topicRemoving duplicates
  • Training topicAdvanced filters
  • Training topicCreating table styles
  • Training topicSubtotals

Pivot tables

  • Training topicCreating pivot tables
  • Training topicSwapping rows, columns and pages
  • Training topicGrouping fields
  • Training topicDrill-down

Covered if time allows If time

Slicers

  • Training topicPivot table slicers
  • Training topicChanging slicer properties

Charts

  • Training topicSelecting data
  • Training topicQuick ways to create charts
  • Training topicFormatting your chart
  • Training topicChart templates

Advanced charts

  • Training topicCombination charts
  • Training topicPicture charts
  • Training topicRegression and trendlines
  • Training topicSpecialist charts

Covered if time allows If time

Sparklines

  • Training topicCreating sparklines
  • Training topicChanging chart types
  • Training topicFormatting sparklines

Recording Macros

  • Training topicAbsolute/relative recording
  • Training topicWhere macros are stored
  • Training topicAssigning macros to buttons

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"The manuals and other materials provided are excellent, the low number of attendees allows a more personal service and helps tailor the course to our needs which is fantastic."

Mark Hickey (Galliford Try Environmental)

"The course was broken down really well and complicated things made to seem simple."

Tracy Ireland (University of Salford)

"Excellent venue and facilities. The course content was excellent and trainer was incredibly patient with very clear instructions."

Jane Bott (Emerson Process Management Ltd)

"The trainer was great - I've never had any real confidence with Excel but I'll definitely be able to use this course back at work. "

Emma Bryce (First Group)

"The course admin, manuals and content are all excellent. I use the Wise Owl SQL manual (from an earlier course) regularly and expect to refer to the Excel one frequently."

Sue Lowe (Learning and Skills Council)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Delegates should already have a good working knowledge of Excel (one way to achieve this would be to attend our one-day introduction to Excel course).  Note that the course uses Excel 2013, although if you're using Excel 2010 or 2007 you'll still find the vast majority of this course useful (you can see what's different about Excel 2013 here).

Related Courses

Excel Business Modelling

Advanced

2 day course

Excel VBA macros RECOMMENDED

Advanced

2 day course

PowerPivot / Excel Power BI

Advanced

2 day course

Other Microsoft Excel training resources

Excel exercises

Excel exercises

Don't book a course blind - have a look at some of our Excel exercises published online first, to see if you like our approach.

View Excel 2010, Excel VBA or Power BI exercises

Excel videos

Excel videos

We've got loads of videos on Excel tips and other Excel subjects online.

View Excel Tips, Excel VBA, Microsoft Excel or Excel 2013 Power BI Tools videos

Excel skills assessment

Excel skills assessment

To see how well you know Excel, try taking one of our tests - they're designed to show you how well you know Excel relative to others.

View Excel or Excel VBA skills assessment tests

Excel blogs

Excel blogs

There are lots of Wise Owl blogs on Excel, usually answering specific questions about the software.

View Excel, PowerPivot 2010 or VBA macros blogs