Random Number Generator for Excel, Revisited

Another, simpler way to do it.

Nearly five years ago, I wrote a short article about creating a simple spreadsheet to generate random numbers in Excel. Lately, it’s been the most popular post on this site.

Trouble is, it’s a bit outdated. There’s actually an easier way to do the same thing: with the RANDBETWEEN function.

The RANDBETWEEN(bottom,top) function “calculates” a random number between the bottom number and the top number. Just provide those two numbers and Excel does the rest.

The benefit of this function is that you don’t need to go through a complex calculation to tell Excel you want a whole number within a range. RANDBETWEEN returns whole numbers automatically. It can also output the top and bottom values in the range. And it might actually be more random than my original solution because you’re not dependent on rounding rules to get the final number.

ScreenshotSo which would you prefer? The old way, with a formula like this:

=ROUND(RAND()*B6-B5)+B5,0)

or the new way, with a formula like this:

=RANDBETWEEN(B5,B6)

I know which one I prefer.

Download the revised sample worksheet here.

Sorting Excel Data: The Basics & Beyond

A definitive guide to sorting data managed in Microsoft Excel.

Sorting Excel Data cover

This guide takes the mystery and confusion out of Excel’s sorting features. It starts by covering the basics of simple, one-column sorts. It then builds on that information to explain multi-column sorting, setting up and using custom sort orders, sorting based on cell colors or icons, performing case-sensitive sorts, and sorting by rows instead of columns. Step-by-step, fully illustrated instructions make it clear what you need to do. Sample files make it easy to repeat exercises so you can see the same results.

Although this book concentrates on Microsoft Excel 2010 for Windows and Microsoft Excel 2011 for Mac OS, it also provides useful tips and instructions for previous versions of Excel.

Buy Kindle Edition
Buy iBooks Edition
Buy NOOK Edition

I’m really pleased to announce that the second book in the Maria’s Guides series — Sorting Excel Data: The Basics & Beyond — is now out and available in three ebook formats, with a print edition on the way.

About the Book

It all started as a question asked by a friend in Facebook. An experienced computer professional, she didn’t know how to perform a four-column sort in Microsoft Excel. I thought back to my computer applications training days and remembered how my students struggled with Excel’s sorting features. I decided it would make a good topic for a Maria’s Guide book.

While researching and writing the book, I realized just how much Excel’s sorting feature has changed since I wrote my last Excel book several years ago. While it was obviously important for me to cover the most recent Windows and Mac OS versions of Excel, I also wanted to explain complex sorting to folks who haven’t yet upgraded. I think the book does a great job of completely covering how to sort data managed in Excel.

Inside, you’ll find the following chapters:

Table of Contents
Before We Begin: Introduction
Chapter 1: Sorting Basics
Chapter 2: Quick Sorts
Chapter 3: Multiple-Column Sorts
Chapter 4: Sorting by Color & Icon
Chapter 5: Using Custom Sort Orders
Chapter 6: Exploring Sort Options
Chapter 7: Sorting with Filters & Tables
Conclusion: That’s Everything

The printed version of the book runs 114 pages, including front matter, table of contents, and index.

The book uses several example worksheets, all of which are contained in a single workbook file. Readers are encouraged to download the sample file and follow along. This ensures understanding, since readers get the same results that appear in the book.

Buy the Book

The book is currently available as an ebook from three sources (so far):

The print edition is currently going through the proofing process. Once approved, it will be available on Amazon.com and BN.com, as well as by special order through your favorite bookstore.

Additional Material, Feedback, and Support

You can find additional material about Excel on this site. Just follow the Excel topic link.

You can also post questions and read questions and answers on the book’s support page. That’s also where you can find the sample workbook file used throughout the book.

Category Feeds Being Removed

As part of the site revision process, I’ve decided to do away with the category-specific feeds. These feeds, which cover Excel, Mac OS, Word, and WordPress content, are being utilized by less than 100 people. If you’re reading this message in your feed reader, YOU might be one of them.

