We spend lot of time in data cleaning. But there is no simple definition of exactly what clean data means. Therefore, I created a simple 10 item checklist. If all
Just released Excel Tables comprehensive video. Have a look. It shows many benefits of using Tables like automatic formula copy, dependents update, structured formulas, automatic headers, easier import in Power
New and very useful feature for artists and designers. Specify accurate colour value using HEX code instead of RGB or HSL. What difference? Well, HEX codes are most commonly used.
If you post a long video to YouTube, it is a good idea to add a Table of Contents to the description. This helps viewers go to specific topics quickly.
The old comments are now called “Notes”. The New Comments are actually discussion threads – like in Word. You can type a comments and others can reply to it. Spend
This content is relevant only if you are a CIO (or IT decision maker). Here is the video of the session I conducted at CIO Power List event on 4th
If a cell has no data in it, the data from the cell on the left side spills over it. This can lead to confusion while reading and understanding the
Excel Data Model is a database that is built-in to Excel. It has been around since 2010. Using it increases the capacity of Excel to handle millions of rows, it
If you use Office 365 Pro Plus and Excel 2016, you should see a new tab under File – Options. The Data tab. This has many useful features which help
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.
