Efficiency365 Test 6: Excel : Copying Formulas
Yes, you have been copying formulas for decades. I know. But you don’t know the most efficient method – most probably! Try it out. Spend just 4 minutes of your
Yes, you have been copying formulas for decades. I know. But you don’t know the most efficient method – most probably! Try it out. Spend just 4 minutes of your
Did you know Word can contain formulas? Yes. It can. For simple calculations you don’t need to use Excel. Estimated learning time 5 min
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
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
Imagine that you have 50,000 rows of data. You want to add a new calculated column. Adding the formula is easy. But copying it to 50,000 rows is nothing but
Yes I know you have been using formulas in Excel for decades. But just trust me… there is more. Here are some small but nice things you should know when
If I have to teach ONE thing to the world, it would be Excel Tables. I recently created this video for a Microsoft Webcast. Excel Tables were introduced in Office
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.
