Sometimes, due to some improper setup of Microsoft Excel or incomplete components for Microsoft Office, direct connection to Excel files may not be possible. Please follow these steps before going forward http://support.microsoft.com/kb/209805 Verify that the Regsvr32.exe file is in the …
Posted in Excel, How-to, MS Access
No Clutter Don’t clutter your dashboard with unnecessary visual elements and data. If it looks too busy, then it will fail to communicate the data effectively. Don’t include every bit of data in a dashboard. Seperate them into separate dashboard …
Posted in General
Previous - Excel Dashboard Tutorial - 11 How do you share your Excel Dashboard with users? Now that you have built the dashboard, you can share the dashboard in multiple ways. " Create a PDF output of the dashboard and …
Previous - Excel Dashboard Tutorial Summary We built the above dashboard completely from scratch. We defined Calculations We defined date hierarchies We built Date Filters We built Date Parameters We built Bar Charts We built Pie Charts We cleaned the …
Previous - Excel Dashboard Tutorial - 9 Cleanup - Resize and Organize Give appropriate names to each portlet. During the chart creation if we did not provide names, now is the time to provide them. Right click on each title …
Previous - Excel Dashboard Tutorial - 8 Finish the Dashboard Design and Development By now, your dashboard is quite chaotic. You have objects all around your dashboard canvas with different sizes. We will start the process of finishing our design. …
Previous - Excel Dashboard Tutorial - 7 Create Pie Chart We will now create a pie chart by product name It is nice to know that the revenue distribution is not dominated by a single product. We can …
Previous - Excel Dashboards - 5 Create Year and Category Parameters Remember, we have not built any charts yet. It is very important that we build our foundation Qlet and its corresponding parameters so that all of the drop down …
Previous Article - Create Excel Dashboards - 4 Add Date Hierarchy Columns Most of the data, has some form of date information. Now date is very granular information. Very often, to generate trending information, you need to derive year and …
Previous Part Build Excel Dashboards - 3 We will Add Calculations and Formulas Add CalculationsSince this is a raw extract of actual transactions, it may need to add additional calculations and columns to create useful metrics. For e.g in our …
Posted in How-to