Within a month or so, these feeds will simply not work. Delete them from your reader.

If you want to continue receiving content from this site via RSS, please subscribe to the main feed, using one of the following URLs:

Creating a Time-Lapse Calculator with Excel

A quick way to perform movie-making calculations.

One of my hobbies is photography and I dabble occasionally with time-lapse. In time-lapse photography, you set up a camera on a tripod to take a photo at a set interval, like every 15 seconds, over a long period of time, like hours. When you’re finished, you take the resulting images and compile them into a movie using each photo as a movie frame. The length of your movie is dependent on the number of shots and the number of frames per second (fps) at which they are compiled.

I wanted to be able to easily calculate various values for a time-lapse movie project based on certain values I provide, which I call “assumptions.” For example, how many seconds between shots if I want 1200 shots over 3-1/2 hours? How long would a movie be if I took shots over 10 hours with 15 seconds between shots and compiled them at 30 fps?

This is basic math, but with a twist. I wanted to be able to solve for any one of three source photo values given the other two values:

  • Time period, in hours
  • Seconds between shots
  • Number of shots

Given that information, I also wanted to be able to solve for either of two resulting movie values:

  • Frames per second
  • Movie length, in seconds

Time-Lapse CalculatorThe resulting Time-Lapse Calculator shown here does the job.

The formulas I put in the green cells are shown below. The IF function tests to see if cells are empty and uses the test result to determine whether it needs to perform and display a calculation. For example, in cell D6, it checks to see if B6 is empty; if it is, it calculates the result based on B7 and B8. Because the last two formulas require data from either cell B8 or D8, they also test to see which one contains data. The result is a nestled IF statement.


D6=IF(B6="",B8*B7/60/60,"")
D7=IF(B7="",60/(B8/B6/60),"")
D8=IF(B8="",B6*60*60/B7,"")

D11=IF(B11="",IF(B8<>"",B8,D8)/B12,"")
D12=IF(B12="",IF(B8<>"",B8,D8)/B11,"")

You can download a password-protected copy of the worksheet here. (The password is not available for distribution.)

After completing this worksheet and beginning to write about it, I realized that it’s not everything I envisioned. What I really wanted was to calculate one of the following based on the other three:

  • Time period, in hours
  • Seconds between shots
  • Frames per second
  • Movie length, in seconds

I’ll likely work on this in the future. If I finish it, it’ll appear here on Maria’s Guides.

Want to learn more about Excel?

Check out my most recent Excel books and video training materials:

And be sure to use the Excel link in the sidebar to track down other Excel articles like this one on Maria’s Guides.

Office 2008 Installer Needs Rosetta? Duh-oh!

Just something idiotic I wanted to share.

I rolled off a book project with a tight deadline right into a video project with an even tighter deadline, so I don’t really have time to blog, share new articles here, or even tweet. But I did run across this the other day while I was installing Microsoft Office 2008 on my 13-inch iMac running Snow Leopard:

Office Installer Needs Rosetta

Yes, the Office 2008 installer requires Rosetta to run. Office 2008 doesn’t need Rosetta. Just the installer does.

Hello? Microsoft? You want to make your installer compatible with current hardware and software?

90 Days on a Wednesday

An Excel solution.

A while back, someone I know here in Wickenburg called me with an Excel question. He needed to calculate the date of the Wednesday least 90 days from an entered date.

So, for example, if he entered 2/14/2009 in a worksheet cell, he didn’t want 5/15/2009 (a Friday), which was 90 days later. He wanted 5/20/2009, which is the Wednesday at least 90 days after the date he entered.

The solution was to use nested IF statements to evaluate whether the day of the week 90 days after the entered date is a Wednesday. If it is, it uses that date. if it isn’t, it does the same evaluation for 91 days after the entered date. And then 92 days. And so on.

