
Excel Hints & Tips - Producing Example Data
Ever needed to produce a large set of random numbers on your spread sheet quickly? This blog will tell you how,.
Here you can find all of Happy’s blog posts, covering our Excel hints and tips, ideas for creating happy workplaces, and ways to be more productive at work — and more.
Ever needed to produce a large set of random numbers on your spread sheet quickly? This blog will tell you how,.
Have you ever seen an Excel spreadsheet with a dropdown list in it and wondered how it was done? This is data validation. Data validation improves the data in your spreadsheets. It makes reporting much easier as there is no risk of typos and no risk of an entry not fitting into your criteria. In this blog we will take data validation a step further and look at how to make one drop-down list change its values depending on the choice made in a previous drop-down.
How do you record a macro that will copy data from a set area on your spread sheet and then paste it into the first available empty row, in an ever increasing list?
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.
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.
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. Our trainer Ian Balboa explains step-by-step how to calculate how many years since an anniversary – both the easy way and the hard way.
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 week's blog, Ian gives step-by-step instructions with how you can create your very first Slicer.
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.
In this blog, Jonny explains how to use the LARGE Function to extract the top values in a row and even add them up.
How do I set my spread-sheet to automatically extract this month’s figure from the accounts?