Excel Videos
I just recently taught my course on "Building Spreadsheets That Last". In it, I actually show a video that was written by Ross on Workbook Structure protection. I like Ross's video, as it shows some interesting tricks with the features.
I just recently taught my course on "Building Spreadsheets That Last". In it, I actually show a video that was written by Ross on Workbook Structure protection. I like Ross's video, as it shows some interesting tricks with the features.
I received a question from a reader of my site about how to adapt my Print Multiple Worksheets to Multiple PDF Files article so that it would also print each file to two separate directories. There are at least a
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. In truth, this add-in does not really add any
Okay, I'll admit that you probably have to be a parent of a young child to agree with this, but here it is: [code]Application.Speech.Speak Target[/code] This all started when I showed my kid how fast the computer could count to
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
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
In our Microsoft migration a couple of months ago, we moved from Novell's Groupwise for email to Microsoft Exchange 2003, using Outlook 2007 as a client. I knew things would be different, but some things just make me shake my
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
I've always been told that the question of what's under Dick Kusleika's hat was under NDA... now I know why...
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,