Every Excel user knows that VLOOKUP is a tricky function to manage, but there are alternatives few people are aware of. This session...
Register Interest
If your role involves combining sets of data that span several periods of time, it can be tricky if they are laid out and formatted...
Register Interest
Tips and tricks for Microsoft Excel including how to insert a chart, format shortcuts and incrementing values. This is a 5-part...
Register Interest
Excel has many functions dedicated to dates and times, for example, to “date stamp” an invoice or identify the number of...
Register Interest
Because of Excel’s tabular format a lot of people believe that they are already familiar with tables, but they were only introduced...
Register Interest
Sensitivity analysis is a process by which different results can be predicted according to a number of variables. This is an important...
Register Interest
Target audience: This course is suitable for any user new to the subject and requires no specific knowledge or experience of Power...
Register Interest
Excel has a number of functions specific to text rather than numbers. In this one-hour session we look at some of these, including...
Register Interest
Excel added a new feature a few years ago that makes it super easy to fill lists of things in a different way once it recognises a...
Register Interest