TheSmallman.com

an XL ideas Lab

  • Home
    • Excel Dashboard Course
    • Financial Modelling Course
    • Excel Infographics Course
    • Excel VBA Course
  • Models
  • Native Excel
  • Charts
  • Dashboards
  • Infographics
  • Modelling
  • VBA
  • Blog
  • About
Menu

Excel Dashboards VBA and more

Street Address
City, State, Zip
Phone Number
an XL ideas Lab

Your Custom Text Here

Excel Dashboards VBA and more

  • Home
  • Courses
    • Excel Dashboard Course
    • Financial Modelling Course
    • Excel Infographics Course
    • Excel VBA Course
  • Models
  • Native Excel
  • Charts
  • Dashboards
  • Infographics
  • Modelling
  • VBA
  • Blog
  • About

Excel Dashboard by Department and Region

April 25, 2015 Marcus Small
Revenue and expense excel finance dashbaord

I have been quiet on my blog of late.  Been busy preparing courses and webinars for the year. This morning a put together a fresh dashboard for the site.  The Excel dashboard has a consistent feel and I have used 3 years as an example.  It spins on the option buttons in the top right.  It is only a very small dataset but works nicely.  The staffing by state chart works nicely.  

I will attach the file to show how the Excel dashboard is put together.

LatestDash.xlsx

Tags Excel, Dashboard, Chart
← Evaluate and Filter Part 2Move Sheets Based on a List with VBA →

Featured Posts

Evaluate and Filter Part 2

Evaluate and Filter Part 2
April 26, 2015

 Showing Trends with a Chart

Showing Trends with a Chart
March 5, 2015

Excel VBA to Sort an Array

Excel VBA to Sort an Array
February 23, 2015

 Excel VBA Slicer Selection

Excel VBA Slicer Selection
January 15, 2015

Recent Posts

Protect a Worksheet, Use the Autofilter

Protect a Worksheet, Use the Autofilter October 18, 2018

Countifs Across Sheets

Countifs Across Sheets October 10, 2018

Excel VBA to Select Sheets

Excel VBA to Select Sheets September 22, 2018

Power BI Desktop Dashboard

Power BI Desktop Dashboard August 20, 2018

New Excel Dashboard Tools

New Excel Dashboard Tools August 1, 2018

Watch This Space

Watch This Space July 11, 2018

The Fuzzy World of Financial Modelling

The Fuzzy World of Financial Modelling May 31, 2018

Excel Autofill - Fill Down to Bottom of Range

Excel Autofill - Fill Down to Bottom of Range April 8, 2018

Social Media Dashboard in Excel

Social Media Dashboard in Excel April 5, 2018

Range Areas in Excel with VBA

Range Areas in Excel with VBA March 15, 2018

 

TrainiNg

  • Dashboarding with Excel
  • Visual Analytics
  • Advanced Dashboard Design in Excel
  • Financial Modelling in Excel
  • Advanced Financial Modelling in Excel

 

  • 3 Statement Modelling in Excel
  • Project Financial Modelling
  • PowerPivot
  • Excel Automation with VBA
  • Financial Modelling with VBA

Follow US:

 

marcussmall@thesmallman.com
 

TheSmallman.com - Making your small systems hum...
© Copyright theSmallman.com All Rights Reserved.