Microsoft Excel Level 1 – Beginners Introduction

  • Select Location
  • Online Live Classroom
Select a location then date
  • Select Date
Price (ex vat): £155

    PrintDURATION: 1 day
    TIME: 09:00 to 16:00 GMT

    This Microsoft Excel training course is designed to introduce users to the features and functions of the Microsoft Excel program. Through hands-on activities, users will learn the basics of spreadsheet creation and manipulation, data entry, formatting, formulas, functions, and charts. IPSO FACTO is based at Fareham, between Southampton and Portsmouth, Hampshire, UK. This course can be delivered live online or onsite across the UK.

    About Microsoft Excel Level 1 – Beginners Introduction

    Microsoft Excel training Online

    Excel training for beginners

    This popular Microsoft Excel training course will provide you with the skills and knowledge needed to become an efficient and confident user of the program. You will learn how to create formulas and functions, work with charts and graphs, and much more. By the end of this course, you will have the confidence and ability to create and work with a variety of data-driven documents and reports. This course is relaxed and informal where you are encouraged to ask questions. Prior knowledge of Excel is not required but beneficial. This course is relaxed and informal where you are encouraged to ask questions. Prior knowledge of Excel is not required but beneficial.

    Is this Excel basic course for you?

    If you have to work with Excel updating company records, creating or amending simple formulas and updating charts, then this course will give you confidence to complete these tasks with ease. There’s plenty of time for questions and to gain confidence with Excel.

    Not sure: Complete our online Excel Questionnaire

    We’ll get back to you one you’ve completed our Excel training questionnaire.

    Training options

    Virtual classroom using Microsoft Teams: £700 for up to 8 delegates
    On-site: £800 – up to 8 delegates

    Excel training includes

    • Microsoft Excel training manual
    • Pre course training downloads
    • Certificate on completion
    • Post course support

    Course Aims

    • To create and edit simple Microsoft Excel worksheets and workbooks.
    • To improve your confidence when using Microsoft Excel at this level.

    Course Objectives

    By the end of this course you will be able to:

    • Create and edit simple formulas
    • Format spreadsheet data
    • Sort a list of data and quickly answer a range of questions
    • Filter a list of data and quickly answer and present data responding to a range of questions
    • Create simple but effective business charts
    • Print spreadsheet data and charts
    • Learn a range of useful short cuts

    Excel level 1 course content

    Introduction to Excel (Get to know Excel)

    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.

    Simple formulas (Create useful formulas)

    Learn common mistakes – Use different techniques to create formulas – BODMAS – AutoSum – Insert Function – Formulas tab – Percentage calculations – Validate simple formulas – Referencing cells – Managing sheets.

    Formatting techniques (Simplify your data)

    Learn how to use a range of formatting techniques to create structure in your spreadsheet.

    Lists of business data (Input, edit and question your data)

    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.

    Business Charts (Create high impact charts)

    Learn how to use important selection techniques – chart options – create and edit charts

    Printing (Print different types of data)

    Understand how to: Print lists – Print charts – use Page Break Preview

    Excel shortcuts (Time savers)

    There are many useful time saving shortcuts included in the course

    Related Excel courses

    [ Excel level 2 ]  [ Excel level 3 ]   [ Data Analysis ]  [ PowerBI ]

    Downloads for Microsoft Excel course

    Please download a copy of the shortcut pdf’s for future use.

    Excel confidence builder including recent comments

    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.

    Aim & Objectives

    Course Content

    Video Testimonials

    Client Testimonials