PrintDURATION: 1 day
|TIME: 09:00 to 16:00 GMT|
Virtual Classroom Training option: This course is delivered online with an expert trainer in a virtual environment. Its very easy to set up your home or work computer ready for training via a simple link we'll send you. This popular MS Excel course includes the latest 2016 features designed to improve your performance when working with data.
Our Microsoft Excel frequent user course has a focus on managing, manipulating and analysing data using a range of simple and complex techniques. It also explores the use of more complex formulas in a business environment and includes techniques to simplify what could be complicated. We also investigate visual techniques that can be used to monitor information by users and managers. The course builds on shortcuts and techniques learnt during our Level 1 course. The course is structured but informal, and you will be encouraged to ask and answer questions throughout. At the end of the course you’ll be sent useful Excel downloads to support your learning and develop new skills. We currently use Microsoft Excel 2016 for this course linked to Office 365, SharePoint and OneDrive.
This course is suitable if you have had formal Excel training at level 1 or you are confident with the content covered in level 1. It is suitable for Office Staff, Finance teams, Managers, Project Managers, Supervisors, Business owners and Executives.
We’ll get back to you on completion: click here
Virtual classroom: £750+VAT for up to 8 delegates
On-site: £795+VAT for up to 8 delegates on the course
On-site: £645+VAT for up to 4 delegates on the course
Session 1: 09:00 to 10:00 [break 10:00 to 10:15]
Session 2: 10:15 to 11:15 [break 11:15 to 11:30]
Session 3: 11:30 to 12:30 [lunch 12:30 to 13:30]
Session 4: 13:30 to 14:30 [break 14:30 to 14:45]
Session 5: 14:45 to 15:45 [summarise and close 15:45 to 16:00]
The files below will be used during training to help improve your performance.
On completion of this course you will have gained improved confidence when tasked to manage, manipulate and analyse business data; create a range of complex business formulas and provide solutions to resolve day to day problems.
By the end of this course you will be able to:
Format Painter rules – Quick Formatting – Clear Formatting – Formatting techniques in Business
Syntax rules for names – Using Formula AutoComplete – Types of Names – Scope of a Name – Getting the best out of Names
Single Column Sort – Freeze Panes – Split Box control – Multi-Column Sort – Simple and complex Filters – Subtotals Techniques – Pivot Table Reports
Common mistakes when creating formulas – Validate simple formulas – Create simple and complex IF statements – Nested IF Functions – IF with AND/OR
Function in detail – Function options – How to use in Business
Create simple Templates – Convert an existing workbook to a Template – Chart Templates – Template options
Selection techniques – Data structures – Best Practice
Use a range of shortcuts and time saving techniques