Intermediate Excel
…Excel your office workflow

In today’s world; MS Office is central to how the vast majority of office workflow businesses run. For employees and businesses to operate effectively it is important that at the very least they have a grasp of how spreadsheets can be used to the maximum.

Prerequisite

Working knowledge of all topics in “Introduction to Excel – White Belt”

Course Level

Intermediate

Duration

2 Days

Who should attend?

Anyone who is familiar with the basic features of Excel and wishes to expand their knowledge and skills further. This course takes a look at how the program works as well as learning how to perform a range of functions.

Performance Focus

This course is designed for those users who wish to step up their current knowledge of Excel to take advantage of the more complex features. To be able to create, edit and format large or multiple spreadsheets. Participants will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment.

What You Will Learn

• Confidently enter basic formulas and functions
• Use the inbuilt ‘If function’ to resolve ‘either/or’ situations
• Understand and use Excels quick AutoCalculate
• Solve problems that occur when copying formulas
• Use LookUp tables to answer to complex queries
• Design, sort, filter, subtotal and manage long lists of data
• Produce data forms for simple database entry
• Outline worksheets so that they can collapse or expand the list of data they are viewing
• Automatically draw attention to data that meets specific criteria
• Link worksheets and workbooks for greater productivity
• Practice using our hints and tips for fun and efficiency

Content

Basic outline of the course:

▲