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 2019 Training-Courses
 

Excel 2019-Introduction (1 day)

Excel 2019-Intermediate (1 day)

Excel 2019-Advanced. (1 day)

Excel 2019 Power Pivot and Power View (1 day)

Excel 2019 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 2019 training-courses MAC

Excel for Mac 2019-Introduction (1 day)

Excel for Mac 2019-Intermediate (1 day)

Excel for Mac 2019-Advanced. (1 day)

 

Microsoft Excel 2016 Training-Courses
 

Excel 2016-Introduction (1 day)

Excel 2016-Intermediate (1 day)

Excel 2016-Advanced. (1 day)

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)

 

 

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.

 

Building Solutions Using Excel and Access 2016 Together (New)

Excel Advanced Formatting Techniques (New)

Excel Charts in depth (New)

Excel for Sales Professionals (New)

 

 

Pivot Tables (half day)

Charts (half day)

Functions (1 day)

Database Tools (1 day)

Dashboards (1 day)

Introduction to Financial Modelling (1 day)

 

Older versions

Microsoft Excel 2003 & 2007 Training
 

Excel 2007 Introduction (1 day)

Excel 2007 Intermediate (1 day)

Excel 2007-Advanced (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 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

 

 
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

Mouse Training Microsoft excel learning 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 learning 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 learning 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. PowerBI Desktop

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,

Training Courses

Mouse Training London LTD (CAT Training) is a certified Microsoft training Centre as well as a Microsoft testing station.

 

Syllabus can be delivered from our extensive range of Standard courses outlines as well as the official Microsoft Certified training course are designed for those people wishing to become Microsoft Accredited by sitting the office specialist exams.

 

We offer a range of flexible training courses, Microsoft Office, Microsoft Office 365, Adobe, Apple and Google Gsuite

 

Course Types

1-2-1, Group Training, Bespoke Training,, Public Courses, Office Migrations

 

Venues

Training courses can be delivered at your premises, Complimantry laptop hire phone for details or one of our training offices. Locations

 

Our Course Approach

Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials
IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London

 

Our courses are focused on ensuring that we make you a faster and more relaxed Office user. Given how widely Office is used in business today we believe that being a comfortable and capable Office user is a key career skill for everyone.

 

Regardless of the application you are using Access, Excel, Project or Visio just to name a few Office 365 or SharePoint we have you covered. Our friendly team of trainers will do their best to make you feel relaxed and confident with the application you choose to learn.

Our range of excel learning courses has been designed to support everyone from complete beginners with our Level 1 training courses, through to those who need to develop advanced Excel skills using Macros and VBA. We also offer a choice of intensive courses – courses that are slightly longer and faster paced than our standard courses, focusing on a specialist area.

All of our courses are available for private groups, either held at your workplace or at our training centre in , London. All courses include two years of free access to our IT helpline, staffed by our IT trainers to give you unlimited support after your course.

 

The Different Versions Of Excel


Excel is the spreadsheet function contained within the Microsoft Office suite of products. It is available within both Microsoft Office for Windows and also Office for Mac.

It has been used incredibly widely since it took over from Lotus 1-2-3 in the mid 90’s.

The recent most used versions of Excel are:

Excel 2003:

This was the last version of Excel before the ribbon system was introduced. It is becoming increasingly rare to see Excel 2003 these days.

This update to Excel (from Excel 2000) introduced new Tables functionality and also allowed information to be saved and modified using the XML data format. This made Excel 2003 far more useful as it made importing data from other sources far simpler.

Excel 2007:

This version of Excel introduced the ribbon. This was a major change to the appearance of Excel and many users struggled with the changes initially.

The other key change was making individual spreadsheets larger so that they could contain over a million rows (previously 65,536 rows) and up to 16,384 columns (previously 256). Other smaller changes were made to Table to make them more easily configurable.

Excel 2010:

Excel 2010 was a refinement of Excel 2007.

The changes while meaningful were far less radical than the changes between the 2003 and 2007 versions. The key improvement was to security given the increasing use of Excel to distribute malware and viruses. Excel 2010 allowed you to preview a document using “Protected View’.

Changes were also made to the ribbon functionality to increase its flexibility and to pivot tables to make them more user-friendly. The number of formulas included within the program was also increased substantially.

Excel 2013:

This version is again more of a refinement and expansion of 2010 than a wholesale change.

There are multiple small changes and improvements throughout the program. Examples of new functionality include Quick Analysis, which creates tables very quickly and simply, and PowerPivot, which is a substantial expansion of the old pivot table functionality. PowerPivot allows very large externally held datasets (often held in Access or SQL databases) to be analysed using Excel. In doing this it moves to being a Business Intelligence (‘BI’).