90OnWednesdayThe spreadsheet I came up with can be downloaded here. This screenshot shows what it looks like. It has a lot of other stuff in it that I used to test the formula. Notes in the worksheet explain. I saved it just to share it here. You might find it useful if you have a similar need.

Just watch those parentheses.

Excel Splitting Digits Example

Another quick spreadsheet to show off the capabilities of Excel.

Site visitor Jamie left the following comment on my recent post, “Random Number Generator for Excel“:

maria dont spose u know how to split a four digit number like 2365 into 4 different numbers 2 3 6 5 in all different cells in excel without having to do it manually just wandering please tell me if you know a way thanks

I had an idea of how to do this with the MID function, which is a text function. I just didn’t know if I had to convert the starting number to text before extracting the digits.

So I whipped up the attached worksheet and popped in the formulas. The answer: no, you don’t need to convert the number to text first.

Split Digits worksheet

The MID function has 3 arguments:

  • text is the text you want to extract characters from. For this example, it’s the four-digit number.
  • start_num is the number of the first character in the string you want to extract. For this example, it’s the digit number (1 though 4).
  • num_chars is the number of characters you want to extract. For this example, it’s 1.

You can examine the formulas in the spreadsheet for yourself to learn more. Download it here.

Hope this helps, Jamie!

Random Number Generator for Excel

A quick little project.

I just happened to visit a Web site that used another Web site to generate random numbers for contest giveaways. To me, an Excel user, that seemed like a silly place to go to get a random number when you could easily generate one on the fly within Excel.

ScreenshotSo I whipped up a tiny Excel spreadsheet to do the job. You just put the minimum value in one box and the maximum value in the other and Excel generates a random number between the two for you. To generate additional random numbers in the range, just press Command-= (on a Mac) or Control-= in Windows. The worksheet is protected so you can’t accidentally delete the formula that does the magic.

Although I created the worksheet in Excel 2004 for Mac OS, it can be opened in Excel 2003 and Excel 2007 for Windows, too.

Want a copy? Download it here.

Update 4/22/11: Apparently, the file has been lost in a server transfer. I’m updating it now and will restore the above link when it’s online. Sorry, folks!

Later: I recreated the file and put it in a new location on the server. The above link should work. Also, please note that there is now an easier way to do this with Excel; use the RANDBETWEEN function instead.

Update 2/6/12: This post has become very popular. But wouldn’t you rather do this the easier way? I explained RANDBETWEEN in a new post today.

Informit Publishes Excel 2007 Book Excerpt

“Working with Excel Files” goes online.

ImageJust a quick note to let Excel 2007 users out there know that Informit has published an excerpt from my Excel 2007 Visual QuickStart Guide on its Web site. The piece is titled “Working with Excel Files.” Access to the site is free.

I’m pretty sure the book is out, but I haven’t had an author copy in my hot little hands yet.

I think my recent article about using WordPress with Google sitemaps will be online there next week. Stay tuned for more info.

Excel Book Done

That’s book number 68.

ImageI put the finishing touches on Microsoft Office Excel 2007: Visual QuickStart Guide. It’s my 68th book (I just counted) and right now, I feel as if I wrote them all yesterday.

Okay, so not that tired.

I had some trouble with this book. First, there was the beta software situation. Not only did I have to work with the Office 2007 beta, but I had to run it on the Vista beta. Double Microsoft Windows betas for a person who usually works on a Mac! You can imagine my concern.

But everything went pretty smoothly with that and I’ve been using release versions since January, so I know everything in the book is based on the final software.

Motivation slowed me down a bit in the middle of the project. I think I really need an editor cracking a whip over my head to get me to work at my old pace. These days, I’d rather fly than write about Excel. (Can you imagine?) The thing that snapped me out of it was money. If I don’t make milestones, my publisher does not send checks. Although Flying M Air is now paying all of its own bills — thank heaven; you should see some of those bills! — it’s not paying my bills. If I don’t write, I don’t eat. And since I like to eat, I became motivated.

