3 Things You Can Do in Excel Without Maths
Do you avoid Excel because of the maths?
As an Excel trainer, one of the most frequent comments I get from learners is that they avoid Excel because of the maths. I know the feeling. I manage with maths in my day-to-day life but I'm the first one to reach for a calculator when it gets complicated…or even when it doesn't! I've never felt as at home in the world of numbers as I have amongst words.
This feedback from learners is why we have now developed a new course, Excel Without Maths. In this blog, Rachael explores three things you can do in Excel without using any maths.
Hi, we are Happy
We are leading a movement to create happy, empowered and productive workplaces.
How can we help you and your people to find joy in at least 80% of your work?
Not everyone loves working with numbers and calculations or finds it easy, and whilst it's important at work and home, a lot of us find that we're put off even starting with Excel because it's all about maths, right?
In fact, whilst Excel has some really useful mathematical formulas available, there is so much you can do without needing them. The non-mathematical features can be really powerful. I love Excel even though I find the numbers daunting.
Happy has created a course called Excel Without Maths that will guide you through how to set your data up easily using smart and easy-to-use tools like Flash Fill and Data Validation so that it flows nicely and is ready to analyse.
Here are three tools you can use in Excel that do not use maths, and will increase your productivity and save you time.
1. Flash fill
You can use clever tricks like flash fill to tidy up your data and turn it from this:
In just two clicks!
2. Pivot Tables
Imagine taking a long list of data records and turning them into a neat summary inside of five minutes and without a mathematical calculation in sight (Excel simply does them for you).
You would start with a list, in this case a list of sales. The list consists of individual records, detailing transactions for each product in every region. The sales are either retail or wholesale. It's not easy to make sense of trends in here. We might want to ask questions like: What were the sales by month for retail versus wholesale? It sounds like a daunting task, but in fact it can be done with minimal effort.
Take this list:
And turn it into something much more meaningful that summarises what the data is telling you, like this:
Pivot Tables and Subtotals can create summaries and in-depth analysis with a few clicks – and you don't need to go near a formula!
3. Range names
Have you ever despaired at being able to get your Excel spreadsheet to print on a manageable number of sheets?
It's great that Excel is not confined to an A4 sheet like a Word document is; it means we can store huge amounts of data in there. It also means that you have to do a bit of work to make it print well.
On this course we'll also look at using named ranges along with the print settings to get large sheets to print well.
Find out more ways to improve your productivity without maths
If you find Excel daunting, then our new Excel Without Maths one-day course is for you. You will learn these three tools, as well as:
- Ways to tidy up spreadsheets using Data Validation.
- Learn to produce reports in a more visually appealing way.
- Save time analysing your data with Charts, Pivot Tables and Subtotals and feel in control.
You will learn loads of exciting tips that will help you become more productive at work. And yes, all without any dreaded maths!
Why not sign up to our newsletter?
Sign up to our monthly newsletter, full of tips, tricks and news to help you to be happier and more productive at work.
Rachael is the IT Product Development Manager, as well as being our Lead IT Trainer. She is responsible for making sure all our courses are of the highest quality. She has worked at Happy for over 15 years. Rachael was awarded Bronze in the Learning and Performance Institute's IT Trainer of the Year Award in 2007.
Testimonials from happy Customers
Siobhan Brennan-Robson3 days ago
Ebiji was an excellent teacher. I will be keeping her on speed dial.
Sophie Allen3 days ago
the initial invitation didn't come to all participants so I wasnt sure if the training was confirmed
Trusted Customer4 days ago
Amazing work! Honestly, I have had such a pleasant experience with Happy whether it be online or in their offices. Hopefully, in the future, I get to have more sessions w...
Trusted Customer6 days ago
I found the Office 365 training really useful. It consolidated my self-taught learning and showed me some new things that will make my life easier as well as doing some t...
Trusted Customer6 days ago
Found the session interactive and engaging throughout. Range of tools shared.
Helen Twigg7 days ago
Really enjoyed the Liberating Structures Online Immersion Workshop. High energy that kept you involved all day and have been able to use the learning immediately. Woul...
Ruth Gibbins7 days ago
Great facilitation, very interactive and organsied
Emma Willcox7 days ago
Great course, with lots of opportunity to practice techniques and not just learn about them. The day is packed full of content, so be ready to embrace the fast pace and t...
Judy Duff7 days ago
Happy are a creative, unique, relevant and modern-day approachers of workshop delivery and content.
Trusted Customer9 days ago
Excellent course and facilitator :) The course had good interactive sessions and well thought out content. It was made relevant to our roles and the trainer was supportiv...
Scott Haines10 days ago
I thought the training was excellent. It was really enjoyable and engaging and gave me lots of ideas to take away.
Toks Kinoshi10 days ago
An excellent session led by Henry where I learnt some new, refreshing techniques