Excel: Finding This, There Deep Dive*

Melissa Esquibel, MCT

Sunday, July 21 | 10:15 a.m. - 4:00 p.m.

We’re not getting any less data. And we’re being asked to extract more and more information from it. From VLookUp formulas to advanced filtering and sorting, to getting cells to automatically change color, there are great tools and techniques to keep you from squinting at your screen trying to find the needle in the haystack. This session will even show you what to do when the thing you’re looking for is in plain sight, but Excel disagrees! There are techniques for every Excel skill level. This fun, fast-paced session will take your Excel proficiency up a notch or two and send you back to the office with real solutions to everyday “where the heck is it” problems. The course is applicable no matter which version of Excel you are using and on which platform. Most techniques will also transfer to Google Sheets.

Key Points You'll Learn:

  • At least three or more workable solutions for finding specific values in your data, fast
  • What “dirty data” is and how it can impact your reports and analysis
  • See data the way Excel does, which will help you uncover even more tools that are built right in the application