Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. If utilised correctly, the benefits of Microsoft Excel cannot be overstated. Due to the program’s capability of formatting data, performing calculations, analyzing data and integrating information, a working knowledge of Excel is vital for most office-based professionals today.
This CPD certified MasterClass guides participants through Excel’s Database features. Participants learn how to use many different types of functions including financial, logical and look-up functions. Participants will learn how to sort, filter and subtotal information and also to work across multiple workbooks and worksheets.
All attendees will receive a highly useful course pack to refer back to at any time, gain valuable CPD points, and have a chance to engage in an informative Q & A on the day.
It is ESSENTIAL to bring along your own laptop with the required software installed (Microsoft Excel 2013).
Overview of Common Features
Using SUM, AVERAGE, MAX, MIN, COUNT
Functions versus Formulas
Convert Numbers to Text Data Types
Calculate data across Worksheets
Using Logical Functions
Understanding the IF Function
Understand the AND Function
Nest IF, AND, and OR into IF
Work with SUMIF, AVERAGEIF, COUNTIF
Work with SUMIFs, AVERAGEIFs, COUNTIFs
Working with Multiple Worksheets and Workbooks
Work across Worksheets and Workbooks
Work with multiple sheet Formulas
Link information between Workbooks
Using Protection Features
Protect Workbook Access and Contents
Presenting Data Using Charts
Create a Column Chart
Create a Pie Chart
Create a Line Chart
Modify a Chart
Format a Chart
Working with Data in Lists
Understand Data Lists
Create a basic Sort
Create a multi-sort
Create a custom Sort
Create a basic Filter
Create a multi-filter
Create and understand Subtotals
Create and understand Outlines
Use the Consolidation Feature
Working with Styles and Formats
Work with Styles
Create Custom Number Formats
Ideally delegates should have completed the ‘Excel Introduction – Level 1’ course or be comfortable in applying the features and functions associated with the Level 1 course content.
Who Should Attend?
This course would be ideal for those who have a basic grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use Excel at a more advanced level.
On completion you will receive your CMG MasterClass Certificate as well as your CPD Certificate containing 5 Structured CPD Hours. Please note certificates are issued only at the close of the training course to participants who complete the full five hours.
This course costs €395 (Early-bird) normal rate is €495. Includes course documentation and light refreshments. While the course fee does not include lunch, we do provide freshly made sandwiches, coffee and a range of teas and fresh juice for those who require a light lunch. Alternatively you can avail of the local food stores and coffee shops opposite the training centre for hot food or alternative lunch options.