Your trusted resource for learning new technologies. We've been providing tutorials, references, and step-by-step instructions since 2003. TechOnTheNet.com is a great place to learn a new technology, or find a quick reference. It has never been easier to learn Database technologies, Microsoft Office products, and more!! Don't forget to subscribe to our channel for upcoming tutorials! Visit us at: www.techonthenet.com or follow us on: Facebook: facebook.com/techonthenetcom Twitter: twitter.com/tech_on_the_net Google+: plus.google.com/+Techonthenetcom Pinterest: www.pinterest.ca/techonthenetcom/
best youtube channel ever i follow. you do not waste time, just focus on mail point which is less time consuming for the viewer. thanks a lot for your effort.
Is it different if I want to search the last letter of a word? For example; if I wanted to search for d as the last letter, would I have to do WHERE first_name LIKE '%d' or would I still use the same process which is WHERE first_name LIKE "d%'
I'm in college and have been busy with excel for more than a month. I'm preparing for a test based on excel and after watching your videos I fully understand all the functions I've been struggling to learn.
vlookup - you provide one table (as a parameter) that contains both your lookup and return values and the value you are searching for MUST be in the first column of the table. xlookup is the next generation lookup function where you provide two arrays (as parameters) - one rray to search for a value and a second array to return a value. It can perform either a vertical or horizontal lookup (basically replacing vlookup and hlookup).