Contents The post Excel Slicers – filter data and pivots appeared first on Efficiency 365 .
https://efficiency365.com/2023/02/03/excel-slicers-filter-data-and-pivots/
Excel VLOOKUP is a very common and popular function. It is now superseded with the XLOOKUP function. Still it’s popularity is not going down. This video (in English and Hindi) covers all variat...
https://efficiency365.com/2020/05/05/excel-vlookup-all-variations/
We have already learnt how to import and clean data from various sources using Power Query (Transform). Once the data is inside Power BI Data tab (or Excel Data Model of Power Pivot), we can refi...
https://efficiency365.com/2020/05/03/enhance-data-after-import-using-power-bi/
Using Power Query, this type of work is extremely painless and quick. What’s more it refreshes data in just a click when more files are added. The post Combine data from multiple files / shee...
https://efficiency365.com/2020/04/27/combine-data-from-multiple-files-sheets/
This is a part of data clean up series based upon the 10 rules for clean data. This video covers rules 1, 5, 6, 10 – cross-tabs, data growing horizontally and multi-layered headings. The post...
https://efficiency365.com/2020/04/24/cross-tab-and-multi-layer-header-cleanup/
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 10 items are correct, data is cl...
https://efficiency365.com/2020/04/21/10-rules-for-clean-data/
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 ...
https://efficiency365.com/2020/04/19/save-15-mins-with-excel-tables/
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. RGB or HSL requ...
https://efficiency365.com/2020/02/29/enter-hex-colour-in-office/
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. In my case, I post the video link + TOC on ...
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 4 minutes to learn about ...