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)

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/

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.

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

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 :-)

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.

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

https://steemit.com/hive-102332/@gikitiki/excel-how-to-open-the-vba-editor

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.

https://steemit.com/hive-102332/@gikitiki/xlookup-almost-has-everything-i-need

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

Congratulations @theexcelclub! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You published more than 200 posts. Your next target is to reach 250 posts.

_{You can view your badges on your Steem Board and compare to others on the Steem Ranking}
_{If you no longer want to receive notifications, reply to this comment with the word STOP}

To support your work, I also upvoted your post!

Vote for @Steemitboard as a witness to get one more award and increased upvotes!

https://onedrive.live.com/?id=C96C234E2EC97E41%21170515&cid=C96C234E2EC97E41
- 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