Visual Analytics in Microsoft Excel Webinar: Raw and Uncut
Get the Download Files
Click here to download the files used in this webinar
What Happened?
Last week, I recorded a webinar for BhamQuants. Unfortunately, the video did not come through well on the webinar. So I rerecorded it on my own.
Unfortunately, I didn't really have time to edit it this week. So you get to watch it raw and uncut, mistakes and all.
I hope you enjoy!
Questions?
Feel free to ask them down below in the comments section.
Sign up to excel your life with tips, career advice, and more!
Session expired
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Hi Jordan, I really liked the way the VLOOKUP with the array for the column numbers. Is there a way to make the array dynamic? I tried several solutions, for example using match to get the column numbers and creating then the array, but nothing was working…
Not that I know of. The alternative would be to use an index/match function, which I think you could actually get to work but I’ve not tried it.