Curriculum
Title | Description | |
Lookup Functions – Intro | In this post, you will learn about the Lookup functions in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/lookup-and-reference-functions-in-microsoft-excel/’,’_blank’)”] |
Duplicate Values with MATCH | In this function you will learn to find duplicate values using MATCH function in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-find-duplicate-values-in-multiple-columns-in-excel-2016/’,’_blank’)”] |
Two-Way Lookup | In this post, you will learn about two way lookups in Excel and how to use them. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/two-way-lookup-in-microsoft-excel/’,’_blank’)”] |
Offset | In this post, you will learn about Offset feature in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/offset-function-in-microsoft-excel/’,’_blank’)”] |
Index and Match | In this post, you will learn about the Index and Match feature in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/index-and-match-in-microsoft-excel/’,’_blank’)”] |
Income Tax Calculator | In this post, you will learn to calculate income tax using Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/income-tax-calculator-in-excel/’,’_blank’)”] |
VLookup | In this post, you will learn about the VLookup feature and how to use them in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/vlookup-in-microsoft-excel/’,’_blank’)”] |
Case Sensitive Lookup | In this post, you will learn to perform a Case Sensitive Lookup in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-perform-a-case-sensitive-lookup-in-excel/’,’_blank’)”] |
Left Lookup | In this post, you will learn about the Left Lookup and how to use them in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/left-lookup-in-excel/’,’_blank’)”] |