This is a 5-part series though sessions don't need to be completed in succession. This one-hour session covers some hints and tips...
Register Interest
Logical functions in Excel allow you to have the program make decisions based on criteria you specify. A simple example could be to...
Register Interest
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
Excel has a number of tools that allow predictions to be made depending on several variables. This can be very useful as a means 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
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
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