Learn MS-EXCEL step by step

How to use the PivotTable in the MS-Excel during your professional and business life. Use the following step to use the PivotTable in MS-Excel. 1. Arrange your data properly in the MS-Excel worksheet(like as below) and select the whole database or table. 2. Select the insert option and click the PivotTable in the MS-Excel.      3. Then below dialog box will appear in the MS-Excel sheet and select the new worksheet or select the cells where you want to place the Pivot table (in professional work you should use the new worksheet) and then click on the OK button.       4. Now PivotTable option will appear in the MS-Excel worksheet, and you find the screen like this.        5. Now drop the months in rows box and other valuable data into the value box.       6. Now your PivotTable will appear as below   in the MS-Excel sheet . 7. Now click on the Sum of Dua or any other employee values under the value box and select the value Field Settings.       8. After selecting the Value Field Settin

How to use the HLOOKUP between two sheets in the MS-Excel during your professional and business life. Why did you need to learn HLOOKUP tool in your professional as well as in business life? 1.     You can easily maintain the data of your customers or other details. 2.     By this function, you did not need to buy complex database management software. 3.     Easy to use and need a basic understanding. 4.     No need to hire special staff and current staff will easily learn the HLOOKUP function. Key point (never forgot the rules) 1.     HLOOKUP work always work from top to bottom. 2.     There is should no empty row or column in your MS-Excel workbook but if there is any empty cell then no issue because sometimes we did not have the information.   Use the following step to use the HLOOKUP in MS-Excel. 1.     Arrange your data properly and heading should be on the left side in the MS-Excel worksheet (like as below)   1.     Now create the form or format for you in

How to use the VLOOKUP between two sheets in the MS-Excel during your professional and business life. Why did you need to learn VLOOKUP tool in your professional as well as in business life? 1. You can easily maintain the data of your customers or other details. 2.   By this function, you did not need to buy complex database management software. 3.  Easy to use and need a basic understanding. 4.  No need to hire special staff and current staff will easily learn the VLOOKUP function. Key point (never forgot the rules) 1.  VLOOKUP work always work from left to right. 2.  There is should no empty row or column in your MS-Excel workbook but if there is any empty cell then no issue because sometimes we did not have the information. Use the following step to use the VLOOKUP in MS-Excel. 1.  Arrange your data properly and heading should be on the top in the MS-Excel (like as below)        2.  Now create the form or format for you   in the MS-Excel ( means how would you like to use the i