catraining

 

Microsoft Partner

Microsoft Excel Training Courses London

 

excel advanced

Microsoft Excel, this is the world's most popular spreadsheet application. With over 750 million users worldwide, Excel is the tool of choice for presenting and analysing data. Having a good understanding of Excel is an essential key skill for any office worker today, it is the one application that the business world cannot live without.

Our Microsoft training courses take you on a journey from being a complete beginner through to an advanced user, able to make full use of the application’s capabilities and beyond.

Taught by highly efficient, expert Microsoft Certified trainers with many years of experience our hands-on courses mean that you will gain practical experience as well as useful tips and tricks. Full access to our extensive library of software help guides is included in the price.

microsoft excel training courses london

 

Excel Training Course Outlines

 

Microsoft Excel 2016 Training Courses
 

Excel 2016-Introduction (1 day)

Excel 2016-Intermediate (1 day)

Excel 2016-Advanced (1 day)

Excel 2016-PowerBI Desktop

Excel 2016 Power Pivot and Power View (1 day)

Excel 2016 Power Pivot DAX  (Data Analysis Expressions) formulas (1 day)


Excel Specialist Training

NOTE: These Specialist Training courses are designed to focus on the principles of using MS Excel as a tool to support the named topics. The courses examine how best to utilize Excel to achieve these objectives.

 

Pivot Tables (half day)

Charts (half day)

Functions (1 day)

Database Tools (1 day)

Dashboards (1 day)

Introduction to Financial Modelling (1 day)


Microsoft Excel 2016 training courses MAC

Excel for Mac 2016-Introduction (1 day)

Excel for Mac 2016-Intermediate (1 day)

Excel for Mac 2016-Advanced (1 day)

 

Microsoft Excel 2013 Training Courses

 

Excel 2013-Introduction (1 day)

Excel 2013-Intermediate (1 day)

Excel 2013-Advanced (1 day)

Excel 2013 Power Pivot and Power View (1 day)

Excel 2013 Power Pivot DAX  (Data Analysis Expressions) formulas (1 day)

 

Excel Specialist Training

NOTE: These Specialist Training courses are designed to focus on the principles of using MS Excel as a tool to support the named topics. The courses examine how best to utilize Excel to achieve these objectives.

Excel PowerBI Desktop

Pivot Tables (half day)

Charts (half day)

Functions (1 day)

Database Tools (1 day)

Dashboards (1 day)

Introduction to Financial Modelling (1 day)

 

 

Microsoft Excel 2010 Training Courses

 

Excel 2010 Introduction (1 day)

Excel 2010 Intermediate (1 day)

Excel 2010-Advanced (1 day)

Excel 2010 PowerPivot (1 day)

Excel 2010 PowerPivot DAX  (Data Analysis Expressions) formulas (1 day)

 

Excel Specialist Training

NOTE: These Specialist Training courses are designed to focus on the principles of using MS Excel as a tool to support the named topics. The courses examine how best to utilize Excel to achieve these objectives.

 

Pivot Tables (half day)

Charts (half day)

Functions (1 day)

Database Tools (1 day)

Dashboards (1 day)

Introduction to Financial Modelling (1 day)

 

 

Microsoft Excel VBA(Visual Basic Applications) Training Courses
 

Excel VBA Introduction (1 day)

Excel VBA Introduction (2 days)

Excel VBA Advanced (1 day)

 

Microsoft Excel Training Courses London

Microsoft Excel Certification Exams

 

We are an accredited Microsoft Partner and Certified Microsoft Testing Centre.

If you are interested in MS Excel Certification exams, then please contact our team to discuss how we can support you with preparation and taking the exams.

 

Click here for Certified Microsoft Curriculum

 

 

certipoint excel training courses london

 

To Book an Exam, Purchase your exam voucher or exam pack (this includes a free Retake voucher, hard Copy Manual and access to G-Metrix pre exam training software), Call us for further details

Microsoft Excel Training Courses London

 
All About Excel

Excel is used comprehensively in business. It has obvious uses in finance but is used far more commonly to Manage and Track and present information visually. It’s ability to hold, manage, present and summarise information quickly and simply make it ubiquitous. The ability for Excel VBA to be used to build custom function means that it can be used to very quickly automate repetitive functions.

 

Excel’s key strength is that is it so flexible and configurable. However, this presents a challenge to the inexperienced user as this means that it offers large numbers of options, often within nested menus. It is not unusual for a user to know that something is possible within Excel but not be able to find the relevant menu.

What we offer

Cats Microsoft Excel training courses can take you from being a complete beginner, who has never used Microsoft Excel, all the way through to an advanced user who will then be able to make full use of the program’s capabilities. If you wish, you can then go on to learn to program in VBA (visual basic for applications) which will enable you to further automate tasks by building your own macros.
Led by highly experienced Excel trainers with many years of experience our hands-on courses mean that you will leave with practical experience as well as useful tips and tricks.
We run scheduled Excel training courses in London at a number of levels. We usually train on version 2013 which is almost identical to 2010 and 2016 we can facilitate standard training but not PowerPivot(see separate course outlines) on your choice of versions, we make a note of what version you are using and the trainer will make you aware if there are any differences.
One-to-one or group bookings can also be arranged on dates to suit you and customised to your specific requirements.
We also frequently provide onsite training to companies. This is nationwide and not limited to businesses based in London and the South East.

Our Delivery Method

Classroom training is proven to give the best learning experience and knowledge retention. You have the benefit of a relaxed but professional learning environment, an experienced trainer and the opportunity to ask questions, so you are 100% sure you understand all the course content.

Post Course support

Access to our Comprehensive Help Library

Email Access to your Tutor

 

 

Click on the version of Excel you are interested in to display the associated courses, then select the course title to see the detailed course outlines


 

Call us now for further information Tel:08001601666

If you know the basics of Excel, including entering data, formatting cells, using functions and formulae and inserting charts and graphs, this Advanced-Excel course will really unlock the power of the programme and its advanced functionality. Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data. This Advanced Excel training course will introduce you to some of Excel's more powerful features. We also provide private and in-company Microsoft Excel courses.

 

Have you taken a look at Power Bi

Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information technology staff or database administrator

 

Microsoft announced April 2017 update for Power BI Mobile apps. This new update comes makes the app experience smoother and faster. Phone reports allow you to use Power BI Desktop to specifically tailor a portrait view of your existing report for mobile viewers. With this update, Microsoft has added support for different report background colors on mobile. If you define a background color in Power BI Desktop, the phone layout will maintain the same color. Power BI iOS app now supports right-to-left languages like Hebrew and Arabic.

Power BI iOS app now allows you to use the microphone button in your iOS device to ask questions about your data, in your own words. Tap the microphone button above your keypad to ask questions about your data, in your own words. And finally, Microsoft now allows developers to create Power BI custom visuals that are optimized for mobile consumption.

Download Power BI apps using the below links,