Excel Without Maths

Do you find Excel daunting and worry about mathematical formulas that it often involves? This is the course for you!

In this one-day course, you will explore several cool Excel features that will help make Excel better and more efficient for you — without having to use formulas!

Note: Some features are not available in 2010 and 2013 versions.

Course Overview

  • Standard Price

  • Public Sector Price

  • Charity Price

  • *Excluding VAT
  • Duration

    1 day
  • Class size

    8 approx.
  • Location

  • Requirements

    This course is for people who are already able to set up a spreadsheet themselves. They should be able to select, insert, delete cell content, enter text as well as save and retrieve documents. If you’re not confident doing these then, have a look at our Excel Core Level 1 course.

Course Overview

What you will learn

You will explore features in Excel that don't involve any maths yet help you produce reports in a more visually appealing way, such as:

  • How to save time analysing your data with Charts, Pivot Tables and Subtotals, and feel in control
  • Ways to tidy up spreadsheets using Data Validation
  • Loads of exciting tips that will help you become more productive at work

And yes! All without any dreaded maths.

With increased confidence in using these Excel features it should encourage you to learn more features that include formulas. See our Beginner Excel Core Level 1 or Intermediate Excel Core Level 2 for Excel with formulas.

Course Timetable

Session 1: Tidy data to enable accuracy

  • Copy, paste and move data from one worksheet or website
  • Paste Options: Transpose data to appear vertically or horizontally
  • Insert and delete rows or columns in your worksheet
  • Use Freeze pane to keep a portion visible while you scroll
  • Remove Duplicate data from a sheet
  • Use Data Validation to limit type or size of data entered in a cell
  • Use Flash Fill to automatically fill in values and combine or tidy a long list
  • Use TEXTJOIN to concatenate a list
  • Use Range Names for selecting and moving around
  • Control the layout of your sheets when printing

Session 2: Using multiple data without maths 

  • Work on more than one worksheet and group them to make changes simultaneously
  • Use Consolidate feature to summarise multiple sheets of data
  • Sort large data into order and filter to show only the data you need

Session 3: Visualise your data

  • Use Conditional Formatting to automatically change the look of cells based on its value
  • Create the best chart type for your data to make them stand out and easy to understand
  • Create sparklines to show trends and pattern

Session 4: Make your data make an impact

  • Quickly convert a range of cells to a table, with its own style
  • Use Subtotal to create mini summaries
  • Create a Pivot Table to summarise large sets of data easily

Which Excel course is right for you?

Making sure you’ve booked the right course isn’t always easy.

Luckily we have a handy survey to help you decide.

And if you’re still unsure, call our friendly team on 020 7375 7300 and we’ll help you work out what you need.

Take our Excel survey
5 out of 5 stars

Just the info I needed, great

Emma Morgan88 days ago

What is it like to learn with Happy?

Our facilitators make learning interactive and fun. In this video, Maureen delivers a session on Formulas and Functions in Excel at Happy's HQ in London.

Book now

See our available course dates, or contact us for bespoke options.

Excel Without Maths
There are currently no upcoming course dates available. Please contact our team on 020 7375 7300 or email happy@happy.co.uk to enquire and find out availability for private groups.

Please note that your booking is not secured until you checkout.

Checkout now

Contact us now!

020 7375 7300

Why choose Happy?

  • Award-winning learner-focused approach
  • Small class sizes to give personal one-to-one support
  • Two years of free support after your course
  • Private group options available
  • No quibble money-back guarantee on all courses

The Small Print

The course will run from 10am to 4:45pm (hot buffet lunch 1pm to 1:45pm). Please be careful to arrive by 9:45am for registration and refreshments. The course will start precisely on time and it may not be possible to go back over material missed by late arrivals. If you arrive over 30 minutes late you may be asked to leave and attend another day.

Please ensure you read our Terms and Conditions before booking for our payment terms and cancellation policy.

The happy Guarantee

We want everyone to go away from our courses feeling as though they have learnt useful, practical skills that they can use straight away when they go back to work.

If you don’t feel that your training has been useful or if you are unhappy in any way, please get in touch with our Customer Services team within 30 days of the course. We will be happy to offer you additional support and training free of charge to help you to gain the skills you need, or if you’d prefer, a full refund.

Your post-course support package

  • 2 years of free access to our IT Helpline
  • Unlimited access - call or email our team as often as you need
  • Ask about any content covered on your course
  • Included in the price of our training sessions

happy learners