Paul McFedries' Tech Tonic

Making the world a better place, one computer book at a time

Follow me!  

Books, Books, Books

iPhone 4 Portable Genius
Published: August 2, 2010
Excel PivotTables and PivotCharts 2/E
Published: June 30, 2010
Excel PivotTables and PivotCharts 2/E
Published: June 28, 2010
Twitter Tips, Tricks, and Tweets
Published: June 1, 2010
Formulas and Functions with Excel 2010
Published: May 24, 2010
Excel 2010 Visual Quick Tips
Published: May 10, 2010
iPad Portable Genius
Published: May 3, 2010
Teach Yourself VISUALLY Excel 2010
Published: April 26, 2010
Excel 2010 Simplified
Published: April 26, 2010
Windows Home Server Unleashed, Second Edition
Published: April 5, 2010
The Complete Idiot's Guide to Windows 7
Published: October 6, 2009
Windows 7 Visual Quick Tips
Published: October 5, 2009
Windows 7 Simplified
Published: September 28, 2009
Teach Yourself VISUALLY Windows 7
Published: September 15, 2009
Teach Yourself VISUALLY Mac OS X Snow Leopard
Published: September 8, 2009
Mac OS X Snow Leopard Simplified
Published: September 8, 2009
iPhone 3GS Portable Genius
Published: August 3, 2009
Microsoft Windows 7 Unleashed
Published: July 24, 2009
Teach Yourself VISUALLY Microsoft Office 2008 for Mac
Published: June 9, 2009
Twitter Tips, Tricks, and Tweets
Published: May 5, 2009
Switching to a Mac Portable Genius
Published: April 6, 2009
Tweak It and Freak It
Published: March 27, 2009
InternetSimplified
Published: February 24, 2009
MacBook Air Portable Genius
Published: November 17, 2008
Teach Yourself VISUALLY Macs
Published: October 27, 2008
Macs Portable Genius
Published: October 8, 2008
iPhone 3G Portable Genius
Published: October 7, 2008
iPhone 3G Portable Genius
Published: August 11, 2008
The Complete Idiot's Guide to Weird Word Origins
Published: August 5, 2008
Build It. Fix It. Own It.
Published: May 29, 2008
Microsoft Windows Vista Unleashed
Published: April 4, 2008
Teach Yourself VISUALLY Windows Home Server
Published: January 29, 2008
Networking with Microsoft Windows Vista
Published: December 19, 2007
Excel 2007 PivotTables
Published: November 5, 2007
Windows Home Server Unleashed
Published: September 20, 2007
Published: September 18, 2007
Published: May 27, 2007
Published: May 16, 2007
Published: May 1, 2007
Published: March 30, 2007
Formulas and Functions with Excel 2007
Published: March 14, 2007
The Complete Idiot's Guide to Microsoft Windows Vista
Published: January 2, 2007
Windows Vista: Top 100 Simplified Tips & Tricks
Published: December 6, 2006
Teach Yourself VISUALLY Windows Vista
Published: November 29, 2006
The Unofficial Guide to Microsoft Office 2007
Published: October 23, 2006
Microsoft Windows XP Unleashed
Published: December 7, 2005
Teach Yourself VISUALLY Windows XP, Second Edition
Published: March 21, 2005
Windows XP: Top 100 Simplified Tips & Tricks
Published: March 21, 2005
The Complete Idiot's Guide to Creating a Web Page & Blog, 6/E
Published: September 7, 2004
Word Spy
Published: February 17, 2004
The Complete Idiot's Guide to a Smart Vocabulary
Published: May 7, 2001
PowerPoint 2007 Visual Quick Tips
Published: December 29, 2006
Microsoft Office 2007 Visual Quick Tips
Published: December 29, 2006 
Microsoft Windows Vista Visual Quick Tips
Published: December 26, 2006
Microsoft Windows Vista Unveiled
Published: June 19, 2006
MySpace Visual Quick Tips
MySpace Visual Quick Tips
Published: August 21, 2006
Microsoft Windows XP Visual Quick Tips
Microsoft Windows XP Visual Quick Tips
Published: January 11, 2006
Tricks of the Microsoft Office Gurus
Tricks of the Microsoft Office Gurus
Published: April 22, 2005
Access 2003 Forms, Reports, and Queries
Published: August 28, 2004
Formulas and Functions with Microsoft Excel
Formulas and Functions for Excel 2003
Published: June 21, 2004
The Absolute Beginner's Guide to VBA
The Absolute Beginner's Guide to VBA
Published: March 19, 2004
Insider Power Techniques for Windows
Insider Power Techniques for Windows XP
Published: February 12, 2003
The Complete Idiot's Guide to Creating a Web Page, Fifth Edition
The Complete Idiot's Guide to Creating a Web Page 5/E
Published: February 1, 2002
Special Edition Using JavaScript
Special Edition Using JavaScript
Published: June 19, 2001
The Unauthorized Guide to Windows ME
Published: September 30, 2000
The Complete Idiot's Guide to Windows ME
Published: August 2, 2000
The Complete Idiot's Guide to Windows 2000 Professional
Published: February 1, 2000
The Complete Idiot's Guide to Creating a Web Page 4/E
Published: December 15, 1999
The Unauthorized Guide to Windows 98
Published: September 7, 1999
VBA for Office 2000 Unleashed
Published: June 1, 1999
The Complete Idiot's Guide to More Windows 98
Published: August 18, 1998
Windows 98 Unleashed Professional Reference Edition
Published: June 5, 1998
Windows 98 Unleashed
Published: June 5, 1998
The Complete Idiot's Guide to Windows 98
Published: May 1, 1998
The Complete Idiot's Guide to Creating an HTML Web Page 3/E
Published: January 1, 1998
The Complete Idiot's Guide to Windows 95 2/E
Published: August 1, 1997
Windows 95 Unleashed
Published: July 1, 1997
Visual Basic for Applications Unleashed
Published: March 1, 1997
The Complete Idiot's Guide to Creating an HTML Web Page 2/E
Published: February 1, 1997
Microsoft Office 97 Unleashed
Published: December 1, 1996
The Complete Idiot's Guide to Windows NT Workstation
Published: August 1, 1996
Windows 95 Unleashed
Published: July 1, 1996
The Complete Idiot's Guide to Creating an HTML Web Page
Published: February 1, 1996
Microsoft Office Unleashed
Published: January 1, 1996
Excel for Windows 95 Unleashed
Published: October 1, 1995
The Complete Idiot's Guide to Windows 95
Published: August 1, 1995
Navigating the Internet
Published: July 1, 1995
The Complete Idiot's Guide to Internet E-Mail
Published: March 1, 1995
The Complete Idiot's Guide to Usenet Newsgroups
Published: February 1, 1995
The Complete Idiot's Guide to Windows 3.1
Published: November 1, 1994
The Complete Idiot's Guide to WordPerfect for Windows 2/E
Published: November 1, 1994
The Complete Idiot's Guide to WordPerfect 2/E
Published: October 1, 1994
The Complete Idiot's Next Step with Windows
Published: September 1, 1994
The Complete Idiot's Guide to WordPerfect for Windows
Published: August 1, 1994
WordPerfect for Windows Cheat Sheet
Published: July 1, 1994
The Complete Idiot's Guide to Access
Published: March 1, 1994
Excel 5 Super Book
Published: January 1, 1994
The Complete Idiot's Guide to Windows 3.0
Published: September 1, 1993
The Complete Idiot's Guide to WordPerfect
Published: June 1, 1993
DOS 6 for the Guru Wanna-Be
Published: June 1, 1993
Windows Woes
Published: January 1, 1993
The First Book of Quicken 6
Published: December 1, 1992
The First Book of Quattro Pro for Windows
Published: November 1, 1992
At Home with Windows
Published: October 1, 1992
Excel 4 Super Book
Published: September 1, 1992
At Home with MS-DOS
Published: July 1, 1992
The First Book of Quicken 5
Published: January 1, 1992
The 10 Minute Guide to the Norton Utilities
Published: October 15, 1991

