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.    

Essential safety measures for secure social media use

Image
सोशल मीडिया का उपयोग करते समय निम्नलिखित प्रमुख सुरक्षा उपाय अपनाए जाने चाहिए: 1. अपनी व्यक्तिगत जानकारी सुरक्षित रखें: अपना पता, फ़ोन नंबर या वित्तीय विवरण जैसी संवेदनशील जानकारी साझा करने से बचें। मजबूत, अद्वितीय पासवर्ड का उपयोग करें और सभी खातों पर दो-कारक प्रमाणीकरण सक्षम करें। 2. गोपनीयता सेटिंग्स समायोजित करें: आपके पोस्ट और व्यक्तिगत विवरण कौन देख सकता है, इसे नियंत्रित करने के लिए प्रोफ़ाइल को निजी पर सेट करें। अपने सोशल मीडिया खातों से जुड़े ऐप्स की अनुमतियों की समीक्षा करें. 3. पोस्ट करने से पहले सोचें: अपने स्थान के बारे में वास्तविक समय की जानकारी पोस्ट करने से बचें। ऐसी राय या तस्वीरें साझा करने में सावधानी बरतें जिनका दुरुपयोग या गलत अर्थ निकाला जा सकता है। 4. घोटाले और नकली प्रोफाइल को पहचानें: मित्रता अनुरोध स्वीकार करने से पहले प्रोफाइल सत्यापित करें, विशेष रूप से अज्ञात व्यक्तियों से। अपरिचित स्रोतों से आने वाले लिंक या संदेशों से सावधान रहें - उनमें फ़िशिंग घोटाले या मैलवेयर हो सकते हैं। 5. अधिक जानकारी साझा करने से बचें: अपनी दैनिक दिनचर्या, यात्रा योजनाओं या परिवा...

ELI-- The Employment Linked Incentive (ELI)

 The Employment Linked Incentive (ELI)  First-time employees in the formal sector receive a one-time payment of up to Rs 15,000 in three installments. This benefit is available to employees who earn up to Rs 1 lakh per month and are enrolled in the EPFO.                  ________________________________

Master guide to creating tables using short cut

Image
    You can easily create a table in Microsoft Word using the "+" and "----" method. Here’s how you can do it: Open your Word document.   Type a line like this:   +----+----+----+ Each "----" represents a column, and each "+" marks the boundaries of a cell.   Press Enter, and Word will automatically convert it into a table.   Example: If you want a table with three columns, type: +----+----+----+ If you want a table with more columns, add more "----+".        

how to quickly check your pc information and specs

Image
    When you press Windows + Pause/Break on your keyboard, it opens the System window in Windows. This is a quick way to view important information about your computer's hardware and operating system. Here's a breakdown of what you can find in the System window: 1. Windows Edition Windows Version : You'll see the specific version of Windows you're running, such as Windows 10, Windows 11, or earlier versions. Edition : For example, Home, Pro, or Enterprise editions. 2. System Processor : Displays the type and model of the CPU (Central Processing Unit). Installed RAM : The total amount of physical memory (RAM) installed on your PC. System Type : Indicates whether you're running a 32-bit or 64-bit version of Windows.   3. Device Specifications Device Name : The name assigned to your PC, which you can modify. Computer Name : This is how your PC is identified on a network (if connected to one). Workgrou...

How to insert date and time in MS words Easily

Image
  we may use the following shortcuts: To insert the current date and time in MS Word,     1. Insert Current Date To insert the current date in MS Word, use this keyboard shortcut: Alt + Shift + D   This will insert the current date in the default date format based on your system’s settings. 2. Insert Current Time To insert the current time, use this shortcut: Alt + Shift + T This inserts the current time in the default time format. 3. Update Date and Time Automatically Both the date and time fields will update automatically if you choose to update them later: Right-click the inserted date or time and select Update Field to refresh it. 4. Insert Date and Time Using Ribbon we may also manually insert the date or time from the ribbon: Go to the Insert tab on the Ribbon. Click Date & Time in the Text section. Choose a format and click OK to insert it.

HOW TO ADD TIME AND DATE IN EXCEL

Image
   When we need to  add time and date in Excel. we may use little  shortcuts or formulas, here's a clear proedure  of how to do it-------------------- 1.   Insert Current Time  To insert the current time in a cell, use the following keyboard shortcut: Ctrl + Shift + : This will insert the current system time into the selected cell.           2. Insert Current Date using Formula                To insert the current date using a formula, use                 =TODAY()          3. Insert Tomorrow's Date           To get tomorrow's date, you can use the TODAY() formula with an addition of 1: =TODAY() + 1 This will always give you the date of the following day.          4. Insert Yesterday's Date              ...

Trick to get the sum row wise or column wise

Image
    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.    

How to separate multiple texts in a cell

Image
  how to separate multiple text of a cell in excel demo------------------------------------------

Quick trick to change text to uppercase in seconds

Image
  How to change uppercase letters using Shift+Ctrl+A or Shift+F3,   Shift + F3 shortcut. Simply highlight the text you want to change, and press Shift + F3 . Excel will toggle between three cases—uppercase, lowercase, and proper case.   Now, if you want to specifically convert text to uppercase, you can use the Shift + Ctrl + A shortcut. When you press these keys together, it will change the selected text to uppercase without toggling between other cases.  

How to create a line in Microsoft Word by short cut

Image
  ·     create a line in Microsoft Word : Type *** (asterisks), ___ (underscores), or ### (hashes) and press Enter to automatically create a horizontal line. demo_______

Excel Shortcut for Multiple Text in a Cell (Alt + Enter)

Image
    Excel Shortcut for Multiple Text in a Cell (Alt + Enter) In Microsoft Excel, you can enter multiple lines of text within a single cell using the Alt + Enter shortcut. This is particularly useful when you want to add detailed notes, break long sentences, or organize data without spreading across multiple cells. Here's how to use it: Select the Cell : Click on the cell where you want to enter multiple lines of text. Enter Text : Start typing the first line of text. Insert a Line Break : Press Alt + Enter . This will move the cursor to a new line within the same cell. Continue Typing : Type the next line of text. Repeat : Use Alt + Enter again for additional lines. DEMO-----------------------------------

Simple and Easy Tips for Adding Zeros in Excel

Image
  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

HOW TO ADD HOUR/MINUTES/SECONDS TO A GIVEN TIME

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

how to insert multiple rows between two rows

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           

How to insert serial no for each item in excel

Image

Age classification

Image
  SCAN-------  

Do you know ABC in excel

Image
  SCAN-----

HOW TO INSERT ARROW MARK IN WORD A LITTLE SHORT CUT

Image
    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...