KKCOMPUTERINFO

  Simple and Easy Tip for Adding Zeros in Excel.   Method 1: Using Scientific Notation In Excel, you can use scientific notation to add zeros after a number by specifying the power of 10. For example, to add 5 zeros after the number 2 , you can use:   =2E5 Explanation : 2E5 means "2 × 10^5," which gives 200,000 (2 followed by 5 zeros). Method 2: Using the Exponentiation Operator ( ** ) You can also use the exponentiation operator to achieve the same result. For example:   =2**5 Explanation : 2**5 means "2 raised to the power 10 of 5," which gives 200000 . This method is more commonly used for powers rather than for directly adding zeros. demo------          scan

  QUICK TIPS TO ADD HOUR/MINUTES/SECOND TO A GIVEN TIME . DEMO

WHY INSERT MULTIPLE ROWS IN EXCEL? Many times, when you need to insert new rows or multiple  rows of data into your spreadsheet Inserting multiple rows in a spreadsheet can be time-consuming if done one by one using the right-click and insert option.   Here's a quick trick to save time: Suppose you have a sheet and need to insert 5 rows between "Mukesh" and "Ratan ." Simply select the row where "Mukesh" is located, (LOWER CELL) hold Ctrl + Shift , and press the + key five times. This will instantly add the desired number of rows, making your task much faster and more efficient! Demo           

  SCAN-------  

  SCAN-----

    To insert arrow marks, including both standard and thick arrows, in Microsoft Word, follow these steps or keep in mind the handy shortcut tricks provided below:---------------- STEPS:----------   Using Keyboard Shortcuts insert arrow mark. Right Arrow (→): Press Alt + 26 (on the numeric keypad). Left Arrow (←): Press Alt + 27 (on the numeric keypad). Up Arrow (↑): Press Alt + 24 (on the numeric keypad). Down Arrow (↓): Press Alt + 25 (on the numeric keypad). You may use   for more arrow marks ALT+8658 ALT+8656 ALT+8657 ALT+8659 1.    Inserting  Arrow Marks: Option : Using the Symbol Menu Place the cursor where you want to insert the arrow. Go to the "Insert" tab in the ribbon. Click on "Symbol" usually at the far right. Select "More Symbols..." . In the Symbol dialog box , choose the font as "Wingdings" o...

      NUMBER TO WORDS IN EXCEL   In Excel on   most of the Windows   there is not a ready   built-in function to convert numbers to words (like "123" to "One Hundred Twenty-Three"). However, you can do this using   the methods below:---------------------------------------------- 1. Using VBA, (Visual Basic for Applications) (Macro) Code. Steps to   insert VBA code : Open Excel and press Alt + F11 to open the VBA editor. In the VBA editor, click Insert in the menu and then choose Module . In the module window, paste the   VBA code which is appended below. After pasting the code, press Ctrl + S to save your workbook. Make sure to save it as a Macro-enabled Workbook ( .xlsm ). Close the VBA editor ( Alt + Q ) and go back to your Excel worksheet. Using the Function in Excel: Now, you can use the new function NumToWords in any cell. For example, if you want to convert ...

    Rearrange columns in excel sheet using a quick trick     No need to copying, pasting, or dragging , just used a simple trick  Select all the table by pressing CTRL +A, This highlight all the cells in your sheet. Next press  ALT +HSU,  This opens the  sorting dialouge box,. In this dialogue box click on option and selct left to right Now choose the row you want to sort by. you will get a  revised table of data as per your need.   scan

  How to find sum of numbers with units in a range in Excel? In Excel, you can use a formula to handle this task. Select a blank cell, and type this formula =SUM(SUBSTITUTE(B1:B7, "kg", "") + 0) into it, and then press  Shift + Ctrl + Enter  keys simultaneously to get the correct result. OR USE THIS  FORMULA  SELECT A BLANK CELL AND TYPE THIS FORMULA=SUM(--LEFT(B1:B7,2)) USE CTL+SHIFT+ENTER . A                                   B APPLE 20KG PEAR 30KG MANGO 10KG BANANA 11KG GRAPES 50KG ORANGE 22KG POTATO 30KG   173 = SUM(--LEFT(B1:B7,2)) USE CTL+SHIFT+ENTER Tip:  in above formula, B1:B7 is the numbers with units you want to sum up, kg is the unit in the data ...

M S Excel shortcuts Here are some basic shortcuts and most of you are comfortable with them. However these are important for beginners. Tips ------- The plus sign "+" means the keys should be pressed simultaneously. The Ctrl and Alt keys are located on the bottom left and bottom right sides of most keyboards. Shortcut    command and their function Ctrl + N    ------------Used to create a new workbook. Ctrl + O    -------------Used to open an existing workbook. Ctrl + S -------------- Used to save the active workbook. F12 --Used to save the active workbook under a new name, displays the Save as dialog  box. Ctrl + W----------          Used to close the active workbook. Ctrl + C -----------     Used to copy the contents of the selected cells to Clipboard. Ctrl + X- ---------      Used to cut the contents of the selected cells to Clipboard. Ctrl + V --------     Used to i...

   If you need to categorize scores into different results (Failed, Third Division, Second Division, First Division, and Extraordinary) based on score ranges in Excel, you can use the VLOOKUP Formula instead of  IF function to achieve this.  Score Criteria Score Range                          Result 0 - 32                                     Failed 33 - 44                                   Third Division 45 - 59                         ...