If you want to record how many times an item occurs, use this function. The frequecy function is an array function that will provide some valueable analytical data when used.
Frequency Function
June 23, 2020
Computer training, Excel, Excel Training, IT training analytical function, excel fnctions, frequency function, microsoft excel Leave a comment
Filter Function
June 21, 2020
Computer training, courses, Excel, Excel Training, IT training, IT's Easy Training excel courses, Excel training, Filter function, Filter in Excel, filtering, microsoft excel Leave a comment
How to use the new filter function in Mixrosoft Excel
One of the issues that I have when teachig the filter feature to Excel beginners, is that they don’t clear the filter and leave the previous filter active when they try to do a second filter. Using the new Filter function filters data away from the original data therfore removing a major user obsticle. I love it.
Hot tips Save Money save Time
May 25, 2019
courses, Excel, Excel Tips, Excel Training, IT training, Microsoft Course Tips Excel, excel time saving tips, excel tutorial, flash fill, hot tips, how do i make a cell absolute i excel, how do i move columns in excel, how do i use flash fill, how to save time and money, instant charts, itseasy training 1st, itseasytraining1st, key commands in excel, microsoft excel, save money, save time, save time in excel, saving money, saving shortcuts Leave a comment
This tutorial explains how to save time in Excel and therefore save money. The video covers some of the more common key commands and features such as flash fill, inserting columns, selecting data sets, time commands, saving shortcuts and instant charts. Training at http://www.itseasy.co.uk Online courses at http://www.itseasytraining.co.uk
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