Excel Intermediate Level 2 course

During this course, you will be manipulating data from external sources, including the use of Power Query. You’ll also create a pivot table built on more than one set of data. A large number of useful built-in functions will be explained together with; text concatenation, advanced database capabilities, grouping and outline modes. We’ll also take a detailed look at Data Validation and working with formulae in conditional formatting.

• Tips & Tricks & Shortcuts
• Introduction to Power Query
• Autofill – Custom Lists
• Flash Fill, Text Functions & Concatenation
• Importing into Excel
• Group Mode – Manual & Automatic
• Data Tables – 1 and 2 Way
• Consolidation
• Automatic Outline & Working with Visible Cells Only
• Automatic Subtotals
• Range Names & Custom Formats
• Date Functions: YEAR, DATE, DATEVALUE
• Logical IFS with AND/ORS
• Other Built-In Functions including; SUMIFS, COUNTIFS, VLOOKUP, XLOOKUP, SUBTOTAL, CHOOSE, SUMPRODUCT, MATCH, INDEX, AGGREGATE, INDIRECT, ROW, COLUMN

Use of:

• Conditional Formatting using Formulae
• Scenario Manager
• Cell Protection
• Data Validation
• Drop Lists
• Goal Seek
• Relational Data Model & Pivot Tables
• Macros – Record Only

N.B. VBA is not covered on this course

Why upskill in Microsoft Excel?

Microsoft Excel, the spreadsheet programme included in the Microsoft Office suite of applications, is commonly used for analysing, sorting, reporting and storing data. Many organisations choose to use Excel because its spreadsheets are simple to use and highly visual.

Upskilling your team with Excel training will provide them with the ability to organise and manage data more efficiently, saving precious time which can be devoted to other projects. Our Excel training courses provide effective tips, techniques and formulas that will help individuals make the best use of Excel in your organisation.

Acquiring in-depth knowledge of working with Microsoft Excel functions and formulas will enable delegates to use Excel efficiently in their daily work life.

We offer Excel training at three levels:

• Excel for Beginners
• Excel Intermediate Level 1
• Excel Intermediate Level 2

A knowledge of subjects covered on our Excel Intermediate course is ideally required for this programme. The course is designed for those who want to build on their existing Excel skills and learn additional tasks including both formulaic and commands.

Anyone who has successfully completed our Excel Intermediate course who wishes to learn additional capabilities of this powerful application.