Excel On Your Own aims to share knowledge about MS Excel and help office workers to cut-short their time on making tedious reports.
18/06/2023
Anime Mouse Pad with Wrist Support Anti Slip Silicone Hand Rest 3D Cartoon Cute Mice Mat for PC Computer Laptop Gaming | Shopee Philippines Buy Anime Mouse Pad with Wrist Support Anti Slip Silicone Hand Rest 3D Cartoon Cute Mice Mat for PC Computer Laptop Gaming online today! COMFORTABLE AND ECO-FRIENDLY MATERIAL: The mouse pad set is made of soft memory form and smooth and breathable fabric. The touch is comfortable and durable, the re...
18/06/2023
04/04/2023
Photobook Philippines - Deal The Right Deals and Discounts by Photobook Philippines
15/05/2017
Upper, Lower and Proper Functions
14/05/2017
Moms are AWESOME!
13/05/2017
The purpose of naming a cell or group of cells is to use the name when you call that cell or group of cells. Calling the name means when you want to use it as an argument to your formula.
It's important that you name your cell logically so that it's easier for you to remember it.
For example you have SALES in cells A1:A10. Highlight the cells (don't include the heading) and change the name in the name box as shown in the picture. Now for the purpose of this tutorial, I'll name that Sales.
Now when I want for example to have the total of that group of cells I'd say =SUM(Sales).
In the name box on the upper left, just below the ribbon (beside the formula bar), you can change the name of the selected cells/range of cells by typing your desired name
12/05/2017
• Nested Function – a function as an argument to another function
o Nested IF FUNCTIONS
 Syntax: IF(condition, [value if TRUE], IF(condition, [value if TRUE], [value if FALSE]))
 The formula tests the condition on the first TRUE value, and then ignores everything else.
12/05/2017
• MATCH FUNCTION - Exact Match Type (Lookup & Reference) – returns the relative position of the value in a range of cells
o Syntax: MATCH(lookup value, lookup array, [match type])
 Lookup value – the value to search for in an array
 Lookup array – the range of cells lookup value will be searched from
 Match type – type of desired match
0 (zero) – finds the exact match
18/06/2023