Advanced MS Excel

Price
€ 295 per participant

Earn 6 CPD points for this course.

€295for members

€395for non-members

9:30am-4:30pm

Full Day

Online

This course is an introduction to the more advanced features of spreadsheets and their use. By the end of this course, delegates should be comfortable with automating worksheet functionality, as well as using a variety of different analysis tools, data presentation and working effectively with multiple workbooks.

See full course details Ask a question

COURSE OUTLINE

This course is an introduction to the more advanced features of spreadsheets and their use. The course is targeted towards people who have a good knowledge and understanding of MS Excel and who wish to learn some of the more Advanced features.

By the end of this course, delegates should be comfortable with automating worksheet functionality, as well as using a variety of different analysis tools, data presentation and working effectively with multiple workbooks.

The course will also be of great benefit to those who have been using Excel for some time but who feel that they are not making best use of its facilities and will also introduce users to many shortcuts.

Attendees should have an understanding spreadsheet terminology and formulae’s & functions.

The is a 1 Day Programme delivered from 09.30hrs – 16.30hrs.

COURSE CONTENT

Analysing Data: Advanced Formula & Functions

Advanced Formula Design
Use Logical Functions (IF/AND/OR)
Use Nested Functions
Use Lookup Functions (V&HLookup)
Use Date & Time Functions
Text & Statistical Functions

Advanced Presentation & Formatting Techniques

Conditional Format data
Custom Format Dates/Numbers/Text
Organizing worksheet data with tables

Data Management Tools

Add Data Validation Criteria
Advanced Filters
Subtotals (Group & Outlines)
Remove Duplicates
Flash Fill & Text to Columns

Analysing Data with Charts, PivotTables, Slicers and PivotCharts

Visualizing data with charts
Create a PivotTable
Working with Data Fields
Summarizing Data
Filter Data by Using Slicers
Analyse Data with PivotCharts
Create Sparklines

Introduction to Macros

Create and Delete a Macro
Using Customised Macro buttons

Worksheet Protection

Protect Cells from editing
Password Protect workbook

CERTIFICATION & CPD

On Completion of the course candidates will receive:

CIF MS Excel Advanced CPD Certificate of Attendance
6 CPD Points

COURSE FEE

Member Rate: €295.00
Non-member Rate: €395.00

CIF MICROSOFT BUNDLE

Upskill your employees with 4 Microsoft courses and receive a discounted rate. The courses include:

Excel Advanced
Data Visualisation for Excel
MS Project Management
Power BI

FIND OUT MORE

CONTACT INFORMATION

For All Enquiries or Course Bookings Contact:

Conor Greham: 01 4066031 / [email protected]

Robert Butler: 01 4066071 / [email protected]

The CIF can deliver this programme in house and may be tailored to your companies requirements.

In terms of programme delivery, the CIF can facilitate learning by virtual means (online via Zoom), or in classroom format (at your premises), subject to criteria. Please get in touch to discuss your requirements.

Need help or have a question?

Send us a message and we will be back to you as soon as possible.

See full course details

Booking information

Please inform the details for your booking.