Calculations on a Filtered List in Excel
Auto filter is a wonderful thing isn’t it? With a few clicks of the mouse little dropdowns appear letting you filter your data in a myriad different ways.
happy people
Darren Andrews
Darren is one of Happy's Senior Trainers, able to train almost every IT course on our course programme. He worked for Happy for 12 years and has been an Associate Trainer since 2018.
Get in touch
Excel Hints & Tips - The OFFSET Function
How do I set my spread-sheet to automatically extract this month’s figure from the accounts?
Pivot Tables: How to Put Your Filtered Data on Different Excel Sheets
Learn how to get your Pivot Table to put your filtered data on different sheets in Microsoft Excel with this blog.
Excel Hints & Tips - Timeline
Learn how to create simple Timeline filters that provide a slider type interactive filter.
Excel Hints & Tips - Florence Nightingale & Excel
What on earth has Florence Nightingale got to do with Excel? Florence Nightingale famously created a polar area diagram (a type of pie chart) in 1858 to show the cause of death in British military hospitals in the Crimean War. This highlighted the extent of preventable deaths (such as from typhus and cholera). The result was that the British government took action and commissioned Isambard Kingdom Brunel to design a new civilian hospital – reducing the death rate to just 1/10th of what it was before. This important use of data visualisation shows how powerful charts (and especially pie charts) can be.
