Advanced MS Excel

Price
295 per participant
Earn 6 CPD points for this course.
Book Now

€295for members

€395for non-members

9:30am-4:00pm

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

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.

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

On Completion of the course candidates will receive:

  • CIF MS Excel Advanced CPD Certificate of Attendance
  • 6 CPD Points
  • Member Rate: €295.00
  • Non-member Rate: €395.00

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.

Clear
Number of Participants:

Participant 1

This field can't be Empty
This field can't be Empty
Email field can't be Empty