High, Medium, Low – visual categories – In-Depth
Please read the previous article so that you understand the context of this article. In the previous article we saw how to divide available data into three categories: High, Medium,
Please read the previous article so that you understand the context of this article. In the previous article we saw how to divide available data into three categories: High, Medium,
We get lot of data and reports every day. Usually, to understand the information easily, we draw charts. Nothing wrong with that. Except that there are other methods available which may
Fourth article in Error Handling (Background Error Checking or Green mark) series. Read these articles first to maintain continuity.Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!Green
Fourth article in Error Handling (Background Error Checking or Green mark) series. Read these articles first to maintain continuity. Auditors, Risk Managers, Everyone: Did you know? These green marks are
This is a continuation of the series on error handling – green marks. We will see how to handle Excel formula errors and two Text related (non-formula) errors in this
Green mark in top left corner of Excel cells is an indication that something is wrong with the data you see. Read this article first to understand the concept: Auditors,
I am sure we see these everyday across almost all Excel files. But do you know the meaning and significance of these green marks? These are WARNINGS – it is
Experts tell us the best practices. But we do lot of mistakes before we can find the best way. Documenting the mistakes – which is what I call “Worst Practices”
This is a common problem – which conditional formatting apparently does not solve. But that is not true. If you use FORMULA based conditional formatting, this problem has been solved
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
