Wallet Install
Home
Explore
Wallet
Video
Profile
Trends
English
janani Prabakaran - Author on ShareChat
janani Prabakaran
554 views • 7 hours ago
#💻Computer Skills
20 Intermediate Excel Shortcuts Action Shortcut No. Autosum Alt + = Fill Down Ctrl + D Fill Right Ctrl + R Flash Fill Ctrl + E Insert Hyperlink Ctrl + K Format as Table Ctrl + T Filter Data Ctrl + Shift + L Name a Range Ctrl + F३ Clear Cell Contents Alt + H+E+ A Conditional Formatting Alt + H+1+ N 10 Freeze Top Row Alt + W + F + R Unfreeze Row or Column 12 Freeze Alt + W+ F+ F Freeze First Column 13 Alt + W+F+C Text to Columns 14 Alt + A+E Remove Duplicates 15 Alt +A+M Merge & Center Cells  Alt +H+M+C 16 Delete Worksheet Alt + E+L Rename Current Worksheet 18 Alt + H + $ + A Sort Descending Alt + H+ $+0 २०
19 likes
9 shares

More like this

  • janani Prabakaran - Author on ShareChat
    janani Prabakaran
    #💻Computer Skills
    Title Barl This lies in the middle and at the top ofl the window Title bar shows the program and the sheet titles Help The Help Icon can be used to excel get related help anytime you need. Zoom Control Zoom for control lets in zoom you a closer look The your text at zoom a slider that you can control consists of slide left to right to zoom in or out View Buttons The group of three buttons located to the left of the zoom control near the bottom of the screen is view buttons. Sheet Area The area where you enter data is called sheet area mS excel Title Barl This lies in the middle and at the top ofl the window Title bar shows the program and the sheet titles Help The Help Icon can be used to excel get related help anytime you need. Zoom Control Zoom for control lets in zoom you a closer look The your text at zoom a slider that you can control consists of slide left to right to zoom in or out View Buttons The group of three buttons located to the left of the zoom control near the bottom of the screen is view buttons. Sheet Area The area where you enter data is called sheet area mS excel
    7
    7
  • janani Prabakaran - Author on ShareChat
    janani Prabakaran
    #💻Computer Skills
    Ribbon Excel has a unique ribbon which contains Page Home  various tabl like: Insert layout, Formulas Data, Review and View Tab The Homel contains thel most frequently used commands in Excel: Title Bar This lies in the middle and at the top of the window Title bar shows the program and the sheet titles ms excel Help The Help Icon be used to excell can get related help anytime you need Zoom Control control Zoom for lets in you zoom a closer look Thel your at text zoom control consists of a slider that you can slide left to right to zoom in or out. Ribbon Excel has a unique ribbon which contains Page Home  various tabl like: Insert layout, Formulas Data, Review and View Tab The Homel contains thel most frequently used commands in Excel: Title Bar This lies in the middle and at the top of the window Title bar shows the program and the sheet titles ms excel Help The Help Icon be used to excell can get related help anytime you need Zoom Control control Zoom for lets in you zoom a closer look Thel your at text zoom control consists of a slider that you can slide left to right to zoom in or out.
    13
    14
  • janani Prabakaran - Author on ShareChat
    janani Prabakaran
    #💻Computer Skills #Melting MS
    Windows Keys Remove current app Win minimizel DOWN from screenl Or the desktop window ARROW Maximize the app Or LEFT Win desktop window thel to ARROW LEFT sidel ofl thel screen Maximize the app Or Winl desktop window thel to RIGHT RIGHT side of the ARROW screen Minimize alll but thel active desktop window Win + HOME (restores windows all on second stroke) Stretch the desktop Win SHIFT window to the top and UP + ARROW bottom Of the screen Win Restore/minimizel activel desktop  windows SHIFT vertically maintaining DOWN ARROW width Windows Keys Remove current app Win minimizel DOWN from screenl Or the desktop window ARROW Maximize the app Or LEFT Win desktop window thel to ARROW LEFT sidel ofl thel screen Maximize the app Or Winl desktop window thel to RIGHT RIGHT side of the ARROW screen Minimize alll but thel active desktop window Win + HOME (restores windows all on second stroke) Stretch the desktop Win SHIFT window to the top and UP + ARROW bottom Of the screen Win Restore/minimizel activel desktop  windows SHIFT vertically maintaining DOWN ARROW width
    12
    14
  • janani Prabakaran - Author on ShareChat
    janani Prabakaran
    #💻Computer Skills
    Types of Vouchers] Shortcut Recording Type Voucher Type Effect Key Decreases CashlBank Records all payments F5 Payment Voucher balance made Increases CashIBank Records all money F6 Receipt Voucher balance received Cash/Bank transfer Records fund transfer Cash Contra Voucher F4 depositlwithdrawal between & bank cash from Bank Records sales ofl Increases Sales F8 Sales Voucher goodslservices  (Income) Records purchases of Increases Purchase F9 Purchase Voucher goodslservices (Expense) Adjusts non cash Records non- transactions (like cashladjustment F7 JJournal Voucher depreciation; entries provisions; etC / Debit Note Increases Receivable / Records return of Alt+F5 goods to supplier Reduces Creditor Voucher Increases Payable / Credit Notel Records return of Alt+F6 goods from customer Reduces Debtor Voucher Delivery Note Tracks delivery of goods| Records outward movement of goods  Voucher to customers Stock Journal Records transfer of Alt+F7 Adjusts stock quantities stock production etc Voucher Records stock taking Updates stock as per Physical Stock Ctrl+F7 [  Types of Vouchers] Shortcut Recording Type Voucher Type Effect Key Decreases CashlBank Records all payments F5 Payment Voucher balance made Increases CashIBank Records all money F6 Receipt Voucher balance received Cash/Bank transfer Records fund transfer Cash Contra Voucher F4 depositlwithdrawal between & bank cash from Bank Records sales ofl Increases Sales F8 Sales Voucher goodslservices  (Income) Records purchases of Increases Purchase F9 Purchase Voucher goodslservices (Expense) Adjusts non cash Records non- transactions (like cashladjustment F7 JJournal Voucher depreciation; entries provisions; etC / Debit Note Increases Receivable / Records return of Alt+F5 goods to supplier Reduces Creditor Voucher Increases Payable / Credit Notel Records return of Alt+F6 goods from customer Reduces Debtor Voucher Delivery Note Tracks delivery of goods| Records outward movement of goods  Voucher to customers Stock Journal Records transfer of Alt+F7 Adjusts stock quantities stock production etc Voucher Records stock taking Updates stock as per Physical Stock Ctrl+F7 [
    10
    9
  • janani Prabakaran - Author on ShareChat
    janani Prabakaran
    #💻Computer Skills
    Computer Skills
    9
    8
  • janani Prabakaran - Author on ShareChat
    janani Prabakaran
    #💻Computer Skills
    Tally Prime Tally Prime Important Topics List Accounting Basics Configuration Company Creation & Ledger Accounting (Bank Sales Purchase Expenses JoEntary (Payment Receipt Sales, Purchases  Voucher Contra, Inventory Management] Accounting GST Reports & Analysis (Profit & Loss, Balance Sheet, Stock Summary) GST Returns (GSTR-1, GSTR-3B, Other Returns) Bank Reconciliation (BRS) Printing (Invoice Cheques Trial Balance) Data Import & Export Import CSY /Text files Import from Web Export reports Office & Job Use Cases Salary Sheet (Advanced ) ப Attendance System Billing K Invoice & 4 MIS Reports 1 Stock Monogement ப GST Calculation Sheet Tally Prime Tally Prime Important Topics List Accounting Basics Configuration Company Creation & Ledger Accounting (Bank Sales Purchase Expenses JoEntary (Payment Receipt Sales, Purchases  Voucher Contra, Inventory Management] Accounting GST Reports & Analysis (Profit & Loss, Balance Sheet, Stock Summary) GST Returns (GSTR-1, GSTR-3B, Other Returns) Bank Reconciliation (BRS) Printing (Invoice Cheques Trial Balance) Data Import & Export Import CSY /Text files Import from Web Export reports Office & Job Use Cases Salary Sheet (Advanced ) ப Attendance System Billing K Invoice & 4 MIS Reports 1 Stock Monogement ப GST Calculation Sheet
    9
    34
  •  - Author on ShareChat
    ✨𝙵𝚕𝚘𝚠𝚎𝚛𝚏𝚕𝚊𝚐💫✍️💞
    #💻Computer Skills
    CIRL SHORTCUT KEYS Ctrl Ctrl Most Useful Keyboard Shortcuts Ctrl + A Ctrl + P Select All Print Ctrl 8 Ctrl + W Bold Close Ctrl + C Ctrl + U Copy Underline Ctrl + D Ctrl + J Ctrl Font Justify Ctrl +E Ctrl + L Find Left Align Ctrl + F Ctrl +M Find Slide Insert NECI COMPUTER Ctrl +Z Ctrl + N INSTITUTE Undo Open  Ctrl + X Ctrl + Y Repeat Cut Redo Ctrl + V Ctrl + N Ctrl + S SAVE Paste Open CIRL SHORTCUT KEYS Ctrl Ctrl Most Useful Keyboard Shortcuts Ctrl + A Ctrl + P Select All Print Ctrl 8 Ctrl + W Bold Close Ctrl + C Ctrl + U Copy Underline Ctrl + D Ctrl + J Ctrl Font Justify Ctrl +E Ctrl + L Find Left Align Ctrl + F Ctrl +M Find Slide Insert NECI COMPUTER Ctrl +Z Ctrl + N INSTITUTE Undo Open  Ctrl + X Ctrl + Y Repeat Cut Redo Ctrl + V Ctrl + N Ctrl + S SAVE Paste Open
    185
    120
  • janani Prabakaran - Author on ShareChat
    janani Prabakaran
    #💻Computer Skills
    COMPUTER GENERATIONST 1 First Generation Examples 1940 1956 ENIAC, UNIVAC, EDVAC Vacuum Tubes Very  large in   size Features High power consumption Slow; expensive, Used Machine Language less reliable 2. Second_Generation] Examples 1956 1963 IBM 1401, IBM 7094, CDC 1604 Transistors] Smaller   size Features Less heat, more reliable Faster; cheaper , Used Assembly Language more reliable 1 ३. Third Generation Examples : IBM 360, PDP-11 1964 1971 Ineiraten Ciostes (TC) Honeywell   ६००० Features More   reliable More efficient; Used High Level Language multiprogramming 4. Fourth_Generotion Examples 1971 2010 Mac; IBM PC, Apple Microprocessors (VLSI)  Intel-based PCs Personal Computers Features Very fast and reliable Smalll sizep low cost, Used GUI and 4GL high performance 5. Fifth_Generation] Examples Present 2010 AI Sgstems, Robotics, Artificial   Intelligence LoT Devices Parallel   Processing Features Smart, intelligent systems Intelligent, autonomous Natural Language Used ~learning self- DCE COMPUTER COMPUTER GENERATIONST 1 First Generation Examples 1940 1956 ENIAC, UNIVAC, EDVAC Vacuum Tubes Very  large in   size Features High power consumption Slow; expensive, Used Machine Language less reliable 2. Second_Generation] Examples 1956 1963 IBM 1401, IBM 7094, CDC 1604 Transistors] Smaller   size Features Less heat, more reliable Faster; cheaper , Used Assembly Language more reliable 1 ३. Third Generation Examples : IBM 360, PDP-11 1964 1971 Ineiraten Ciostes (TC) Honeywell   ६००० Features More   reliable More efficient; Used High Level Language multiprogramming 4. Fourth_Generotion Examples 1971 2010 Mac; IBM PC, Apple Microprocessors (VLSI)  Intel-based PCs Personal Computers Features Very fast and reliable Smalll sizep low cost, Used GUI and 4GL high performance 5. Fifth_Generation] Examples Present 2010 AI Sgstems, Robotics, Artificial   Intelligence LoT Devices Parallel   Processing Features Smart, intelligent systems Intelligent, autonomous Natural Language Used ~learning self- DCE COMPUTER
    6
    11
  • janani Prabakaran - Author on ShareChat
    janani Prabakaran
    #💻Computer Skills
    Computer Skills
    11
    7
  • janani Prabakaran - Author on ShareChat
    janani Prabakaran
    #💻Computer Skills
    Computer Skills
    9
    20
Home
Explore
Wallet
Video