The SUMPRODUCT function is one of those hero functions that, once discovered, you wonder how you ever managed without. It does not just do “what it says on the tin”, there’s a lot more to it than that. In particular, it’s one of the most powerful and flexible filter functions in Excel. And so much better than SUMIF or SUMIFS.
Microsoft Excel Training Courses
Our Excel Training Courses
Mouse Training offers a wide range of Microsoft Excel training courses from beginner to advanced levels either at our comfortable and fully equipped London training centre, in-house at your office or Excel Online. Improve your Excel skills from Excel formulas and Excel Pivot Tables to Excel VBA macros. Our Excel courses can be tailored to best suit your requirements and are provided in a variety of delivery styles, including group bookings, private courses and 1-2-1 sessions. All our Excel courses are instructor led and hands-on. There is plenty of time for experimenting with what you are being taught, trying things out for yourself and asking questions, reinforcing the concepts that you are being taught.
All versions of Excel including, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 365 and Excel 2019.
Apple – Excel 2011, Excel 2016, Excel 365 and Excel 2019.
Mouse Excel Trainers
Why Attend Excel Training at our Training Venue
When attending our centre we provide everything you need for your time with us in a comfortable relaxed atmosphere for training.
- Refreshments available throughout the day
- Complimentary lunch, normally including sandwiches, cakes, fruit, biscuits– you don’t go hungry!
- State of the art Computers – All matching, 23’’ touch screen, all Microsoft Excel versions are available.
- High Speed internet up to 500 meg.
- Air conditioned rooms.
- Course Materials Full access to our extensive library of software manuals included in the price.
- Stationery – Pens and notebooks supplied
- Certificates – Course attendance certificates are available
- Recognised Examinations – Microsoft Office specialist MOS examinations available for Excel.
If you have any questions or wish to discuss options, please don’t hesitate to contact us.
Excel Course Materials
All our Excel training materials are published by two well known publishers, CCI Learning for Microsoft Office Specialist and Velsoft.
CCI Learning Manuals
CCI Learning publish our Microsoft Office Specialist manuals. Titles include Access 2016, Word 2016 Core, Word 2016 Expert, Excel 2016 Core, Excel 2016 Expert, Outlook 2016 Core and PowerPoint 2016 Core.
These manuals can be purchased from ourselves either as part of the official study MOS 2016 kit or manual only. You do not need to attend one of our courses to purchase these fantastic manuals.
Manuals for other Office versions are available – Office 2010, Office 2013, Office 2016, Office 2019 and Office 365
Velsoft publish a vast range of manuals, these manuals are available to all those attending our courses. For group booking requiring tailored course outlines we can provide a tailored course manual.
Excel Certified Courses
As well as our standard courses we also provide Microsoft Office Specialist ( MOS ) courses.
MOS – Microsoft Office Specialist – Weekend testing and On site testing is now available. Validate your Excel skills and expertise with MOS, the globally recognised Microsoft Office certification program. Read More
Exams – Excel Online exams now available, testing daily
Available Excel Training Courses
Hints and Tips
It’s easy to calculate someone’s age from their date of birth if you know about Excel’s DATEDIF function, unfortunately it’s easy to miss this function as it is not documented. Excel will not help you fill in the DATEDIF function interval values, you need to see the list here.
Our Excel double click tricks are some of those little things that make your life so much easier. You probably know most of them already. Or do you? I think that anyone who uses Excel regularly should know them.
Complicated text formulas using either ampersands and the CONCATENATE function are the bane of our life. Not any more! Excel new text functions will really help us nail those text formulas. We’ll be looking at the CONCAT function and the TEXTJOIN function.
Usually the formulas you need for percentages and differences are quite straightforward: divisions for percentages and a minus sign to take one value from another. But there are pitfalls for the unwary which we shall explore.
I think the Excel FILTER function does the filter job better than AutoFilter. It’s a live formula and an extraction, you don’t have to filter your data in place. There’s no need for that clunky Advanced Filter…
You can use the Excel UNIQUE function to extract a list of unique or distinct items from a range of Excel cell values. It’s really easy. See how to sort the results automatically when the data changes…
You can use Excel’s ROMAN function in a formula whenever you need to express normal, Arabic numbers as Roman numerals. And you can use the ARABIC function to convert them back the other way…
Why is Microsoft Excel Popular
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.
Mouse training providing quality Excel Online training courses in London.