Training Course

Excel Level 1

PDF
1 Day
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.

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
20 Jan 2025
in
Newcastle
£375
24 Jan 2025
Virtual Course
£245
14 Feb 2025
Virtual Course
£245
20 Feb 2025
in
Durham
£295
12 Mar 2025
in
Newcastle
£375
13 Mar 2025
Virtual Course
£245
21 Apr 2025
Virtual Course
£245
22 Apr 2025
in
Durham
£295
15 May 2025
Virtual Course
£245
19 May 2025
in
Durham
£295
13 Jun 2025
in
Newcastle
£375
16 Jun 2025
Virtual Course
£245
03 Jul 2025
Virtual Course
£245
05 Aug 2025
in
Durham
£295
07 Aug 2025
Virtual Course
£245
02 Sep 2025
in
Durham
£295
11 Sep 2025
in
Newcastle
£375
07 Oct 2025
Virtual Course
£245
04 Nov 2025
Virtual Course
£245
25 Nov 2025
in
Durham
£295
04 Dec 2025
Virtual Course
£245
18 Dec 2025
in
Newcastle
£375

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course 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.

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

Included with this course

    • Lunch and refreshments when training is delivered at our training venues
    • Comprehensive course materials and exercises
    • Telephone and Email Support

Excel Level 1 Course Content

  • 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 Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
20 Jan 2025
in
Newcastle
£375
24 Jan 2025
Virtual Course
£245
14 Feb 2025
Virtual Course
£245
20 Feb 2025
in
Durham
£295
12 Mar 2025
in
Newcastle
£375
13 Mar 2025
Virtual Course
£245
21 Apr 2025
Virtual Course
£245
22 Apr 2025
in
Durham
£295
15 May 2025
Virtual Course
£245
19 May 2025
in
Durham
£295
13 Jun 2025
in
Newcastle
£375
16 Jun 2025
Virtual Course
£245
03 Jul 2025
Virtual Course
£245
05 Aug 2025
in
Durham
£295
07 Aug 2025
Virtual Course
£245
02 Sep 2025
in
Durham
£295
11 Sep 2025
in
Newcastle
£375
07 Oct 2025
Virtual Course
£245
04 Nov 2025
Virtual Course
£245
25 Nov 2025
in
Durham
£295
04 Dec 2025
Virtual Course
£245
18 Dec 2025
in
Newcastle
£375

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Excel Level 1 Course Options
    Public Scheduled
    Public Scheduled
    Fixed course content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

"Recommending to everyone!"

M.C. Sheard Packaging, Excel Level 1

"Enjoyable!!"

M.D. Public course, Excel Level 1

"[The trainer] was fantastic throughout the day and made me feel at ease as I was a little nervous."

M.D. Public course, Excel Level 1

"Challenging in a good way."

M.W. CMR, Excel Level 1

"Thank you very much, I feel I have learned a great deal."

J.C. , Excel Level 1

"Very happy with what I have learnt."

J. Lincolnshire Housing Partnership, Excel Level 1

"Really enjoyed the course and felt I learnt more that I expected"

K.W. James Jones and Sons, Excel Level 1

"All aspects were worthwhile, Everything was well laid out explained."

L.G. James Jones and Sons Ltd, Excel Level 1

"Really enjoyed the training, Thank you"

L.G. James Jones and Sons Ltd, Excel Level 1

Following this training what are you going to do differently "Too much to mention"

J.R. James Jones and Sons Ltd, Excel Level 1

"This will help me within my current role, and help me develop my own spreadsheets"

D.B. NHS South Tyneside and Sunderland, Excel Level 1

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."

S.B. , Excel Level 1

"Excellent course well presented."

N.C. Cembre Ltd, Excel Level 1

"Good trainer, worked at a good pace."

J.B. Nexus, Excel Level 1

"[The trainer] was super patient and explained really well"

N. Schlegel, Excel Level 1

"Very nice approach and teacher style"

L.H. SchlegelGiesse, Excel Level 1

"I enjoyed everything as it was very helpful and informative"

H.M. , Excel Level 1

"Everything was clear and straight forward"

A.S. Hitachi CMUK, Excel Level 1

Following this training what are you going to do differently "My whole approach to spreadsheets and obtaining selecting information"

W.F. , Excel Level 1

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."

L.M. Blue Phoenix, Excel Level 1

"Well presented and easy to follow"

C.M. Nexus, Excel Level 1

"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."

L.D. , Excel Level 1

"Would definitely recommend"

L.H. Hitachi, Excel Level 1

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!"

S.S.G. Lighthouse, Excel Level 1

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"

H.S. Dartmouth Global Trading Co Ltd, Excel Level 1

Please select the words that best describe your learning experience "For someone who hasn't used computers much this was a great help"

G.H. universal wolf, Excel Level 1

Following this training what are you going to do differently "Play around a lot more and be more confident with excel."

J. LHP, Excel Level 1

"Very friendly and helpful trainer, very knowledgeable."

D.S. LHP, Excel Level 1

"First team's training session wasn't sure what to expect. Great facilitator, excellent handouts and an inspiring way to train.Thank you."

S. , Excel Level 1

"Very good course would recommend to anyone needing upskilling."

