Excel

Microsoft Excel – Foundation 

Excel for the Real World:  Gain the Foundation Skills of Microsoft Excel 

This course introduces you to the power of Microsoft Excel starting from the beginning. You’ll learn how to open, close and save files, how to enter formulae into a cell, build basic charts and format a spreadsheet. You’ll learn how to use the most important features of Excel. 

Choice of Flexible Delivery Options: 

1 Day of Training 

2 Mornings  /  2 Afternoons  /   2 Evenings 

Programme Benefits 

If you’re new to Excel or are going to be using Excel in the future, you’ll need to understand the fundamentals. In this beginner-level course, our Instructor will introduce new users or anyone who has not used the produce for a period of time to the fundamentals of Excel. 

Who should Attend?

This course is intended for those who wish to gain a foundation and understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data. 

Learning Objectives 

Upon successful completion of this course, you will be able to create and develop Excel 2016 worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. 

Prerequisites 

• No prior knowledge is needed 

• Software is provided in the Classroom and Live Virtual options 

Course Outline 

• Getting Started with Excel 

• Performing Calculations 

• Modifying a Worksheet 

• Formatting a Worksheet 

• Printing a Worksheet 

• Managing Workbooks 

Microsoft Excel – Intermediate 

Excel for the Real World:  Bring your Excel skills to a New Level 

Our intermediate course is designed to introduce new features of Excel that will enable users to be understand more of Excel ‘s features. 

Choice of Flexible Delivery Options: 

1 Day of Training 

2 Mornings  /  2 Afternoons  /   2 Evenings 

Programme Benefits 

The objective of our Microsoft Excel Intermediate training course is to develop a good working knowledge of Excel to include features such as functions and formulae, sorting and filtering data, working with charts and pivot tables. 

Who should Attend 

The Microsoft Excel Intermediate course is aimed at users who have basic experience with Excel and want to build on their current knowledge to set up their own spreadsheets and manipulate existing ones. 

Learning Objectives 

Upon successful completion of this course, you will deepen your understanding of Excel and be ready to custom formulas, apply built-in Excel functions and manipulate data to extract the insights you need. 

Prerequisites 

• Participants should be existing users of Microsoft Excel who can create, edit, format and print a spreadsheet. 

• If you have attended or understand the concepts covered at the foundation level, this course may be your next step. 

Course Outline 

• Create complex formulae incorporating relative and absolute cell addressing 

• Use a wide range of Excel functions such as Sumif, Countif, IF, Or, And, Lookups, ISError and many more 

• Build and apply Conditional Formatting 

• Link Sheets and Files 

• Manipulate Data – Sorting, Filtering, Validation 

• Create Pivot Tables 

• Create a wide range of Charts 

Microsoft Excel – Advanced 

Excel for the Real World:  Supercharge your Microsoft Excel Skills to the next level 

Structuring the organisation of information in a workbook is crucial to developing powerful models.  Our Advanced course is designed to help attendees work with larger spreadsheet models.  This course will explore how existing data can be mined using different analysis techniques. The course will examine several real world problems and discuss how these can be tackled using techniques available in Excel. 

Choice of Flexible Delivery Options: 

1 Day of Training 

2 Mornings  /  2 Afternoons  /   2 Evenings 

Programme Benefits 

There is a huge amount to gain by being confident at this level. There are many features to learn and this course will save you hours and hours of work as you start to make the most of Excel and what it has to offer. 

Who should Attend 

This class is for users familiar with primary Excel features but who need more powerful features like lookups, error-handling, macros and scenario analysis. 

Learning Objectives 

This course provides you with solid knowledge in the most important tools in Excel. Once you have finished the course you will know more than most people who are using Excel each day. You’ll have a powerful skill-set that you can use in building spreadsheets that make you even more efficient in your role. 

Prerequisites 

• Participants should be existing users of Microsoft Excel. 

• If you have attended or understand the concepts covered at the intermediate level, this course may be your next step. 

Course Outline 

• Create multi-sheet spreadsheet models 

• Protect workbooks and worksheets 

• Use the tracking tool to debug spreadsheets 

• Creating Sparklines and Mapping Data 

• Learn lookup and conditional formulae 

• Customise graphs 

• Forecasting Data