Paul McFedries' Tech Tonic

Making the world a better place, one computer book at a time
  • 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.

  • 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.
  • 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.

  • 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.
  • 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."

More Posts Next page »
Copyright © 2008 Logophilia Limited and Paul McFedries
Powered by Community Server (Commercial Edition), by Telligent Systems