Back to All Events

Microsoft Excel – Intermediate Level

  • 5 CPD Hours Apex Building, Blackthorn Road Sandyford Business District Dublin 18 (map)

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 training course 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).

Course Content Includes:

Overview of Common Features 

  • Using SUM, AVERAGE, MAX, MIN, COUNT

  • Functions versus Formulas

  • Relative Calculations

  • Absolute Calculations

  • 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

  • Protect Worksheets

  • Protect Cells

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


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.

Certification

On completion of this one-day training course, you will receive your CMG MasterClass Certificate as well as your CPD Certificate containing 5 Structured CPD Hours. Please note certificates are issued at the close of the training course to participants who complete the full five hours.

Cost

This training course costs €395 EARLY-BIRD (Normal rate €415). The price includes course documentation and training pack, teas and coffee, snacks, biscuits, fruit on arrival. Lunch is a light fare containing freshly cut sandwiches, wraps, a selection of teas and coffee. Alternatively, you can avail of the local food stores and coffee shops within a one-minute radius of the training centre for hot food or alternative lunch options.

Earlier Event: November 6
Leading without Authority