Business Intelligence
We design and engineer custom Excel dashboards to monitor all your objectives and key results. We create custom queries to retrieve your data, allowing users to update their views with a single click in real-time. Our dashboards allow all project stakeholders a straightforward and quick status snapshot. We will create a beautiful and simple dashboard with charts, pivot tables, conditional formatting, and whatever you need to understand your data.
We specialize in developing Excel education programs tailored to your individual needs. Whether a single person is new to Excel or an entire team of Excel super users, we can build a curriculum to help build knowledge, expertise, and confidence. Our seminar series differs from traditional training as it offers an opportunity for users to bring their data, challenges, and collective skill sets to improve the Excel knowledge of the entire team.
We also provide spreadsheet development and repair. Maybe you just have a formula that needs a little tweaking? Or perhaps you have data in an old database you cannot easily access? We can assist with all formulas, data retrieval, analysis, charts, pivot tables, macros, and basic custom Visual Basic functions.
Case Study 249 - Automated Repair for a Winelist
We wrote a macro to help maintain a sommelier’s list kept in Excel
Case Study 201 - Custom Excel Function
A Visual Basic for Applications (VBA) function that returns true if a given year is a leap year
Case Study 375 - Macro to Round All Numbers on a Worksheet
Our client needed a workaround to clean up output from a legacy system