Microsoft Excel – Advanced

Save up to 40% on our Microsoft Excel Advanced self-study workbooks.

All versions available from 2007 – 2016

Clear
Contact Us
    Please tick the box above if you agree that Training Link may collect and use your personal data which you have provided in this form, for providing the information that you have agreed to receive, in accordance with our terms and conditions and General Data Protection Regulations.
  • This field is for validation purposes and should be left unchanged.

The Microsoft Excel books are designed as self-study manuals or classroom based courses.

These manuals will help you understand and use your Microsoft Excel software. Please make sure you check which version of Excel you are using and match this with the selection above. We have Beginners, Intermediate and Advanced levels available for 2007, 2010, 2013 and 2016 version.

  • Before You Start
  • Text to Columns
  • Paste Special
  • Data Validation
  • Subtotals and Grouping
  • Consolidate Data
  • What-if Analysis – Data Tables
  • What-if Analysis – Scenarios
  • What-if Analysis – Goal Seek
  • Text Functions
  • Lookup Functions
  • Maths and Trig Functions
  • Statistical Functions
  • Database Functions
  • Formula Auditing and Error Tracing
  • Linking Data
  • Hyperlinks
  • Getting External Data
  • Pivot Tables and Pivot Charts
  • Protecting and Sharing Worksheets and Workbooks
  • Workbook Properties and Inspection
  • Encrypting and Finalising Workbooks
  • An Introduction to Macros
  • Illustrations, Text Boxes and WordArt
  • Custom Number Formats
  • Custom Lists
  • Tracking Changes
  • Compare and Merge Workbooks