In this one-hour session we continue our exploration of Pivot Tables, and cover Expanding Pivot Table functionality, Adding a Calculated...
Register Interest
This one-hour session continues the discussion of charts made in Part 1 and covers Plotting on a second axis, Adding Trendlines, Forecasting...
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
In the final Pivot Tables session we conclude our training on this subject by discovering how the same field can display different...
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
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...
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
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