New Edition: iPhone 4 Portable Genius

My book iPhone 4 Portable Genius is now available! This is another book in Wiley's great Portable Genius series, which features full-color screen shots, a clean, crisp layout, and content that turns the book into a portable version of Apple's Genius Bar. In this case, of course, the content is related to the iPhone 4 smartphone, and you learn all kinds of tips, tricks, and workarounds to help you get the most out of your iPhone 4 and the new iOS 4 operating system.

For much more info about the book, see the book's home page. If you have questions or comments about the book, see The Dialogue Box, this site's discussion group.

New Book: Using the Microsoft Office Web Apps

Using the Office Web AppsMy book Using the Microsoft Office Web Apps is fresh off the printer! In this book I show you how to get the most out of the Office Web Apps, Microsoft's new cloud-bound applications. You learn how to use both Windows Live SkyDrive and SharePoint 2010, and I put all four of the Web Apps—Word, Excel, PowerPoint, and OneNote—through their paces.

For much more information about the book, see the book's home page. If you have questions or comments about the book, see The Dialogue Box, this site's discussion group.

New Edition: Microsoft Excel PivotTables and PivotCharts, 2nd Edition

Excel PivotTables and PivotCharts 2/EThe second edition of my book Microsoft Excel PivotTables and PivotCharts is now available. The book—fully revised and updated for Excel 2010—covers building PivotTables, customizing PivotTable data and calculations, creating custom calculations, visualizing data with PivotCharts, and creating advanced PivotTables from multiple consolidatation ranges, external databases, and even OLAP data cubes.

