Traincel Logo
Excel - Top... Banner

Excel - Top 10 Functions, Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP, MATCH, INDEX, IFERROR, IF, COUNTIF, SUMIF)

90 Minutes

Recorded Webinar

OVERVIEW

Microsoft Excel contains about 400 built-in worksheet functions. Excel functions can greatly enhance your ability to perform tasks in day-to-day activities and save you a ton of time. While there are hundreds of functions available, there are 10 functions that all Excel users should know, regardless of their job function, industry, or business sector. This webinar covers top ten most popular functions of Excel.

Learning about the lookup functions in Excel will allow you to match data between databases. VLOOKUP enables you to look for a value quickly and easily down a column of data and return a value from the same row in a different column. Perfect for when working with large tabular data. INDEX and MATCH work in a similar way but provide more flexibility.

LEARNING OBJECTIVES

This webinar covers top ten most popular functions of Excel. Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more. Explore what are considered the top 10 functions.

Lookup functions in Excel are far superior to manually searching for specific data elements in a spreadsheet. VLOOKUP, HLOOKUP, XOOKUP, INDEX and MATCH are some of the most well-known (and most useful) functions in Excel.

This training is categorized as an intermediate to advanced level user of Excel, not only do you want to take your knowledge and skills to the next level, you want to produce meaningful, impactful and insightful reports in the shortest time possible. These features of the application will help you to do just that.

Although the training will be delivered using the latest version of Excel, this training is relevant for users of all versions of Excel (although XLOOKUP is only available to Office 365 subscribers)

AREAS COVERED

  • Master Microsoft Excel from Beginner to Advanced
  • Creating formulas to perform mathematical calculations
  • Creating complex functions the easy way
  • Lookup Functions - VLOOKUP, HLOOKUP and the new XLOOKUP
  • Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT
  • Understand the importance of absolute references within many lookup functions
  • Use VLOOKUP to perform approximate matches
  • Use IF and its counterparts COUNTIF, SUMIF, and AVERAGEIF
  • Learn why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP
  • Use the MATCH function to find the position of an item on a list
  • Use the IFERROR function to display something other than an #N/A error value when VLOOKUP can’t find a match
  • Text Functions - CONCATENATE, UPPER, LOWER, MID
  • Date Functions – NETWORKDAYS, WORKDAY, EOMONTH
All Access Pass Banner

All Access Pass Benefits

$999 per year

  • Access to 12 Live Webinars per year
  • Access to 12 On-Demand Webinars per year
  • All Live and On-Demand webinars include certificates, printable presentation material and handouts
Learn More

Speaker

Mike Thomas's Avatar

Mike Thomas

Microsoft Excel Expert

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012, he founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a variety of Excel topics. Mr. Thomas is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.