Learn how to total multiple columns and rows, add conditional formatting and create a custom list for Microsoft Excel....
Tricks and tips for Microsoft Excel 365 including using subtotal instead of sum, identifying duplicates and how to create a drop-down...
Tips for Microsoft Excel including how to apply layout changes, how to set and clear a print area and visualising data using a heat...
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...
In this short 20-minute Micro Learning session we will look at some of the most useful Tips and Tricks for Microsoft Excel 365 including......
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...
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...
This one-hour session continues the discussion of charts made in Part 1 and covers Plotting on a second axis, Adding Trendlines, Forecasting...