Go to XChangeTraining Home Page
Main XChange Training Logo White

0845 363 1130 • info@xchangetraining.co.uk
Book a creative publishing course by clicking here Desktop Publishing Training Resources Learn more about us and our training centre in central London, UK Contact XChangeTraining
Spacer
Spacer between logo and content

Advanced training courses in Microsoft Excel for specific needs (bespoke)— Bespoke

Microsoft Excel is the standard spreadsheet application, an essential component of the Microsoft Office Suite. Excel provides comprehensive tools to help you create, analyze, and share spreadsheets, and its powerful, enhanced formatting features allow users to analyze and visualize data through the creation of graphs and charts.

XChangeTraining offer Microsoft Excel bespoke courses that are tailored to focus on your specific needs.

If you are interested in discussing bespoke training from XChangeTraining please contact our training department to discuss this option further or fill in our course-builder form and we’ll contact you with a proposed course outline tailored to your needs.

Arrow style bullet pointInformation on Pricing, Location and Booking for this course.

Arrow style bullet pointView all Microsoft Excel training courses

 Spacer image on Microsoft Excel training at XChangeTraining page
Microsoft Excel training at XChangeTraining
 
Horizontal Red Line

Advanced training courses in Microsoft Excel for specific needs (bespoke) Outline

The following is a general outline. The range of topics covered during your training is dependent upon student level, time available and preferences of your course booking.

Lookup & Information Functions
-Build the Vertical Lookup (Vlookup) function
-Build the Horizontal Lookup (Hlookup) function
-Build the Match and Index functions
-Build the IsText, IsValue, IsDate , IsNull , IsErr, IsNa functions
-Build and use Database Functions

Pivot Tables
-Create A PivotTable
-Change the PivotTable layout
-Manipulate PivotTable fields
-Format the PivotTable and apply Styles
-Use Banding (Formatting)
-Group & Ungroup items
-Filter data in the PivotTable
-Insert calculated fields
-Change calculation options
-Change PivotTable Options
-Display and hide data in fields
-Lay out reports on worksheet
-Create a PivotChart from report
-Manipulate PivotChart fields
-Use Slicers

What If Analysis
-Create and manipulate Scenarios
-Create and change Custom Views
-Build scenario Reports
-Use the Goal Seek tool
-Use Solver & Advanced Solver Features
-Build Data Tables

Protecting & Sharing Files
-Share a file
-Track changes
-Accept or reject changes
-View Change history
-Apply Data validation rules
-Insert, edit and delete comments

Spacer image

Introduction to Macros
-Review the purpose of Macros
-Record a macro
-Save a macro
-Edit a Macro
-Absolute and relative records
-Running macros:
-Apply macro to Custom buttons on the Ribbon or Quick Access toolbar, keyboard shortcuts

Customizing Excel
-Customize the Quick Access Toolbar and Ribbons
-Set Workbook options
-Change workbook defaults

Templates
-View Template Types
-Use Normal Template
-Open Sample Templates
-Create Custom Templates
-Use Custom and online Templates
-Open And Edit Templates
-Setting Template Properties

Objects In Excel
-Insert, Format And Delete Objects
-Insert A Drawing Object
-Use the design ribbon
-Use SmartArt
-Apply Formatting to SmartArt
-Use QuickStyles
-Explore 2D And 3D Formatting
-Insert and use WordArt
-Insert and Format Shapes
-More on Themes and styles
-Manually Format an object
-Customize or create A Them


Horizontal Red Line

Related Microsoft Excel training courses — Bespoke

Below you'll find an up-to-date list of related bespoke training courses in London or throughout the UK offered by XChange Training. Just click on a link to view course details:

Arrow style bullet pointAdvanced courses in Microsoft Project for specific workflows (bespoke)
Arrow style bullet pointAdvanced courses in Microsoft Visio for specific workflows (bespoke)
Arrow style bullet pointAdvanced training courses in Microsoft Outlook for specific needs (bespoke)
Arrow style bullet pointAdvanced training courses in Microsoft PowerPoint for specific needs (bespoke)
Arrow style bullet pointAdvanced training courses in Microsoft Word for specific needs (bespoke)

  [For Pricing, Location and Booking information click on a course link above.]

 

Horizontal Red Line

Advantages of learning Microsoft Excel with XChangeTraining

-Our Microsoft Excel trainers are experienced professionals with excellent knowledge of all aspects of the Microsoft Office suite.
-It's bespoke and solutions based: before you come to XChange Training we agree the course content with you based on your needs.
-We take the time to work specifically on any files you bring along to the course, ensuring that you see benefits to your workflow immediately.
-XChange training focuses on real tasks that reflect how the software is used in professional situations.
-On-site and off-site training is available for the whole UK.
-Free email support service for 6 months after course.
-We get consistently good feedback from our clients.
 Read client testimonials...

Horizontal Red Line Spacer

Training Pricing

On-site course pricing
Prices include a set of course notes per trainee, 6 months telephone and/or e-mail support service after the course, all refreshments and lunch if held at the training centre.

For training onsite courses outside of London a standard return train fare and/or taxi fare may be applicable.

Training centre pricing
Pricing for training at the Clerkenwell facility:
1 person £495 for a 1 day course
2 people £595 for a 1 day course
3 people £695 for a 1 day course
4 people £795 for a 1 day course
5 people £895 for a 1 day course
6 people £995 for a 1 day course
7 people £1045 for a 1 day course
8 people £1095 for a 1 day course
All prices subject to VAT

  

Training Centre address
5 St John's Lane
Clerkenwell, London
EC1M 4BH

Tel: 0845 363 1130
Email: info@xchangetraining.co.uk

Arrow style bullet pointCourse Location Map Link

For courses held outside of London for less than 3 trainees, an additional charge may be applicable depending upon the location - please ask for details.

Training Booking
To reserve a place on a training course, please click the link at right or contact us by telephone or email on the details above. You will then be contacted shortly to confirm the booking.

 Enquire about or book
this course here
Spacer
Horizontal Red Line

All prices offered for business users and exclude delivery and VAT. E&OE
©XChange Training 2012. All Rights Reserved. | Privacy Policy