It is straightforward to compare values between each row in an Excel table and the next row. You can create a calculated column in a table and reference values in other columns in the same row by name and cells…
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. While indirect method cash flow statements can be prepared easily from P&L…
I don’t like to answer these or similar questions: “What is your career path?” “Where do you see yourself in five years?” “…in ten years…?” I generally find it hard to answer questions about what I do, because my…
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. Each subsidiary can also have one or multiple subsidiaries beneath it.…
How often do you think about quality checking your reports? Sounds about as fun as listening to a lecture from Ferris Bueller’s professor, right? Why Test? Quality testing is one of those things that few of us enjoy but is…
Not long after I started my career in FP&A, I became interested in KPI development. It’s a natural progression I think: you get the budgeting, forecasting, and reporting under control, and then you begin to dig a little deeper. When…
I wanted to share my experience more as a thank you than as a technique to share. About a year ago, I moved into a new role in health care as a clinical performance analyst. My previous experience easily qualified…
Recently I was teaching a private course on Power BI to one of our clients. We were learning about the ALL() function and how to use it to get % of total calculations. After demonstrating how to get an individual…
Figure 1 View outside of my home office window May 2nd, 2018 Fairbanks, Alaska. Intro Hello, my name is Matthew Brice and I am guest broadcasting from my home office (via tape delay) in Fairbanks, Alaska. PPPro put out a…
I read this blog (and Matt Allington, and Ken Puls) pretty religiously. But PowerPivotPro is probably my favorite because it deals with a lot of real-world situations, not just technical solutions. So, I’m going to continue that theme and…