Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger sub menu
More
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Microsoft Excel Introduction
Microsoft Excel Introduction
Search

EXCEL INTRODUCTION

The best solution for Introduction To Excel Training Courses

A hands-on one-day course with free e-learning revision after your training and pre-course online skills testing. Free bespoke course design is also available for private classes if the content needs to be adjusted
Need PRICES or DATES?  See the blue link buttons on the right  >>>
CPD CERTIFIED COURSE
CPD accredited course

Note: this Excel Introduction course is CPD certified.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as an Activia diploma of completion.

COURSE OUTLINE

Full details of modules and topics covered in this one-day course

VERSIONS COVERED

This course covers 2007, 2010, 2013 and 2016 versions

Blended learning
FREE E-LEARNING REVISION

Note: Free e-learning revision is available with this course: 12 months of access for each delegate on scheduled public (open) classes and standard on-site/private classes (not available for bespoke courses) .

DURATION

This is a one-day training course structured into 6 modules

COURSE AIMS

This intensive one-day training course is designed to let users get to grips with the main features of Microsoft Office Excel 2007, 2010, 2013 or 2016, including a thorough treatment of the new 'Ribbon' interface, originally introduced with Excel 2007. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.

TARGET AUDIENCE

The course is intended for new users of Microsoft Excel 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Excel is required.

MODULE 1:  Getting Started with Microsoft Excel
Learning outcomes:
Starting Excel and some of its basic navigation and help controls.
Topics covered:
  • Starting Out
  • About Workbooks
  • Exploring your Workbook
  • Getting Help with Excel
MODULE 2:  The Excel Interface
Learning outcomes:
A look at the Ribbon interface and the different tabs and options the Ribbon offers.
Topics covered:
  • The Quick Access Toolbar and File Menu
  • The Home Tab
  • The Insert Tab
  • The Page Layout Tab
  • The Formulas Tab
  • The Data Tab
  • The Review Tab
MODULE 3:  Microsoft Excel Basics
Learning outcomes:
Working with a Workbook, its cells, columns and rows.
Topics covered:
  • Working with Excel
  • Basic Excel Features
  • Moving your Data
  • Smart Tags and Options Buttons
  • Editing Tools
MODULE 4:  Editing your Workbook
Learning outcomes:
Understanding formatting features and enhancing a workbook's overall appearance and using Conditional Formatting.
Topics covered:
  • Cell Formatting
  • Conditional Formatting
  • Enhancing a Worksheet's Appearance
MODULE 5:  Printing and Viewing your Workbook
Learning outcomes:
Exploring Excel's printing and viewing options enhancing your ability to print and work with your data effectively.
Topics covered:
  • Using the View Tab
  • Managing a Single Window
  • Managing Multiple Windows
  • Printing your Workbook
  • Print Page Layout options
MODULE 6:  Working with Charts in Excel
Learning outcomes:
Introducing charts within Excel and explain how to create basic charts to help convey your data with.
Topics covered:
  • Using Recommended and Standard Charts
  • Chart Elements
  • Chart Tools - Design & Format
RELATED COURSES

Excel Intermediate

COURSE OUTLINE
[Duration: one day]

Excel Intermediate

  • Advanced File Tasks
  • Working with Functions and Formulas
  • Managing Tables in Microsoft Excel
  • Data Tools in Excel
  • Doing More with Charts in Excel
  • Sparklines

Excel Advanced

COURSE OUTLINE
[Duration: one day]

Excel Advanced

  • Grouping & Outlining and Subtotals
  • What-If Analysis
  • PivotTables
  • Charting Pivoted Data
  • Advanced Excel Tasks
  • Creating HLOOKUP and VLOOKUP Functions
  • Introduction to Macros in Excel

Excel Professional

COURSE OUTLINE
[Duration: one day]

Excel Professional

  • Advanced Conditional Formatting
  • Using Form Controls and Templates
  • Advanced Lookup Functions
  • Advanced Functions in Excel
  • Advanced Pivot Table Tools
  • Introduction to User Defined Functions Using VBA

Excel VBA Introduction

COURSE OUTLINE
[Duration: one day]

Excel VBA Introduction

  • Recording and Running Macros in Excel
  • Introduction to the Excel VBA Editor
  • Creating Procedures and Functions
  • Working with the Excel Object Model
  • Controlling Program Flow

Excel VBA Advanced

COURSE OUTLINE
[Duration: one day]

Excel VBA Advanced

  • Advanced Procedures
  • Advanced Variables
  • Interacting with Office Applications
  • Debugging and Error Traps
  • Creating Custom User Forms
  • Workbook and Worksheet Events

Excel Dashboards

COURSE OUTLINE
[Duration: one day]

Excel Dashboards

  • Introduction to Dashboards
  • Inserting Graphics for a Dashboard
  • Specialist Functions and Formulas
  • Dashboard Navigation
  • Preparing your Workbook's Layout and Structure
  • Using Excel Objects for Specialist Dashboard Views
  • Using Macros and VBA with Dashboards

Excel Business Intelligence (BI)

COURSE OUTLINE
[Duration: one day]

Excel Business Intelligence (BI)

  • Importing and Linking Data
  • Data Manipulation with Pivot Tables
  • Advanced Reporting Functions
  • Automating Reports with Controls
  • Advanced Charting Features

DELEGATE FEEDBACK FOR OUR
MICROSOFT EXCEL INTRODUCTION COURSE

AVERAGE REVIEW: 4.6 out of 5  BASED ON 226 REVIEWS

