Microsoft Excel Intermediate
£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.