So this week I’ve had a bit of inspiration creating some Excel tutorials but don’t worry I’ve also started others including the photography and video podcasts which will be with you in January 2014. But here is one Excel one that I use all the time.
It is the database functions in Excel. These functions can look at a list and by putting in some criteria you can use some functions to do things like total up, average, find the highest or lowest figure. For example, if you had a list of student grades you could find the average just of maths students or find the highest or lowest scores of science students.
In the example I have in the video below I use a list of computer models and how many in stock. Then I can use the DSUM function to total up the quantities of a particular brand. I also use it to find out the average cost using DAVERAGE and the highest and lowest costs using DMAX and DMIN.
This is one of those functions that I find needs a bit of practice if you are doing the ECDL advanced for Excel.
Don’t forget you can also find more on my website www.jargonfreehelp.com