Master Excel fundamentals by learning efficient data entry, formatting, formulae and ways to streamline your spreadsheets. Gain analytical skills under expert guidance.
1 day course 10am - 5pm Live Online or Classroom-based
What you will learn
- Understanding Excel foundations, enabling professionals to organise data accurately, reduce errors and work more confidently with everyday business information.
- How to navigate the Excel interface efficiently, improving personal productivity through custom shortcuts, faster movement and clearer worksheet views.
- Applying data entry and management techniques, helping teams input, sort and maintain reliable datasets for reporting, analysis and decision making.
- How to structure worksheets and workbooks logically, improving collaboration, scalability and long-term usability in shared Microsoft 365 environments.
- Understanding formula logic and cell referencing, empowering learners to build calculations correctly and avoid costly mistakes in financial or operational spreadsheets.
- How to use essential Excel functions, boosting workplace efficiency by automating totals, comparisons and simple decision rules within live datasets.
- Applying formatting, charts and print controls, enabling professionals to present insights clearly, share results confidently and support better business outcomes.
Related Courses
This Excel Introduction course includes
-
Authorised Certificate
-
Lifetime support after your course
-
Course materials
-
Live Instructor-led training
-
Refreshments all day
-
Latest Mac or PC ready to go
-
Authorised Trainers
-
Hands-on exercises
Course Dates
| Date | Location | Price (ex VAT) | |
|---|---|---|---|
| Fri 28 Aug 2026 | Live Online |
£375
|
|
| Tue 3 Nov 2026 | London |
£345
|
|
| Wed 2 Dec 2026 | London |
£375
|
|
| Thu 3 Dec 2026 | Live Online |
£375
|
|
| Thu 7 Jan 2027 | Live Online |
£395
|
|
| Thu 14 Jan 2027 | London |
£395
|
|
| Thu 21 Jan 2027 | Live Online |
£395
|
|
| Thu 28 Jan 2027 | London |
£395
|
|
| Tue 2 Feb 2027 | Live Online |
£395
|
|
| Wed 10 Feb 2027 | London |
£395
|
|
| Thu 18 Feb 2027 | Live Online |
£395
|
|
| Fri 26 Feb 2027 | London |
£395
|
|
| Tue 2 Mar 2027 | Live Online |
£395
|
|
| Thu 11 Mar 2027 | London |
£395
|
|
| Mon 22 Mar 2027 | Live Online |
£395
|
|
| Wed 31 Mar 2027 | London |
£395
|
|
| Fri 9 Apr 2027 | Live Online |
£395
|
|
| Fri 16 Apr 2027 | London |
£395
|
|
| Fri 23 Apr 2027 | Live Online |
£395
|
|
| Fri 30 Apr 2027 | London |
£395
|
|
| Tue 4 May 2027 | Live Online |
£395
|
|
| Wed 12 May 2027 | London |
£395
|
|
| Thu 20 May 2027 | Live Online |
£395
|
|
| Fri 28 May 2027 | London |
£395
|
|
| Tue 1 Jun 2027 | Live Online |
£395
|
|
| Thu 10 Jun 2027 | London |
£395
|
|
| Mon 21 Jun 2027 | Live Online |
£395
|
|
| Wed 30 Jun 2027 | London |
£395
|
Video success stories
Course Outline for Excel Introduction
Excel Foundations for Everyday Business Tasks
- Establishing what Excel is used for in modern workplaces across administration, marketing and analysis
- Recognising spreadsheet concepts such as cells, ranges, sheets and workbooks in practical contexts
- Identifying where Excel fits alongside tools such as Google Sheets and Microsoft 365
- Understanding how Excel skills support accuracy, speed and confidence in daily work
Excel Interface Navigation and Personal Productivity
- Navigating ribbons, tabs and contextual tools efficiently
- Customising the Quick Access Toolbar to reduce repetitive actions
- Using keyboard and mouse techniques to move around large worksheets quickly
- Understanding workbook views and zoom options for clarity
Entering, Editing and Managing Data in Excel
- Entering text, numbers and dates accurately for analysis and reporting
- Using AutoFill and series tools to reduce manual data entry
- Editing cell content safely without overwriting underlying data
- Sorting data to reveal patterns, priorities and errors
- Clearing content correctly while preserving structure
Worksheet Structure and Workbook Organisation
- Creating, renaming and reordering worksheets to reflect real tasks
- Grouping related data across multiple sheets logically
- Removing redundant sheets to keep workbooks manageable
- Understanding worksheet size and limits when working with growing datasets
Excel Formula Logic and Cell Referencing
- Writing simple calculations using arithmetic operators
- Understanding calculation order to avoid incorrect results (BODMAS)
- Working with relative and absolute cell references confidently
- Copying formulas safely across ranges without breaking logic
Essential Excel Functions for Everyday Calculations
- Applying core functions such as SUM, AVERAGE, MIN and MAX
- Using logical tests with IF to automate simple decision making
- Combining text values using modern concatenation techniques
- Applying basic text functions to clean and standardise data
Formatting Data for Clarity and Professional Presentation
- Formatting numbers, dates and text for readability and consistency
- Adjusting column widths and row heights efficiently
- Inserting and removing rows or columns without disrupting formulas
- Using formatting choices that support interpretation rather than decoration
Creating Charts to Communicate Insights
- Selecting appropriate chart types for different data stories
- Creating charts directly from worksheet data
- Editing chart elements to improve clarity and emphasis
- Understanding when charts help decision making and when tables work better
Preparing Worksheets for Printing and Sharing
- Defining print areas to control output precisely
- Adding headers and footers for context and traceability
- Adjusting layout settings for clean printed or PDF results
- Exporting worksheets to PDF for sharing with non-Excel users
FAQs about the Excel Introduction course
Is the Excel Introduction course suitable for beginners?
Yes, this Excel Introduction course is ideal for beginners with little or no prior experience in Excel. It covers foundational topics like data entry, formula creation and formatting, ensuring attendees build confidence while learning practical skills applicable to everyday tasks.
How is the content taught throughout the Excel Introduction course?
Our Excel Introduction course is extremely interactive. You will be using Excel throughout the day, working through examples and live projects under the guidance of our trainer, who will be supporting you through each step.
What is the recommended number of people for the class when I attend the Excel Introduction course?
For private classes in Excel Introduction, we recommend a maximum of 8 to 10 people from the same company in the class. Please ask our customer service team to help you find the right balance of people per class and the number of days training you need.
Should I attend the Excel Introduction course in person or live online?
For in-person courses at our London training centre, you will receive a warm personal welcome, your choice of the latest Mac or PC and morning and afternoon refreshments. If you prefer to attend remotely, rest assured that you will be taught live by the same experts that deliver our in-person courses, covering the same training content, using the same exercises and materials. A second monitor is recommended but not essential.
What support is available after I attend the Excel Introduction course?
We offer ongoing support to our Excel Introduction course attendees through email and by arrangement, phone calls. You are welcome to ask any questions on topics covered during training. Our trainer will always do their best to explain principles and help you with any issues you encounter.
Will I receive a certificate upon completion of my Excel Introduction course?
Yes, you'll receive a certificate of completion from Transmedia, demonstrating your knowledge and attendance on our Excel Introduction course. Our certificates note our Authorised Training Centre status.
Excel Introduction — Team and Bespoke Training
Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.
- Sessions can be run online or in person, on your site or at our London training centre.
- We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
- Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
- We offer a free consultation service to work out every detail of your course.
Private One-to-One Training
One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.
Book NowTeam Training for Companies
Group bookings provide you with the most cost-effective way to train your team.
Book Now
Our Clients
Latest Blog Articles
10 Excel functions you might not know and how to use them
Google Guide to Generative AI: Tips for UX Designers and Content Teams
Claude Connectors: What Every Creative Professional Should KnowWhy Transmedia?
Unlimited Training Support
We offer unlimited training support after your course.
Bespoke Training Solutions
Customised training and software solutions based on your exact requirements.
Worldwide Creative Skills Training
Join our authorised training courses live online from anywhere in the world.
Authorised Training Professionals
Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.