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...
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...
Because of Excel’s tabular format a lot of people believe that they are already familiar with tables, but they were only introduced...
Excel, and indeed all of Microsoft 365, has recently been upgraded with AI-powered tools. This Hints & Tips session explores three...
Excel has many functions dedicated to dates and times, for example, to “date stamp” an invoice or identify the number of...
Auditing tools allow users to problem solve formulas and ensure accuracy and error handling is an essential skill for anyone performing...