For much more information about the book, see the book's home page. If you have questions or comments about the book, see The Dialogue Box, this site's discussion group.

New Edition: Twitter Tips, Tricks, and Tweets, 2nd Edition

Twitter Tips, Tricks, and TweetsThe latest editon of my Twitter book—Twitter Tips, Tricks, and Tweets, 2nd Edition—is now available to order, purchase, or pre-order (depending on where you live and whether you prefer to shop in your pajamas). This book takes you on a complete tour of the Twitter universe, from setting up your account to using advanced Twitter tools, and also includes complete coverage of all the changes to Twitter and the various Twitter tools that have happened over the past year. Whether you're a member of the Twitterati or have only just heard of this Twitter thing, this book's got you covered.

For more information about the book, see the book's home page. If you have questions or comments about the book, see The Dialogue Box, this site's discussion group.

Posted Jun 01 2010, 03:23 PM by Paul with no comments
Filed under:

New Edition: Formulas and Functions: Microsoft Excel 2010

Formulas and Functions with Microsoft Office Excel 2010The latest edition of my book Formulas and Functions: Microsoft Excel 2010 is now available. This book demystifies worksheet formulas and presents the most useful Excel functions in an accessible, jargon-free way.

To find out more about Formulas and Functions: Microsoft Excel 2010, see the book's home page. If you want to talk about the book or ask a question or two, head over to The Dialogue Box.

New Book: Microsoft Excel 2010 Visual Quick Tips

Excel 2010 Visual Quick TipsMy book Microsoft Excel 2010 Visual Quick Tips was released on May 10, 2010. This beautifully book (if I do say so myself) offers more than 125 practical and useful tips and tricks laid out in easy-to-follow step-by-step instructions, where each step is illustrated with a full-color screen shot. This book shows you how to customize and configure Excel 2010, get the most out of workbooks, worksheets, and formulas, enhance Excel security and privacy, import and analyze data, and much more.

For much more information about the book, see the book's home page. If you have questions or comments about the book, see The Dialogue Box, this site's discussion group.

