Training Courses

Microsoft Excel : Introduction

  373 reviews

One Day Course

Now Available As Online Training!

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.

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

You need no previous experience to attend this course.

Public Course Dates & Pricing

SOLD  OUT London Bridge SOLD  OUT

Online
SOLD  OUT London Bridge SOLD  OUT

Online
London Bridge
London Bridge
London Bridge
London Bridge
London Bridge

Public Courses

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

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 £499 + VAT per day

Enquire Here

Course Outline

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

    Effectively Organise Your Workbooks
    • Creating, saving & opening a new Workbook
    • Entering numbers, text & dates in a Workbook
    • Deleting Cell Contents
    • Adding, deleting & naming sheets

    Controlling the Layout of Spreadsheets Effortlessly
    • Inserting Columns & Rows
    • Deleting Columns & Rows
    • AutoFill
    • Using Cut, Copy & Paste
    • Using Undo & Redo

    Uncomplicate Tasks by Defining & Creating Calculations
    • Writing a basic formula
    • Understanding the order of BODMAS
    • The Sum function & AutoSum
    • Creating statistical functions (Average, Max and Min)
    • Working with Relative References when Copying Formulas

    Questions & answers
  • Beautifully Presenting Your Data
    • Font formatting
    • Borders & Shading
    • Number formatting (currency etc)
    • Alignment options
    • Clearing formats

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

    Visual Representations of Your Data
    • Creating a chart
    • Changing the Chart Type
    • Basic Formatting of Charts

    Questions & 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 more than 7 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 20423 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 surveyed20423
  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.6%

  Recent Feedback




"The teaching was methodical and at a pace that I could learn."



"Very happy with all"



"Explaining things in a way that makes sense. I didn't expect to understand it all, but I did. Great tutor, great location and great offices/catering. Thanks for having me! x"



"Everything! Everyone was informative, knowledgeable and helpful."



"Good facilities and clean environment. Nice location "



"Everything Food was amazing Location was Great Easy to access - Even I found it without asking a stranger!"



"Everything, the staff are extremely friendly and the trainers are great at keeping you engaged. The right amount of breaks. Kate was great, I feel I've learnt exactly what I came for. Thank you!"



"It was extremely efficient and you did great job at keeping it active enough to manage to keep me engaged. "



"Useful techniques and playing back our learning and the end of each exercise "



"talking step by step - very supportive and available for any questions"



"Managing the pace of the class and helping those on different levels of ability"



"The lecture setting was amazing"



"Explaining and being patient!"



"delivery and hospitality "



"Appropriate content for the level; clear and concise instructions, lovely staff and food. The tips really helped! :-) "



"Nice, welcoming atmosphere. Really lovely! "



"Experience was good."



"Knowledge, Training, Hospitality, EVERYTHING. I will definitely be back Thanks Lisa "



"Welcoming and knowledge"



"making sure everyone in the room was up to speed and answering any questions and explaining fully "



"very informative and patient and well explained"



"The trainer made sure we all understood before moving on."



"very knowledgeable and I didn't feel afraid to ask to explain again. Very good session. Thank you."



"Examples were really useful."



"classroom teaching, overall welcome, lunch"



"Very efficient running of the day, with good number of scheduled breaks. Organised well in table numbers per room, so doesn't feel overwhelming with lots of different groups in here. Well organised class with clear learning outline. Snacks, lunch and drinks were great. "



"Covered all areas very well and waited for others to understand everything before moving on. Easily taken in and great teaching. Will be coming back for the intermediate course in December. "



"explaining examples clearly and thoroughly "



"Taking the time to explain to everyone in the room, despite being on different levels"



"Friendly staff, very professional. "



"* Providing excellent training examples and a very supportive and knowledgeable trainer. "



"The course went at the right pace for me. The trainer was very approachable and helpful. I felt I could ask questions when I needed to."



"The trainer was great at going round each of us to provide help. She was very patient! I also like the summary at the end of each section. Overall, the location and everything else about the day was excellent."



" Katie was very clear with her instructions and made understanding the task of formatting data in Excel far less intimidating! The hospitality was also fabulous :) Very pleased with the day and would come to another course!"



"detailed explanation and practice answers were very useful "