I am a senior administrator in a financial company and now selectively looking to transition to a business analyst role. This course will be certainly helpful during the process. Thank you for sharing.
I watched so many video trying to learn more about VLookup. Your instructions are absolutely top notch. I learned a lot more from this video than any other video I watched on youtube,Thank you!
You're welcome 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
40:11 match function for vlookup 1:06:00 xlookup 1:10:00 if functions 1:22:00 nested ifs 1:30:00 IFS function (better than nested ifs) 1:38:00 count if and sum if
Thanks for the suggestion. You can playback the video at a slower speed if needed. If you need additional Excel training, there is plenty of it here -> ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
Hi Tony! If you are need of advanced Excel tips, that video offers quite a few. We have an Excel playlist with additional intermediate and advanced Excel tutorials -> ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
This is what I did =INDEX(GameApps,MATCH(H4,App,0),MATCH(G5:G8,GameApps[#Headers],0)) using the INDEX function. This works great, dynamic spilled array that changes when the selected item changes. I could not get Xloopup to do this dynamic spilled array.
Guys I know I am late to the party. but I really would like to learn this. I can't download the material. can you please help with that. either than that, great work. I am learning so much. thank you
Cannot say how amazing those tutorials are. I'm waiting to possibly start an assistant purchaser's course next month and I think that those vids will have saved me an unbelievable amount of time, by the end of my course. Thanks SO MUCH.
Thanks for the kind comments, Tony 🙂 If you haven't already seen them, plenty more Excel tips and tricks here ➡️ ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
I appreciate the videos you produce. I slightly changed your formula to =VLOOKUP($A$18:$A$20,Review,MATCH(B17:D17,$A$4:$H$4,0),FALSE) to create a dynamic spill array. This spills down. I then cop over to population and spill the other two columns. I tried to do a dynamic spill array for the range & match permitted me to do that, but it did not work right in the vlookup formula. Just trying to better understand all that can be done.
For those that can't any files its because its not free very misleading what gets sent to u is a few introductory courses nothing advanced so you can get these files for $25 a month honestly can't believe that this person didn't state that anywhere confusing the hell out of everyone
The files referenced for this video are free. The courses offered on our RU-vid channel consist of a portion of our complete courses. If we offered a 10-hour course free, we wouldn't have a viable business. Anyone interested in the complete course without ads is welcome to subscribe to our membership site.
Exactly! I love these tutorials, but I wanted the Excel file for another Simon Sez IT tutorial so I could follow. 30 hours later and I'm still waiting. I have been lucky a few times where the files appear from the web and I just save into my docs, but this one, and the one I viewed yesterday I had to enter my email address. Yes, we might be able to get these files "For Free", but WHEN?
We're glad you found the tutorial helpful! Thank you for watching and leaving your feedback. 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
Thanks Ronnie for taking the time to say thanks. We have additional DA videos here 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 Merry Christmas to you, and all the best in 2023!
Tony - I bought my HP Lap top overseas during the COVID pandemic, and with mine F3 alone doesn't work, however if you have a "fn" key (to the right of "Ctrl"), hold down "fn" key then F3 and it should work.
Glad you enjoyed it. Thanks for watching! 🙂 You may find my other free tutorials for various data analysis tools and services here 👉 ru-vid.com/group/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
@@SimonSezIT you are just replying to positive comments, many of us here, haven't received the files after confirming the e-mail. please address this..
@@SimonSezIT the link to download the files i cant access. But I signed up and I am glad to have an extended version of all of this. Thank you so much for sharing
If it is not in your Data tab by default, try right clicking on the ribbon, then select Customize the Ribbon and see if you can find what you need in the list of commands.
Follow along and download the Excel for Business Analysts files for this tutorial here: www.simonsezit.com/excel-biz-analysis-instructor-files/ We have additional free Excel training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u