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
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
