Wednesday, June 26, 2013

NFL 2012 Fixtures

This template is an overall fixture for NFL 2012 Season. The dates of upcoming games can be viewed as well as results for played games can be entered. The template automatically calculates the scores of teams to update the score history with new inputs. The score history has been aggregated by division, by conference and by overall league. With this template you will have a hands-on NFL monitoring tool in your hand and once the season is over, it will be a perfect archive to be kept in your records.



EU Energy Production and Import Statistics

Energy Production, Dependency and Import Statistics of European Union countries, from 1998 to 2008.



EU Tourism Statistics

Tourism characteristics of European Union countries.



Family Budget

Track and organize your family economy; member by member, category by category, period by period.



Revenue Forecast

This template is prepared for forecasting sales. 3 cases are analyzed: optimistic forecast, expected, pessimistic forecast. In the second sheet, comparison of 3 cases, monthly forecasted revenues and revenues by categories are displayed by charts.





Currency Tracker

Track daily changes at cross rates of world currencies and reach historical data list of 40 different currencies.



HR Dashboard 2

This template visualizes various employee and HR related measures in an interactive manner. It allows HR managers and senior management quickly view employee statuses including payroll, sick days, employee performances by year, location, department as well as by individual employee level. You can update underlying data with you own to customize with for your company.



College Enrollment Dashboard

This is a dashboard of the college enrollment data for the purpose of yearly enrollment analysis and analysis on the departments.



Manufacturing Dashboard

This template prepared for tracking and reporting production, labor, and sales activities of a multi-location manufacturing company. Dashboard reports can be generated by Month and Location interactively.



College Dashboard

This is an Excel based interactive dashboard visualizing demographic information and attendance statistics. The dashboard includes various interactive charts and data filters.



Sales Dashboard

This dashboard provides the following analysis for a selected period: Revenues by Industry, Revenues by Region, Revenues by Product and Revenues by Sales Representative.



Hotel Dashboard

This dashboard is prepared for displaying monthly hotel occupation performances.



Personal Monthly Budget

Keep your personal monthly income and expenses. Track them tables and charts.



Customer Satisfaction Report

This is a customer satisfaction report to evaluate forms filled by customers to get information about services of companies.





Global Electricity Consumption Dashboard

This template is another example of building dashboards in Excel. It includes a worksheet containing source data that can be updated. The dashboard will refresh immediately with new data. Also included in this template, information to deploy it as a web application via SpreadsheetWEB.




Monday, June 10, 2013

Global Import Export Statistics Dashboard

This is an Excel based interactive dashboard visualizing data on countries' import-export statistics released by World Bank. The dashboard includes various interactive charts, data filters and data grids.



EU Compsumption of Energy

Energy comsumption values and charts for EU countries.



World GDP Dashboard

This template is another example of building dashboards in Excel. It features various charts and sparklines. It uses data from World Bank on global GDP data. It is interactive in a way that user can select from a list of data indicators and countries to update the charts.



Global Carbon Dioxide Emissions Dashboard

This template is another example of building dashboards in Excel. It includes source data about carbon dioxide emissions around world since 1980.



Economic Growth Rates (US GDP)

This template is prepared for analyzing the growth rate of GDP of U.S. since 1929. The data may be entered manually. However, this template is prepared in a proper format, that the user may directly copy the data provided by Bureau of Economic Analysis. This property allows to update the template easily as new data files are published. Linear and exponential regression methods are used for estimating the GDP of future years. SpreadsheetWEB version of the template allows to use the dashboard online.



Global External Debt Stocks Dashboard

This template is another example of building dashboards in Excel. It features various interactive charts and uses data from World Bank on external debt stocks of various countries. It is interactive in a way that user can select from a list of data indicators and countries to update the charts.



Stock Portfolio Dashboard with MSN Money

Track your indicies, analyze your portfolio and get up-to-date information for stock quotes by using MSN Money Service.



World Education Statistics Dashboard

This template is another example of building dashboards in Excel. It includes a worksheet containing source data which released by World Bank.



Monday, June 3, 2013

Expense Tracker

Enter your expenses daily and analyze them with powerful dashboard tools. Click here to download your workbook!

Retail Store Dashboard

This is a dashboard displaying the retail store sales, salesperson sales and marketing distribution by the selected month. Also monthly sales chart is available. Click here to download the workbook!

EU Population & Population Change

European Union population statistics and factors of population changes Click here to download workbook!

USA Stock Quotes Tracker

Keep track of your major indicies in US Markets. Compare them by charts. Click here to download your workbook!

Renewable Electricity Generation Dashboard

This is an Excel based interactive dashboard visualizing data on Renewable Electricity Generation from across the World. Underlying data was obtained from U.S. Energy Information Administration. The dashboard includes various interactive charts and data filters. Click here to download your workbook!

Dow Jones Ind. 5-Year Data Analysis

Analyze Dow Jones Industrial Index's 5-Year Data by main indicators, filters and charts. Click here to download your workbook!

Global Industry vs Agriculture Dashboard

This template is another example of building dashboards in Excel. It features various interactive charts and uses data from World Bank on value added to GDP by industry and agriculture of various countries. It is interactive in a way that user can select from a list of data indicators and countries to update the charts. Click here to download your free workbook!

Global Final Consumption Expenditure Dashboard

This template is another example of building dashboards in Excel. It features various interactive charts and uses data from World Bank on final and household final consumption expenditure of various countries. It is interactive in a way that user can select from a list of regions and countries to update the charts. Click here to download your free workbook!

Global External Debt Stocks Dashboard

This template is another example of building dashboards in Excel. It features various interactive charts and uses data from World Bank on external debt stocks of various countries. It is interactive in a way that user can select from a list of data indicators and countries to update the charts. Click here to download your free workbook!