Our beginners Microsoft Excel course.
Learn to confidently create, navigate around and format workbooks along with creating and using simple formulas.
Take advantage of our price reduction of £55 by booking our 1 day Excel Essentials and 1 day Excel Intermediate courses together on consecutive days.
Build on your Excel knowledge and skills.
Focused on charts, formulae and Excel’s list functions, it’ll take your skills to the next level.
Learn to use Excel’s most powerful functions.
By the end of this course you will be able to confidently build reports using PivotTables, edit and analyse complex data and record your own macros.
Build on your advanced Excel skills and master Excel VBA.
Learn to confidently write VBA code and to completely customise, automate and control your spreadsheets.
An advanced course focused on working with Excel Macros.
Learn to confidently record macros and edit them using Excel VBA.
All of our courses have been carefully designed to ensure you become a much faster and more capable Excel user. Given how widely Excel is used, we believe that being a comfortable Excel user is a key career skill for everyone.
Our courses are very hands-on and interactive. Whether you are a beginner tackling Excel for the first time, or an advanced user learning to automate tasks using VBA, you will be working in Excel through your training.
We believe that useful skills are developed through guided practice which reinforces learning and shows you how to apply your theoretical learning. Our exercises are carefully chosen to emphasise and reinforce the key aspects of each lesson.
Excel’s key strength is that is it so flexible and configurable. However, this presents a challenge to inexperienced users as it offers huge numbers of options, often from 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. By encouraging delegates to work independently in Excel we allow them to become familiar with how menus are structured and where different options can be accessed from.
Our main training centre is in Guildford. This offers a full schedule of monthly courses. It is in the Surrey Technology Centre, very close to the Royal Surrey Hospital.
We also run a full schedule of Excel courses in London and Manchester. Our London centre is very close to Bank and Monument tube stations, and a short walk from Liverpool St and Cannon Street overland stations. Our Manchester centre is in the centre of Manchester and only a short walk from both Oxford Road and Piccadilly stations.
We are also very happy to provide on site Excel training at your premises. This can done on a date that suits you and customised to your requirements so that it only covers those topics most relevant for you.
Excel is used extensively in business. It is used extremely widely to track and manage information. It’s ability to hold, manage, present and summarise information quickly and simply mean that it is almost ubiquitous.
Many businesses use Excel VBA to build custom functionality into frequently used spreadsheets to automate repetitive tasks. This allows them (e.g. weekly / monthly report generation) to be carried out extremely quickly.
A typical example of the use of Excel is in the creation of financial models that are used to forecast a business’s financial performance. An experienced Excel modeller can build a detailed and highly configurable financial model in a few days. Once created Excel contains a large number of financial functions which automate the analysis of the output, including IRR, XIRR, NPV and DCF. It’s graphics functions then allow graphs of the output to be created very simply.
Excel is the spreadsheet application contained within the Microsoft Office, Office 365 and Office for Mac suite of products.
A wide variety of recent versions of Office are still in use. The differences between the most recent versions are:
This version included a far larger Business Intelligence (‘BI’) suite. The BI tools now included PowerMap (for plotting geographical information), forecasting abilities and improved querying functionality.
The other substantial change was to the graph types included. This version of Excel added waterfall, box and whisker and treemap graphs.
In the main Excel 2013 continued the trend towards incremental change to improve Excel between versions.
Examples of this were the new Quick Analysis functionality for rapid table creation and PowerPivot which was an expansion of the PivotTable functionality. PowerPivot allowed Excel to be used to work with very large external datasets held in databases.
In doing so it moved Excel into the traditional area of Business Intelligence.
Excel 2010 was a refinement of Excel 2007. The changes while meaningful were far less radical than the changes made between previous versions.
A key security improvement was made given the increasing use of Excel to distribute malware and viruses. It allowed users to preview a document using “Protected View” rather than having to download a document to view it.
Changes were also made to the ribbon functionality to increase it’s flexibility and to pivot tables to make them more user friendly. The number of formulas included within the program was also increased substantially.
This was the version of Excel that introduced the ribbon.
This was a major change to the appearance of Excel and many users struggled with the changes initially.
Other changes were introduced were allowing individual spreadsheets to contain over a million rows (previously 65,536 rows) and up to 16,384 columns (previously 256).
Changes were made to the Tables function in order to make these more easily configurable.
Hear what previous attendees have had to say about this course
Have a question?
We're here to answer them
01483 688488Contact us