“Lean Sustainability - Lean and Green Practices : Creating Sustainable Value"
2025-03-11 15:00 - 16:00 (Europe/Dublin) | Online session
We are delighted to offer a 5 X 1.5-hour series of webinars/workshops for Advanced Excel with eBridge
Session 1 - Thursday, May 20th - 11:30am - 1pm
Session 2 - Thursday, May 27th - 11:30am - 1pm
Session 3- Thursday, June 3rd - 11:30am - 1pm
Session 4 - Thursday, June 10th - 11:30am - 1pm
Session 5 - Thursday, June 17th - 11:30am - 1pm
Cost: €65 Member; €95 Non Member
Book above or contact alison@icbe.ie to book your place
These online webinars have been designed to replace classroom-based training whilst people are required to work from home. Participants have the option of either attending the live webinars at the scheduled date and time or alternatively can view a recording of the webinar at a time that suits them. Recordings will be available for 6 months after completion and a link to the recording will be sent to all participants following the live webinar along with all relevant course files – exercises, user reference guides etc. A trainer will be on hand via email to answer any queries or questions that might arise following the training.
SESSION 1: DATES / PROTECTING CONTENT / DATA VALIDATION
→ Working with Dates
 Understanding how Excel sees dates
 Calculating difference between 2 dates
 The TODAY Function
 Calculating Age
 EOMONTH / ISONUMBER
 Using the Text Function with dates
 Text to Columns to convert date format
→ Protecting worksheets, workbooks & restricting input.
 Data Validation - Text, Numbers, Drop-Down List.
 Locking cells and enforcing protection
 Password protecting workbooks
SESSION 2: MORE ON FUNCTIONS (PART ONE)
→ Grouping and Outlines
→ Working with the Subtotals
→ SUMIFS / MINIFS / MAXIFS / AVERAGEIFS / COUNTIFS
→ Writing and Understanding the IF Function
 Writing a basic IF Statement
 Using IF with AND / OR / IS Functions
 Created Nested IF Functions.
→ Using the IFS Function
SESSION 3: MORE ON FUNCTIONS (PART TWO)
→ Creating and working with named ranges.
→ VLOOKUP Function
→ IF Error function revisited
→ Index and Match
→ XLOOKUP – Excel 2019 / 365 only
 Basic XLOOKUP
 XLOOKUP – argument
 Search Mode argument
SESSION 4: PIVOT TABLES & PIVOT CHARTS
→ Creating and understanding a basic Pivot Table
→ Filtering Data
→ Refreshing a Pivot Table / Refresh automatically on opening
→ Using the Pivot Table Design Ribbon
→ Resizing columns and preserving column widths
→ Grouping Dates / Grouping Fields
→ Using Slicers with Pivot Tables
→ Creating / Modifying Calculated Fields
→ Creating and Modifying Pivot Charts
SESSION 5: MACROS
→ Recording simple macros
→ The VB Editor
→ A brief explanation of VBA code
→ Assigning macros to buttons
→ Building a macro to open a file and copy data
→ Using variables
→ Assigning macros to the Ribbon

ICBE Benchmarking Visit to Regeneron
2025-03-12 09:00 - 13:00

Resilient Minds @ Work | Bite-sized 2 hour session | Thursday March 20th
2025-03-20 10:00 - 12:00

Aviation Update Webinar with John McMahon & Brian Hayden 2025 | FREE EVENT
2025-03-24 13:00 - 14:00

ICBE Conference 2025 - Navigating Transformation
2025-03-27 | Lyrath Estate Hotel, Kilkenny, Paulstown Road, Lyrath, Kilkenny,, Kilkenny, R95 F685, Ireland

ICBE Advanced Productivity Webinar - Sustainability Leadership
2025-04-02 11:00 - 12:30 | Online session

Certificate in Part 21 Design Technician Level 7, 10 ECTS
2025-04-03 18:00 - 2025-06-26 21:00

Leadership Coaching Programme (F2F with Gerry Ryan & Kieran Murphy)
2025-04-08 09:00 - 2025-04-10 16:00 | Clayton Hotel Galway, Monivea Rd, Ballybrit, Galway, H91 D526, Ireland

BioMarin Benchmarking Visit
2025-04-09 09:00 - 13:00

AI for Everyone: Exploring Co-Pilot across Office 365 | Free Webinar
2025-04-16 12:30 - 13:00

Navigating the Funding Landscape: 1 hour webinar with IMR
2025-04-17 14:00 - 15:00 | Webinar, Webinar

Presenting Made Brilliant | The Lir National Academy of Dramatic Art
2025-05-01 09:00 - 17:00

ICBE Senior Leaders/Managers Generative AI Workshop
2025-05-08 09:30 - 11:00 | Online session

Making Facts & Figures Fascinating 1-hour Masterclass: ICBE Members only
2025-05-08 14:00 - 15:00 | online

Wisdom In Action - A Cross Campus Venture into Leadership (Director Level and above)
2025-10-08 - 2025-10-10 | Kemmy Business School UL, Kemmy Business School, University of Limerick, Limerick

1-hour Knowledge Session: PowerPoint Productivity Tips NEW DATE
2025-05-20 10:30 - 11:30 | Webinar, Webinar

AI – Efficiency Tool of the Future?
2025-05-20 14:30 - 18:00 | University of Limerick Campus. International Business Centre 2 Building, Castletroy, Limerick

Lean Business Ireland Annual Enterprise Excellence Conference 2025
2025-05-21 08:30 - 16:00

ICBE Benchmarking visit | Ipsen Dublin, Shingo Prize Recipient 2024
2025-05-21 09:00 - 13:00 | Ipsen Manufacturing Ireland Ltd, Blanchardstown Industrial Park, Snughborough Road Blanchardstown, Dublin

MS Visio online training: Create Visually Appealing & Informative Diagrams with Minimal Effort
2025-05-22 11:30 - 13:00 | online

Unlock Lean Success: Lean Engagement/Lean Leadership Masterclass
2025-05-28 09:00 - 16:00

The 3 Pillars Leaders can Leverage to Prevent & Reduce Burnout / ICBE Member-Only Event in Dublin
2025-05-29 09:45 - 12:30

Data Analytics for Business Support Functions - Start Your Journey (Virtual Classroom)
2025-06-02 11:00 - 12:00 | online

Benchmarking Visit - Johnson & Johnson Innovative Medicine
2025-06-09 09:30 - 13:30

Power Up, Scale and Deliver: HR Process Excellence for Greater Efficiency at UCD
2025-06-10 10:30 - 15:10 | UCD Michael Smurfit Graduate Business School (Lecture Theatre 1), Carysfort Avenue, Blackrock, Dublin, A94 XF34, Ireland

Presenting Made Brilliant | The Lir National Academy of Dramatic Art | June 11th
2025-06-11 09:00 - 17:00

ICBE Knowledge Session: Handling Conflict and Giving Constructive Feedback that Lands Well
2025-06-11 10:30 - 11:00 | online

Financial Wellbeing | Empowering Employees for Life and Performance | Free Webinar
2025-06-12 12:00 - 12:30

From Good to Great: Enhancing Data Visualisation in PowerPoint
2025-06-18 10:00 - 12:30 | online

Leading In Times of Disruption – A new ICBE Senior Leadership Programme with Ade McCormack
2025-07-11 12:39
