Search

# Tag: Formulas

###### 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

###### Using Formulas in Microsoft Word tables

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

###### Green Marks Part 5/5 (Background Error Checking in Excel)

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

###### Green Marks Part 4: Inconsistent Formulas

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

###### Green Marks Part 3: More error handling

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

###### How to apply conditional formatting across the row

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

###### Automatic formula copying in Excel (even with blanks)

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

###### How to edit a formula in Excel

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

###### 9 benefits of using Excel Tables

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

## Pivot Table Pro Course

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.

## Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

##### Subscribe to Blog

Join 1,755 other subscribers