Of course, the killer was my February hard disk crash and the two weeks it took me to get everything back to normal here. What a productivity killer! But it taught me a new valuable lesson about backups — you think I would have learned the last two times — and my old dual G5 is still running, now with a new hard disk to go with last year’s new motherboard. Sheesh. (Now you know why I bought AppleCare for my MacBook Pro.)

I churned through the last few chapters relatively quickly, anxious to meet deadlines tied to promotional opportunities. (I’m not sure of those promos really exist or if my editor has learned to tell me about fantasy promos to get me to work faster. I wouldn’t blame her if she made it up.) I had first pass files done last week and spent the past few days finalizing files based on edits. Today, after fooling around a bit — I’m the queen of procrastination — I laid out the index, created an ad for the book’s companion Web site, and turned it all in. The e-mail message I sent to my editor said:

I think I’m done. Can you ask them to send that final check? (Still waiting for the last one, too.)

The book weighs in at 360 pages, which is about the same as the last edition. It’s got the new VQS cover design. It lists for $21.99, but you can buy it from Amazon.com for $14.95 right now, which is 32% off. (Not a bad deal.) It should be in stores by April 20 or thereabouts.

Meanwhile, life goes on.

Tomorrow, I have to take my helicopter in to the avionics shop in Mesa to see if they can figure out why my radio isn’t working right. I have a meeting with a marketing guy down there at 10 AM. Then a tour of Phoenix for a man and his daughter at 2. Somewhere in between, I’ll have lunch with Mike, who has been away for the past few days. Then a flight home.

Friday I get started on my next book. Those of you who know me should know what that is.

Printing an Excel Function Reference Sheet

A how-to for Excel users.

My Visual QuickStart Guide books for Excel — from the edition for Excel 95 for Windows through the edition for Excel X for Macintosh — have always included an Excel function reference. In an effort to make pages available for other content, however, we’ve cut that appendix from the Excel 2007 edition of the book. I don’t feel badly about the cut, since this information is readily available in Excel Help and on the Web.

Here’s how you can find a function reference for your version of Excel and print it for your own hard-copy reference guide.

In Excel 2007 for Windows

  1. Click the Help button in the upper-right corner of the Excel window to display the Excel Help window.
  2. Enter function list in the search box and press Enter.
  3. Excel Help search resultsAmong the search results that appear, you should see an item titled “List of worksheet functions (by category).” Click its link.
  4. Function List for Excel 2007A help document titled “List of worksheet functions (by category) appears in the help window. It includes a complete list with brief descriptions of all Excel 2007 functions. You can read through this document and click links within it to learn more about specific functions.
  5. To print the reference sheet, click the Print button in the Excel Help window’s toolbar. Use the Print dialog that appears to set printing options and click the Print button.

Note that you may need a connection to the Internet to access the Function List from within Excel Help. And remember that you can always resize the Excel Help window to better read what’s inside it.

Get this Information Online

This reference information is also available online for some versions of Excel. Click this one of these links:

These pages contain clickable links to details about specific functions. They can also be printed from within your Web browser; use the Print command.

Excel Alignment Tips

For perfectionists.

One of the things that always bothered me about Excel was the way it handled right alignment in cells with certain types of number formatting applied.

The Problem

For example, in the following illustration you’ll see that some cells containing values have currency formatting and other cells containing values have comma formatting applied. The line up nicely in a column. But when right-align the column headings as I’ve done here, the headings don’t line up with the numbers:

Excel Alignment Example

This is the case in all recent versions of Excel that I’ve worked with, including Excel 2004 for Macintosh and Excel 2007 and Excel 2003 for Windows. (The illustrations here are from Excel 2007 running on Windows Vista.)

Why It Happens

Before we can fix this problem, we should have a good understanding of why it occurs.

You may have noticed that when you apply currency or comma formatting (for example) the numbers shift to the left. Ever wonder why?

