top of page

ChemEnggLife Webinar

Workshop on excel functions for extracting key points from a dataset

Humzaa Imtiaz Ullah

Guest Speaker

05-FEB-2023 | 13:00 (GMT+1)


If you are working with huge datasets, it can be quite time consuming, if you have filter and find important key points every time. But luckily, there are inbuilt functions within Excel f.e. VLOOKUP(), HLOOKUP(), COUNTIF() and INDEX(MATCH()), which can allow you to extract key points using given variables from a bigger data set. These can make your life easier and can automate processes which might take you long time to do. In this webinar, we will look at these functions and to see how they can be applied and in what situations are they most useful!  


You'll learn:

  • How to set up the excel workbook to allow the dashboard to use pivot table to extract key information.

  • How to VLOOKUP() and HLOOKUP() to extract information across columns and rows

  • How to use COUNTIF() to determine the sum of variables

  • How to make use of INDEX() and MATCH() to find the matching value for a variable in a dataset.


Humzaa Imtiaz Ullah

QMS Engineer

Humzaa Imtiaz Ullah is a Chemical Engineer, with an MS from the Technical University of Denmark. He has been working within the Pharmaceutical Industry, starting as a Supplier Quality Engineer and then taking on the role of QMS Engineer and also working as a Project Manager within Quality. Previously, he has worked as a Procurement Analyst in Cement Industry. He has strong experience in Excel Solutions for KPI Monitoring and creating interactive dashboards.

bottom of page