R.B. LYHA, Excel Level 1

"Informative and easy to understand course"

S.D. Bang & Olfsen, Excel Level 1

Which part of the course did you find particularly valuable "The trainer was willing to help until everyone understood"

H.L. Hoults Ltd, Excel Level 1

Following this training what are you going to do differently "More confident in Excel "

H.A. Relate, Excel Level 1

Which part of the course did you find particularly valuable "All useful particularly graphs, making tables and copying formula"

G.H. Capstone Foster Care, Excel Level 1

"Great course, engaging trainer and a good pace. Just what I was looking for."

G.H. Capstone Foster Care, Excel Level 1

"Very helpful course! Especially due to my knowledge of Excel being non existent. "

J.B. Tharsus, Excel Level 1

"Really enjoyed the course and found it really useful. "

H.P. Labour Party, Excel Level 1

Following this training what are you going to do differently "Feel more comfortable using Excel at work"

E.J. AESICA Pharmaceuticals, Excel Level 1

Any other comments or recommendations "Trainer was good at delivering the info and being helpful"

R.S. ENGIE Fabricom, Excel Level 1

Following this training what are you going to do differently "It will make using Excel a lot quicker"

H.B. ENGIE Fabricom, Excel Level 1

Following this training what are you going to do differently "Use excel more for stock levels, validation sheets etc"

G.S. Egger (UK) Ltd, Excel Level 1

Which part of the course did you find particularly valuable "Formulas and charts. Good overview of features "

S.K. Egger (UK) Ltd, Excel Level 1

Following this training what are you going to do differently "Work more efficiently using shortcuts and saving time "

B.S. Egger (UK) Ltd, Excel Level 1

Following this training what are you going to do differently "More confident "

N.A. Egger (UK) Ltd, Excel Level 1

"I feel much happier after sitting the course"

D.G. Stobart rail, Excel Level 1

"All of the course gave me a wide insight into Excel and its capabilities."

M.W. Litterboss Ground Control, Excel Level 1

"Ideal for entry level"

M.Q. Nissan, Excel Level 1

"Very enjoyable course"

W.M. Gestamp UK Ltd, Excel Level 1

"Fantastic. Easy to follow. Excellent venue and trainer"

D.G. SPIE UK, Excel Level 1

"Very well explained, it was so easy to follow. All excellent, lovely venue."

M.N. MAN Diesel & Turbo UK Ltd, Excel Level 1

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
20 Jan 2025
in
Newcastle
£375
24 Jan 2025
Virtual Course
£245
14 Feb 2025
Virtual Course
£245
20 Feb 2025
in
Durham
£295
12 Mar 2025
in
Newcastle
£375
13 Mar 2025
Virtual Course
£245
21 Apr 2025
Virtual Course
£245
22 Apr 2025
in
Durham
£295
15 May 2025
Virtual Course
£245
19 May 2025
in
Durham
£295
13 Jun 2025
in
Newcastle
£375
16 Jun 2025
Virtual Course
£245
03 Jul 2025
Virtual Course
£245
05 Aug 2025
in
Durham
£295
07 Aug 2025
Virtual Course
£245
02 Sep 2025
in
Durham
£295
11 Sep 2025
in
Newcastle
£375
07 Oct 2025
Virtual Course
£245
04 Nov 2025
Virtual Course
£245
25 Nov 2025
in
Durham
£295
04 Dec 2025
Virtual Course
£245
18 Dec 2025
in
Newcastle
£375

Private Training

Flexible dates, location and content. All prices exclude VAT.

Other Courses In This Training Series

Excel Level 2 Course Course Overview: In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gai Excel Level 3 Course Course Overview: 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 advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and an Excel Formulas and Functions Indepth Course Course Overview: This course is designed to help users get the most from the advanced functions in Excel. Advanced Lookup and Reference functions to help you gather data, Text functions to organise and validate the data, Logical functions to analyse the data. You will use the advanced features of Microsoft Excel to Excel Advanced Macros Course Course Overview: 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 and then be able to gain a better understanding of the code and make changes to it. We even teach you some commands that cannot be recorded, such as how to sh Excel Business Intelligence using Excel Power Tools Course Course Overview: This course is split into 3 main areas:1. Get and Transform (Power Query)2. Power Pivot - Data Models and DAX calculations3. Dashboard Creation with Pivot Tables, Charts and SlicersIt is aimed at users who want to analyse data from multiple sources and want to create effective data dashboards.Thi Excel Analysing and Presenting Data with Dashboards and Pivot Tables Course Course Overview: This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to VBA Essentials using Excel Course Course Overview: 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 better suited to their environment, by creating their own functions and procedures.

 

 

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 request a quote for your Excel Level 1 course.

General Information

Microsoft and Microsoft Excel are Registered Trademarks Microsoft Excel training courses throughout North East England. Microsoft Excel Training courses North East England, courses in Durham, North East courses in Washington, Newcastle. Microsoft Excel 2010 training courses. Excel Training Courses in the North East of England. Excel training courses in England. Excel Training Courses Newcastle. Excel introduction training courses for beginners in Newcastle, Washington, Durham, Darlington and throughout the North East of England. Microsoft Excel starter training courses.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:1/14/2025 4:51:45 PM