Maria’s Guides

Support and additional material for readers of books, articles, and digital media by Maria Langer.


Random Book Cover #1Random Book Cover #2Random Book Cover #3Random Book Cover #4Random Book Cover #5Random Book Cover #6Random Book Cover #7Random Book Cover #8Random Book Cover #9

Excel 2007 QuickProject Excerpts

Posted on October 15th, 2007 at 10:58 am · 2 Comments
Filed in: RSS Downloads   RSS Excel Books   

Excel QuickProjectTwo Excerpts from Creating Spreadsheets and Charts in Microsoft Office Excel 2007: Visual QuickProject Guide.

Want to see some sample pages from my Excel Visual QuickProject? Here are a few links.

→ 2 Comments • Read 1310 Times
Add to Del.icio.usAdd to Del.icio.us • Technorati ThisTechnorati This • Digg ThisDigg This • Stumble ItStumble it! • Twit ThisTwit This


Peachpit Launches New Web Site

Posted on August 21st, 2007 at 1:05 pm · No Comments
Filed in: RSS Excel Books   RSS Mac OS Books   RSS Word Books   RSS WordPress Books   

And offers 40% discounts on books purchased online.

Peachpit PressJust a quick note to pass along some info I got in e-mail from Peachpit Press, one of my publishers.

Over the last several months, you’ve been talking and now it’s our chance to show you that we’ve been listening. You told us you wanted better and faster searches for our books and content. You said you wanted more videos, better access to our authors, and more ways to get involved. After listening to everything you had to say, we’re proud to introduce the newly redesigned Peachpit.com.

They’ve added features to the site, including online video tutorials, access to blogs, and online reference guides. But the news that might interest you most is that they’re also offering a 40% discount on all books purchased on the site:

To thank you for your feedback and to celebrate our new site we would like to offer you a 40% discount on your purchases. Just order before September 15 and enter coupon code PPT-NEWSITE-EM01 during checkout!

Sounds like a good deal to me. I hope you’ll take advantage of it, perhaps to buy one or more of my books?

→ No Comments • Read 497 Times
Add to Del.icio.usAdd to Del.icio.us • Technorati ThisTechnorati This • Digg ThisDigg This • Stumble ItStumble it! • Twit ThisTwit This


Microsoft Office 2004 for Mac 11.3.7 Update

Posted on August 14th, 2007 at 11:59 pm · No Comments
Filed in: RSS Excel Books   RSS Word Books   

Information from the Microsoft Web Site.

This update fixes a vulnerability that an attacker can use to overwrite the contents of your computer’s memory with malicious code. For more information about this update, see the Microsoft Knowledge Base article (KB940763).

System requirements

Before you install this update, make sure that the Microsoft Office 2004 for Mac 11.3.6 Update is installed on your computer. To verify that you have installed this update, select the Microsoft Component Plugin file in the Microsoft Office 2004/Office folder on your hard disk, and then on the File menu, click Get Info.

Additionally, your computer must meet the following minimum requirements:

  • Operating system: Mac OS X 10.2.8 (Jaguar) or a later version of Mac OS

Note:To verify that your computer meets these minimum requirements, on the Apple menu, click About This Mac.

More information

If you have technical questions or problems downloading or using this update, visit the Microsoft Support page at www.microsoft.com/mac/support to learn about the support options that are available to you.

→ No Comments • Read 429 Times
Add to Del.icio.usAdd to Del.icio.us • Technorati ThisTechnorati This • Digg ThisDigg This • Stumble ItStumble it! • Twit ThisTwit This


Excel Splitting Digits Example

Posted on July 11th, 2007 at 10:20 am · 1 Comment
Filed in: RSS Downloads   RSS Excel Books   

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!

→ 1 Comment • Read 1078 Times
Add to Del.icio.usAdd to Del.icio.us • Technorati ThisTechnorati This • Digg ThisDigg This • Stumble ItStumble it! • Twit ThisTwit This


Microsoft Office 2004 for Mac 11.3.6 Update Now Available

Posted on July 10th, 2007 at 7:14 am · No Comments
Filed in: RSS Excel Books   

Information from Microsoft’s Web site.

This update fixes a vulnerability that an attacker can use to overwrite the contents of your computer’s memory with malicious code. This update also addresses an issue with using public folders in Entourage, and it contains the latest postal code information for Japanese addresses.

System requirements

Before you install this update, make sure that the Microsoft Office 2004 for Mac 11.3.5 Update is installed on your computer. To verify that you have installed this update, select the Microsoft Component Plugin file in the Microsoft Office 2004/Office folder on your hard disk, and then on the File menu, click Get Info.

Additionally, your computer must meet the following minimum requirements:

Operating system: Mac OS X 10.2.8 (Jaguar) or a later version of Mac OS

Note: To verify that your computer meets these minimum requirements, on the Apple menu, click About This Mac.

Improvements for Excel 2004

  • Security is improved. This update fixes vulnerabilities in Excel 2004 that an attacker can use to overwrite the contents of your computer’s memory with malicious code.

Improvements for Entourage 2004

  • Microsoft Exchange public folder data loss issue is fixed. This update fixes an issue that causes data loss when public folder users who have a permission level of “Editor” or greater use Entourage to empty the cache for all public folders on the server running Exchange Server.
  • Japanese postal code dictionary is updated. The Japanese postal code dictionary is updated with the latest information as of May 2007.

More information

If you have technical questions or problems downloading or using this update, visit the Microsoft Support page at www.microsoft.com/mac/support to learn about the support options that are available to you.

→ No Comments • Read 375 Times
Add to Del.icio.usAdd to Del.icio.us • Technorati ThisTechnorati This • Digg ThisDigg This • Stumble ItStumble it! • Twit ThisTwit This


Random Number Generator for Excel

Posted on June 28th, 2007 at 10:14 am · 22 Comments
Filed in: RSS Downloads   RSS Excel Books   

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.

→ 22 Comments • Read 7874 Times
Add to Del.icio.usAdd to Del.icio.us • Technorati ThisTechnorati This • Digg ThisDigg This • Stumble ItStumble it! • Twit ThisTwit This