Richard Harker retweeted
Nice! Microsoft 365 worksheets now have a lock indicator when an @msexcel sheet is protected.
Richard Harker retweeted
How to use the SUMPRODUCT function in Excel - #excel excelzoom.com/use-sumproduct…
Richard Harker retweeted
Forward and reverse lookups for the last occurrence of lookup criteria #MSExcel #datascience #businessintelligence #Analytics
Richard Harker retweeted
Ending a presentation with a "Thank You" slide is like ending a great date with a handshake.
Richard Harker retweeted
Tom's Tips For #Excel: Fast shortcut to apply a border around the selected range is Ctrl+Shift+& Remove borders Ctrl+Shift+_ (underscore)
Richard Harker retweeted
Tom’s Tutorials For #Excel: Finding and Deleting Phantom Links
bit.ly/1rD356Z #analytics #BI #DataScience
Richard Harker retweeted
Tom's Tips For #Excel: Sum every other row, odd: =SUMPRODUCT(A1:A30*(MOD(ROW(A1:A30),2)=1)) To sum just even rows change =1 to =0
Richard Harker retweeted
Tom’s Tutorials For #Excel: Rounding Elapsed Time by the Half-Hour
bit.ly/16kYJ9V #BI #data #charts #spreadsheet
Richard Harker retweeted
The new World Cup trophy design. #FIFACongress
Richard Harker retweeted
Replying to @excelmate
@excelmate A unique MVP gathering #AmsXLSummit on Apr 13-14 2015. Would you pls retweet? Thanks topexcelclass.com/index.php/… …
Richard Harker retweeted
Replying to @excelmate
@excelmate anyone not taking up your tip on forcing Option Explicit in @msexcel VBA is welcome to contact me for free mental assessment. – at Sydney, New South Wales
Richard Harker retweeted
Replying to @excelmate
@excelmate Hi Richard, I just released an infographic that your readers may be interested in myexcelonline.com/blog/excel… Feel free to share. John
Richard Harker retweeted
Power Query – The Round Function excelguru.ca/blog/?p=857





















