Loading Events

Advanced Excel Training (5 X 1.5 hour workshops)

Back to Training
  • Date: 20 May 2021
  • Time: 11:30 am to 1:00 pm
  • Location: Online
  • Cost: €65 – €95

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Member Advanced Excel
65.00
10 available
NonMember AdvancedExcel
95.00
10 available

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