New Book: iPad Portable Genius

My book iPad Portable Genius is now available! This is another book in Wiley's great Portable Genius series, which features full-color screen shots, a clean, crisp layout, and content that turns the book into a portable version of Apple's Genius Bar. In this case, of course, the content is related to the iPad, and you learn all kinds of tips, tricks, and workarounds to help you get the most out of your iPad.

For much more info about the book, see the book's home page. If you have questions or comments about the book, see The Dialogue Box, this site's discussion group.

New Book: Teach Yourself VISUALLY Microsoft Excel 2010

Teach Yourself VISUALLY Windows 7My book Teach Yourself VISUALLY Microsoft Excel 2010 was released on April 26, 2010. This book uses the famous full-color, profusely illustrated style that's the hallmark of the Teach Yourself VISUALLY series. In more than 155 lessons, this book gives you the full scoop on the Excel 2010 spreadsheet program. You learn what you can do with Excel, and then you learn how to enter and edit worksheet data, format data, manipulate worksheets and workbooks, build formulas, use Excel's built-in functions, analyze data, create charts, and much more.

For much more information about the book, see the book's home page. If you have questions or comments about the book, see The Dialogue Box, this site's discussion group.

New Book: Microsoft Excel 2010 Simplified

Windows 7 SimplifiedMy book Microsoft Excel 2010 Simplified was released on April 26, 2010. This beautifully laid out book offers straightforward, practical tasks, where each step is illustrated with a full-color screen shot. In 110 lessons, this book takes you on a tour of the most useful and essential Excel 2010 tasks. You learn some important basics to get you started, and then you learn how to enter, edit, and format data, build formulas, manipulate worksheets and workbooks, create charts, collaborate with other Excel users, and more.

For much more information about the book, see the book's home page. If you have questions or comments about the book, see The Dialogue Box, this site's discussion group.

Mirrors, Mirrors, on the Walls

If you're standing in a room where the walls are completely lined with mirrors, and someone lights a match, is it possible to design the room so that another person in the same room never sees the match, despite all the mirrors? The surprising answer is yes, you can, as shown over at Futility Closet.
Posted Apr 29 2010, 10:31 AM by Paul with no comments
Filed under: ,

Textual Productivity and the Editors' Choice App

I've been using the New York Times Editors' Choice app on my iPad for a few weeks now. It's a pretty good way to discover interesting stories in the Times, but each time I use it I feel a sense of disconnection, of something missing. This unease was just a low-level background hum until Steven Johnson (author of, among other terrific books, Everything Bad Is Good for You and The Ghost Map), nailed it his lecture The Glass Box and the Commonplace Book (the video is here; SJ shows up at about 9:00):

You can’t do anything with the words. They’re frozen there, uncopyable, unlinkable, like some beautiful ice sculpture. Frozen is the right word, because we’re so used to selecting and copying digital text, encountering text on a screen that can’t be selected leaves you with a strange initial assumption: that the application has crashed, and the screen is frozen.

Ah, that's it. [Insert sound of hand slapping forehead.] So much of the text you read on the iPad is web-enabled, that the absense of links in the Times app is just plain weird. And not being able to quote from a story without—gasp!—typing it by hand, is perverse:

When your digital news feed doesn’t contain links, when it cannot be linked to, when it can’t be indexed, when you can’t copy a paragraph and paste it into another application: when this happens your news feed is not flawed or backwards looking or frustrating. It is broken.

In the same essay, Johnson coins the phrase "textual productivity":

Ecologists talk about the "productivity" of an ecosystem, which is a measure of how effectively the ecosystem converts the energy and nutrients coming into the system into biological growth. A productive ecosystem, like a rainforest, sustains more life per unit of energy than an unproductive ecosystem, like a desert. We need a comparable yardstick for information systems, a measure of a system’s ability to extract value from a given unit of information. Call it, in this example: textual productivity. By creating fluid networks of words, by creating those digital-age commonplaces, we increase the textual productivity of the system.

