Microsoft Excel Data Analysis Using Functions Training in Ireland

  • Delivery Method: Online Instructor-Led / Classroom Based / Onsite
  • Participation Model: Public Training / Private / In-House Training
  • Duration: 2 Days
  • Level: Expert
  • Price: From €1,100 +TAX
  • Upcoming Date:
  • UK & Ireland Based Global Training Provider

In previous Excel courses, you would have learnt to write formulas and functions to perform calculations using a variety of techniques. This course takes your use of functions to the next level and teaches you many more functions within Microsoft Excel.

The course examines the use of functions with real-world scenarios.



Prerequisites

This course is aimed at existing Excel users who need to further their knowledge. Delegates are assumed to have experience of the following:

  • Create, edit, and format spreadsheets
  • Navigate within worksheets and books
  • Use Insert Function to create functions
  • Work with absolute references (e.g. $A$1)
  • Create formulas using functions such as IF or VLOOKUP
  • Create named ranges
  • Create Tables within Excel
  • Sort and filter data

What You Will Learn

At the end of this course, you’ll be able to:

  • Use fundamental Excel functions in advanced situations
  • Combine and nest Excel functions
  • Understand a wide variety of Excel functions and their use
  • Understand Dynamic Array functions and the benefits of their use

Training Outline

Module 1: Function Writing Review

  • What is a function?
  • Reading function syntax
  • Using range names
  • Using tables
  • Recap of common functions
    • SUM
    • AVERAGE
    • AVERAGEA
    • MEDIAN
    • MODE.SNGL and MODE
    • MIN and MAX
    • COUNT, COUNTA and COUNTBLANK

Module 2: Ranking and aggregate functions

  • Functions for ranking data
    • SMALL and LARGE
    • MINA and MAXA
    • RANK, RANK.AVG and RANK.EQ
  • Calculating quartiles and percentiles
    • QUARTILE, QUARTILE.INC and QUARTILE.EXC
    • PERCENTILE, PERCENTILE.INC and PERCENTILE.EXC
  • Aggregating data
    • SUBTOTAL and AGGREGATE

Module 3: Rounding numbers

  • Common rounding functions
    • ROUND, ROUNDUP and ROUNDDOWN
  • Rounding to multiples
    • MROUND
    • CEILING.MATH and FLOOR.MATH
  • Eliminating decimal places
    • INT and TRUNC

Module 4: Nesting functions

  • Introducing nesting
  • Nesting examples

Module 5: Calculate using selective data

  • Criteria-based functions
    • COUNTIFS
    • SUMIFS, AVERAGEIFS, MINIFS and MAXIFS

Module 6: IF and related functions

  • The IF functions
    • IF
    • IFS
    • IFERROR and IFNA
    • AND, OR and XOR
    • Popular related functions: CHOOSE and SWITCH

Module 7: Array functions

  • Introducing arrays
  • Legacy array formulas and functions
  • Dynamic array formulas and functions
    • UNIQUE
    • SORT
    • SORTBY
    • FILTER
    • SEQUENCE
    • TRANSPOSE
    • MODE.MULT

Module 8: Lookup and reference functions

  • Lookup functions
    • VLOOKUP, HLOOKUP and XLOOKUP
    • INDEX, MATCH and XMATCH
  • Other lookup functions
    • GETPIVOTDATA
    • OFFSET
    • INDIRECT
    • FORMULATEXT

Module 9: Date and Time functions

  • Excel and date and time data
  • Date and time essentials
    • TODAY and NOW
    • DAY, MONTH and YEAR
    • HOUR, MINUTE and SECOND
    • DATE and TIME
    • WEEKDAY
  • Calculating from a date
    • EDATE
    • WORKDAY and WORKDAY.INTL
    • DATEDIF
    • YEARFRAC
  • Calculating differences between dates

Module 10: Text functions

  • Introducing text functions
  • Combining text strings
    • CONCAT and CONCATENATE
    • TEXTJOIN
  • Extracting from within a text string
    • LEFT and RIGHT
    • MID
    • LEN
  • Finding and replacing with functions
    • FIND and SEARCH
    • REPLACE and SUBSTITUTE
    • TRIM and CLEAN
  • Changing case
    • UPPER, LOWER and PROPER
  • Converting data types
    • VALUE
    • TEXT

Module 11: Custom functions

  • Introducing LET and LAMBDA

Why Choose Us

Experience Microsoft Excel Data Analysis Using Functions in Ireland through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

  • Delivery Method: Online Instructor-Led
  • Participation Model: Public / Private (In-house)
  • Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
  • Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
  • Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
  • Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's professional training experience since 1995.
  • Worldwide Access: Join our live virtual classrooms from Ireland or anywhere else in the world, or arrange a dedicated online training program for your organization.

Experience Microsoft Excel Data Analysis Using Functions through face-to-face Classroom Based training in Ireland. Training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class for your organization.

  • Delivery Method: Classroom Based
  • Participation Model: Public / Private (In-house)
  • Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
  • Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
  • Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
  • Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Microsoft Excel Data Analysis Using Functions in Ireland as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

  • Delivery Method: Onsite
  • Participation Model: Private (In-house)
  • Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
  • Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
  • Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
  • Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
  • Worldwide Onsite Delivery: Arrange the training in Ireland or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.


Contact us for more detail about our trainings and for all other enquiries!

Microsoft Excel Data Analysis Using Functions Training Course in Ireland Schedule

Join our public courses in our Ireland facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.
13 October 2026 (2 Days)
Dublin, Cork, Limerick
€1,100 +TAX
14 October 2026 (2 Days)
Dublin, Cork, Limerick
€1,100 +TAX
23 October 2026 (2 Days)
Dublin, Cork, Limerick
€1,100 +TAX
25 October 2026 (2 Days)
Dublin, Cork, Limerick
€1,100 +TAX
05 November 2026 (2 Days)
Dublin, Cork, Limerick
€1,100 +TAX
08 November 2026 (2 Days)
Dublin, Cork, Limerick
€1,100 +TAX
09 November 2026 (2 Days)
Dublin, Cork, Limerick
€1,100 +TAX
10 November 2026 (2 Days)
Dublin, Cork, Limerick
€1,100 +TAX

Other trainings and courses related to the Microsoft Excel Data Analysis Using Functions

Ireland has firmly established itself as the premier digital gateway to Europe, with Dublin and Cork serving as the regional headquarters for the world's most influential technology giants. Known as the 'Silicon Docks,' the Irish tech ecosystem thrives on a unique blend of high-level academic research and a pro-business environment, supported by institutions like Trinity College Dublin and University College Cork. The country is a global leader in software localization, pharmaceutical tech, and cloud-based enterprise solutions, attracting top-tier talent from across the globe. Our IT training programs in Ireland are designed to meet the rigorous demands of these multinational corporations, focusing on advanced certifications in Data Analytics, Cybersecurity, and Cloud Architecture. We empower professionals to excel in a high-growth environment that remains at the absolute center of the global digital economy and innovation.

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.