Excel Knowledge Sharing week ending Fri. 20 Dec

Its Excel knowledge sharing time peeps :-) Have you published an Excel resource this week? Or maybe you found a resource online that really helped you solve a spreadsheet problem you had?

Well now is the time to share it (with a few simple rules)


  • The resource and knowledge you share must be related to Excel.
  • You must include a descriptive summary of the link you are providing. The title of the resource is not sufficient.
  • You must disclose if the link you share is your own work or a fantastic resource you found.
  • Users must be able to access the resource for free without signing up.

The comments section on this post is the only place you can self promote external links within Excel for ALL community, so get promoting and share your Excel knowledge today.

Excel For ALL community news

With a private beta test underway of a new Excel Community - Excel for All, I thought it was time to test a post published directly from my blog.

Although the testing is private testing, features such as publishing from a blog directly to the community are live. By publishing from The Excel Club to Excel for All, If you happen to be reading this on my blog, you can engage right here in the comments section below. This comment should also appear as a comment within the community. If you comment from within the community, it should appear right here on this blog. Let's hope it works!

Private beta testing is open to all those that have a steem account. Feel free to join in with the community!!

Cross posted from my blog with SteemPress : http://theexcelclub.com/excel-knowledge-sharing-week-ending-fri-20-dec/

Comments 9

I was determined to complete my excel post yesterday but alas it didn’t get finished. I’m gunning to make progress on it, though now probably won’t be until Monday.

I have to look for some sample data to work with since all the stuff I was using was confidential.

15.12.2019 00:54

Im looking forward to the article. For sample data I tend to use =RANDBETWEEN(Lower number, higher number)

15.12.2019 13:34

Oh and I forgot to mention, you can post directly to the community from any steem interface using hive-102332 as your first tag. You dont have to link to it in this post (although you can if you want) as this post is for Excel resources not published to the block :-)

15.12.2019 20:44

Thanks, I was browsing the site earlier I’m interested in poking around it more! I’ll give it a try when I post it up.

16.12.2019 00:44

Here's my VBA for a modified vlookup. (slightly different functionality compared to xlookup) I wrote it a while ago, but it's still fairly useful.


17.12.2019 20:53

Nice work. I had a read of it. I really love how it returns an array :-)

17.12.2019 22:23

This one is for anyone who would like to try VBA. But hasn't had a chance yet.


19.12.2019 17:12

- Wendy Bouchoux

This comment was made by a guest account using @steempress. Rewards will be sent to the user once they have a Steem account

21.12.2019 02:45