webnior.com Open in urlscan Pro
13.226.145.51  Public Scan

Form analysis
0 forms found in the DOM

Text Content

WEBNIOR


Webinars
Industries
doneHuman ResourcesdoneBanking & Financial ServicesdoneAccounting &
TaxdoneBusinessdoneLife SciencesdoneHealthcare
Speakers
Contact Us
Login
Sign Up
shopping_cartMy Cart


WEBNIOR

Webinars
Industries
doneHuman ResourcesdoneBanking & Financial ServicesdoneAccounting &
TaxdoneBusinessdoneLife SciencesdoneHealthcare
Speakerssssss
Contact Us
Login
Sign Up


EXCEL - TOP 10 FUNCTIONS, LOOKUP FUNCTIONS (VLOOKUP, HLOOKUP, XLOOKUP, MATCH,
INDEX, IFERROR, IF, COUNTIF, SUMIF)



LIVE WEBINAR
calendar_todayOctober 14, 2021
access_time01:00 PM EDT
autorenew90 Minutes
Product ID: #WB000070
Purchase Options
receiptOverview
subjectLearning Objectives
vpn_keyWhy should you attend
assignmentAreas Covered
accessibility_newWho will benefit
faceFaculty
$300 / attendee
Purchase now



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 quickly and easily look for a value
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.


WHY SHOULD YOU ATTEND

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


WHO WILL BENEFIT

This training is categorized as intermediate. It is aimed at users who want to
learn about the commonly-used worksheet functions in Excel.



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)




FACULTY

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.



Faculty



Mike Thomas

Microsoft Excel Expert

COMPANY

 * keyboard_arrow_rightAbout Us
 * keyboard_arrow_rightIn-House Trainings
 * keyboard_arrow_rightKey Note Speakers
 * keyboard_arrow_rightSpeaking Opportunities
 * keyboard_arrow_rightCareers

TRAININGS

 * keyboard_arrow_rightLive Webinars
 * keyboard_arrow_rightRecorded Webinars
 * keyboard_arrow_rightCustomized Trainings
 * keyboard_arrow_rightSeminars
 * keyboard_arrow_rightTraining CD/DVD

QUICK LINKS

 * keyboard_arrow_rightTerms and Conditions
 * keyboard_arrow_rightPrivacy Policy
 * keyboard_arrow_rightDisclaimer
 * keyboard_arrow_rightRefund Policy

SUPPORT

 * keyboard_arrow_rightContact us
 * keyboard_arrow_rightFeedback
 * keyboard_arrow_rightFAQ's

Copyrights © 2019, Webnior LLC. All rights reserved.


WEBNIOR