- Got Sheet
- Posts
- 4 Excel Hacks You Need to Know
4 Excel Hacks You Need to Know
How to search and filter your data sets
Eamonn Cottrell
October 01, 2024
In today’s email:
Three ways to search for values in a dataset
A bonus way to Filter values
How to create a legit search bar inside your Excel workbook
HEADLINES
Two formulas are now generally available in Excel: PIVOTBY() and GROUPBY()…I’ll have videos coming soon about these.
Microsoft really wants you to use Copilot in Excel…I think it’s better for beginners for now
Gemini can now generate structured tables in Google Sheets. Rolling out now for rapid release domains and Oct 17 for scheduled release domains.
Got Sheet is brought to you by beehiiv. Newsletters made simple.
Check them out for 20% off your first three months…try beehiiv now.
MAIN ARTICLE
These functions are extremely useful. I’ve used different combinations in tons of workbooks when I need to search for entries in a dataset.
I walkthrough four unique ways to search for data in your Excel workbook. The last way is my favorite because it creates a search bar that returns all matches for a search term.
Video training:
You can click above to go to the video or select the section of the video below that you want to skip to.
MATCH
SEARCH
EXACT
COUNTIF
FILTER
Got Sheet is brought to you by Coursera. If you learn well with structured courses, check them out for 30% off Coursera Plus…try them now.
NEXT STEPS
Whenever you’re ready, here’s how I can help:
Business tech stack (FREE)
My recommendations for software and tools I use to create content and run my online business.Sponsor Got Sheet
Got Sheet teaches business operators, teachers and entrepreneurs how to get good at spreadsheets. Interested in sponsoring an issue or a series of Got Sheet newsletters? Reach out to get more information.Personal budget tool
As a Got Sheet subscriber, I want you to have a 75% discount on the personal budget I built 10+ years ago and am still using to this day.
Reply