Tel: 0844 844 2428

Elstree Film Studios - Training Courses - Microsoft Excel Training Course

Microsoft Excel is a mathematical genius so you don't have to be! Very often, users new to the software are nervous about the mathematical implications of using Excel; this course will relieve and dispel your concerns by showing you the most commonly used formulae, equations, practices and tips and tricks that will have you tallying the most complex of profit and loss sheets in no time.

As well as providing workflow, timesheets, profit and loss, etc. for millions of offices worldwide, there is much more to Excel and most users will barely scratch the surface. Much more than simply spreadsheets, Excel provides database functions used to import and export large volumes of information, ported between software applications, complex relational understandings enabling accurate sorting and distribution of data, and a graphical interface which is able to produce the most detailed charts and reports.

Most training available for Microsoft Excel is, at best, basic. We, on the other hand, know that to truly master the software and create meaningful spreadsheets, databases and charts requires a much more detailed understanding of all that Excel has to offer, which is why the Complete Microsoft Excel 2 day course is ideal for everybody interested in and required to use the software regularly.

The 2 day course will introduce you to all of the features of MS Excel with practical hands-on exercises to take you through each scenario you will face while working with formulas, charts and databases. You will be tutored in a small group with time for tailored advice ensuring that you to gain the most from the expertise on offer, with options to focus on aspects of the software relating specifically to your needs.

Duration: 1 day.

Prerequisites: To gain the most from this class, it is essential that you are familiar with Windows, including creating, deleting and moving files and folders. You must be comfortable using a keyboard and mouse.

Location: 21st Century New Media Ltd (Production Offices), Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire, WD6 1JG. [Click here for a map]

Times: 10.00am to 4.30pm. For security reasons, further details are only provided upon booking.

Courseware: The book which accompanies this course is posted to you upon payment confirmation.

Accommodation & Transport: Details of local accomodation and transport can be found here.

Further assistance: Our FAQ help page contains the answers to many popular questions. Alternatively please call 0844 844 2428 to arrange to speak to our training manager.

COURSE CONTENT

Basics

  • What is a Spreadsheet?
  • Terminology
  • The Excel Window
  • Opening and navigating a Workbook

Working with Data

  • Creating a new Workbook
  • Entering and editing data
  • Entering & editing formulas
  • Saving a workbook

Making changes

  • Cutting, Pasting & Moving
  • How to apply special formats (i.e. date format)
  • Creating and editing formulas
  • Saving a workbook

Formulas

  • What is a Formula?
  • The difference between relative & absolute
  • Using SUM, MAX, MIN, AVERAGE & COUNT

Charts

  • Chart types
  • Creating charts
  • Editing charts
  • Copying charts into another program
  • Making adjustments

Working with Lists

  • Creating a list in Excel
  • Sorting Alphabetically & Numerically
  • Filtering a List
  • Creating Subtotals

Working with Multiple Workbooks

  • Creating formulas that reference more than one workbook
  • Working simultaneously on multiple workbooks
  • Consolidating Data

Customising Excel

  • Using Tools Options
  • Working with Toolbars
  • Changing the default settings

Advanced Formatting

  • Borders and Shading
  • Using different number formats
  • Working with Date & Time
  • Using Excel's Templates
  • Headers & Footers


5-20% discount if you book for more than one delegate!
Further discounts are available when booking multiple courses,
Please call our training secretary on 0844 844 2428.

Excel 2007 Training Courses
We are currently scheduling dates for this course. If you would like to be notified when this course is next due to be run, please enter your details below. All of our courses cost £250 + VAT per day which includes lunch, coffee/tea and training materials.

Your First Name *
Your Last Name *
Your Email Address *