Keys for moving and scrolling in a worksheet or workbook Arrow keys: Move one cell up, down, left, or right CTRL+arrow: key Move to the edge of the current data region HOME: Move to the beginning of the row CTRL+HOME: Move to the beginning of the worksheet CTRL+END: Move to the last cell on theContinue reading “Shortcut Keys in Excel”
Category Archives: Excel
IF function
Function Type: Logical Description: IF is one of the most popular functions in Excel. It checks if the condition is met then it returns a value. It is used to return one value if the logic is true and another value if false. Function Structure: =IF(logical_test, [value_if_true], [value_if_false]) Argument Breakdown: logical_test – This is whereContinue reading “IF function”
Excel Cell
In Microsoft Excel, a cell is a rectangular box that occurs at the intersection of a vertical column and a horizontal row in a worksheet. Thus, it is defined by a combination of column and row e.g., A1 A cell stores 1 data at a time. These data can be a formula, text value, numericContinue reading “Excel Cell”
VLOOKUP
Function Type: Lookup and Reference Description: VLOOKUP is one of the most popular functions in Excel. It is used to lookup a data and retrieve the corresponding data from a specific column. You may either lookup for the exact or approximate match. The “V” in Vlookup means Vertical. Function Structure: =VLOOKUP(lookup_value, table_array, column_index_number, [range_lookup]) ArgumentContinue reading “VLOOKUP”
Cash Heaven 