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.
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.