The whole idea of a Dashboard is to provide a graphical interpretation of the most relevant data, such as a balanced scorecard. Moreover, the updating of new data into the dashboard every week or month should be automated as much as possible. This is where the data model becomes crucial if you want to achieve […]
Here are some cool options for entering data quickly into an Excel worksheet…
When you spend a lot of time entering data in Excel it helps to understand the tools available to you to speed up data entry. Here, I’ll show you a range of Excel features which make entering repetitive data much easier.
The main benefit of connecting to external data from Microsoft Excel is that you can periodically analyze this data in Excel without repeatedly copying the data, which is an operation that can be time-consuming and error-prone. After connecting to external data, you can also automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.
If you have data from an alternative source, you may be able to import it into Excel 2010 instead of having to re-enter all the information again. Depending on the type of data you would like to import, you can select from a number of options. We’ll look at one of the most common import types – a text file.
To make sure you’re making your data as convincing as possible, you should always customize your graphs in Excel. And by customization, we’re not talking about big sweeping changes. Below are some quick tweaks you can make to your graphs convincing, easy-to-read, and beautiful.
We are often asked by Microsoft Office power users whether, why, and when they should use Microsoft Access versus Microsoft Excel. Especially when they are very comfortable using MS Excel and don’t understand the reasons why anyone would use MS Access or databases. Here’s our perspective.
Learn to handle #N/A error values to make charts look more presentable
Lately there has been great interest in lightweight in-cell charting, using worksheet formulas and sometimes a special font, to display values graphically.
The world today has way too much data, but very little information. In this tutorial I’ll show you how to convert your data into powerful information by selecting the right charts for expressing them.
Structured references make it much easier and more intuitive to work with table data when you are using formulas that reference a table, either portions of a table or the entire table. They are especially useful because table data ranges often change, and the cell references for structured references adjust automatically. This minimizes the need to rewrite formulas as rows and columns are added and deleted in a table, or when external data is refreshed.