Training Courses

Microsoft Excel : Introduction

  99 reviews

One Day Course

Overview

This course is ideal for complete novices, those who have basic knowledge of Excel or are self-taught. The course will provide you with the skills you need to work quickly and produce functional and well formatted spreadsheets.

This course is often used to benchmark MS Excel skills and ensure a level of understanding for new starts at companies.

Delegates will leave feeling confident about creating professional worksheets with the software and be able to navigate the interface intuitively and productively.

Delegates attending the public scheduled course may choose to use either MS Office 2013 on PC or 2016 on either Mac or PC.

There is a maximum class size of eight on our MS Office public courses. You need no previous experience to attend this course.


What are the 5 things you will get out of the course?
• Create a spreadsheet from scratch.
• Format text and numbers.
• Learn shortcuts and tips to help you perform the above as efficiently as possible.
• Perform basic calculations.
• Present data visually using charts.

Public Course Dates & Pricing

Weekday
Weekday
Weekday
Weekday
Weekend
  • Public Courses

    Small class sizes so you get the maximum amount of trainer time possible. You attend with delegates from other companies.

    A great, cost efficient way to learn, discounts are also available for group bookings.

     

    Discount Info
  • Private Courses

    One to one tuition or a private group with just your colleagues. Your choice of duration, content and location. We can train at one of our centres or onsite with you wherever you are located.

    We offer a free consultation service to help work out every detail and build the perfect course for you.

    From £475 + VAT

    Free Consultation

Course Outline

  • Getting to Grips with the Basics
    • The Excel Interface
    • Using Backstage View
    • Understanding the Ribbon
    • Using the Quick Access toolbar

    Customising the Quick Access Toolbar
    • The Formula Bar
    • The Status Bar
    • Using shortcuts

    Effectively Organise Your Workbooks
    • Creating, saving and opening a new Workbook
    • Entering numbers and text in a Workbook
    • Adding, deleting and naming sheets

    Entering Data into Spreadsheets Effortlessly
    • Inserting Cells, Columns and Rows
    • Deleting Cells, Columns and Rows
    • Using SmartTags
    • Inputting dates and times
    • Using Copy and Paste
    • Using Undo and Redo

    Beautifully Presenting Your Data
    • Font formatting
    • Borders and Shading
    • Number formatting (currency etc)
    • Alignment options
    • Clearing formats
    • Applying cell styles
    • Formatting shortcuts

    Questions and answers
  • Uncomplicate Tasks by Defining and Creating Calculations
    • Writing a basic formula
    • Understanding the order of BODMAS
    • The =Sum function and AutoSum

    Creating statistical functions (Average, Max and Min)
    • An introduction to the Function Wizard

    Enhancing Key Messages with Visual Representations of Your Data
    • Creating a chart
    • Editing a chart
    • Changing the layout of a chart
    • Adding and removing

    Formatting a chart
    • Combination charts

    Fine-Tuning Your Page Layout before Printing Worksheets
    • Setting page margins and page orientation
    • Creating a Header and Footer
    • Printing all or part of a worksheet
    • Setting Print Titles for large Worksheets

    Questions and answers
Experience + Flexibility

We know training inside out. We can advise you on all the options to make sure you get the best possible course.

Tell us you need to cancel 5 working days before your course and there’s no charge. Great for your peace of mind.

Our trainers bring their years of industry experience into the classroom. You'll leave confident and prepared.

The smallest class size in the industry. More one on one time with the trainer and a less intimidating group size.

Tell us which you use and it'll be booted up and waiting with the latest software when you arrive.

We provide a lovely onsite lunch so you can relax. We can cater for any dietary requirement with no fuss.

Comfort + Location
Reputation + Feedback

Our Clients


We've worked very hard over the last 20 years to grow our business through personal recommendations.

When you attend a course we ask you to tell us how it went. We use your feedback to help us improve our courses.

We publish all our customer satisfaction stats live on our site (good or bad) because we want everyone to know just how highly you rate us every day, every week and every year.

We know that choosing the best course can be difficult, maybe the thoughts of the 9705 other clients we've asked will give you the inspiration to join us too.

The most recent comments from attendees of our courses are shown below. We reckon they will give you a pretty good indication of how they think we perform.

  Client Ratings

Attendees surveyed9705
  Trainer Knowledge9.8 / 10
  Trainer Materials9.6 / 10
  Trainer Preparation9.8 / 10
  Overall Trainer Score9.7 / 10
  Centre Lunch9.6 / 10
  Centre Staff9.9 / 10
  Overall Centre Score9.7 / 10
  Overall Experience9.6 / 10
  % Who Would Recommend Us99.7%

  Recent Feedback




"Debbie took her time and was a fantastic trainer. I really liked that we were given worksheets to create and to practice what we learnt. I learnt a lot of really useful tools that i'll be able to utilize in every day work life so thank you!"



"The whole course was delivered excellently, the food was delicious and the course very informative"



"Made what seemed like a potentially boring day interesting, and all done in a fun and light hearted environment, would definitely recommend!!!!"



"Everything was great. "



"Everything she went through. Excellent course! Very happy! Lisa has been amazing"



"Fantastic tutor, learnt a lot "



"The course was fun and interesting. I was worried about struggling with the course but the instructor was very calm and has a good sense of humour so the teaching element was stress free . "



"friendly and helpful trainer"



"Amazing training building, good lunch, easy to find location, very nice facilities, knowledgeable and friendly trainer. "



"Everything! Impeccable service!"



"Ready made booklets and exercises that we needed to complete was really helpful as it meant we could practise the stuff as soon as we learnt it. "



"Fitting in lots of things in one day - covered more than I expected. The demos on the big screens were very helpful"



"Making something that could be quite boring super fun and accessible!"



"Again, a great course - thanks!"



"Friendly and knowledgable trainer."



"Very knowledgeable, nice environment, good food"



"Very knowledgeable trainer and interactive with practical examples. Encouraged to ask questions. Very positive experience"



"Good knowledge, examples, interactive, all questions answered, friendly staff"



"Assisting each individual separately as well as a group Keeping at a steady pace explaining each task clearly"



"the teaching was excellent "



"Everything was lovely, great staff and food! Thank you!"



"-trainer was very knowledgeable/able to answer all questions effectively -trainer was very kind and friendly"



"Facilities; trainer; food"



"coming back to reinforce the info on (harder bits) .explanatory , "



"Very clear! Simplifying more technical issues"



"relevant info, digestible, easy to folloiw"



"Relevance of material. Great trainer."



"Good trainers who care "



"facilities & food were excellent"



"The food was amazing. Everyone was so friendly, such a good vibe!"



"VERY APPROACHABLE AND PROACTIVE TEACHER (Tom) ! "



"Tom was very knowledgeable, and he made everyone feel extremely involved in the class. He has a good sence of humor and he makes everyone feel at home and welcome. You also learn so much in his classes, since he answers all the questions you ask him."



"Making sure everyone is OK at all times, stopping for questions, and explaining in a understandable way and being able to watch what the trainer is doing on the big screen to follow. "



"The whole course was very informative and very well explained. "



"The course content and building up my confidence in the use of Excel. "