SEA vs GB NFC Championship Game: Visualized in Power BI Dashboard #
Articles Tagged: Dashboard
Excel Dashboard : PivotTables and Data Modelling
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 […]
7 Simple Tricks to Make Smart and Neat Excel Graphs
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.
Learn how to Organize Data to Make Consistent Pivot Tables & Charts
Learn how to organize your data to easily create consistent pivot tables & chart.
The easiest way to organize your data if you want to use the powerful tool of pivot table in Excel is to work by columns with titles on first row, such as the example below:
How to Reduce Size of Excel Files? – Top 10 Tips
Did you ever wonder why your Excel File is so huge while it actually has very little information?
When you receive an excel file it was in KBs but when you make changes and save, file size surprisingly increased to MBs!! Fortunately there are several ways to overcome this problem, this article will help you learn the Top Ten Awesome Tips & Tricks to Reduce Excel File Size to a great extent without losing the actual content.
How to handle #N/A error values to make charts look more presentable
Learn to handle #N/A error values to make charts look more presentable
Excel tip: Instant in-cell graphs with worksheet formulas
Lately there has been great interest in lightweight in-cell charting, using worksheet formulas and sometimes a special font, to display values graphically.
Choose the Right Chart Type for your Data
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.
How to create a dynamic chart
We all know that to make a chart we must specify a range of values as input. But what if our range is dynamic and keeps on growing or shrinking. Wouldn’t it be cool if the ranges were dynamic and charts get updated automatically when you add (or remove) rows?
Automate Excel Charts in Two Keystrokes
Today I’ll show you how to automate an Excel chart with just two keystrokes. I’ll first show you the typical way that most users accomplish adding data to a chart, and then I’ll share the simple technique that eliminates this mundane need.