PrintDURATION: 1 day |
| TIME: 09:00 to 16:00 GMT |
Master Essential Formulas: Learn to confidently create and validate simple formulas (including BODMAS logic) and utilize the AutoSum function for rapid calculations. Data Structure & Formatting: Apply formatting techniques to organize raw data, ensuring your spreadsheets are professional, structured, and easy to interpret. Reporting & Presentation: Create high-impact business charts from your data, enabling you to present key insights and answers quickly and effectively. Time-Saving Shortcuts: Drastically improve your daily workflow by incorporating essential Excel shortcuts and tips for faster data entry and navigation. Practical Application: Gain skills immediately applicable to tasks like updating company records, amending spreadsheets, and producing accurate data-driven documents and reports.
“Become a confident and efficient data user in just one day. This Microsoft Excel Level 1 training course is the foundational step toward spreadsheet efficiency and data management. Delivered onsite at your business location, or live online, you will master simple formulas, data formatting, and high-impact charting under the guidance of our Microsoft trained instructors, who have delivered results-driven training since 1998.”
Yes, absolutely. This course assumes no prior knowledge of the program. It is designed to build confidence from the very first step, covering fundamental concepts like the interface, data entry shortcuts, and basic cell referencing before moving into formulas.
Delegates gain immediate spreadsheet efficiency by mastering essential skills, enabling them to confidently create simple formulas, manipulate business data lists, and generate effective reports in a structured and error-free manner.
Our Microsoft Excel trainers have between 10 and 25 years experience in delivering Microsoft Excel courses for individuals and groups, for small and large companies across the UK and Europe.
Our primary training centre is located in Fareham, Hampshire (PO15 5TU), which is conveniently situated between Southampton and Portsmouth. We offer both open scheduled dates and private onsite training across the UK.
Yes, absolutely. All our courses include elements of Copilot AI depending on the delegates who are attending and their requirements.
We’ll get back to you one you’ve completed our Excel training questionnaire.
Virtual classroom using Microsoft Teams: £700 for up to 8 delegates
On-site: £800 – up to 8 delegates
By the end of this course you will be able to:
Learn a few important facts about Excel – Techniques for selecting cells and data – Enter spreadsheet data – use shortcuts – Prepare the quick access toolbar – Saving to local – 365 SharePoint – OneDrive.
Learn common mistakes – Use different techniques to create formulas – BODMAS – AutoSum – Insert Function – Formulas tab – Percentage calculations – Validate simple formulas – Referencing cells – Managing sheets.
Learn how to use a range of formatting techniques to create structure in your spreadsheet.
Interrogating and manipulating lists of business data are important skills. Learn how to input data using shortcuts, manipulate data, and quickly answer a range of questions relating to the data.
Learn how to use important selection techniques – chart options – create and edit charts
Understand how to: Print lists – Print charts – use Page Break Preview
There are many useful time saving shortcuts included in the course
[ Excel level 2 ] [ Excel level 3 ] [ Data Analysis ] [ PowerBI ]
Please download a copy of the shortcut pdf’s for future use.
Gaining confidence after taking a Microsoft Excel online training course can be a rewarding experience. Not only will you be able to use the program in a more efficient manner, but you will also feel empowered to tackle more complex tasks and projects.
Before taking the course, I was overwhelmed by the amount of features and formulas available in Excel. After taking the course, I felt much more comfortable with the various functions and features available, enabling me to use them with more confidence. The course provided me with a comprehensive overview of the program, and step–by–step instructions on how to use the features. This was extremely helpful, as it gave me the confidence to start working with Excel on my own.
The course provided me with practical tips on how to make the most of Excel, and how to get the most out of the data stored in the program. This was especially useful, as I was able to apply my new knowledge and skills to my work and projects. Overall, I am extremely grateful to have taken the Microsoft Excel online training course. It gave me the confidence to use the program confidently, and to tackle more complex tasks and projects. I would highly recommend this course to anyone looking to gain confidence in using Microsoft Excel.