The real problem, then, with the New York Times app — and, as Johnson reminds us, the iBooks app, with its inability to copy even snippets from DRM-encrusted ebooks — is the extreme lack of textual unproductivity. These apps add precisely nothing to the information ecosystem, which in this digital day and age just feels wrong.

Posted Apr 28 2010, 09:55 AM by Paul with 1 comment(s)
Filed under: ,

Neologism of the Day

Today on Word Spy:

collaborative consumption n. An economic model in which consumers use online tools to collaborate on owning, renting, sharing, and trading goods and services.

Attention-Getting Language

My April column for IEEE Spectrum Magazine, titled "Attention-Getting Language," is now online and ready to read.

Creating a Folder-Opening Taskbar Shortcut in Windows 7

Windows 7 enables you to pin programs to the taskbar, which is great for one-click access to the programs you use most often. You can also pin documents to the taskbar, although in this case Windows 7 adds the document to the program's jump list, so you first right-click the program's taskbar icon, and then click the document. You can also do this with folders by pinning a folder to the Windows Explorer taskbar icon.

However, a reader recently asked me if it was possible to simply have a folder shortcut pinned to the taskbar, so that you could open the folder just by clicking its taskbar icon. This was a tricky proposition, but I finally figured out a workaround:

  1. Create a new text file and add the following code to it:

Set objWshShell = WScript.CreateObject("WScript.Shell")
objWshShell.Run "folder", 1, False

In the second line, replace folder with the path of the folder you want to open.

  1. Save the text file as a VBScript file (.vbs extension). For fastest service, save the file on your desktop.
  2. Display your desktop.
  3. Drag the new VBScript file to the taskbar, and drop it there. This pins the Windows Based Script Host (WSH) program to the taskbar, which isn't quite what you want.
  4. To fix this, hold down Shift, right-click the WSH icon, and then click Properties. Windows 7 opens the property sheet for the WSH shortcut.
  5. In the Target text box, add the path to the VBScript file after the wscript.exe executable path. For example, if your VBScript file is named folder.vbs, and it resides on your desktop, then the Target text box will now look like this (where user is your user name):

C:\Windows\System32\wscript.exe c:\users\user\desktop\folder.vbs

  1. Click OK and, voila!, your folder-opening taskbar icon is in place.
Posted Apr 25 2010, 02:33 PM by Paul with 1 comment(s)
Filed under: ,

The New 13-Inch MacBook Pro: Why the Poky Processor?

I was updating one of my Mac books the other day, and I came across the new processor specs for the latest iteration of the MacBook Pro (the bolding is mine):

The MacBook Pro lineup starts with advanced Intel Core 2 Duo processors running at up to 2.66GHz. And things only get faster from there. The 15- and 17-inch models now feature the latest Intel Core i5 and Core i7 processors — the fastest dual-core processors on the market — which reach Turbo Boost speeds up to 3.33GHz.

Hunh!? The 15- and 17-inch models rock the speedy Core i5 and i7 CPUs, but the 13-inch model remains stuck with a poky Core 2 Duo processor (albeit running at a slightly faster clip than in previous versions)? This made no sense to me, but my eyes were subsequently opened by the alpha geeks at Ars Technica:

It turns out that there are several reasons that factored into Apple's decision, including cost, graphics performance, battery life—and the laws of physics.

The full story is fascinating, but if you just want the digested version, here's the nut graf:

As Steve Jobs recently explained in one of his increasingly frequent, succinct e-mails to customers: "We chose killer graphics plus 10 hour battery life over a very small CPU speed increase. Users will see far more performance boost from the speedy graphics."

Posted Apr 22 2010, 06:42 AM by Paul with 1 comment(s)
Filed under:
Copyright © 2008 Logophilia Limited and Paul McFedries
Powered by Community Server (Commercial Edition), by Telligent Systems