We offer a range of Microsoft Excel Training Courses, suitable for beginners and advanced users alike at our training centre in Peterborough, Cambridgeshire. We can also organise Excel onsite training anywhere in the UK.
If you need to train a number of people on Microsoft Excel, and have a dedicated training room or a conference room which can be used for training, we can provide you with customised training on any version of Microsoft Excel, for up to 10 users, at a competitive flat rate.
Call us on 0800 998 9248 to discuss your requirements.
Microsoft Excel is an essential tool for most modern businesses, providing a dazzling array of features for manipulating and analyzing organisational data. The traditional route to becoming an Excel power user has been to develop a fairly large repertoire of advanced techniques; such as the creation of complex formulas and VBA macros. However; thanks to the significant enhancements made to Excel by Microsoft; it is now possible for all of your Excel users to become power users!
Our Excel power user courses show delegates who have an intermediate to advanced knowledge of Excel how they can become power users simply by mastering a series of powerful new features which have been available in Excel for a few years now, but of which most users are still blissfully unaware. G Com Solutions run Excel power user courses every month, at our training centre in Peterborough; and we can also provide on-site training, anywhere in the UK.
This course is aimed at intermediate and advanced users of Excel who are only familiar with Excel’s “traditional” features. It aims to show delegates how to make the transition from over-reliance on Excel’s VLOOKUP function to working with tabular information from multiple sources using Excel’s supercharged Power Query and Power Pivot tools. Delegates will be introduced to the Excel data model and will learn how to create pivot tables and dashboards which visualize data from multiple related sources.
This one day course is designed for users who are already familiar with Excel’s Power Query and Power Pivot tools. It shows users how to connect to a wide variety of data sources and create data models which include DAX calculated columns and measures. Delegates will also be shown how to create rules for transforming data as it is added to the data model and how to create Power View reports.
This course is designed for experienced users of Excel’s Power Pivot and Power Query tools and provides insights into the advanced aspects of these powerful technologies. Delegates will be shown how to write their own functions in the M language which underlies Power Query; and to create complex DAX formulas using advanced time intelligence functions.
This course is designed for beginners and covers: excel basics; working with data; editing a worksheet; editing text; formatting a worksheet; page setup and printing; working with pages; formulas and functions; and modifying workbooks.
This course is suitable for those with prior experience and covers: working with tables; working with charts; working with graphics; workgroup collaboration; financial & logical functions; financial and logical functions; date and time functions; and managing workbooks.
This course is suitable only for those with considerable prior experience and covers: importing & exporting data; importing and exporting data; formatting numbers; working with ranges; working with macros; customizing excel; data analysis tools; summarizing data; what-if data analysis; and workgroup collaboration.
This one day course is designed for experienced Excel users who will be using pivot tables extensively in their work. Delegates will learn how to use this powerful tool to summarise and analyse data and then enhance it with formatting, custom calculations and filtering to produce unique and useful reports.
Functions are at the core of Microsoft Excel and provide much of its power. However, many users find working with functions and formulas confusing and frustrating. This Excel training course focuses on the creation of formulas using the most useful and essential functions in each of Excel's main function categories. Delegates will also be shown the various types of formulas and the different methods of creating them, the different ways of inserting functions and using nested functions to build complex formulas. This Excel course also covers the auditing of formulas and and the handling of errors.
The ability to understand and create complex formulas is critical to the building of effective Excel solutions. This one day course shows experienced Excel users how to rank and tabulate data using statistical functions, format data with text and math functions, and work with financial data using advanced formulas. This course assumes a good familiarity with Excel formulas and focuses on advanced tips and techniques.
Our Excel VBA level 1 course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment.
Our Excel VBA Level 2 course is designed for experienced Excel users who have already begun to create macros and know their way around Excel's Visual Basic Editor.
Our Excel VBA Level 3 course is designed for experienced Excel VBA developers who are familiar with working with the Excel object model.
One of the pivotal components of the Microsoft Office, Microsoft Excel is the
world's premier spreadsheet software. It boasts an extremely powerful infrastructure
incorporating complex tools for data analysis and manipulation with a user-friendly
interface and huge range of time-saving shortcuts and helpers. If you have bought this sophisticated piece of software, it makes sense to ensure that your staff members know how to use it effectively.
Tutor-led software training has the benefit that delegates are able to ask questions as they learn and have complex concepts explained and demonstrated to them until they fully understand them.
Booking your staff on a public Excel course is of course one possibility. However, increasingly companies are demanding to have this training customised to meet their specific demands. Microsoft Excel can be used for a variety of data analysis and storage tasks: not everyone uses it in the same way. Perhaps you will be using it for complex business modelling. Or, you may be using it to create interactive forms and reports complete with complex calculations. Maybe your staff will be using the program in a database role recording information under column headings. Booking a customised course will ensure that you only pay for instruction which is relevant to your requirements and reflects the way in which you will be using Microsoft Excel.
Before you start contacting Excel training companies, it would be a good idea to ensure that you have a clear idea of what you want to achieve by using Excel and that your expectations are realistic. When you approach training companies, you should make it clear that you do not simply want them to deliver their standard Excel courses but that you require a customised programme of training. Between you, a schedule of topics to be covered should then be drawn up and the duration of the program decided.
The customisation process may also involve identifying different requirements within your own organisation. Different people may need to do different tasks with the program and therefore need different skills. For example, some of your users will be primarily interested in using Excel for business analysis and projection. Their primary areas of interest may be the "What if" analysis tool like goal seek, scenarios and pivot tables. On the other hand, you may have people who are interested in creating charts and reports either for printing or for use in PowerPoint presentations.
We are always willing to accommodate the specific needs of your organisation and the different profiles of the staff members: accounts, sales and marketing, etc. Between us, we can create a program of study which satisfies the needs of all your users. Perhaps this may mean, having different courses for users with different profiles or perhaps the best approach may be a modular one whereby some modules are taken by everyone while others are only attended by certain user groups.