Excel Alignment ExampleWell, you can thank Excel for thinking ahead about something that you might not have in a column of numbers: negative values. As shown here, certain number formatting options place parentheses around negative numbers. To make sure all the numbers in a column line up, positive numbers are shifted by the width of a parentheses character to the left. So every number formatting with currency or comma formatting actually has a tiny bit of space after it.

The Solution

Since you don’t normally apply currency or comma formatting to text, cells containing text are truly aligned against the right side of the cell when you use the right alignment formatting option.

But guess what? You can apply currency or comma formatting to a cell containing text. And when you do, the contents of the cell will shift to the left by the width of one parentheses character. The result: everything is nicely aligned:

Excel Alignment Example

Minimize the Ribbon

Getting back some screen real estate.

One of the things that you might find bothersome about Excel 2007′s Ribbon is the amount of space it takes up at the top of the workbook window. Fortunately, you can get it out of the way and recover that space. Here’s how.

  1. Right click on any button on the Ribbon. A contextual menu appears:

    Contextual Menu

  2. Choose Minimize the Ribbon. The Ribbon shrinks so it looks a lot like a good, old fashioned menu bar.

    Minimized Ribbon

From that point on, to access the Ribbon, click the tab you want to expand and display it. It will overlap the top of the document window, as shown here:

Expanded Ribbon

When you continue working in the worksheet window, the Ribbon collapses again.

To get the Ribbon back to normal, right-click on any Ribbon tab and choose Minimize the Ribbon from the contextual menu that appears. That will toggle the feature to “off.”

Excel 2003 VQS Correction of the Day

Another very minor correction to my Excel 2003 VQS for Windows book.

As I continue to revise the book for Excel 2007 on Windows Vista, I continue to find tiny errors in the existing book.

Today’s error is on page 118, in the caption for Figure 38. The caption states that gridlines have been turned off for the illustration. In reality, they have not. But I do explain how to turn gridlines off in Chapter 15.

Excel 2003 VQS Figure Correction

Well, it only took me 3 years to notice this.

Sheesh. It always happens. I find errors in books I’m revising, after thousands of people have bought the book and consulted it, sometimes for years.

Well, that’s part of what my Book Support sites are about: to provide corrections and clarifications to the books. So here’s a correction on my Excel 2003 Visual QuickStart Guide.

Due to a cropping error in the layout (my fault), Figure 6 on Page 107 is incorrect. It should look like this:

Formatting Examples

If you find an error in any of my books, please don’t keep it to yourself. Use the appropriate Q & A post to comment on it. If it’s wrong, I’ll fix it and note it on the Book Support pages. If it’s not wrong, we’ll try to figure out why you think it is.

Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: Visual QuickStart Guide is Off to the Printer

(I just write ‘em — I don’t name ‘em.)

Excel Visual QuickProjectThe revision to my Excel 2007 Visual QuickStart Guide was shipped to the printer this week. My editor expects the book to be in stores by year-end.

The book is a raw beginners guide to Excel. This version covers Excel 2007, which will be widely available at January month-end. The previous edition, which is still available and has been selling very well since its publication over two years ago, covers Excel 2003 for Windows and Excel 2004 for Macintosh. I expect both editions of the book to sell side by side at least until Excel for Macintosh is revised — whenever that may be.

For more information about the book and downloadable files, visit the Excel QuickProject area of this site.

Interested in buying the book? Check it out at Amazon.com.

Solutions for Failing Eyesight

Don’t make the font size larger — zoom it!

Yesterday, I reread a blog entry I wrote earlier this year about my failing eyesight (“The Eyes Had It“). My far vision has always been bad, but now I’m beginning to lose my close vision, too. Miraz, my co-author on the WordPress book, commented that she’s going through the same thing and now uses a larger font size when working with Word.

As a writer, I spend a good portion of my workday in front of word processing or page layout software. I have a 21″ Sony monitor at my office — you know, one of those enormous super VGA CRTs that weighs about 80 lbs. I have the screen resolution set so I see a lot on my screen. But that means that most of what I see is small.

