Home > Articles > Home & Office Computing

Home & Office Computing

66 Items

Sort by Date | Title

The Next Step Beyond the Macro Recorder in VBA Programming
Jan 5, 2016
Don’t rely solely on the macro recorder to teach you VBA programming; it’s meant only as an introduction, and you can’t rely on it for more advanced programming methods. Tracy Syrstad, co-author of Excel 2016 VBA and Macros, provides 10 macro recorder tips that will take your VBA programming skills up a level or two.
Excel 2016 VBA and Macros: Referring to Ranges
Dec 11, 2015
This chapter from Excel 2016 VBA and Macros shows you different ways of referring to ranges, such as specifying a row or column. You’ll also find out how to manipulate cells based on the active cell and how to create a new range from overlapping ranges.
Customizing Excel 2016
Dec 9, 2015
This chapter from Excel 2016 In Depth walks you through examples of customizing the ribbon and discusses some of the important option settings available in Excel.
Sorting Data in Microsoft Excel 2016
Nov 30, 2015
You’ll often need to sort your data in Excel, whether it be numerically, alphabetically, by color, or by icon. In this chapter from My Excel 2016, you’ll learn the various ways of sorting data, allowing you to view data from least to greatest, greatest to least, and even by color.
Video: The Ultimate Guide to Minecraft: Host Your Own Adventure
Jun 18, 2015
In this excerpt from The Ultimate Guide to Minecraft: Multiplayer and Resource Packs, Joel and Zach Comm show you how to set up your own server in multiplayer Minecraft.
Video: How to Shoot Underwater Photos and Video Using the GoPro Hero Camera
May 14, 2015
In this excerpt from My GoPro Hero Camera, Jason R. Rich explains how to take clear, in-focus, high-resolution photos or shoot HD video underwater using any of the GoPro Hero cameras. Viewers learn how to select the ideal GoPro housing and mount for their camera, adjust their camera’s settings, and choose which type of lens filter to use, based on water conditions. This video is ideal for swimmers, snorkelers and scuba divers, for example, who want to use their GoPro Hero camera in or around water.
Video: Introduction to the LIVE4 GoPro Mobile App
May 12, 2015
In this excerpt from My GoPro Hero Camera, Jason R. Rich introduces the LIVE4 GoPro Mobile app and the related online service that allows GoPro Hero users to broadcast live content via the Internet.
Video: Using Optional Accessories with the GoPro Hero Cameras
May 7, 2015
In this excerpt from My GoPro Hero Camera, Jason R. Rich explains what types of optional housings, mounts, and accessories are available for the popular GoPro Hero cameras and the best ways to use them in a wide range of shooting situations. GoPro camera users will discover how to shoot even better photos and videos when they use the right optional equipment with their camera.
Video: Getting Started with Evernote
May 6, 2015
In this video excerpt from Managing Your Information Using Evernote: Gather, Organize, Archive and Share Your Information (Que Video), Jason R. Rich shows you how to get started using Evernote.
Video: Using the Time Lapse Video Shooting Mode with Your GoPro Hero4 Camera
May 5, 2015
In this excerpt from My GoPro Hero Camera, Jason R. Rich explains how to use the new Time Lapse Video feature offered with the February 2015 GoPro Camera Software update. GoPro Hero4 users will learn how to use this feature, and discover some things it can be used for.
Video: Using Moleskin Smart Notebooks with Evernote
May 4, 2015
In this video excerpt from Managing Your Information Using Evernote: Gather, Organize, Archive and Share Your Information (Que Video), Jason R. Rich shows you how to use a special line of paper-based Moleskine notebooks and your smartphone camera or tablet to scan your pages and quickly import them into Evernote.
Video: Using Your GoPro Hero 3+: Videography Tips and Tricks
Apr 14, 2015
In this excerpt from Using Your GoPro Hero3+, Jason R. Rich offers tips that will help you ensure that you capture the most visually interesting, smooth, and in-focus video footage possible, regardless of the shooting situation.
Video: Predictive Analytics with Excel: Smoothing Constant and Exponentiation
Jan 23, 2015
In this excerpt from Predictive Analytics with Excel LiveLessons (Video Training), Downloadable Video: Exponential Smoothing and Autoregression, Conrad Carlberg takes a look a exponential smoothing.
Keep Your Web Surfing History Private when Using Safari on the iPhone/iPad
Apr 23, 2014
Jason R. Rich discusses ways to keep your web surfing history and activities private when using the Safari browser on your iOS mobile device. Meanwhile, you can reverse some of the information offered within this article to keep close tabs on the web surfing activities of your kids.
Registering and Downloading Minecraft: The Ultimate Player's Video Guide to Minecraft
Jan 31, 2014
Make your own reality with Minecraft, the game of adventure, survival, and imagination that everyone is talking about! This video will help you get started by showing you how to download and register Minecraft, quickly and easily.
Computer Resources for Seniors: The Best Books, Videos, and Websites for Learning About PCs and Gadgets
Sep 5, 2013
Michael Miller guides you through some of the best computer and technology resources available for seniors, including books, video tutorials, and websites.
Getting Data onto a Sheet in Excel 2013
By Tracy Syrstad
May 13, 2013
This chapter provides tricks for copying down data, fixing entered data, and helping your users enter data correctly by providing a predefined list of entries for Excel 2013 users.
Working with Formulas and Functions in Excel 2013
May 8, 2013
This chapter explains your options for creating formulas in Excel across the whole spectrum from basic entries to more complex ones.
Customizing an Excel 2013 Pivot Table
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.
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.

Page 1 2 3 4 Next >