Frequently, you will find yourself creating a same IF function (or any other function) over and over and over and over… So why don’t we just create the function ONCE and then keep re-using this function over and over and over…? Read more to find out how to build your own custom function exactly fitting […]
Month: August 2017
Excel Tranining for PPC? Try Power Query Instead
Looking for Excel training for PPC? Try Power Query instead and stay miles ahead of your competition. Power Query (aka Get & Transform) is a set of Excel features which can totally replace standard Excel which is slow, inefficient and too complicated to use. Power Query (Get & Transform) is an official Excel extension built […]
List Functions: an Elegant Way to Manipulate Text
List functions can become your favorite set of functions if you often need to manipulate text (aka “keywords”). You are now probably wondering what “list” function even means in Power Query. Basically, a “list” is a special object whose elements can be easily manipulated separately. ***Tip: Have a question? Ask in the comment section below […]