For business users of Microsoft Excel Free guides and templates
Home > 

Free Excel Downloads

by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

These are many of the files you can download, but not all of them. If you see an article that discusses a file you'd like to download, and it doesn't start with a download link, please let me know.


Example Dashboard

MiniDash Excel Dashboard

Free Excel dashboardThis is the first time I've offered a free download of an Excel dashboard with much of its "plumbing" included.

That is, this dashboard uses Excel formulas to return data from a simple Excel database to the report page you see here. With these formulas included, when you change the report date, the report worksheet updates automatically.

Because this report is half-size, I call it a MiniDash. You can download your MiniDash workbook here.


Worksheet Functions

Dozens of Examples of Excel Worksheet Functions

My Excel Help section, All Excel Worksheet Functions, with Links to Help Topics, includes a growing list of workbooks that show how the worksheet functions work. Currently, more than five dozen worksheets are included. You can download a zipped file of all example workbooks here.


Excel Charts

Sample Charts from How to Create Bullet Graphs to Replace Gauges in Excel Charts

The article, How to Create Bullet Graphs to Replace Gauges in Excel Charts, shows how to create bullet charts. You can download the sample workbooks here.

Horizontal Excel bullet chart

Excel Shortcuts

The Complete List of Excel Shortcut Keys from Five Really Useful Excel Keyboard Shortcuts

The article Five Really Useful Excel Keyboard Shortcuts refers to my definitive guide to keyboard shortcut keys for all versions of Excel. It's the most complete guide I know because Excel users quickly correct any errors and oversights. Download Kyds-Excel-Shortcut-Keys.xls here.

Excel Charts

Sample Charts for Creating Normal Curves

Excel's NORM.S.DIST function translates standard deviations (z) into cumulative probabilities.Two articles explain how to create normal curves in Excel: How to Create Normal Curves With Shaded Areas in New Excel and How to Create Normal Curves With Shaded Areas In Classic Excel.


You can download the worksheet with normal curves for New Excel (Version 2007+) here, and download the worksheet with normal curves for Classic Excel here.

Excel Lookup Functions

Download a Simple Invoicing System

When a visitor asked how to create a simple invoicing system, I explained the process in Use Excel's INDEX-MATCH or VLOOKUP Functions to Populate Invoices and POs.

You can download the example Orders.xls workbook here.

Excel Loan Calculations

Amortization Schedules for Two Types of Loans

Term loans use a different amortizing method than traditional amortizing loans. In How to Use Excel Formulas to Calculate a Term-Loan Amortization Schedule I explained how to create an amortization schedule for both term loans and traditional amortizing loans. You can download the example workbook here.

Early Dates in Excel

Download the Macro to Work with Dates Before 1900

In How to Work with Dates Before 1900 in Excel I explain how some Excel formulas and a free macro can provide much of the help you need. You can download the early-dates workbook here.

Make Excel Faster

Use Excel VBA to Test Report Calculation Times

The blog post Use Excel VBA to Test Report Calculation Times explains how to use a calculation timer to test the calculation times of alternate formulas in Excel. You can download the example workbooks here for Excel 2007 and after, and also for Excel 2003 and before.

Excel Reporting

How to Spawn Excel Models, Analyses, Forecasts, and Reports for Many Categories

The article How to Spawn Excel Models, Analyses, Forecasts, and Reports for Many Categories explains how to create a forecast or report for one category (one movie theater, for example) and then "spawn" that report for each of many members of that category (that is, for all theaters in the chain).

You can download the example workbooks here for Excel 2007 and after, and also for Excel 2003 and before.

 

Free Excel Dashboards


Charley's SwipeFile charts