We are excited to announce the launch of a new course and to share some updates to our range of Excel programmes. With Excel being such a key skill in today’s business world, Underscore are keen to ensure our training courses match the current business needs.
To this end, we have introduced an extra course to enhance our current offering. Our new Excel Module 3 – Data Management Techniques course focuses on innovative ways to manage and manipulate your data, and is a perfect follow on from our Excel Module 2 for those looking to improve their skills. You’ll discover how to set up more complex conditional formatting, get started with VLOOKUPs, and get inventive with how you use dates in your formulas, among many other topics.
If you’ve attended our Excel courses in the past, you’ll be glad to know that this new module does not replace the old module 3. However, we have updated our courses listings, so our current Excel Module 3 – Advanced Formulas and Functions has been renamed Excel Module 4, which now gives you four modules to choose from depending on your experience and skill level:
Excel Module 1 – Key Skills and Formula Creation
Ideal for new, or self-taught, users of Excel who want to get to grips with the tool, learn shortcuts and ensure they have not missed any top tips.
Excel Module 2 – Data Analysis and Pivot Tables
For existing users of Excel who want to take the next step and learn more about working with and analysing data.
Excel Module 3 – Data Management Techniques
An intermediate level course aimed at those who want to learn some of the more sophisticated techniques around data handling.
Excel Module 4 – Advanced Formulas and Functions
For advanced level users who want to learn how to work with a range of complex formulas and functions to interrogate and tidy up their data.
In addition to this, we have introduced two specialist courses for those wanting to focus on particular areas:
Excel – Pivot Table Specialist
And of course we still have our VBA in Excel Part 1 and Part 2 for those who want to master the Visual Basic programming language that sits behind Excel to automate their spreadsheets.
Have a look at our public programme dates and book your place on our next course, or contact us to discuss your needs.
Read Next
Keeping up to Date With Excel – Advanced Statistical Analysis
Excel plays such a huge part in most people’s everyday work and yet most people only use a small fraction of its capabilities. The trouble is, with Excel 365, they are adding new features [...]
What Are Macros and Why Should You Use Them?
What Is a macro? A macro is shorthand for a programming term: macroinstruction. In the most basic terms, a macro is a way to automate simple tasks. They can be used in a variety [...]
Using Advanced Formulas and Functions in Excel
With everyone using Excel more and more in business, the level of skill and knowledge required has increased hugely. Just being able to create a simple spreadsheet and input data is often no longer [...]
The Digital Skills Gap – Don’t Mind the Gap, Bridge It
We’re surrounded by technology; immersed in it so completely that most of us barely even realise it’s there (although we certainly notice when it’s not). Yet, it seems that despite our growing dependence on [...]
How to Make the Most of Your Digital Skills
It would be hard to think of a role that exists today that doesn’t require the use of technology in some form. The evolution of the digital realm has been so rapid that it [...]
Power BI – Adding Custom Columns
When we talk about transforming your data as well as tidying it up you can also add extra columns to your data and again this will be added as steps and inserted every time [...]