LEARN. DEVELOP. INSPIRE.
Excel Essentials: Everyday Confidence
Duration: 1-Day
Public Course Price:
Training Formats: Public Classroom, Public Online, Private Course
Certification on Completion
Take control of your spreadsheets and confidently embrace the power of Microsoft Excel.
4.9/5 rated
From 6,000+ learners
30+ years
Delivering professional training
Live and practical
Trainer-led courses
Flexible delivery
Online, venue or onsite
YOUR NEXT STEP
How would you like to train?
01 · PUBLIC COURSE
Book a place for yourself or a colleague
View scheduled dates, locations and prices for this course when public sessions are available.
02 · PRIVATE TRAINING
Plan training around your team
Discuss your objectives, preferred dates and delivery location with us. We can tailor a course to your group.
Course Overview
Introduction
Designed for beginners and self-taught users, this Excel training course will empower you to use Excel confidently and effectively in your everyday role - whether that's inputting data, using calculations, creating reports or managing simple lists.
You'll discover the essential tools that help you work faster, stay organised, and avoid common time-wasting errors - all while building your Excel confidence.
Note: This course was previously known as Excel Introduction. The name and content have been modernised to include exciting new features for our learners.
Course objectives
By the end of this course, you will be able to:
-
Confidently navigate and use essential features of Microsoft Excel
-
Enter, format and organise data with ease
-
Use basic formulas and functions to perform calculations
-
Create simple charts and reports
-
Work more efficiently and accurately with everyday spreadsheets
Who this course is for
This course is ideal for:
-
Beginners or self-taught users of Microsoft Excel
-
Professionals looking to build confidence in everyday spreadsheet tasks
-
Teams who want consistent foundational Excel skills across staff
Prerequisites: Basic computer skills such as using a keyboard and mouse, and saving or opening files.
Full course outline
Getting Started with Microsoft Excel
-
Introduction to the Excel interface: ribbon, formula bar and layout
-
Tips for selection and movement across cells
-
Creating, saving and opening workbooks
Entering and Formatting Data
-
Typing and formatting text, numbers and dates
-
Selecting cells, rows and columns efficiently
Formulas and Functions
-
Using basic arithmetic: +, –, ×, ÷
-
Understanding BODMAS and how Excel calculates
-
Creating functions: SUM, AVERAGE, MIN, MAX, COUNT
-
Using the Function Wizard for guided formulas
Working with Dates
-
Performing date calculations
-
Formatting dates for consistency
Copying, Moving and Filling Data
-
Cut, copy and paste
-
Using AutoFill to repeat patterns
-
Drag and drop techniques
Relative and Absolute Referencing
-
Understanding cell references
-
Locking cells with
$in formulas
Editing Worksheets
-
Inserting, deleting and resizing rows and columns
-
Hiding and unhiding worksheet elements
Formatting for Clarity and Impact
-
Adjusting fonts, colours, borders and fill
-
Aligning cell content
-
Applying number formats and using the Format Painter
-
Merging and unmerging cells
Working with Larger Worksheets
-
Freezing panes and using split view
-
Applying AutoFilter for data filtering
Basic Conditional Formatting
-
Applying simple highlight rules (e.g. greater than, duplicates
-
Using basic colour scales and data bars
-
Clearing conditional formatting
Printing and Layout Options
-
Print preview and setting the print range
-
Sizing sheets to fit on a page
-
Adjusting margins, headers and footers
Managing Multiple Sheets
-
Creating, renaming, colouring and deleting sheets
-
Navigating between sheets easily
Charts and Graphs
-
Creating charts based on your data
-
Choosing chart types
-
Applying basic formatting to charts
Reflections & Planning
-
Recap key skills and tools covered during the session
-
Discuss how to apply the learning in your specific role
-
Identify personal next steps or areas to build on after the course
Public scheduled courses
Choose a scheduled session below if public dates are available for this course. If there isn’t a suitable date, or you’d like a private session for your team, send us an enquiry.
-
14 October1 day, 09:30 AM BST - 04:30 PM BST
-
20 October1 day, 09:30 AM BST - 04:30 PM BST
-
10 November1 day, 09:30 AM GMT - 04:30 PM GMT
-
09 December1 day, 09:30 AM GMT - 04:30 PM GMT
-
17 December1 day, 09:30 AM GMT - 04:30 PM GMT
Booking for a team or need a different date?
Tell us the number of learners, your preferred format and what you’d like them to achieve. We’ll suggest a suitable private training option. Ask about this course →
Trusted by
What our learners say
Hear from people who have trained with SquareOne.
TRAINING LOCATIONS
Learn where it works for you
We offer scheduled public courses in selected locations and private training at your workplace. Check the dates on this page for this course’s current availability.
Training at your workplace: for private groups, we can deliver at your premises across the UK and discuss international options. Ask us about onsite training →
Questions before you book?
Practical answers about course formats, group sizes and what to expect.
What’s included in the training?
Sessions are led by a trainer and designed to be practical, with opportunities to ask questions. Course materials and certificates are provided where applicable; we’ll confirm the exact arrangements when you book.
How many people do you recommend for a private course?
For hands-on training, we usually recommend a small group so everyone can practise and get support. Around 8–10 people is often a good starting point, but we’ll advise based on the subject and your goals.
Can you tailor the course to our team?
Yes. Tell us what your team already knows and what they need to achieve, and we can discuss a private course built around those priorities.
Do you offer public and private courses?
It depends on the course. Public dates are shown on this page when available; we can discuss private training even if no public session is scheduled.
Can we train online or at our premises?
Yes, many courses can be delivered live online or privately at your workplace. We can also discuss venue-based training for your group.
What if I’m unsure about the right level?
Tell us about your current experience and what you want to learn. We’ll help you choose a suitable course or plan a session for your team.
Ready to Get Started?
Tell us which course you’re interested in, how many people you’re booking for and where you’d like to train. We’ll come back with the right options.
"*" indicates required fields