Training Courses

Microsoft Excel : Introduction

  186 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 & numbers
• Learn shortcuts & tips to help you perform the above as efficiently as possible
• Perform basic calculations
• Present data visually using charts

Public Course Dates & Pricing

Weekday SOLD  OUT SOLD  OUT
Weekday SOLD  OUT SOLD  OUT
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
  • 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 £499 + VAT per day

    Free Consultation

Course Outline

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

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

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

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

    Questions & answers
  • 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)
    • 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 chart elements
    • Formatting a chart
    • Combination charts

    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

    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 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 13103 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 surveyed13103
  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




"Everything. Thorough enjoyed the day"



"all was great."



"Perfect training course!"



"Tom was very concise, full of top tips and made the course fun. Lunch was also delicious."



"Explaining clearing the work tasks and helping when needed : ) "



"Teaching-informative and went round to ensure everyone was at correct stage etc"



"Understanding that some people needed a bit extra time. Trainer very patient"



"Making you feel welcome, the lunch was great and Kate the tutor was great, very knowledgeable and could answer any questions I had. "



"Excellent and engaging course, kept delegates involved using workbooks and quiz at the end Excellent lunch/refreshments "



"I liked the way we were taught how to do something and then set a task to do on our own to reconsolidate our knowledge."



"A very well-run and efficent day. Kate was clearly a pro."



"Very organised and clear. "



"Timings of breaks, getting through everything on time, quality of teacher and staff, quality of lunch and refreshments."



"Friendliness and professionalism. "



"Training at the right pace"



"Very welcoming and supportive"



"Everything was good."



"The overall environment, lunch, and friendly staff - 10/10. Course content for a beginner was relevant, however as explained above, being able to attend a higher level would have been ideal. "



"EVERYTHING . VERY WELCOMING AND AN EXCELLENT TRAINER. STAFF HERE WERE AMAZINGLY FRIENDLY"



"great trainer, good facilities"



"Very informative"



"Covering a great deal of information in a short space of time. Getting us to think about how we can apply techniques in our own roles."



"Very thorough with working examples"



"You were very good at everything. "



"I now feel a lot more confident working with excel"



"Everything is great "



"Excellent food and refreshments. Friendly staff and a very knowledgeable instructor"



"Good basic examples and handy tips on how to use Excel, including shortcuts and formatting tables which is great for making planners look professional and presentable. Autofill and flash fill are very cool."



"great knowledge and food"



"Food was good!"



"good how everything was here to use e.g equipment / didnt have to use our own computer "



"Course content, resources, course clarity and catering resources. Modern facilities. "



"Every topic was well explained with practical exercises to enhance learning. The trainer was very knowledgeable and approachable and took time to explain where necessary"



"This was an excellent course - from booking through to day-of training. I thoroughly enjoyed the experience and will definitely come back for more relevant training, as well as recommend to colleagues and friends. Adam was excellent as a trainer and I go away with so much more knowledge and equipped to use Excel much more efficiently than before. The course was excellent for beginners with no prior use as well as myself who had used Excel a little bit (but hadn't been using it very well or quickly). Thank you Adam and Media Centre Training!"



"Lunch was great! Course was very thorough. Started nice and easy at the beginning and progressively got more in depth. Trainer was good to make sure everyone was keeping up and answered all questions we had. "