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