This date is now SOLD OUT -
CLICK HERE to see the next available date
Microsoft Excel is the most commonly used spreadsheet application, and 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 course will show you how to take your existing knowledge to the next level, to help you fully utilise this highly useful application.
It is ESSENTIAL to bring along your own laptop with the required software installed (Microsoft Excel 2013).
Course Content Includes:
Using Lookup Functions
- Use VLOOKUP
- Use HLOOKUP
- Use PMT
- Use Data Validation
- Use Named Ranges
Working with Advanced Functions
- The SUMPRODUCT function
- Use INDEX and MATCH
- Deal with Errors
Working with Macros
- About Macros
- Recording Macros
- Running Macros
- Editing Macros in the VBE
- Assigning Macros to Buttons
- Find Referenced Cells
- Trace Cells
- Troubleshoot Errors in Formulas
- Troubleshoot Invalid Data and Formulas
- Watch and Evaluate Formulas
- Find Formulas that Refer to a Cell
Working with PivotTables
- Create PivotTables, Editing PivotTables
- Update Information in a PivotTable
- Add Fields to a PivotTable
- Remove Fields from a PivotTable
- Change the Layout of a PivotTable
- Modify PivotTables
- Group PivotTable Data
- Understand Calculated Fields
- Display Page Fields on Separate Sheets
- Create PivotCharts
- Create Slicers
Organizing Worksheet and Table Data
- Create and modify Tables
- Format Tables
- Sort and Filter Table data
- Calculate data in a Table
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 end of the training course to participants who complete the full five hours.
This course costs €375 (early-bird) per person – normal rate €425. and 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.