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
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
I see lot of movies. I am the First-Day-First-Show guy. Usually, I post the Movie Rating on my personal FB page. See some examples below. But recently I posted a
Yes. This long-awaited feature is finally here with Office 365 Pro Plus (May 17). This is a short article showing the steps. Detailed video coming soon. Ability to Change Pivot
Cross-tab data is where you have row headings as well as column headings. Consolidating (combining) multiple blocks of such data is a laborious process. Usually the rows and columns do
Here is a fast paced, 8 minute video which will revolutionize Pivot Report Sharing. Using OneDrive or SharePoint, control the visibility and provide full interactivity. Reports render instantly even with
This article is for CFOs, CEOs and other members of Senior Leadership Team. It requires just 10 minutes to read. But it will reduce your personal as well as organizational
Here is the list of articles I have written about Show Values As in Pivot table. This is a very important set of features but are mostly ignored.
Here is a new year gift for the Indian customers. Converting Amount to Words is always a problem. Many application require it and that code is always written manually, within
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.
