Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Intermediate Microsoft Excel 2007™

Summary
Length:
1 day
Price:
199 GBP excl. VAT
Training Provider:
Reed Learning PLC plusReed Learning PLC
Location:
Training Method:
Startdate:  
London: 21/02/2012, 07/03/2012, 23/03/2012

About Intermediate Microsoft Excel 2007™

In addition to a complete new user interface Microsoft have added new features and enhanced others in Office Excel 2007. This course follows on from our Office Excel 2007 introduction course with more complex formulas and functions. There is a recap session at the start for delegates who may have completed the introduction in a previous version.Course Overview
  • Recap on user interface, environment and shortcuts
  • Absolute references
  • Naming cells and ranges
  • Referring to named cells and ranges in formulae
  • Editing named cells and ranges
  • Setting up entire workbooks with group editing
  • Using lookup statements to retrieve data
  • Editing lookups and ensuring accuracy in returned data
  • Linking spreadsheets and workbooks together with formulas and functions
  • Utilising If statements to assist decision making
  •  If statements and calculations
  • Analysing data with the all new conditional formatting features
  • Databases in Excel understanding fields and records
  • Sorting data numerically and alphabetically
  • Filtering data for range and precision  analysis
  • Setting up data validation to ensure integrity of the data
  • Attaching security to a spreadsheet
  • Selective protection i.e.: protecting formulas while allowing data entry
  • Setting up and utilising templates
  • Creating and formatting charts
  • Adding trend lines to the chart
  • Utilising custom chart types

Suitability and application

This intermediate course is designed for users who are already confident in the basic features of Microsoft Excel (any version but preferably Office 2007) and wish to further their knowledge and understanding.  In this course we will focus on working with large amounts of data.

What will I get out of it?

  • The skills to utilise database functionality
  • How to create look-ups to obtain range and precise data
  • An understanding of how to add 'IF' statements and using validation to restrict access to cells, rows and columns
  • Knowledge to use the new an improved conditional formatting
  • Useful practical exercises
  • Free attendance on a refresher course within a year
  • The confidence and knowledge to move on to the next level - Advanced Microsoft Excel 2007

Expenses

£199.00 + VAT

About Reed Learning PLC

Reed Learning Short Courses and Professional Qualifications

Reed Learning

Short Courses and Professional Qualifications

Reed Learning is one of the biggest business training companies in the UK. We’re part of the Reed group of companies, founded 50 years ago and still family-run.

Public, scheduled training courses

We run more than 250 different short courses. In the last 10 years we’ve trained over 150,000 people, including 20,000 new managers, 12,000 people who were scared of doing presentations, and 14,000 who needed to learn to prioritise.

Our core areas are:

  • Management & leadership
  • Personal Development including Communication, Anger, Stress & Time Management
  • Project Management
  • Health & Safety
  • Microsoft & Google
  • Sales, Customer Service & Marketing
  • HR & Training
  • PA & Secretarial

We also offer a brand new range of virtual classrooms on our most requested topics. These 75 minute sessions provide tutor-led, concentrated tuition in core subjects."

People choose us because our trainers are experienced, we have a vast choice of programmes, our rates are very reasonable and because our training makes people feel motivated and full of ideas to use back at work. 

Try one of our courses – we guarantee you’ll feel it's worthwhile, or your money back. 

Professional qualifications

Reed Learning offers one of the widest choices of professional qualifications in the UK, including:

  • Chartered Management Institute management qualifications at levels 3 to 5, new CMI one-day qualifications and Chartered Manager qualification
  • Postgraduate Certificate in International Business from Royal Holloway, University of London
  • ASTD & CIPD qualifications in training, L&D and HR
  • Senior management accelerated route to Chartered Banker status
  • The UK’s first Certificate in Professional PA & Secretarial Skills, in partnership with the Institute of Professional Administrators
  • ISMM Diploma in Advanced Sales and Marketing
  • NEBOSH national certificate and the IOSH Managing Safely programme

In-house / on-site training

As well as our scheduled courses, we can come to you. We run successful on-site training for some huge organisations like Sky, the AA and Pepsi, and some smaller ones like the Welsh Language Board, Webworks and London Borough of Brent

Outsourcing & Managed Services

We run outsourced training services, providing trainers, scheduling courses and taking care of all the administration. Our clients span the banking, local government and media sectors, and in the past five years we’ve helped them save hundreds of thousands of pounds.

Get in touch

Whether you want to book a short course, arrange something in-house or discuss your organisation’s learning strategy, we’ll bend over backwards to deliver the right training programme at the right price.

Contact us and tell us what you’re looking to achieve this year here.


plus Show all courses with Reed Learning PLC

Request information - obligation free

Get more information from Reed Learning PLC by filling out the following form. This is a free service for you and the course provider to help you find the most suitable training.
To request information from Reed Learning PLC, please fill out the following details:
* =  Required field
Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date
Number of participants
Message*
Rules

Contact information for Reed Learning PLC

Reed Learning PLC

9 Kingsway
WC2B 6XF London

Phone no: 020 7520 5100
www.reedlearning.co.uk

More Information
Request Information
To request information from Intermediate Microsoft Excel 2007™, please fill out the following details:

What happens now?
Be Inspired - watch the training videos
   
Write a course review
Have you studied » Intermediate Microsoft Excel 2007™ at » Reed Learning PLC? Share your experience & help others to pick the right course. Set grades (1-5) where 1= very poor & 5 = excellent.
V. Poor | Poor | OK | Good | Excellent
Trainer / Provider
Venue / Facilities
Course Materials
Networking with other delegates

Do you recommend the provider:


Need help finding the right course?

  
By submitting your e-mail, you become a member of Trainingforit.co.uk