In this one-hour session we continue our exploration of Pivot Tables, and cover Expanding Pivot Table functionality, Adding a Calculated...
In this session we discover how a simple Pivot Table and Chart can be graphically filtered to show your best performers over time,...
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...
In the final Pivot Tables session we conclude our training on this subject by discovering how the same field can display different...
Register Interest
Logical functions in Excel allow you to have the program make decisions based on criteria you specify. A simple example could be to...
Register Interest
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...
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