OngoleSpider BLOG

Formulas in excel are a very important feature. They are used to calculate values based on what is in cells, perform operations on a cell content, fetch values based on your search criteria and much more. As a matter of fact, learning excel formulas is very critical for the successful use of spreadsheet software. Excel formulas let you do so much more once you master them. This site gives easy to understand help for 50 of most frequently used excel formulas. Click on the below sections or formulas to get started. Mathematical Functions Text Functions Logical & Reference Functions Date & Time Functions Financial Functions Information Functions Average Formula Int Formula Mod Formula Rand Formula Round Formula Sum Formula Concatenate Formula Find Formula Left Formula Len Formula Lower Formula Mid Formula Proper Formula Rept Formula Substitute Formula Trim Formula Upper Formula Value Formula And Formula Countblank Formula Countif Formula If Form...

Here is a quick formula tip to start another awesome week. Often while working with data, I need to split a number in to integer and decimal portions . Now, there are probably a ton of ways you can do this. But here are two formulas I use quite often and they work well. Assuming the number is in cell A1, Integer part =INT(A1) Decimal part =MOD(A1,1) These formulas work whenever my data has only positive numbers (which is the case 90% 0f time). But if I am dealing with a mix of positive and negative numbers, I use, Integer part =INT(A1) +(A1<0) Decimal part =MOD(A1,SIGN(A1)) What formulas do you use to process numbers? I use a lot of formulas while working with numbers. But my favorite ones are MOD, INT, SIGN, ABS, RAND and RANDBETWEEN (new in Excel 2007, requires Analysis toolpak in earlier versions ).

Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your data. In plain English, it means, you can take the sales data with columns like salesman, region and product-wise revenues and use pivot tables to quickly find out how products are performing in each region. In this tutorial, we will learn what is a pivot table and how to make a pivot table using excel . click here to see a video tutorial of making pivot tables in excel Example uses of Pivot Tables As I said before pivot tables are very powerful and useful. There are numerous uses of pivot tables that we can talk about them until Christmas. Here are some example uses of pivot tables: Summarizing data like finding the average sales for each region for each product from a product sales data table. Listing unique values in any column of a table [ learn more ] Creating a pivot report with sub-totals and custom formats Making a dynamic pivot...