The last week I’ve been spending time learning more about Power Queries, advanced editing of those queries with M, and being able to use Slices as a type of easy to access filter. I have also been exploring the suggesting of using True/False as the values 1/0 to get away from using Nested If statements in order to streamline formulas.
I found out that Google Sheets is implementing some of the same tools Excel has with the slices https://gsuiteupdates.googleblog.com/2019/08/sheets-slicers-scorecards-themes.html and want to explore more with that for creating easy to view sheets for others to use
Example for true false uses:
=rept(“Canine”, –(search(“dog”,a1)>0))& rept(“Feline”, –(search(“cat”,a1)>0))
The use of Power queries to manipulate 1 or more CSV files to either automatically filter for desired data sets and compare against other lists or combine multiple sets of data (250,000+rows) and filter them to display only the relevant data (~45,000 rows) has helped streamline review processes for my billing procedures.
Pierce's Blog 