For my work I receive a few entirely text based emails for invoices, bank drafts, and some that are just informational that I commonly translate into either spreadsheets or into a Document. I have found that using GScripts accompanied with Regular Expressions has greatly helped me automate this translation process for a number of different …
Category Archives: Spreadsheets
Power Queries and Logic Statements
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 …
Pierce's Blog 