Microsoft Excel Intermediate

What topics are covered by the course?

•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

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.

What will I be able to do on completion?

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

How will I be assessed?

Not applicable

This course is suitable for you if you require to have data appear on the worksheet according to certain conditions, e.g. Display the word Chase in a cell if an invoice is older than 60 days old. If you require 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.
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.

Guide Price: £199 Exc VAT

Delivery: Classroom
Category: Intermediate Microsoft Excel »
Duration: 1 Day

Search for intermediate microsoft excel courses in