Richard Harker (@excelmate) header
Richard Harker (@excelmate) profile picture

Training & advice in Excel, Access, MSProject, Primavera, SQL, VBA, Captivate & Oracle purchasing

Crawley UK
Joined January 2011
Photo by Richard Harker (@excelmate)Photo by Richard Harker (@excelmate)Photo by Richard Harker (@excelmate)Photo by Richard Harker (@excelmate)Photo by Richard Harker (@excelmate)Photo by Richard Harker (@excelmate)Photo by Richard Harker (@excelmate)Photo by Richard Harker (@excelmate)Photo by Richard Harker (@excelmate)Photo by Richard Harker (@excelmate)
Nice! Microsoft 365 worksheets now have a lock indicator when an @msexcel sheet is protected.
9
36
Richard Harker retweeted
Boris Johnson commits his first faux pas…
1
2
1
9
Richard Harker retweeted
How to use the SUMPRODUCT function in Excel - #excel excelzoom.com/use-sumproduct…
2
2
4
Richard Harker retweeted
Forward and reverse lookups for the last occurrence of lookup criteria #MSExcel #datascience #businessintelligence  #Analytics
1
3
13
Ending a presentation with a "Thank You" slide is like ending a great date with a handshake.
8
56
1
76
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)
2
6
Richard Harker retweeted
Tom’s Tutorials For #Excel: Finding and Deleting Phantom Links bit.ly/1rD356Z #analytics #BI #DataScience
2
1
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
2
6
Richard Harker retweeted
Tom’s Tutorials For #Excel: Rounding Elapsed Time by the Half-Hour bit.ly/16kYJ9V #BI #data #charts #spreadsheet
2
2
Richard Harker retweeted
The new World Cup trophy design. #FIFACongress
1
120
63
Replying to @excelmate
@excelmate great course highly recommended!
1
1
Richard Harker retweeted
5
2
Richard Harker retweeted
Microsoft Excel Top Tip Number 30 #Training #IT #Excel goo.gl/SCtfj1
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
The Excel Daily is out! paper.exceldailynews.com Stories via @msexcel @excelmate @MrExcelArticles
Richard Harker retweeted
Healthy discontent is the prelude to progress. Gandhi
1
3
1
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
1
2
Richard Harker retweeted
Power Query – The Round Function excelguru.ca/blog/?p=857