Search

# Tag: Formulas

###### New Excel Functions – Live Event

Let us welcome the new year 2021 by learning some new Excel functions. I am conducting this live event on Saturday, 16th Jan at 3 PM India time (UTC +5.30).

###### IFS function: Goodbye nested IFs

With Excel 2016 and Office 365 Pro plus, a less confusing and powerful function was introduced – IFS function. It eliminates the confusion generated by multiple nested IFs for complex

###### Excel Function Warning – The Yellow Triangle

When you type  something in a cell after an = sign in Excel, a list of functions is shown.  Functions have an icon next to them. For some functions, the

###### Excel IF function – Dos and Don’ts

So far, I have not written an article about the humble IF function. But in the last few months I came across many customers who asked me to explain how

###### How to Sum visible cells only in Excel

This is a picture blog. Self-explanatory! Learn how to Sum visible cells only using the Aggregate function. Works only in vertical direction (not horizontal). It is best to use it

###### Excel Tables 10 – Everything is in a name

Like column names, table names can also be used in formulas. Read the previous article to understand the context.

###### Excel Tables 9 – Readable Formulas in Calculated Columns

Readable formulas in Excel tables are so nice, you will curse yourself for not noticing earlier (since 8 years!). Teach this to everyone around you – NOW! Show off

###### Excel Tables 6 – Miraculous Formula Auto-Copy

Most probably, you have been missing this Auto-copy feature for the last 8 years. Take 3 minutes to find out how it can simplify your life and increase accuracy.

###### Excel – Impact Analysis – Trace Dependents

The Need: Trace Dependents Excel workbooks are complex. Multiple persons share and handle the same file. We keep mailing them to each other. Often the person who created the file

## 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,745 other subscribers