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
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
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,
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
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
