Excel Level 1
Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.
This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.
- 1 Day
- Online or in person
- Private courses available
Course Objectives
- Create a spreadsheet containing data, navigate using keyboard shortcuts, add new columns and rows and save the spreadsheet.
- Create and format a spreadsheet using the main features of the formatting tools,
- Perform the following calculations on a range of numbers: addition, subtraction, multiplication and division.
- Use: sum, average, count, min and max on a range of numbers.
- Present the data in a chart and print the spreadsheet
Prerequisites
- Delegates should be familiar with using computers and have used a mouse and keyboard. Delegates should be comfortable in the Windows environment and be able to use Windows to manage information on their computer.
Included
- Lunch and refreshments when training is delivered at our training venues
- Comprehensive course materials and exercises
- Telephone and Email Support
Course content Back to top
-
Exploring the Microsoft Excel environment
Exploring the user interface
Exploring the ribbon
Obtaining help
Customising the quick access toolbar -
Understanding Workbooks and Worksheets
Creating a new workbook
Saving a workbook
Opening a workbook already created
Navigating in Microsoft Excel
Selecting and entering data
Saving a workbook -
Entering and Editing Specific Data
Entering text and numbers
Entering numbers as text
Inputting dates and times
Editing the contents of a cell
Manipulating data
Undo and redo buttons -
Using and Understanding Cell Formats
Cell Formats options
Understanding the General Format
Date and Time Formats
Currency and Accounting Formats
Text Formats
Clearing and Resetting Formats -
Ranges
Selecting a range of cells
Selecting more than one range
Selecting an entire column and row
Highlighting the entire worksheet -
AutoFill
Using Autofill to automate data entry
Text AutoFill
Number Autofill
Date AutoFill
Custom Lists
FlashFill -
Columns and rows
Inserting and deleting cells, columns and rows
Changing column widths and row heights
Auto-fitting a column to its contents
Changing back to standard widths
Hiding and un-hiding a column or row
Searching for data in a worksheet
Freezing and unfreezing rows and columns -
Developing a workbook
Formatting worksheet tabs
Repositioning worksheets in a workbook
Inserting and deleting worksheets
Copying and pasting worksheets -
Formatting a worksheet
Modifying fonts
Merging cells
Aligning cell contents
Finding and replacing formats
Applying borders to a selection
Deleting borders around a selection of cells
Changing the alignment of the contents of a cell
Using the format painter
Clearing cells (removing formats) -
Cut, Copy and Paste
Cut, Copy and Paste
Shortcuts
Copying and Pasting to different sheets
Paste Options -
Performing calculations
Adding and Subtracting Numbers
Multiplication and Division
BODMAS
Cell references
SUM function
AUTOSUM
Useful Basic Functions AVERAGE, MIN, MAX and COUNT -
Basic Sorting and Filtering Data
Sorting data
Filtering data -
Basic Charts
Chart types
Simple Chart Customisations -
Spelling and Printing
Spell checker
Print preview
Printing the spreadsheet
Printing a section of a worksheet
Clearing a print area
Public dates and prices Back to top
Prices are per delegate and exclude VAT.
-
Tuesday 3 November 2026
£295+ VAT
-
Tuesday 24 November 2026
£345+ VAT
-
Thursday 3 December 2026
£295+ VAT
-
Thursday 17 December 2026
£425+ VAT
-
Monday 11 January 2027
£295+ VAT
-
Wednesday 17 February 2027
£295+ VAT
-
Tuesday 11 May 2027
£295+ VAT
-
Wednesday 16 June 2027
£295+ VAT
-
Wednesday 28 July 2027
£295+ VAT
-
Friday 30 July 2027
£295+ VAT
-
Thursday 9 September 2027
£295+ VAT
-
Tuesday 5 October 2027
£295+ VAT
-
Tuesday 2 November 2027
£295+ VAT
-
Thursday 2 December 2027
£295+ VAT
Can't make these dates? Ask about a private course on a date that suits you.
Training a team?
Run this course privately, on your dates
What delegates say Back to top
“Very well explained, it was so easy to follow. All excellent, lovely venue.”
“Fantastic. Easy to follow. Excellent venue and trainer”
“Very enjoyable course”
“Ideal for entry level”
“All of the course gave me a wide insight into Excel and its capabilities.”
“I feel much happier after sitting the course”
Following this training what are you going to do differently
“More confident”
Following this training what are you going to do differently
“Work more efficiently using shortcuts and saving time”
Which part of the course did you find particularly valuable
“Formulas and charts. Good overview of features”
Following this training what are you going to do differently
“Use excel more for stock levels, validation sheets etc”
Following this training what are you going to do differently
“It will make using Excel a lot quicker”
Any other comments or recommendations
“Trainer was good at delivering the info and being helpful”
Following this training what are you going to do differently
“Feel more comfortable using Excel at work”
“Really enjoyed the course and found it really useful.”
“Very helpful course! Especially due to my knowledge of Excel being non existent.”
“Great course, engaging trainer and a good pace. Just what I was looking for.”
Which part of the course did you find particularly valuable
“All useful particularly graphs, making tables and copying formula”
Following this training what are you going to do differently
“More confident in Excel”
Which part of the course did you find particularly valuable
“The trainer was willing to help until everyone understood”
“Informative and easy to understand course”
“Very good course would recommend to anyone needing upskilling.”
“First team’s training session wasn’t sure what to expect. Great facilitator, excellent handouts and an inspiring way to train.Thank you.”
“Very friendly and helpful trainer, very knowledgeable.”
Following this training what are you going to do differently
“Play around a lot more and be more confident with excel.”
Please select the words that best describe your learning experience
“For someone who hasn’t used computers much this was a great help”
Following this training what are you going to do differently
“It will save alot of time on my day to day knowing the shortcuts and how excel can help me to work faster”
Which part of the course did you find particularly valuable
“I found so many useful features I didn’t know existed. I can stop wasting time now!”
“Would definitely recommend”
“I know how to do formula’s now so that’s really going to help me day to day. I also know lots of short cuts now too.”
“Well presented and easy to follow”
Following this training what are you going to do differently
“I will be a lot more efficient and not waste so much time on Excel figuring things out.”
Following this training what are you going to do differently
“My whole approach to spreadsheets and obtaining selecting information”
“Everything was clear and straight forward”
“I enjoyed everything as it was very helpful and informative”
“Very nice approach and teacher style”
“The trainer was super patient and explained really well”
“Good trainer, worked at a good pace.”
“Excellent course well presented.”
Which part of the course did you find particularly valuable
“It was useful to gain a wider knowledge on how the pie chart function works.”
“This will help me within my current role, and help me develop my own spreadsheets”
Following this training what are you going to do differently
“Too much to mention”
“Really enjoyed the training, Thank you”
“All aspects were worthwhile, Everything was well laid out & explained.”
“Really enjoyed the course and felt I learnt more that I expected”
“Very happy with what I have learnt.”
“Thank you very much, I feel I have learned a great deal.”
“Challenging in a good way.”
“The trainer was fantastic throughout the day and made me feel at ease as I was a little nervous”
“Enjoyable!!”
“Recommending to everyone!”
“I feel much more confident using formulas now. I will definitely do more charts for insertion into reports now.”
“The one on one tuition was really helpful”
“Very well presented”
Following this training what are you going to do differently
“I am now able to create spreadsheets using excel to compile, present and share data.”
Other courses in this series Back to top
- You are here Excel Level 1
-
Excel Level 2
In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates…
-
Excel Level 3
This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply…
-
Excel Advanced Macros
This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in…
-
Excel Business Intelligence using Excel Power Tools
This course is split into 3 main areas:1. Get and Transform (Power Query)2. Power Pivot - Data Models and DAX calculations3. Dashboard…
-
Excel Analysing and Presenting Data with Dashboards and Pivot Tables
This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive…
-
VBA Essentials using Microsoft Excel
This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be…
Related courses
-
Word Essentials
This course is for delegates who want to learn to be more productive with Microsoft Word. Delegates will learn how to use the essential day…
Please contact us to discuss your Excel Level 1 course, we have many solutions available to ensure you receive the best training possible.
Your Excel course can be delivered online or in-person. You can choose your Excel path with introduction to advanced levels. Master Excel Business Intelligence and Power Tools, VBA and more. Learn in-person or online with our virtual classrooms. Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible Excel Level 1 course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account. You can master Excel, please contact us to book a place or get a quote for your Excel Level 1 course.
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed: 10/23/2026 10:23:11 PM