Microsoft Excel Intermediate

Course Duration is 1 Day

£215.00 Plus VAT

Business Benefit

Being able to handle large amounts of raw data can be a problem in today’s businesses. The tools and techniques learnt on this course will arm you with the knowledge to be able to make sense of all of your information. This course provides underpinning knowledge towards the Microsoft Office Specialist Qualification.

How to Book

If you are interested in booking this course, then please select an available date and then click book now to complete the booking.

Who Should Attend

This course is suitable for you if you require data to appear on the worksheet according to certain conditions. If you need to visually trace the logical flow of formulae across a Worksheet and/or map circular references. If you need to maintain a single list of up to a few thousand items in rows, e.g. a list of company cars, personnel, or products or invoices.

Learning Outcomes – by the end of this course you will be able to…

Query values with in a spreadsheet
 Analyse data using advanced formulas
 Manage large amounts of data
 Create and manage pivot tables and charts

Course Content

 The IF Function
 Nested IF
 The Lookup Function
 Validating Lookups
 IFs With lookups
 Date Functions
 The Auditing Toolbar
 Checking Errors
 Precedent & Dependent Tracing
 List Management
 Subtotals & Outlines
 Data Statistical Functions
 Goal Seek
 Pivot Tables & Pivot Charts