creative learning by ritesh

  • MUST USE EXCEL SHORTCUTS

    MUST USE EXCEL SHORTCUTS

    MUST USE EXCEL SHORTCUTS Apply borders to cells Ctrl +shift +& Cmd+Shift +&  Auto sum selected cells Alt + =…

  • MS WORD IMPORTANT SHORTCUTS

    MS WORD IMPORTANT SHORTCUTS

    MS WORD IMPORTANT SHORTCUTS Ctrl + A Select all Ctrl+Left Bracket[= decrease font size by 1 point Ctrl +B  Bold…

  • DAILY USE EXCEL SHORTCUT KEYS

    DAILY USE EXCEL SHORTCUT KEYS

    DAILY USE EXCEL SHORTCUT KEYS Shortcut Action Menu equivalent Excel Version CTRL +S SAVE FILE+ SAVE ALL CTRL + T…

  • MICROSOFT EXCEL FORMULA

    MICROSOFT EXCEL FORMULA

    MICROSOFT EXCEL FORMULA Basic Maths Functions Function Formula Example To add up the total =SUM(cell range ) =SUM(B2:B9) To add…

  • BASIC EXCEL FORMULAS

    BASIC EXCEL FORMULAS

    BASIC EXCEL FORMULAS 1 SUM =SUM(A1:A5) 2 SUM =(A1+A2+A3+A4+A5) 3 SUM =(45+2+43+48) 4 PRODUCT =PRODUCT(F1:F2) 5 PRODUCT =(34*65) 6 SUBTRACT…

  • COMPUTER SHORTCUT KEYS IN MS OFFICE AND WINDOWS

    COMPUTER SHORTCUT KEYS IN MS OFFICE AND WINDOWS

    COMPUTER SHORTCUT KEYS IN MS OFFICE AND WINDOWS WORD SHORTCUT KEYS EXCEL SHORTCUT KEYS CTRL +A SELECT ALL CONTENTS OF…