Ms Excel | VBA | Power Query
Macros | Automation
Custom Function with VBA!
Contrary to popular belief, Excel's built-in functions are not the only option available for complex calculations and needs. By utilizing VBA, we can develop custom functions that streamline our working and eliminate the need for long, nested functions and formulas!
Click Here to check the sample file and read the scenario
Design Invoice/Report & Export to PDF!
A client had requested a few features in Excel that would allow them to print invoices, use it like software, and save time and money. They required a specific design, drop-down menus to select customers, the amount in words, conditional formatting, and most importantly, the ability to export to PDF with just a single click.!
Click Here to check the sample file and read the scenario
Customer Success Dashboard
Powered by Google Sheets and designed with a user-first approach, this interactive dashboard helps track customer performance metrics at a glance. Filterable by state, acquisition channel, product, and year, it provides visual clarity on:
Monthly sales trends and regional patterns
On-time delivery performance and product return rates
Acquisition channel contribution (organic, ads, returning)
Customer satisfaction scores across multiple products
This dashboard empowers businesses to optimize customer experiences and drive better decision-making through actionable insights.
Sales Performance Dashboard
Visualize team, product, and regional performance with precision. This Power BI dashboard provides a comprehensive view of business health through:
Time-filtered sales trends from 2018 to 2019
Regional revenue mapping for strategic market targeting
Employee-wise sales performance to track individual contribution
Customer revenue rankings for focused relationship management
Item share breakdown to optimize product mix
With easy-to-use filters by year, region, sales rep, and item, this tool is ideal for business leaders seeking data-driven growth.
Sorting & Filtering onEdit or on user input!
This FIFA Scenario will save your time! It shows how Autofilter and AutoSort can do more than just the basics. With simple steps, you can use macros and sorting to simplify your tasks and it will just apply as you edit on a sheet. It's like having a secret weapon that takes the hassle out of organizing and filtering data.
Click Here to check the sample file and read the scenario