I found that if I received a document from someone with a normal font size — say 12 points — I just wasn’t able to view it comfortably at 100% magnification. So I needed a workaround.

There were two options:

  • Change the screen resolution to a lower setting. On a Mac, you do this with the Displays preferences pane. On Windows, I think it’s also called Displays and its a control panel. I’m not sure what that big monitor at the office is set to, but my 12″ PowerBook is set all the way up to 1024 x 786. If I dropped that down to 800 x 600, everything on screen would look larger and I’d probably have a better time seeing it. But I’d also get less on my screen. And some Web sites — like Flying M Air, for example — actually require a high resolution setting of at least 1024 x 786. So that isn’t the optimum solution.
  • Zoom the contents of windows. Most applications have a zoom feature. For example, in Microsoft Word 2003 for Windows and 2004 for Mac OS, there’s a Zoom drop-down list right on the Standard toolbar. Choose an option from the menu or enter a new value in the text box there and press Return or Enter. I usually use 120%, unless the author of the document formatted it at some crazy font size like 9 points. Then I pop it up to 150%. I even had a document I worked on at 200% because between the small font size and the font design itself, I just couldn’t read it comfortably at any other magnification. Other programs, such as Excel, Adobe Reader (and Apple Preview, for that matter), Photoshop, and just about any other graphics or page layout program you can think of, have zoom features. I even have keystrokes remembered in some apps to toggle magnifications as necessary.

It’s odd because on one book I worked on, I’d submit Word files I’d been reading at 120% magnification and get them back from the copyeditor at 92% magnification. I’d have to pop them back up to read them. The benefit of using the magnification feature rather than simply changing font size is that layout isn’t affected. Document magnification settings can be set at anything and it’ll always have the same word wrap (except in Word’s Online Layout View perhaps) and it’ll always print the same. If you change the font size, however, you also change the word wrap and layout.

Of course, if you have trouble reading a printed version of the document, font size is just about the only solution.

But I’m not quite there. Yet.

New Excel Book in Progress

After two months off from writing, I begin work on an Excel book revision.

Creating Spreadsheets and Charts in Excel: Visual QuickProject GuideI dove into a revision of my Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide book today. I actually got the first chapter — all 16 pages of it — done.

If you’re not familiar with the VQJ (as Peachpit calls it) series, it’s pretty simple. Written for raw beginners, the books use a lot of full color illustrations, large text, numbered steps, and callout lines. Each book in the series is only 144 or 168 pages long — this one weighs in at 144 pages. It’s not the least bit intimidating for any reader.

The first edition of the book covered Excel 2003 for Windows and Excel 2004 for Mac OS. The two versions of Excel are virtually identical, so it made sense to do one book to cover them both. I think I did a good job giving each platform equal space and showing screenshots from both platforms when they were significantly different.

The idea behind the series is to present a project — in this case, creating a budget spreadsheet, duplicating it for multiple months of information, consolidating the months, formatting the spreadsheets so they look good, creating a chart, and printing. All the basics are covered in one project, presented over multiple chapters. The first chapter covers preliminary stuff like interface elements and terminology. The next chapter is where we start creating the spreadsheet.

Creating Resumes, Letters, Business Cards, and Flyers in Word: Visual QuickProject GuideI have two books in this series. This one is doing very well and has been translated into at least two languages. The other book — take a deep breath if you plan to read the title out loud — Creating Resumes, Letters, Business Cards, and Flyers in Word: Visual QuickProject Guide (I had to look it up; I can never remember the title of that book), isn’t doing quite as well. I like to think it’s because people don’t really want to create all those things. But it’s probably because the Word book market is full of titles and this 168-page tome just doesn’t stand out enough on bookstore shelves.

