Posts

Featured post

Trick to get the sum row wise or column wise

    Row-wise or Column-wise Sum Using a Shortcut: Select the range of numbers in the table that you want to sum (either a column or a row, or even multiple columns or rows). Press the Alt key on your keyboard. After pressing Alt , press the +   = key . This is the AutoSum shortcut. If you're summing a column , Excel will automatically fill the cell directly below the selected range with the sum of that column. If you're summing a row , Excel will automatically fill the cell directly to the right of the selected range with the sum of that row.   The AutoSum feature ( Alt + = ) automatically sums numbers in a contiguous range of cells.    
1 comment
Read more

Insert Serial Numbers in Roman Numerals, Alphabets, and Numbers in Excel

Image
  How to Insert Serial Numbers in Roman Numerals, Alphabets, and Numbers in Exce l To easily generate serial numbers in Roman numerals, alphabets, or numbers, follow these simple formulas in Excel: SL NO in  Roman Numerals: Click on the cell where you want to start the serial number (e.g., A1). Enter the following formula: =ROMAN(ROW(A1)) After entering the formula, drag the fill handle (small square at the bottom-right corner of the cell) down to apply it to additional cells. SL NO in Alphabets Click on the cell where you want the alphabet sequence to begin (e.g., A1). Enter this formula: =CHAR(64 + ROW(A1)) Drag the fill handle down to continue the alphabet sequence.    Sl no in Numbers: Click on the cell where you want to start numbering (e.g., A1). Enter the formula: =ROW(A1) Drag the fill handle down to generate a sequence of numbers. By using these simple formulas, you can quickly generate serial numbers in Roman numerals, alphabets, or numbers across your spre...
Post a Comment
Read more

CONVERT TABLE FROM HORIZONTAL TO VERTICAL AND VERTICAL TO HORIZONTAL

Image
  kkcomputerinfo scan
1 comment
Read more

TIPS TO INSERT A SERIAL NUMBER IN AN EXCEL SHEET

Image
  TIPS TO INSERT A SERIAL NUMBER IN AN EXCEL SHEET USING A COMAND AND TRICKS             To insert a serial number (SL NO) in an Excel sheet using a command, you can use a simple formula. Here’s how you can do it: Open Excel and navigate to the cell where you want to start your serial numbers (e.g., A1).   Enter the Formula : In cell A1, type 1 to start the numbering. In cell A2, type the formula =A1 + 1 . This will add 1 to the value above.   AutoFill the Series : Click on the small square at the bottom-right corner of cell A2 (the fill handle). Drag it down to fill the cells below with sequential numbers as you desired. 1       =A1+1                 TRICKS   TO INSERT...
Post a Comment
Read more

essential BAsic excel formulas a quick guide

Image
  Here are some tips for using Excel formulas: All formulas start with an equal sign (=) To refer to a cell, enter the column letter followed by the row number. For example, B2 refers to the cell at the intersection of column B and row 2.           The formula bar shows the formula you enter in a cell. You can see it whenever that cell is selected. Here are some basic Excel formulas you can use for common tasks: 1. SUM Adds a range of numbers. =SUM(A1:A10) 2. AVERAGE Calculates the average of a range of numbers. =AVERAGE(B1:B10) 3. COUNT Counts the number of cells that contain numbers. =COUNT(C1:C10) 4. MAX Finds the maximum value in a range. =MAX(D1:D10) 5. MIN Finds the minimum value in a range. =MIN(E1:E10) 6. IF Performs a logical test and returns one value for TRUE and another for FALSE. =IF(F1 > 10, "Yes", "No") 7. CONCATENATE (or &) Joins two or more strings together. =CONCATENATE(G1, " ", H1) =G1 & " " & H1 8...
Post a Comment
Read more

basic tips to learn POWER POINT

Image
  ·       Some important tips to learn Power Point ·        Steps: To open M.S. Power Point click on start click on program Click on MS Power Point   ·        Steps: If you want to insert a slide (To insert a slide) Roll up the Insert menu and choose the New Slide option Choose the Auto Layout option ·       Steps: To insert date and time Select the insert menu Select the date and time option Then click on the style you like   ·       Steps: Slide Show (To show the slide) Select live menu Select Slide Show or press F5 go to slide sorter Add slide transitions to slides Click on a preset animation that will affect the written text   ·          Steps: To change the colour, layout, background and design temperate of slide Select the format menu choose a slide layout choose background choose slide co...
Post a Comment
Read more

steps to INSERT DATES

Image
Post a Comment
Read more

tips to learn ms windows

Image
kkcomputerinfo.blogspot.com      Some important tips to learn Windows by KKCOMPUTERinfo   Steps:                  To Set the Background of the Desktop Right click the mouse on an empty space on the desktop ·         Select the property and click on it ·        Click on the type of background you want .     Click on the Apply button .      Click the OK button Steps: To Specify a Text in Screen Saver ·         Select 3-D text from the screen saver ·         Click on Settings button ·         Display and decorate your text with the different types of keys provided   ·        Steps: To change ICONS/Background scheme ·         Right click on an empty space of the Desktop. ·         Select the pro...
Post a Comment
Read more