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).
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
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
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
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
Like column names, table names can also be used in formulas. Read the previous article to understand the context.
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
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.
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
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.
