Microsoft Office training -  Advanced Excel

Excel Training

Advanced Excel (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 coursesLocations:Manchester, London
  • Next Advanced Excel course locationNext course:Thu 04 May 2017
  • Advanced Excel 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 family of functions

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

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 topicGrouping fields
  • Training topicDrill-down
  • Training topicSlicers and timelines

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 trainer was very patient, gave clear precise instructions and put me at ease immediately."

Teresa Jewell (DH Welton & Co (Builders) Ltd.)

"Very helpful, supportive, clearly explained and feel more informed overall. Thanks!"

James Panton (Cancer Research UK)

"Great course with an enthusiastic tutor. Enjoyable two days."

Daniel Brooke (Investec Wealth Investment Limited)

"The course was very informative and will be very useful to me at work. Our trainer was very knowledgeable and approachable."

Kathleen Rowden (Intelect Recruitment)

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 2016, although if you're using Excel 2013 or 2010 you'll still find the vast majority of this course useful (you can see what's different about Excel 2016 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