Creating Spreadsheets and Charts in Microsoft Excel 2007: Visual QuickProject GuideThis Excel book revision is not cross platform. Tentatively titled Creating Spreadsheets and Charts in Microsoft Excel 2007: Visual QuickProject Guide, it covers Excel 2007 for Windows only. (It always amazes me when Amazon.com knows what one of my books will look like before I do.) To write it, I not only had to get my hands on the Office beta, but I also had to get the Windows Vista beta, which my editor wanted running on the computer for all the screenshots. Without Vista, he claimed, the book would look outdated right away. He’s right. And although I wasn’t too thrilled about running beta application software on beta System software, it seems to be working pretty well. Of course, I had to buy a new computer to run all this stuff. My ancient Dell desktop machine would have dropped dead if I tried installing Vista on it, especially with the new graphics-intensive interface. The new Dell Latitude 820 laptop I bought to replace it is handling everything with ease. It should for what it cost me. But with luck, I won’t have to replace it for 4 to 5 years.

Office 2007 is no secret. You can see screenshots and all kinds of training material on the Microsoft Office 2007 Preview site. You might even still be able to download a beta. It’ll run on Windows XP and Vista, so you don’t have to do a double beta like I did to run it.

Over the years, many have complained that Office doesn’t change much with each new version. You won’t hear those complaints this time around. Microsoft has completely reworked the interface. The menus and toolbars are gone, replaced with something called the Ribbon. Click a Ribbon tab to view groups of commands. Click a command to invoke it. Or click a tiny button in the corner of a group to display a good old dialog box.

The new design does appear to be easier for newbies to grasp. But I think it’ll frustrate the hell out of seasoned Office users — at least until they get used to the interface. There’s logic behind it, so if you think about what you want to do, you can figure out where to find the buttons or menus you need to do it. And all the old keyboard shortcuts still work, so if you’ve been using Office applications for years, you won’t be at a total loss in the new version.

Of course, all this has me wondering whether they’ll use the same interface in the Mac version of Office when it gets updated. That would be almost sacrilegious. After all, didn’t Apple invent the interface so widely used by Mac OS and Windows programs? I can’t imagine a Mac program without a menu bar that starts with File and Edit. I guess time will tell.

What’s good about all this for me is that people will need a book to learn the new versions of Office applications. They can’t just use an old Office book to work with the new version. With luck, that’ll help book sales a little. After all, I have to pay for that fancy new computer, don’t I?

Stay tuned for more information about this book as it is completed. It will definitely make it to stores at the same time as Office 2007 — heck, at the rate I’m going, I should be done with it by the end of the month.

Excel Books Q & A

Post your questions about my Excel books here.

Have a question about something in one of my Excel books? Here’s how to get the answer:

  1. Browse through the comments at the end of this article to see if someone else has already asked your question. You might get the answer without even asking!
  2. If your question is not asked (or answered), use the Leave a Comment form at the bottom of this post to enter your question. (If the form does not appear, click the Comment link below to display it.)
  3. Check in once in a while to see if your question is answered. I usually answer questions within 48 hours, unless I’m out of town. To have responses to your question delivered to you automatically by e-mail, along with other Q & A comments submitted for this book, turn on the Notify Me check box at the bottom of the form when submitting your question (step 2). You can unsubscribe to the notification feature at any time.

Please do not use the Contact form to ask me questions. I won’t answer them. I want the questions and answers here, where everyone can see them, so I don’t have to answer the same questions over and over again.

Remember, I can only answer questions that clarify or correct information in my books. If the answer to your question is in my book, I will provide a page number reference to help you find it.

October 27, 2011 Update: Due to the age of these titles, they are no longer supported. Comments have been closed but remain in case you have a question that has already been answered here. Support for my Lynda.com titles can be found on the course page on Lynda.com.

Absolutely the Last Article You Need To Read About Absolute References in Excel

Informit article.

Ever copy a formula you think is perfect and have surprising (and incorrect) results in the destination cells? You might be missing out on a feature of Excel that can make your spreadsheet work easier.

Read more at: Absolutely the Last Article You Need To Read About Absolute References in Excel