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 February 2017
  • 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

"I enjoyed the course and thought it was very well run. The instructor was very good and very patient with me and explained everything fully and made sure everyone understood before moving on to the next stage. "

Debi Jones (Canal & River Trust)

"The trainer was very knowledgeable and enthusiastic. The manual is very informative. I appreciated the nice biscuits and lunches!"

Liz Cooper (Verus UK LLP)

"The trainer explained everything really well. Happy to answer any questions we had and to go over anything we didn't understand. The manual and exercise book are really helpful; I can practice these techniques back at work on spreadsheets I use daily."

Louise Thompson (ABB Ltd)

"Fantastic course and very well delivered. Much learnt and enjoyed - thank you. I will be back for other courses in the near future."

Craig Johnson (Greater Manchester Comprehensive Local Research Network)

"A quality course, enthusiastic delivery in a clear and understandable format."

Mike Howard (Ferranti Technologies Ltd.)

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 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, Power BI - Excel 2013 or VBA macros blogs

This page has 0 threads Add post