In this one-hour session we continue our exploration of Pivot Tables, and cover Expanding Pivot Table functionality, Adding a Calculated...
Tips and tricks for Microsoft Excel including how to insert a chart, format shortcuts and incrementing values. This is a 5-part...
PowerPoint is in use everywhere in business, but few people have been trained in its use. In this session we look at some of the rarer...
This one-hour session continues the discussion of charts made in Part 1 and covers Plotting on a second axis, Adding Trendlines, Forecasting...
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...
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...
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...