This tutorial overview explains what is covered on the Intermediate course at http://www.itseasy.co.uk or http://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
Excel training courses
May 6, 2019
courses, Excel, Excel Training charts in Excel, Excel online courses, excel trainijng, online classes, online courses, pivot tables, sumif function, vlookup Leave a comment
Waterfall and dial charts
May 1, 2019
Computer training, Excel, Excel Training chart on two axis, charts on two axis, combination chart, date function, dial, dial chart, Excel, excel computer courses, excel tutorial, how to create a chart on two axis, how to create a Dial chart, how to create a waterfall chart in excel 2016, itseasytraining1st, microsoft excel, stacked column chart, sumif chart, sumif charts, sumif function, Two axis and SumIF charts, Waterfall, waterfall chart Leave a comment
This tutorial explains how to create a chart on two axis and how to create a Dial chart and a Waterfall chart and a column chart that has the SumIF function and the date function driving the data. Training at http://www.itseasy.co.uk online courses at itseasytraining.teachable.com