Loading...

Follow TheSmallman.com | Blog on Feedspot

Continue with Google
Continue with Facebook
or

Valid
TheSmallman.com | Blog by Marcus Small - 2w ago
Microsoft have finally done it… created the XLOOKUP. The Index match versus VLOOKUP argument has been one that has boiled for a while ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
The following procedure will show you how to populate an Excel userform with the data in a file and send the edited data back to the ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
TheSmallman.com | Blog by Marcus Small - 1M ago
Over the past few days I have taken one of my infographics and weaponised it into a fully functional dashboard.  I took a baseline and ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
TheSmallman.com | Blog by Marcus Small - 1M ago
Excel has the ability to sort data into an order of your choosing.  The custom sort can be achieved with the assistance of a customised ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Photo by Victor Garcia on Unsplash This Excel VBA procedure will remove all of ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
TheSmallman.com | Blog by Marcus Small - 2M ago
Source - Brisbane Times - Article I happened across this article on the Brisbane ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
TheSmallman.com | Blog by Marcus Small - 2M ago
I recently gave an interview for a blog regarding my Excel journey ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
My good friend Liam Bastick is running The Excel Summit South again. I went last year and it was a genuine blast. Great presenters and a ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Latest iteration in the dashboard stable. I created this for a corporate client and it was so enjoyable. It is an Excel sales dashboard ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
The wildcard character and SUMPRODUCT are like oil and water, they just don’t gel well together. The beauty of SUMPRODUCT is somewhat ..read more

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview