Faysal Easy Excel

Happy New Year to all of Microsoft Excel Users. Wish your task in Excel becomes more easy this year. |||| Please SUBSCRIBE our YouTube Channel |||| https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw

What is AutoSUM in Excel? AutoSum is a feature found in Microsoft Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019. It helps user to calculate the SUM of multiple cells, multiple rows or multiple columns. It stays as AutoSum button (Drop Down List) under Editing group of Home tab. Image 1: AutoSum button in Microsoft Excel This feature made the SUM calculation quick and easy. Most of the beginner users use this AutoSum calculation feature in Excel for quick and easy way to calculate the SUM . The below example is for those users who wish to use AutoSum in Excel 2007, AutoSum in Excel 2010, AutoSum in Excel 2013, AutoSum in Excel 2016, AutoSum in 2016. This is also known as Quick Sum in Excel. You can apply the AutoSum feature for the following calculation: 1. AutoSum for Multiple Rows (with no blank cells) 2. AutoSum for Multiple Rows (with blank cells) 3. AutoSum for Multiple Columns (with no blank cells) 4. AutoSum for Multiple Columns (with blank ce...

Mr. D is working in Logistic Department of a Company .  He is trying to make a formula that will show the "Product Remarks" Like below logic: Table 1: IF Statement logic According to his logic he is trying to build a formula. He tries but failed and finally asked " How to create a formula that contain a combination of aging in a cell to result as stated on Remarks? ". Also add " copy it down to the next rows that resulted the aging accordingly ." Solution: In C1 cell, enter below formula: =IF(AND(A1<=0,B1>=0),"Fast Moving",IF(AND(AND(A1>=1,A1<=5),AND(B1>=1,B1<=3)),"Slow Moving",IF(AND(AND(A1>=6,A1<=10),AND(B1>=4,B1<=10)),"Slow Moving",IF(AND(AND(A1>=11,A1<=15),AND(B1>=7,B1<=9)),"Surplus",IF(AND(A1>=16,B1>=10),"Dead Stock","Unknown"))))) The result will looks like below image: Image 1: IF Statement result ...

A Bank Employee in many case needs to calculate the Closing Balance after each transaction in PivotTable like a Bank Statement . But with the help of Calculated Field of a PivotTable , you can only calculate Field with Field . It's not possible to use a formula in Calculated Field where you can mention a single cell with Relative Reference Cell . Because a PivotTable acts like a Table format where you can work with Field or Column Name . A Helping Column (A regular column, that helps to get a partial result where formula applied) can be a good idea. But there is an option in PivotTable by which you can Calculate Cumulative . In this article I will show you, how you can do it. Calculating with Formula: Assume that, you have an Excel file with Debit and Credit transaction of an Account . Image 1: Sample Bank Statement In a Bank Statement , Month wise Cumulative Balance is important. In the Excel sheet, as above, it is very easy to use a formula and calc...

Battery Chart is a great way to view the percentage information. It can easily represent many reports with " Still Remaining " information. Such as, The remaining achievement value, the remaining achievement percentage, the remaining days to go in this month etc. This chart can attract audience in seconds. So, using of this chart could be a plus point of your professional career.   Image 1: Battery Chart in Excel Understanding A Battery Chart: To create a Battery Chart, first of all I divide a battery into 4 parts. Bottom Portion , Achievement Value , Remaining Value and Top Portion . To design a Battery Chart I also need to divide a single information into 4 parts.  Data Require to Create a Battery Chart:   If I have a single information like, Achievement Percentage is 63% , then I can find another information like, 100% - 63% = 37% . So I can call it, Achievement Value = 63% and Remaining Value = 37% . Manually I have selected The Botto...

Someone asked, " How to convert Logical Text to Logical Value in Excel? " In more details, his question like, you have below data table: Image 1: Logical Text to Logical Value The D2 cell contains a formula and it will show the logical result like: =CONCATENATE(A2,B2,C2) as TRUE or FALSE . More specifically he wanted: =IF(CONCATENATE(A2,B2,C2),"Logical","Illogical") But according to Microsoft Excel, if you apply CONCATENATE function then the value always returns TEXT and IF function will always return FALSE that means " Illogical ". He wanted if he change the logical operator symbol in B2 cell, then depends on this logical operator symbol, the result in D2 cell of =CONCATENATE(A2,B2,C2) will change as TRUE or FALSE . Solution: After studying on it, I've found a simple solution. And the solution is why don't we use a IF formula on this? Yes, an IF formula can help us regarding this issu...

Assume that you have a file that contains TEXT value in Column A2:A4 . In each cell a special delimiter (character) has used " ^ ". Now you wish to separate rest of the text after " ^ " character to another column. If I say more clearly and in short then: You have this: Image 1: Sample data And you want to convert it like this: Image 2: Converted data Seems it is easy. But the problem is, + (Plus) symbol is the starting character of next column. And if you start a cell value from + (Plus) then it will converted as a formula "=" (Equal) character in excel and returns an #NAME? error: Image 3: Converted data If you take a close look then you will see + symbol converted as Formula character and returns #NAME? error due to =ebook1.php is not a Microsoft Excel function. Solution: So, how you can convert it as same as in image 2 shows? Well, follow the below steps: Step 1: Select A2:A4 cell. Step 2: Click on Dat...