| 41.
| - Using the Philips Hue Lighting System in Your Home and Controlling It with Your iPhone or iPad
-
By
Jason Rich
- Mar 20, 2013
- Jason R. Rich introduces you to Philips Hue, the world’s first LED home lighting system that can be managed and controlled using an Apple iPhone or iPad.
|
| 42.
| - My iMac: Sharing Devices, Files, and Services on a Network
-
By
John Ray
- Mar 18, 2013
- This chapter helps you make your iMac an extension of your personality by customizing and personalizing your workspace.
|
| 43.
| - How Mobile Networks Work
-
By
Michael Miller
- Mar 14, 2013
- This chapter describes how cellular networking works — and how these networks relate to the other wireless networks you employ on a daily basis.
|
| 44.
| - Customizing an Excel 2013 Pivot Table
-
By
Bill Jelen, Michael Alexander
- Mar 12, 2013
- This chapter covers six functional areas in making pivot table customization: Minor Cosmetic Changes, Layout Changes, Major Cosmetic Changes, Summary Calculations, Advanced Calculations, and Other (less common) Options.
|
| 45.
| - Using the Nike+ FuelBand to Help You Stay in Shape
-
By
Jason Rich
- Mar 12, 2013
- Jason R. Rich takes a look at the Nike+ FuelBand fitness accessory and helps you determine if this $149.95 Apple iPhone accessory can become a useful tool in your ongoing personal fitness routine.
|
| 46.
| - Getting Started with Siri
-
By
Erica Sadun, Steve Sande
- Mar 11, 2013
- This chapter shows how to get started with Siri: how to enable it, launch the service, and try it out.
|
| 47.
| - Sync and Share Files Using iCloud
-
By
Jason Rich
- Mar 7, 2013
- This chapter shows how to get the most out of your iCloud account by syncing and backing up files and devices.
|
| 48.
| - How Excel's LINEST() Handles Collinearity
-
By
Conrad Carlberg
- Mar 5, 2013
- Excel expert Conrad Carlberg discusses the implications of the manner in which LINEST() implements QR decomposition for its results—implications which are largely undocumented and which involve the unannounced removal of a variable from the regression equation.
|
| 49.
| - Working with SmartArt in PowerPoint 2013
-
By
Patrice-Anne Rutledge
- Mar 4, 2013
- This chapter introduces SmartArt Graphics and shows how you can insert and modify them in your PowerPoint 2013 documents.
|
| 50.
| - Adding Art to Documents in Office 2013
-
By
Steve Johnson, Perspection Inc.
- Mar 1, 2013
- This chapter shows how you can add pictures, charts, and other graphics to spruce up your Office 2013 documents.
|
| 51.
| - My Google Nexus 7 and Nexus 10: Google Now and Navigation
-
By
Craig James Johnston
- Feb 28, 2013
- This chapter shows how to use your Google Nexus Tablet as a GPS Navigation device with Google Maps, Navigation, and Google Now.
|
| 52.
| - How to Read Kindle Books on Your Samsung Galaxy Tab 2
-
By
Eric Butow
- Feb 27, 2013
- You don’t need a Kindle tablet from Amazon to download and read e-books and periodicals from Amazon’s Kindle Store. Eric Butow shows you how to use the built-in Kindle app on the Galaxy Tab 2 to shop for, purchase, and read materials from the Kindle Store on your Tab 2.
|
| 53.
| - Civility in the Digital Age: Who Are the Troublemakers?
-
By
Andrea Weckerle
- Feb 26, 2013
- Online troublemakers come in a wide variety of types. This chapter describes the various troublemakers and offers some advice on dealing with them.
|
| 54.
| - Excel's LINEST() Function Deconstructed
-
By
Conrad Carlberg
- Feb 25, 2013
- For the user to fully understand how LINEST() calculates its results, it is necessary to walk through the individual calculations, starting with the coefficients, moving to the sums of squares and ending with the standard errors. This article discusses the required calculations and shows how they can be carried out directly on the worksheet using just a smattering of Excel's matrix functions.
|
| 55.
| - Unboxing the LEGO Mindstorms NXT Set
-
By
John Baichtal
- Feb 22, 2013
- This chapter looks at every part that comes with the Lego Mindstorms NXT 2.0 set and talks a little about each one.
|
| 56.
| - Excel 2013 VBA and Macros: Referring to Ranges
-
By
Bill Jelen, Tracy Syrstad
- Feb 21, 2013
- This chapter shows you different ways of referring to ranges such as specifying a row or column. You also find out how to manipulate cells based on the active cell and how to create a new range from overlapping ranges.
|
| 57.
| - Using the Excel 2013 Interface
-
By
Bill Jelen
- Feb 20, 2013
- This chapter introduces the Excel 2013 interface elements such as the ribbon, formula bar, and status bar.
|
| 58.
| - Exploring the Game Hub for the Galaxy Tab 2
-
By
Eric Butow
- Feb 14, 2013
- The Game Hub app is the place to find games for your Galaxy Tab 2 that you can install and play by yourself or against other game players through your Wi-Fi connection. Eric Butow shows how the app displays a list of installed games you can play by tapping on the game tile.
|
| 59.
| - Share Content Across Devices with Samsung’s AllShare Play App
-
By
Eric Butow
- Feb 13, 2013
- The AllShare Play app allows you to share photos, music, videos, and other files on your Galaxy Tab 2 with one or more file sharing services. You can also share files with other devices that have the AllShare Play app installed, such as a smartphone.
|
| 60.
| - Forcing the Constant in Regression to Zero: Understanding Excel's LINEST() Error
-
By
Conrad Carlberg
- Feb 12, 2013
- One of the options in Excel's LINEST() function is to force the constant in the regression equation to a value of zero. This article focuses on a serious error in the LINEST() results when the option is selected. The error was not corrected until Excel 2003, and it remains in Excel 2010.
|