Druva has a Pivot Table consisting of her expenses for April and May. It looks as follows In this module, we will look at the advanced features that she can use to modify this table. Inserting Timelines Creating Pivot Charts Formatting and Customizing Pivot Table Inserting Timeline By inserting a timeline, she can filter the …
Advanced Pivot Table Settings in Microsoft Excel Read More »
Text functions are those predefined formulae available on Excel that can be used on alphabetical characters or strings. In this module we will look at CODE and CHAR functions. Text Functions – CODE This function can be used to display a specific numerical value to an alphabetical character. This character is decided by the character …
A cell reference is naming of a cell that can be used while calculating formulas and functions in Excel. There are two types of Cell References- Relative and Active. Difference Between Relative and Active Cell References The relative cell references change in relation to their location while the active cell references remain constant no matter …
Cell References in Microsoft Excel – Relative and Active Read More »
Microsoft Excel offers a variety of functions in its ‘Function Library’. In this module, we will look at the logical functions under the heading ‘Logical’ and their uses. The ‘Logical’ group of functions is present in the ‘Formula’ menu in the ‘Function Library’ towards the left hand side. The various options present under this heading …
What is the LOOKUP Function? LOOKUP Function in Excel scans through the given data in a range of cells to find the user a particular value that he or she wants. It is a worksheet function, meaning that, it can be used within a worksheet as a formula. Where is the LOOKUP Function Found? The …