Microsoft Excel Intermediate
£99.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
Scenarios
Pivot Tables & Pivot Charts