Excel Talkies
Sharing custom made solutions to automate day to day operational processes and provide analytical solutions.
Top Excel Features - To Improve Productivity
Customizing Format In Excel
Decoding SUMIF
Power BI - Control Visual Interactions
Interactive Buttons - Build User Interface In Power BI
PowerBI Top N Filter
Stock Connector - Excel Addins
Rank Function - Get highest and second highest value
Disable pivot reset of column width
Design Process Flow Diagram - Using Visio Addin
Excel - Xlookup (Matching Ranges)
Power BI - Custom Sort
Power BI Basics - Load, Transform and Visualize Data in Power BI
Power BI in Excel - Using Slicers
Indian to US Accounting Standards
Pivot options to add fields
Pivot table with inputs from multiple data sets
Handling Huge Excel Files