This tutorial overview explains what is covered on the Intermediate Excel course at www.itseasy.co.uk or www.itseasytraining.co.uk (online courses). The video demonstrates the use of Names and Named ranges in Excel, how to use Conditional formatting in Excel. How CountIf and Subtotals can be used. The video also explains the IF function and Vlookup. A large part of the tutorial focuses on Pivot tables, timeline, charts and slicers, including calculations. The final part is the use of the SumIF function and charts to produce a dynamic chart.
On-line courses are at www.itseasytraining.co.uk check them out.