Ambika Aggarwal – XLCubed Blog

Lessons from IBCS – Maintaining Visual Integrity

Ambika Aggarwal — Fri, 14 Aug 2020 07:46:24 +0000

When reading reports and dashboards, we often find ourselves spending more time than we’d expect analysing the charts and tables tying to comprehend the data. In many cases that’s due to inconsistencies in the presentation, or poor design. Ideally a report should convey the message clearly and quickly. One of the underlying rules of IBCS […]

The post Lessons from IBCS – Maintaining Visual Integrity appeared first on XLCubed Blog.

Updating SQL Tables from Excel

Ambika Aggarwal — Thu, 05 Mar 2020 15:55:02 +0000

Most of our customers use XLCubed for reporting, analysis and data visualisation, but an increasing number use it for data updates, either within budgeting and forecasting solutions or in niche applications. XL3RunSQL is a neat method for running SQL updates from Excel, and allows users to build input forms (which can ultimately be web-enabled) quickly […]

The post Updating SQL Tables from Excel appeared first on XLCubed Blog.

Rolling Actual and Forecast Reporting

Ambika Aggarwal — Tue, 27 Aug 2019 12:24:01 +0000

It’s a very common requirement in financial reporting to show actual and forecast data by month across the entire year. Often, we are focusing on the expected year end position so we will want to use the actual data where it exists, and the forecast data where it doesn’t so that the year-end total becomes […]

The post Rolling Actual and Forecast Reporting appeared first on XLCubed Blog.

Usage Metrics in XLCubed

Ambika Aggarwal — Mon, 22 Jul 2019 10:09:44 +0000

With a wide range of reports being accessed and published daily, it is important for administrators and management to be able to keep abreast of their usage. Common questions are: What reports are being published? How many reports have been updated? How long are they taking to open? Who is publishing the reports? Which reports […]

The post Usage Metrics in XLCubed appeared first on XLCubed Blog.

Optimizing Excel Reports on Mobile Devices

Ambika Aggarwal — Wed, 15 May 2019 09:38:07 +0000

Want to view your Excel report on a mobile device? Tired of having to zoom in on your data? Well then look no further, XLCubed has you covered! With the XLCubed Mobile App, you can take your Excel reports with you. Workbooks published to XLCubed Web can be accessed by other users on any mobile […]

The post Optimizing Excel Reports on Mobile Devices appeared first on XLCubed Blog.

XLCubed: A Beginner’s Advice

Ambika Aggarwal — Thu, 02 May 2019 09:20:24 +0000

I have been working with XLCubed for approximately two weeks now and when I first started, I wasn’t sure what to expect. I had come from a Mathematics background and so had no in-depth technical IT background. Over the last two weeks, my main priority has been to get to know XLCubed like the back […]

The post XLCubed: A Beginner’s Advice appeared first on XLCubed Blog.