Microsoft Excel basic course for 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

    Join our Microsoft Excel basic course for beginners. Improve your confidence using Excel and create formulas, update and analyse business data plus create simple but effective charts. This basic Excel course for beginners is delivered live online from home or work. Its exactly the same as a classroom based course where you can ask questions and discuss ideas.

    About Microsoft Excel basic course for beginners Introduction

    Microsoft Excel basics for beginners

    This Microsoft Excel basic course has been designed to improve the confidence of delegates when using Excel in the work place. It can be daunting to be faced with a spreadsheet full of company data, formulas and graphs and be asked to update it with new information. Also knowing that you can very easily mess up a spreadsheet and make changes without knowing what you’ve done. This course is relaxed and informal where you are encouraged to ask questions. Prior knowledge of Excel is not required but beneficial. Sample data can be downloaded from this site at the start of the course for us to manage, manipulate and update. We even try to have fun.

    The majority of our IT courses are successfully delivered live online using Microsoft Teams. You can connect to the course from home or work and interact with the trainer asking questions and getting the same support as a classroom based course. All this can be done from the comfort of your own home.


    Is this basic Excel 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 on completion: click here


    Training options

    Virtual classroom: £700 for up to 8 delegates
    On-site: £600 – up to 4 delegates
    On-site: £750 – up to 8 delegates


    Live Virtual Classroom schedule

    excel basic courses live online with ipso facto

    Session 1: 09:00 to 10:00

    Session 2: 10:15 to 11:15

    Session 3: 11:30 to 12:30

    Session 4: 13:30 to 14:30

    Session 5: 14:45 to 16:00


    Excel Basic course includes

    • Microsoft Training Manual
    • Pre course training downloads
    • Certificate on completion
    • Post course support relating to course content

    Related Excel courses

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


    Microsoft Excel basic course training files

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


    Excel basic confidence builder

    With the right training Microsoft Excel can become easy to use, and not that complicated scary tool that you have to use at work. Once you’ve learnt some of the basics, and how to quickly recover from mistakes, your confidence will start to grow. The more you use Excel the more you will gain confidence with this tool.

     

     

    Aim & Objectives

    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

    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

    Video Testimonials

    Client Testimonials

    • Name: 386 + reviewsCompany: Via Reviews.co.uk

      View all testimonials