Mouse Training London Ltd
Mouse Training London Ltd provides IT training courses, we are a MOS Specialist and a Certified Microsoft Training Centre in London working throughout the UK. We have many years of experience and knowledge in providing effective training support to businesses and individuals helping develop their confidence and expertise. Our company holds numerous training qualifications and accreditations such as ISO 9001:2015 which are reviewed on a regular basis. This ensures that you receive the very best training available.
How we work at Mouse Training London Ltd
Our team is made up of certified and experienced trainers allowing us to provide effective training that best suits you. We don’t just read from the book but work hard to understand your needs and devise a method that works for you. Our style of delivery and content can be adjusted to best suit your needs for IT training courses, delivered either at your offices or at our training centre in London.
IT Training Courses in London and Online
Mouse Training London Ltd offer a wide range of services including applications training from all major software providers including Microsoft, Apple and Adobe. We are an Accredited Microsoft Test Centre. We also provide a full range of training and exam materials. Laptop hire is available on request.
Efficient service at competitive rates
We offer top quality Microsoft Office training at competitive rates. If you need help choosing your course, give our team a call on the number below to discuss your requirements.
Read More ..
Training Course Homepages
Exams from home are available daily Monday – Friday
Weekends on request.
MOS, Microsoft 365 Fundamentals, MTA, Adobe, Unity and all Certiport online exams
Additional dates can be scheduled for group bookings
For latest date please see sidebar
Voucher Order Forms
MOS Voucher Offers
- Purchase 4 MOS vouchers, get 5 free – Applies to Vouchers and Self-Study Kits
- Purchase your MOS vouchers from Mouse and pay zero exam admin fees
Choose Mouse Training for all your commercial software licensing needs. Whether its Microsoft 365 (used to be known as Office 365), Windows 365 or anything else. We are always here to help. Call 020 7920 9500.
Featured Courses – Essential Excel Functions
Functions are the backbone of most worksheets. But there are around 500 worksheet functions in Excel. How can you possibly learn them all? The answer is, of course, you don’t need to learn all of them. But you do need to know Excel’s best ever functions. The ones you will actually use time and time again.
Our one-day training course is devised to give you a broad skill set covering all the primary categories of Excel functions. We will examine how to create filtering calculations using functions like SUMIFS and COUNTIFS. Then concentrate on introducing logical decision-making into our formulas. Make your formulas think for themselves! And, finally, master the use of lookup functions like VLOOKUP.
All our courses are available online with Zoom or Teams. You are welcome to attend our training centre, or we can come to you. Call 020 7920 9500 today for further details.
Everybody can do a SUM or a COUNT. But, in real life, many of our calculations require some type of filter. Add up all the sales between two dates. Count the number of deals for a specific product. These are examples of filtered calculations. And this where SUMIFS and COUNTIFS are invaluable. Some people would say that you can’t do without them, they are essential functions.
We’ll also deal with the legacy functions, SUMIF and COUNTIF and take a quick look at some of the other handy filtering functions like AGGREGATE and SUMPRODUCT.
One of the best Excel skills to master is the ability to make your formulas intelligent. Then you’ll start to feel that Excel is working for you. And not the other way round! We shall see how to use functions like IF, IFS and SWITCH to get our formulas to follow a set of simple rules and return different results based on logic.
Mastering logical functions completely changes your formula game. We’ll start by considering the basic if-then-else logic. And then see how to make multiple tests, combine different tests together and how to force out ugly error values.
Many people first discover lookup formulas in Excel worksheets that they’ve inherited from their colleagues. Then they realise, with a sense of horror, that these formulas are driving most of the calculations in the worksheet. And they can’t make head nor tail of them!
Don’t let functions like VLOOKUP or MATCH work their mystery on you. Have you ever looked up the price of a Flat White in your local coffee shop? Yes? Then you already understand what VLOOKUP does. Spend a bit of time with us and learn how to use these all-important and essential Excel functions. It’s time well spent.
Hints and Tips – Excel Drop Down Lists
Have you ever seen those drop-down lists in Excel cells? And wondered how to do them? It’s all about Excel Data Validation.
The video starts with a few simple examples. Usually, that’s all you’ll ever need. Then we move on to dealing with data validation in Excel Tables. And solve that knotty problem you sometimes get when a Table is the data source.
This uses an Excel formula incorporating the INDIRECT function. The INDIRECT function is used again to create Dependant Validation Lists. This where you have one validation list which changes, based on the choice made in another list.