Tel: 0844 844 2428

21biz.co.uk Complete Microsoft Excel - Scheduled 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: 2 days.

Location: 21st Century New Media (Production Offices), Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire WD6 1JG. [MAP]

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.

Why Take This Course? The 2 day Complete Microsoft Excel training course will show you how to make the most of your time with Excel with helpful tips & tricks, best practices and expert advice. This course is designed for everyone who wishes to learn Microsoft Excel of any experience and covers the essential aspects of the software and covers more of the less common elements.

About the Tutor: With nearly 2 decades of experience performing IT training Lesley Keddy is a first choice tutor, particularly when you need to learn MS Office thoroughly and promptly. Starting her career with AES/XIOS Systems before training at Uxbridge Technical College for her City & Guilds Further Education Certificate, Lesley set up shop as a freelance trainer and swiftly gained recognition. Now armed with 18 years experience, knowledge and insight of the applications she teaches through her own company Abacus Computer Training, Lesley is hired regularly by major blue-chips to perform seminars and training; clients such as BP, Nestle, Royal Bank of Scotland, Barclays, Michael Shanly Construction, and Ammariti Puris Lintas to name but a few, have all relied on Lesley to bring staff quickly up to a professional standard using Office applications. Lesley has been invited back on several occasions to speak and teach at her former college and is sought after by all of the leading Microsoft training companies in the UK - including 21st Century New Media thanks to her impeccable reputation and testimonys!

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.

Microsoft Excel 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 *