Wallet Install
Home
Explore
Wallet
Video
Profile
Trends
English
M.A Computer Classes - Author on ShareChat
M.A Computer Classes
942 views • 5 months ago
Shortcut Key to Jump to Last Row & Column in Excel #excel2007 #EXCEL EDUCATION #tios&trick

Video tag is not supported on your browser

9 likes
10 shares

More like this

  • Pankaj - Author on ShareChat
    💫Pankaj 💫
    #excel #excel shortcut key💻 #EXCEL EDUCATION #advance excel #ms excel
    26 Advanced Excel Formulas Formula Pattern SL No Formula Name SUM =SUMA1 A10) ব (2) AVERAGE =AVERAGE(B1 B10) @ =IF(C2>100,"Yes" "No") VLOOKUP =VLOOKUP(D2 42810 2 FALSE) HLOOKUP =HLOOKUP(Sales" A1:D3 2 FALSE) (6) INDEX =INDEX(A2 C5,2. 3) MATCH =MATCH(500 82.810 0) OFFSET (8) =OFFSET A1 2, 3) (9) =TEXT(TODAY() "DD-MMYYYY") TEXT 10) CONCAT =CONCAT(A1 81 C1) TEXTJOIN =TEXTJOIN( TRUE , A2 A5) (11) =UNIQUE(A2 A10) UNIQUE (Excel 365) (12)  =FILTER(A2:810, 82:B10="Yes") (13) FILTER (Excel 365) | (14) SORT Excel 365) =SORT(A2 B10, 2,TRUE) (15) SORTBY (Excel 365) =SORTBY(A2:A10  B2 B10 -1) (16) SEQUENCE (Excel 365) =SEQUENCE(5 1, 1 2) =RANDARRAY(3 2 1 100, TRUE) RANDARRAY (Excel 365) (17) A2A10,B2B10, "NA") (18) XLOOKUP (Excel 365` =XLOOKUP("John" =XMATCH(100, A2 A10, 0) (19) XMATCH (Excel 365) =LAMBDA(X x1०)(५) (20) LAMBDA (Excel 365) =LET(X. A1*2, y x+10, y) (21) LET (Excel 365) =ISNUMBER(A2) ISNUMBER (22) =TODAY() (23) TODAY (24) NETWORKDAYS =NETWORKDAYS(A2 82) (25) YEARFRAC =YEARFRAC(42, 82) A1=2,"Two", TRUE "Other") (26) IFS (Excel 365) =IFS(A1-1 "One" 26 Advanced Excel Formulas Formula Pattern SL No Formula Name SUM =SUMA1 A10) ব (2) AVERAGE =AVERAGE(B1 B10) @ =IF(C2>100,"Yes" "No") VLOOKUP =VLOOKUP(D2 42810 2 FALSE) HLOOKUP =HLOOKUP(Sales" A1:D3 2 FALSE) (6) INDEX =INDEX(A2 C5,2. 3) MATCH =MATCH(500 82.810 0) OFFSET (8) =OFFSET A1 2, 3) (9) =TEXT(TODAY() "DD-MMYYYY") TEXT 10) CONCAT =CONCAT(A1 81 C1) TEXTJOIN =TEXTJOIN( TRUE , A2 A5) (11) =UNIQUE(A2 A10) UNIQUE (Excel 365) (12)  =FILTER(A2:810, 82:B10="Yes") (13) FILTER (Excel 365) | (14) SORT Excel 365) =SORT(A2 B10, 2,TRUE) (15) SORTBY (Excel 365) =SORTBY(A2:A10  B2 B10 -1) (16) SEQUENCE (Excel 365) =SEQUENCE(5 1, 1 2) =RANDARRAY(3 2 1 100, TRUE) RANDARRAY (Excel 365) (17) A2A10,B2B10, "NA") (18) XLOOKUP (Excel 365` =XLOOKUP("John" =XMATCH(100, A2 A10, 0) (19) XMATCH (Excel 365) =LAMBDA(X x1०)(५) (20) LAMBDA (Excel 365) =LET(X. A1*2, y x+10, y) (21) LET (Excel 365) =ISNUMBER(A2) ISNUMBER (22) =TODAY() (23) TODAY (24) NETWORKDAYS =NETWORKDAYS(A2 82) (25) YEARFRAC =YEARFRAC(42, 82) A1=2,"Two", TRUE "Other") (26) IFS (Excel 365) =IFS(A1-1 "One"
    13
    10
  • M.A Computer Classes - Author on ShareChat
    M.A Computer Classes
    How to remove surname #EXCEL EDUCATION #excel2007 #tips & trick #computer education #msexcel
    How to remove surname, EXCEL EDUCATION
    8
    19
  • M.A Computer Classes - Author on ShareChat
    M.A Computer Classes
    How to freez row & column|| #excel #tips & trick #excel2007 #EXCEL EDUCATION
    How to freez row & column||, excel
    10
    14
Home
Explore
Wallet
Video