VANESSA HILLMAN , Jun 27 2017
Course rating of 4 stars "My trainer Shalini was very patient and explained everything in detail. We covered all aspects in the training manual. Thank you Shalini "

 
Joanna Swan, Jun 22 2017
Course rating of 5 stars "the trainer was outstanding, made you feel at ease and was very helpful. I came back to work the next day and made a spread sheet the way I had been trained and was so impressed with myself, so it just goes to show how good her training and explaining of things were, if I can do it from the training after one day then anybody can, thank you so much "

 
Louise Robinson, Jun 20 2017
Course rating of 5 stars "I found the course extremely useful and the trainer was very pleasant and helpful."

 
Layla Dunn, Jun 19 2017
Course rating of 4 stars "Gareth was a good tutor and kept the course interesting. "

 
Kelly Marshall , Jun 7 2017
Course rating of 5 stars "I can also use the information learned to create Spreadsheets at home."

 
Jasmine Owen, Jun 7 2017
Course rating of 5 stars "I felt that the trainer Steve was very engaging, helpful and made the course interesting. Really good!"

 
Seth Hargraves, Jun 7 2017
Course rating of 4 stars "I was very happy with the results of the session. "

 
Shelagh Jesson, Jun 7 2017
Course rating of 4 stars "very interesting and informative."

 
Sue Kitcher , May 31 2017
Course rating of 4 stars "Trainer was very good / professional"

 
Sue Barry , May 31 2017
Course rating of 4 stars "It was a very useful course "

 
Lisa Bach, May 22 2017
Course rating of 4 stars "Tina was a great teacher. Easy to follow & friendly personality. Overall, a very enjoyable day "

 
Lisa Bach , May 22 2017
Course rating of 4 stars "Excellent teacher. Very pleasant and easy to follow"

 
Eva Meisinger, May 17 2017
Course rating of 4 stars "The tutor was excellent! Hope to get this tutor on an advanced course!"

 
Charlotte Charlton, May 17 2017
Course rating of 4 stars "Great tutor"

 
Sylvia Cooper, May 15 2017
Course rating of 5 stars "Well worth it."

 

MORE INFORMATION FOR
MICROSOFT EXCEL INTRODUCTION

Blended learning
FREE E-learning Revision

With our latest Microsoft Excel courses, you get free e-learning revision for a full 12 months after your class so you can reinforce the knowledge you have gained.

Access is simple: go to www.activia.co.uk/login/ and log in using your email address.   This will give you free access to our e-learning revision modules.

Note: These have been developed and written exclusively by Activia to maximise effectiveness, by matching the e-learning exactly to what you cover in class.   We hope you have fun, on the day of the course and with honing your knowledge afterwards!

General Information

All Activia introduction to excel training courses have been created, reviewed and developed to ensure up to date provision and constantly improving standards of content. Our Microsoft Excel training is interactive and classroom-based which maximises learning through the ability to ask questions and discuss specific issues.

Class Sizes

Maximum class size for Microsoft Excel courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates.

Note that we never cancel our scheduled classes -- even if there are only one or two delegates -- so once you have booked, your place is assured.

Larger Class Sizes for Excel 2007 to 2016

On our Public courses, you will always benefit from our small maximum class sizes of 8 delegates. In fact, the actual class size is often less.

However, if you want training for larger groups at your offices, we can deliver exactly the same content (though with a little less interactivity) for classes of up to 18 delegates, provided they have their own PCs or laptops. You will still have the exercises to download, and the same access to free e-learning revision, after the course.

These "large class" courses are a great choice if you need to get a lot of people trained in a short space of time, and the cost per delegate allows you to get more people upskilled within a limited budget.

[Note: Bespoke options are not available for these courses.]

If you would like to find out more, please get in touch to discuss.

How to book
Course, dates and delegate numbers
Decide on the Microsoft Excel course you want, the date(s) you can attend, and the number of delegates involved
Training location
Also decide whether you want training at your offices or at one of our centres
Speedy course booking
You can use the Speedy Quote option to contact us for a quick price, or you can book online from the schedule on this website
Call us
if at any time you want help or advice, or you want to book on the telephone, just call us on 0333 6000 111 to speak to one of our friendly training advisors

Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.

Also note: If you are a private individual you must pay by credit card at the time of booking.

The confirmation process
Course places allocated
Your place is allocated, along with workbooks (and lunches if it's at our centre)
Booking confirmation
You receive an official confirmation, with joining instructions (and directions if it's at our centre)
Training invoice
You receive a VAT invoice

Note: Please allow 1 - 2 working days for your confirmation and invoice.

What happens on the day

If you are coming to our centre, dress code is smart casual.   Refreshments and a free buffet lunch will be provided, but please note that, as a training company who relies on caterers, we are unable to reliably provide for differing dietary requirements, so if you are in any doubt then please bring your own.   The timetable is as follows:

9:15

ARRIVAL TIME

9:30

TRAINING STARTS

11:00

MID-MORNING BREAK



1:00

ONE HOUR LUNCH BREAK

3:15

MID-AFTERNOON BREAK

4:30

WRAP UP

Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !

For training at your offices, this itenerary can be varied by prior arrangement.

What you get

With every Microsoft Excel training course with Activia, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge. With all Excel 2007 to 2016 courses, you are also given 12 months access to free e-learning revision which will further help you to reinforce the lessons you have learned.

Every delegate on a Microsoft Excel course also gets an Activia Training Attendance Certificate.



GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

MICROSOFT EXCEL TRAINING

We can enhance your skills with Microsoft Excel spreadsheet training at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our introduction to excel courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft Excel training all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of courses for training in Excel to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Courses for Training in Excel from Activia.

Why not contact us today to see how we can help with providing your courses for Microsoft Excel ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top
Quick Links
More on This Page