About Microsoft Excel Intermediate • Level 2
Introduction to this Excel course
Our Microsoft Excel level 2 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.
Is this course for you?
This course is suitable for you 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.
A typical Excel course
This is a typical Excel course at our training centre at Whiteley in the Solent Business Park. In this case there are eight delegates from local companies attending a scheduled intermediate level course. Its a very relaxed atmosphere with every opportunity to learn new skills and efficient techniques.
Join this scheduled course at our training centre in Whiteley, near Fareham, Portsmouth and Southampton.
Or, consider onsite training using our computers at no extra cost. £100/delegate or £650 for up to eight delegates on the same course. Minimum charge: £400 plus vat.
- Lunch and refreshments – Lunch at Caffe Dallucci (Whiteley only)
- Training manual
- Post course training downloads
- Certificate on completion
- Post course support relating to course content
More discounted courses
Link to Office 365 Microsoft Excel Download
Follow this link to Microsoft to read the capabilities of Excel 2016. You can also buy it or try it for free.
Aim & Objectives
On completion of this course the aim is for you to gain 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:
- Use Conditional Formatting and Range Names to improve your performance
- Interrogate, Manipulate and Report against business data using (Sort, Filter, Subtotal, Pivot Table)
- Interrogate tables of data using various IF statements (IF, IF(OR), IF(AND), SUMIFS etc.
- Link key business data using VLOOKUP statements
- Create and Edit Templates to speed up routine tasks
- Create and Edit a range of effective business charts including Sparklines and Forecast sheets
- Use a range of shortcuts to improve speed and efficiency
Conditional formatting (Use visual tools to understand data)
Format Painter rules – Quick Formatting – Clear Formatting – Formatting techniques in Business
Range names (Simplify formulas and navigation)
Syntax rules for names – Using Formula AutoComplete – Types of Names – Scope of a Name – Getting the best out of Names
Data lists (Interrogate, manipulate and report data)
Single Column Sort – Freeze Panes – Split Box control – Multi-Column Sort – Simple and complex Filters – Subtotals Techniques – Pivot Table Reports
IF functions (Question data)
Common mistakes when creating formulas – Validate simple formulas – Create simple and complex IF statements – Nested IF Functions – IF with AND/OR
VLOOKUP functions (Link data)
Function in detail – Function options – How to use in Business
Using templates (Improve your efficiency)
Create simple Templates – Convert an existing workbook to a Template – Chart Templates – Template options
Professional business charts (Create visual reports)
Selection techniques – Data structures – Best Practice
Shortcuts (Time savers)
Use a range of shortcuts and time saving techniques