Sensitivity analysis is a process by which different results can be predicted according to a number of variables. This is an important...
Excel, and indeed all of Microsoft 365, has recently been upgraded with AI-powered tools. This Hints & Tips session explores three...
In the final Pivot Tables session we conclude our training on this subject by discovering how the same field can display different...
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...
Because of Excel’s tabular format a lot of people believe that they are already familiar with tables, but they were only introduced...
Excel has many functions dedicated to dates and times, for example, to “date stamp” an invoice or identify the number of...
This is a 5-part series though sessions don't need to be completed in succession. This one-hour session covers some more hints...
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...
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...