A Course on the VLOOKUP & XLOOKUP Functions in Excel | Free Udemy Course
A course for complete beginners on what the VLOOKUP and XLOOKUP functions are, and how to use them in Excel - Free Course | Free Udemy Course
new- 2 hours hours of on-demand video
- Full lifetime access
- Access on mobile and TV
Hello and welcome to this course on the VLOOKUP and XLOOKUP functions in Excel.In this course, we shall go through the VLOOKUP and XLOOKUP functions in Excel to have a look at what they are, how to use them and some examples of using each. VLOOKUP and XLOOKUP are handy built-in functions in Excel that are used to find and retrieve information from datasets or tables. Throughout this course, I assume you have absolutely no knowledge of Excel or even spreadsheets in general, so I take you right from the start and describe each step in terms you will understand. We will have a look at each section of the VLOOKUP and XLOOKUP syntax as well as looking at examples with each. Some of the sections we cover in the course are:The syntax of each functionExact matching and approximate matchingMatch_modeSearch_modeRules to follow to avoid common errorsNA ErrorsUsing wildcards with each functionUsing the insert function optionUsing the functions across different tabs and spreadsheetsThis course is ideal for anyone who wants to learn what the VLOOKUP and XLOOKUP functions are and how to use them. You may have been using VLOOKUP for years but are ready to find out what XLOOKUP can do for you instead, or you may just want refreshers on using both of these functions. Who this course is for:This course is for anyone that wants to learn what VLOOKUP and XLOOKUP areIt's for complete beginners and even more advanced spreadsheet users
Course Content:
Sections are minimized for better readability, click the section title to view the course content
JOIN OUR WHATSAPP GROUP TO GET LATEST COUPON AS SOON AS UPDATED
JOIN WHATSAPPJOIN OUR TELEGRAM CHANNEL TO GET LATEST COUPON
JOIN TELEGRAMJOIN OUR FACEBOOK GROUP TO GET LATEST COUPON
JOIN FACEBOOKFree Online Tools And Converters for your use
URL Encoder
Input a string of text or a URL and encode the entered string
Try itURL Decoder
Input an encoded string of text or a URL and decode the entered string
Try itColor Contrast Checker (WCAG)
Calculate the color contrast ration for your website (WCAG)
Try itXML Formatter
Paste or upload an XML and have it formatted to a beautiful XML format
Try itURL Slug Generator
Convert any title or sentence into a variety of slugs for your pages URL
Try itE-Signature
Draw an e-signature or type a signature for your online signature
Try it