Microsoft Excel Intermediate

Course Duration is 1 Day

£215.00 Plus VAT

Delivery Method

Face To Face Delivery  Virtual Delivery One To One Coaching Closed Group Course Public Course

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. Can’t see a suitable date contact us on [email protected] and we can discuss specific date requirements.

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

Embedding

These follow up coaching sessions help support your colleagues to embed their learning during their skills transfer period.  Applying new skills and changing behaviour takes effort and practice.  After attending a training course many colleagues will find they need support through this transition.  EQV can provide that support with follow up coaching sessions to help embed the learning.

Embedding coaching sessions can be delivered in 90 minute and half day durations.  The facilitator will work with the group to capture feedback about challenges and how to overcome them ensuring success going forward.

Having a formal embedding coaching session will not only increase the success of the skills transfer period but helps create a platform of motivation, inclusivity and commitment within the group.