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
Featured
Protect a Worksheet, Use the Autofilter
Oct 18, 2018
Marcus Small
Protect a Worksheet, Use the Autofilter
Oct 18, 2018
Marcus Small

Protect an Excel worksheet and use the auto filter.  A how to guide.

Read More →
Oct 18, 2018
Marcus Small
Countifs Across Sheets
Oct 10, 2018
Marcus Small
Countifs Across Sheets
Oct 10, 2018
Marcus Small

Add a count formula across multiple sheets in Excel.

Read More →
Oct 10, 2018
Marcus Small
Excel VBA to Select Sheets
Sep 22, 2018
Marcus Small
Excel VBA to Select Sheets
Sep 22, 2018
Marcus Small

Excel VBA to select sheets and print out the selected sheets using PDF.

Read More →
Sep 22, 2018
Marcus Small
Power BI Desktop Dashboard
Aug 20, 2018
Marcus Small
Power BI Desktop Dashboard
Aug 20, 2018
Marcus Small

A Power BI Desktop example using Power BI

Read More →
Aug 20, 2018
Marcus Small
New Excel Dashboard Tools
Aug 1, 2018
Marcus Small
New Excel Dashboard Tools
Aug 1, 2018
Marcus Small

This is a list of Excel dashboards - the best I have produced to date.  These are time saving Excel tools.

Read More →
Aug 1, 2018
Marcus Small
Watch This Space
Jul 11, 2018
Marcus Small
Watch This Space
Jul 11, 2018
Marcus Small

No Spaces in Excel sheet names is a good habit to get into.

Read More →
Jul 11, 2018
Marcus Small
The Fuzzy World of Financial Modelling
May 31, 2018
Marcus Small
The Fuzzy World of Financial Modelling
May 31, 2018
Marcus Small

This post is about financial modelling, how to do it and what is important when it comes to manipulating Excel data.

Read More →
May 31, 2018
Marcus Small
Excel Autofill - Fill Down to Bottom of Range
Apr 8, 2018
Marcus Small
Excel Autofill - Fill Down to Bottom of Range
Apr 8, 2018
Marcus Small

In Excel you may wish to drill down on a range which has a header value not already contained in the rows.  The following article shows a practical example of how to generate a unique row name based on the heading in a specific place.  The procedure is in VBA.

Read More →
Apr 8, 2018
Marcus Small
Social Media Dashboard in Excel
Apr 5, 2018
Marcus Small
Social Media Dashboard in Excel
Apr 5, 2018
Marcus Small

This is a social media dashboard created in Excel.  It is free to download and has all of the graphs and source formula in the file.

Read More →
Apr 5, 2018
Marcus Small
Range Areas in Excel with VBA
Mar 15, 2018
Marcus Small
Range Areas in Excel with VBA
Mar 15, 2018
Marcus Small

Trap a range area with VBA and loop to next range area.  This little used Excel VBA technique is awesome and a real win when you learn the mechanics of it.

Read More →
Mar 15, 2018
Marcus Small
 

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.