Microsoft Excel 2013 Training Course Advanced Cambridge

Cambridge Advanced Microsoft Excel 2013 Course Overview

The science park to St. John's Innovation centre. The university city of Cambridge is a regular training venue. We've trained various companies in and around Cambridge as far out as Cambourne, Newmarket, Huntingdon and St. Ives. A Advanced Microsoft Excel 2013 Training Course at the offices we use at the Regus in Cambourne is easy to set up and conduct even at short notice. Or maybe you just want us to come to you bringing a projector, laptops with Excel preloaded along with fully comprehensive course notes.

Cambridge is renowned for its prestigious university and stunning architecture.

Cambridge was actually the first area we started training. From Cambridge Consultants on the science park to ARU, CRC (Cambridge Regional College) and many more have taken advantage of the computer training courses conducted by us.

Course Duration: 1 Day

Course Prerequisites for your training in Cambridge

The delegate would preferably have had previously experience using Excel formulas and functions. Either by having been on a Beginners and Intermediate training course or by having used Excel regularly.

Complete Course Outline

Using and Editing Macros in Excel 2013

• Recording a Macro
• Editing the Macro Code
• Attaching a Macro to a Button on the Ribbon

Conditional Formatting changing cells based on a value

• Using Formulas with Conditional Formatting
• Customising the Icon Sets

Working with Others

• Password Protecting Files
• Sharing Workbooks
• Tracking Changes
• Merging Workbooks
• Digital Signatures

Data Validation including drop down lists

• Ensuring Users Enter the correct Text
• Using Drop Down Lists
• Giving guidance to users by displaying an Input Message
• Giving custom error messages

Auditing Worksheets

• Trace Formulas in Excel
• Finding Errors in your Formulas
• Evaluate your Formulas
• Scenarios
• Using the Analysis Toolpak Add on
• Sparklines - Mini charts in your Cells

Integrating External Data

• Importing data
• Getting live Data from the Web
• Getting Data from Access
• Using XML what is it and how can it benefit me

Have a look at our range of Excel Training Courses

You may also be interested in:

Microsoft Excel 2016 Training Course Beginners

Microsoft Excel 2016 Training Course Intermediate

Microsoft Excel 2016 Training Course Advanced

Microsoft Excel Pivot Tables Training Course Beginners

Microsoft Excel PowerPivot Training Course Intermediate

Microsoft Excel 2013 Training Course - Intermediate

Microsoft Excel 2013 Training Course - Beginners

Microsoft Excel 2010 VBA Training Course - Beginners

Microsoft Excel 2010 Training Course - Advanced

Microsoft Excel VBA 2007 Training Course - Intermediate