Loading Events

Advanced Excel Training (5 X 1.5 hour workshops)

Back to Training
  • This event has passed.
  • Date: 20 May 2021
  • Time: 11:30 am to 1:00 pm
  • Location: online
  • Cost: €65 – €95

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 – [if_not_found] 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

Login