This particular file will show an interactive break-even analysis for an event entailing food and beverage.

You can interact with the file and have the chart redraw. Probably the best route is to adjust by very large amounts to see the effects.

Here you go, have a play!
...

Tonight I had to do some work on my financial model from home. Naturally, I copied the files into my "work stuff" folder on my laptop hard drive, and headed out at the end of the day. But as I disclosed in my last post, it now has (shudder) external links in the file. So in order to work effectively on the model, I needed to replicate the file paths.
...

Just for fun, I decided that I would build a game in Excel, so here's my version of Blackjack.

Features:
The rules are pretty standard Blackjack rules... adjust your bet, then hit Deal. You get two cards, the dealer gets one up, one face down. You can hit or stay, and the hand will unfold for you.
...

Introduction:
This macro can be used to count how many files exist in a folder and subfolders. In addition, if passed the file extension, it can also be used to count only files of a specific type. (For example "xls" files.) If you are looking for a macro that counts files within a specific folder only (ignoring subfolders), please see this entry.
...

I've received several comments on my blog that people dislike Excel 2007's Compatibility Checker, and would like to turn it off globally. While it's true that you can turn it off for each workbook, the main user interface seems devoid of a way to actually tell Excel that you never want to check your workbooks for compatibility when saving to 2003 or earlier versions. ...

Macro Purpose:
This code quickly replaces all external links in an Excel workbook with their values. It is something that can be very handy when you need to send a heavily linked workbook outside of your immediate network, to a user who doesn't have access to the directory containing the linked ...

Introduction
This is a very simple add-in that adds a button to the Review tab's Proofing group, allowing the user to have Excel read the selected cells back to them aloud. ...

Introduction
How many times have you built a table of data, and put totals on it. You ship it out the door, and another user comes along and inserts a new row right before the totals row? If you have seen this in play, you'll know that the new row is actually inserted between the end of the data range and the totals row, meaning that your sum formula no longer picks up the entire range of data!

Fortunately, the issue with missing rows in totals can easily be fixed so that a user can insert a row immediately above your totals without missing the last line(s). ...

Introduction
When keying in large amounts of data, it can be helpful to have Excel read the input back to you... either as you go, or after you have finished. In either case, this lets you focus on reading the numbers from the page, comparing what you have typed to the original values.

This article covers both scenarios individually. ...

What are Styles?
A style is pre-defined set of formatting instructions held together in one convenient package. They can be configured to apply one, two or many formatting characteristics, and can be applied to a worksheet cell or range very easily.

Why use Styles?
The biggest reason that you'd want to use styles is their ease of use when you want to update a cell, be it a color/colour change, number style or font. If you have a style set up, you simply need to change it in one place, and every other cell in your entire workbook that uses that style is updated with it. ...

What are dates?
This may seem like a strange thing to ask but, as far as Excel is concerned, dates are numbers. By storing them as such, it gives us the ability to add or subtract days to/from a date, as well as get the difference between two dates. If dates were stored as text, this would not be possible. Storing dates as numbers also allows us to construct far more complicated formulas, based on results that we may want to know.
...

Due to a recent migration from a Novell to Microsoft, our company has also migrated from Novell Groupwise to Outlook 2007. This article is one of a series of short "How To" articles that I have been publishing internally to make the transition easier. Please keep in mind that this was written with Outlook 2007 in mind, so you may have to follow slightly different steps to make this work in earlier Outlook version.
...

Due to a recent migration from a Novell to Microsoft, our company has also migrated from Novell Groupwise to Outlook 2007. This article is one of a series of short "How To" articles that I have been publishing internally to make the transition easier. Please keep in mind that this was written with Outlook 2007 in mind, so you may have to follow slightly different steps to make this work in earlier Outlook versions.
...

Due to a recent migration from a Novell to Microsoft, our company has also migrated from Novell Groupwise to Outlook 2007. This article is one of a series of short "How To" articles that I have been publishing internally to make the transition easier. Please keep in mind that this was written with Outlook 2007 in mind, so you may have to follow slightly different steps to make this work in earlier Outlook version.

Creating a signature file
In most email ...

Introduction:
This macro can be used to count how many files exist in a folder and, if passed the file extension, can also be used to count only files of a specific type. (For example "xls" files.) I've actually published two articles along this vein at VBA Expresss, but this one uses the File System Object (some know it as the File Scripting Object, or just FSO,) to do it. The biggest reason for the re-write is that I needed to use this in an Excel 2007 instance, which does not support the FileSearch method.
If you are looking for a version to count the files in a folder AND subfolders, then look here.
...

This article contains code which will print all open Word documents into a single PDF file.

These code examples are built for PDFCreator, an open source PDF writer utility. Unlike Adobe Acrobat and CutePDF, which both require pro versions to create PDF's via code, PDFCreator is completely free! Download PDF Creator from Sourceforge here. Please note that this code will NOT work with Adobe Acrobat. ...

Introduction:
This article covers the basics of using Form Controls in an Excel worksheet, and originated from one of my blog posts, which can be found here.

While I don't tend to use Form Controls a great deal, they are certainly one of the Excel features I'm glad are in the toolbox. The main reasons I'll use one of the Form Controls are:

• They give an obvious visual style to your worksheet
• They can be used to force users to choose one of your provided options (Pro-active data validation)

...

I'm very pleased to be able to share a Chapter from my new book, RibbonX - Customizing the Office 2007 Ribbon.This chapter discusses the comboBox and dropDown RibbonX elements in detail. From using Microsoft's built in elements to creating your own with XML and programming the callbacks with VBA, it displays how to work with them. As you'll see, we provide practical examples for working with the elements in Excel, Word and Access so that you can follow along. ...

Introduction:
This article contains code that can be used to print worksheets or entire workbooks to a PDF file, using Microsoft's free Save as PDF or XPS add-in for Office 2007. These routines will NOT work in versions of Office prior to 2007. If you are running an earlier version of Office, and are running on Windows XP, then have a look at my PDF Creator articles.
...