701 подписчиков
68 видео
CONDITIONAL FORMATTING ! ADVANCE EXCEL TOOL! Formating data as you type date or number
List of Files in Folder to Excel | in just few click| Power Query
Say Goodbye to Manual Splitting: Discover new TEXTSPLIT Formula in MS Excel
Restrict Data Entry in Cell - Based on entry in another cell | MS Excel
Discover the Art of Advanced Filtering - Transform Your Data World (Part-2) - Multiple criteria
XLOOKUP with Multiple Lookup Value | Advance EXCEL Feature
Doughnut Progress Circle Chart in Excel as NEVER seen before!
Discover the Art of Advanced Filtering - Transform Your Data World - (Part-3)-Extract filter only
3D Sum Formula in MS Excel. Saving Tons of Time.
MS Excel to create a Half Donut Chart and visually represent your data in an eye-catching way
Pivot Unpivot Data in MS Excel by Using Power Query. You will be surprised at how easy it is.
Convert Pivot Table Values to Crores: Simplify Your Data in Excel
Large & Small Formulas in MS Excel - Less Known but very powerful
Magic of the UNIQUE function in Excel – Say no to duplicates!
Discover the Art of Advanced Filtering - Transform Your Data World (Part 1)
Discover the Art of Advanced Filtering - Transform Your Data World (Part-6)-Shortcut to launch
DEPENDABLE DROPDOWN | ADVANCE EXCEL | By using Excel 365 Formulas
Mastering Excel: Uncover Hidden Insights with Advanced Data Comparison Techniques
Discover the Art of Advanced Filtering - Transform Your Data World (Part-4), - And/OR/wildcards
One Pivot Table from two or Multiple Tables - Power Pivot | Very Easy & Useful
Actual vs Budget Chart with Variance Analysis with Emoji Indicators 🟢🔴👍
Justify your Text in Excel | without using Wrap & Merge | Very Useful Excel Feature
Multiple Value Lookup in Single Cell (By using UNIQUE & TEXTJOIN FORMULA)
OFFSET function in Excel - To make your Cell reference Dynamic | Mysterious formulas, One must learn
AGGREGATE Function in Excel – The Advanced SUBTOTAL You MUST Use!
Get Financial Year and Quarter from Date in MS Excel with formula.
Pivot Table from Multiple Excel Workbook by Power Query in MS Excel. Should not Miss this video.
Dynamic Array Excel365/2021| Get Value in Multiple Cells | Change the way you write Formula in Excel
Excel Magic: Send Emails Without Coding! Hyperlink Hacks for Email Wizards 🚀✉️
Multiple Value Lookup in Single Cell | Very simple after 365 formulas
Search multiple files in folder by using Excel 365 - TEXTJOIN -Don’t miss out on these expert tips
Table Range - Excel Formula Typing with Ease
Auto Currency Conversion in MS Excel - New Feature ~
Transform Your Excel Charts: Highlight Highs & Lows with Dynamic Colors!
XLOOKUP IN ADVANCE EXCEL | WITH DYNAMIC LOOKUP RANGE
