Curriculum
Title | Description | |
Formula & Functions – Getting Started | In this post, you will learn about the basic formula and functions used in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/formulas-and-functions-in-microsoft-excel/’,’_blank’)”] |
Paste Options | In this post, you will learn about the paste options in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/paste-options-in-excel/’,’_blank’)”] |
Sum Alternate Rows with SUMIF | In this post, you will learn to Sum Alternate Rows with SUMIF function in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-sum-alternate-rowscolumns-cell-values-in-microsoft-excel/’,’_blank’)”] |
Duplicate Values with COUNTIF | In this post, you will learn to count the Duplicate Values with COUNTIF function in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-count-the-duplicate-values-in-a-column-in-microsoft-excel-2016/’,’_blank’)”] |
Get Count of an Item with COUNTIF | In this post, you will learn to count an item using COUNTIF function in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-get-the-count-of-item-from-a-list-in-microsoft-excel/’,’_blank’)”] |
Advanced COUNTIF | In this post, you will learn about the advanced features of COUNTIF function in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/prevent-duplicate-entries-in-microsoft-excel/’,’_blank’)”] |
Hide & Lock Formulas | In this post, you will learn to hide and lock formulas in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/hide-and-lock-formulas-in-excel/’,’_blank’)”] |