Excel Hints & Tips – Line Breaks in a Cell & Cell Formats
Sometimes you may want to add text in Excel that’s spread over multiple lines. Find out how to do this, or how to remove these, in this week’s blog by Happy trainer Ian Balboa.
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.
In this blog, learn how to create a dropdown filter in your Excel spreadsheets.
Excel Hints & Tips – Calculating Age
You’d think that there would be an AGE function that worked out how many years since the anniversary by passing in a date. However, life is not that easy.
How to Customise Your Excel Reports With Slicers
At Happy we talk a lot about how great Pivot Tables are — and Slicers make your Pivot Tables and reports even better. With Slicers, you can have one Pivot Table that switches between different categories through the click of a button.
In this blog, Ian gives step-by-step instructions with how you can create your very first Slicer.
Classroom Training: Still the Best for Knowledge Transfer and Skills Development
At Happy we have been developing e-learning for over 12 years. More recently we have got excited about Live Online Learning, where you learn from your desk but with a real live trainer in a virtual classroom. But some of the most effective learning we deliver still takes place in the classroom.
How to Use the LARGE Function in Excel
In this blog, Jonny explains how to use the LARGE Function to extract the top values in a row and even add them up.
Excel Hints & Tips – The OFFSET Function
How do I set my spreadsheet 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 Excel.
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.
Excel Hints & Tips – Timeline
How to use the Timeline feature in Excel 2013/2016.
