Data Ikseer logoData Ikseer Let's talk
Home / Portfolio / Excel & VBA

Ms Excel · VBA · Power Query.

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

VBA custom functions
Custom VBA function adding ordinal suffixes in ExcelCustom VBA rounding function in Excel
VBA · Custom functions

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!

Invoice · one-click PDF export
Excel invoice with one-click PDF export buttonExported PDF invoice page generated from Excel
VBA · PDF export

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!

Customer success dashboard
Customer success dashboard with sales trends, delivery and satisfaction metrics
Dashboard

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
Sales performance dashboard
Sales performance dashboard by region, employee, customer and item
Dashboard

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
Auto sort & filter on edit
Excel macro that sorts and filters on user inputExcel sheet re-sorting automatically on edit
VBA · Events

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.

We're just a click away.

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