Archive for August, 2010

Computer literacy courses for Mac and Windows include assessments to assist in learning

Published by | Tuesday, August 10th, 2010

This week, we released two courses with a new feature: Chapter-level assessments to help you determine how well you know your computer and what you might need to review further. Both Computer Literacy for Windows and Computer Literacy for the Mac with Garrick Chow walk through the skills necessary to use computers comfortably, while improving learning, productivity, and performance.

Both courses offer a thorough introduction to computers, networks, and computer peripherals such as printers, digital cameras, and more. In addition, basic procedures with software applications, the Internet, and email are covered. The assessment files includes an assessment movie, chapter-level assessments, and answer keys. Let us know what you think!

Computer Literacy for Windows

Computer Literacy for the Mac

Top Excel Power Shortcut #2: Converting formulas to values

Published by | Monday, August 9th, 2010

We’re very excited about our upcoming course, Excel 2010 Power Shortcuts with Dennis Taylor, that’s due to be released soon—so excited that we’ve decided to give you a sneak peek at some of his top power shortcuts. Here’s the second:


If you want to convert formulas to values in Excel, you don’t need to use a multi-step copy and paste process. This time-saving shortcut shows how you can convert formulas with a simple drag.

Did you miss the first top shortcut? Watch Top Excel Power Shortcut #1: Entering the same data into nonadjacent cells.

Essential tips and techniques for getting the most out of your Apple iPad

Published by | Friday, August 6th, 2010

In iPad Tips and Tricks, Mac productivity expert Christopher Breen provides essential tips and techniques for getting the most out of the Apple iPad. The course shows how to get productive on the iPad immediately, with tips for effective gesturing and typing and for loading it up with content. It demonstrates how to connect the iPad with the rest of the world, how to sync documents between the iPad and a desktop computer or cloud-based services, and how to configure email and deal with the fact that the iPad has no spam filter. It demonstrates built-in and third-party solutions for opening and editing files on the iPad. Finally, it offers tips for troubleshooting the iPad when the device doesn’t work as expected.

This course will be expanded with additional tips and techniques later this year.

Top Excel Power Shortcut #1: Entering the same data into nonadjacent cells

Published by | Thursday, August 5th, 2010

We’re very excited about our upcoming course, Excel 2010 Power Shortcuts with Dennis Taylor, that’s due to be released soon—so excited that we’ve decided to give you a sneak peek at some of his top power shortcuts. Here’s the first:

In Excel, if you have to enter the same data into multiple cells, you don’t need to retype it or even copy and paste. This time-saving shortcut shows how you can enter text or formulas into multiple, nonadjacent cells simultaneously.

Making the move to Excel 2010 from Excel 2003

Published by | Tuesday, August 3rd, 2010

In Migrating from Excel 2003 to Excel 2010, author David Rivers walks through the switch to Excel 2010 from Excel 2003. The course covers key differences in Excel 2010, including the Ribbon interface and the Office Open XML file format, and shows how to perform common Excel 2003 tasks in Excel 2010.