Reducing DSO using Power Pivot
One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens.
One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens.
Many accountants consider that cash flow statements are the most important indicator of a company’s performance, as they do not involve estimates or judgments of the preparers.
A common accounting task is to consolidate the financial results of subsidiary companies into combined results of a parent company. A parent company can have one or multiple subsidiaries.
For me, whenever I am new to a concept, and I read a statement like the one above, I often say “Well that’s great, but just what does that mean?” I am a big believer in mental models or ways of visualizing the flow of execution.
P3 Adaptive has tried many different flavors of our brand of “consulting” through the years, but co-development projects that combine real projects with coaching and knowledge transfer have turned out to have been the sweet spot in terms of success.
n today’s fast-paced digital world, information is power, especially when it comes to mastering the intricacies of software development and deployment.
After completing the Part 3 extension of Rob’s Dynamic TopN Reports via Slicers, Part 2 post, I did not plan on a forth installment.
After Rob posted Dynamic TopN Reports Using PowerPivot2!, I downloaded the workbook from the provided link to examine how his “tricks” were done
OK, picking up from Tuesday’s post, with the goal of explaining the techniques. And remember, you can download the workbook here! Two Disconnected Slicers Ah, another favorite technique. Slicer tables […]
Way back during the period of the first CTP of Gemini (which later became PowerPivot), I was working with a data set that included a column of month numbers
On Tuesday, in my intro to David Hager’s post, I promised to circle back “later today” and add some follow-on thoughts. Well, ONE of those words ended up being truthful
After a long hiatus, David Hager has returned with a new guest post. He has a clever Excel trick/formula for applying different conditional formatting “acceptable ranges” depending on the context of the current row. In his work, different Tests have different acceptable ranges of values that qualify as Pass/Fail/Warning