Microsoft Excel Training Course Index

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.

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  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’)