# Excel & VBA

> Excel & VBA portfolio: custom VBA functions, one-click invoice PDF export, Excel dashboards and automatic sorting & filtering macros.

Source: https://dataikseer.com/excel-vba

Macros and automation that make Excel work like software. Download the sample files to see each scenario in action.

[Excel & VBA](https://dataikseer.com/excel-vba) [Sheets & Apps Script](https://dataikseer.com/google-sheets-apps-script) [Dashboards & Power BI](https://dataikseer.com/dashboards-power-bi)

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

[Download sample file](https://assets.zyrosite.com/Yg21bxajEpuW13pj/custom_function_through_vba-YNqJrkW3nqH2Kj5z.xlsm)

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

[Download sample file](https://assets.zyrosite.com/Yg21bxajEpuW13pj/invoice_pdf_export-mP4pQylNOyhB9oBg.xlsm)

### Customer Success Dashboard

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

[Download dashboard](https://assets.zyrosite.com/mP4O89XoXRHvly7G/excel-customer-success-dashboard-A85VD34QJlsr5ped.xlsx)

### Sales Performance Dashboard

Visualize team, product, and regional performance with precision. This 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

[Download dashboard](https://assets.zyrosite.com/mP4O89XoXRHvly7G/excel-sales-performance-dashboard-YNq2D8P6zLir769G.xlsx)

### 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 a sheet. It's like having a secret weapon that takes the hassle out of organizing and filtering data.

[Download sample file](https://assets.zyrosite.com/Yg21bxajEpuW13pj/sorting_and_filtering_onedit_or_user_input-YD0p4RK8Rei3LqZY.xlsm)

## We're just a click away.

Need Excel to do something it doesn’t do yet? Tell us what you need.

[Chat on WhatsApp](https://wa.me/message/MCCD3YCRKQZ5H1) [Email us](mailto:contact@dataikseer.com)

---

## Contact Data Ikseer

- WhatsApp / phone: +92 311 1031453 (https://wa.me/message/MCCD3YCRKQZ5H1)
- Email: contact@dataikseer.com
- Address: Saify Foundation Building, 2nd Floor, #202, Mansfield Street, Dr Syedna Mohammed Burhanuddin Road, Saddar, Karachi 74100, Pakistan
- Hours: Monday–Saturday, 9am–5pm PKT (GMT+5)
- Contact form: https://dataikseer.com/contact-us
- All pages: https://dataikseer.com/llms.txt
