Attention: You are using an outdated browser, device or you do not have the latest version of JavaScript downloaded and so this website may not work as expected. Please download the latest software or switch device to avoid further issues.

News > Past Events > Masterclass: Advanced Data Analysis in Excel

Masterclass: Advanced Data Analysis in Excel

Many people across all sectors of industry rely heavily on Excel to help provide key insights from their data, using tools such as pivot tables and Vlookups on a day to day basis.

This webinar provided an overview of the key features in Excel which help work with and analyse data on a more advanced level.

Topics covered:

Function Writing: an overview of some of the most powerful functions (old and new) – with a particular focus on Lookup & Reference Functions and Text Functions

Format as Table: learn about its key benefits and the important role it plays when working with datasets and pivot tables

Advanced Filter: Use Criteria and Extract ranges to pull out the data you need

Quick overview of What-If  Analysis & Data Analysis Tools

Shortcuts, Tips & Tricks to help use Excel more efficiently

Similar stories

Most read

Have your say

 
image

Contact Us:

Analytics Institute Limited
38/39 Fitzwilliam Square
Dublin 2
D02 RV08
Ireland

+353 87 1446017
info@analyticsinstitute.org


Follow us:

image

About Us:

About the Institute

Registration Number: 479298
VAT Number: IE9739127A
Managing Director: Lorcan Malone

Our Privacy Policy
Terms & Conditions

image
image

Resources:

Downloads
Our Podcast

Jobs

© Analytics Institute 2022 All Rights Reserved

This website is powered by
ToucanTech