Absolute Activity Search Results

How To: DIY your own iPad stylus

While the iPad can do many things, it is missing the ability to be controlled by anything other than a finger. This can be frustrating if you would like to use your iPad for more intricate activities such as drawing or designing.

How To: Use macros in Microsoft Excel 2007

Looking for an introduction on how to work with macros in Microsoft Excel 2007? Learn how to create linkage formulas in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started using absolute and relative macros in your own Excel 2007 workbooks, watch this free...

How To: Build a conditional average calculation table in Exel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 583rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF & IFERROR functions with absolute and mixed cell references to create a large table of conditional average calculations (averaging with criteria).

How To: Stop Your iPhone from Counting Steps & Tracking Fitness Activity

Every iPhone since the 5S has come equipped with a microchip called a motion coprocessor, which collects data from integrated accelerometers, gyroscopes and compasses, and can then transfer that information to fitness apps that track physical activity. Essentially, the chip knows whether you're running, walking, sleeping, or driving — but what if you don't want it to?

How To: Make a sundial

This video looks at some of the issues around constructing sundials. Included are step by step instructions for building a horizontal sundial and instructions for setting it up. This activity supports both science and math curriculums. A good project providing an opportunity to use protractors and rulers. The sundial example in this video is designed for use at latitudes close to 45 degrees north.

How To: Replace (or install) a brand new toilet in your bathroom

You're in drastic need of a new toilet, but you're scared of the cost of installation— don't worry, you can install it yourself with absolute ease. You don't need a plumber for this at all. It's actually one of the easiest home repairs you can DIY, right alongside a leaky faucet. This step-by-step tutorial will show you the whole process of removing your old "crap" toilet and install a bright, shiny new one. You'll need a putty knife, tape measure, crescent wrench, gloves and wax ring.

How To: Monitor memory use in Mac OS X with Activity Monitor

You can use Activity Monitor to see how your Mac is using memory. But what do free, active, inactive and wired mean? How about page ins and page outs? Plus, learn to use them to figure out if you need more memory. It's easy! So easy, in fact, that this home-computing how-to from MacMost can present a full overview of the process in about four minutes. For more information, including detailed, step-by-step instructions, and to get started monitoring your own RAM use, watch this Apple lover's g...

How To: Find the hidden error code behind your Xbox 360's RLoD

It goes by many names. The RLoD (Red Lights of Death), the RRoD (Red Ring of Death), absolute disaster. Whatever you call it, the XBox 360 error that causes many console's front LED's to turn red in rage and cessation of function has caused all sorts of headaches for consumers and Microsoft. It can be caused by a couple of different cooling-related issues, and determining the error code that has caused your console to malfunction can go a long way to helping you fix it. This video will show y...

How To: Fix other people's Microsoft Excel spreadsheets

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:

How To: Name cell ranges and use names in formulas in MS Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;

How To: Make an Excel dynamic named range across multiple rows

Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...

How To: Make natural elderberry syrup for cold and flu season

Learn how to harvest your elder tree! If you have an elder in your backyard, you can finally do something special with those elderberries. Mountain Rose Herb shows you the steps required to make delicious elderberry syrup with this video recipe. This herbal syrup can be used for colds, flu and coughs. It's a simple natural home remedy with dried elderberries.

How To: See If Anyone's Hacked into Your Dropbox, Facebook, or Gmail Accounts

Dropbox announced Tuesday that a recent security breach compromised a list that included the email addresses of certain Dropbox users. To avoid future complications, the service announced that it would be implementing two-factor authentication, and even more useful, a security page that lets you monitor all activity on your account. In light of this and other recent web security threats, you might also want to know that services like Gmail, Facebook, and Yahoo! Mail have similar pages where y...

How To: Choose a bicycle helmet

In this how-to video, you will learn how to choose a proper bicycle helmet. They are the most important safety equipment a cyclist owns. Picking the right helmet starts with understanding what a helmet consists of. The micro shell is the thin tough layer that covers and protects the interior of the helmet. It absorbs the impacts of the helmet. The adjustable retention system consists of 2 straps. The chin strap goes across your chin and the other goes across the back of your head. The vents a...

How To: Do activities and crafts with toddlers

In this video series you will learn several easy and fun ideas for your child to participate in that will challenge him or her and bring their creativity to the surface. It will walk you step by step through each craft and tell you what materials you will need as well as give you alternatives to certain types of materials. This fifteen video series will keep you and your Toddler occupied for hours of fun and creativity and give your child something to be proud of once he or she is done.

How To: Do an Easter basket art activity with your kids

In this video, we learn how to do an Easter basket art activity with your kids. First, grab some white paper bags and have the child cut a line across the top of the bag. You can also use decorative scissors for more of an Easter effect. After this, let the child use paint, cookie cutters, glue, glitter, crayons, and markers to paint all over the bag! Let them make any design that they would like for the upcoming season! Once finished, let these dry and then open them up! These can be used fo...

How To: Take a patient's sexual history as a doctor or nurse

Sexual activity is a health behaviour and therefore it is important that doctors are able to gather information about sex confidently and competently. In this consultation, the patient presents to his GP with a worry that he may have contracted a sexually transmitted disease. It is important for the GP to enquire about the patient's risk factors in a sensitive and non-judgmental way. The GP needs to gather information about the patient's sexual activity and work with the patient to negotiate ...

How To: Attach a pendant to an earring hook easily

What is the absolute, most basic thing you need to know in order to asemble an earring? Attaching the earring to its earring hook, of course. By learning how to do this, you'll be able to create a neverending host of funky earrings, from cool guitar pick earrings to drop pendant earrings.

How To: Build a YouTube channel presence and get subscribers

Any successful blogger and business brand will tell you that social media is really the only PR you need these days. Whether you're tackling Facebook, MySpace, Twitter, or planning a takeover of YouTube, getting your product name out there - even if it's just your own name because you run a blog - is the number one absolute, most importan thing you can do to sell your brand.

How To: Use the Scale Node in the Blender 2.5 Compositor

In this tutorial, you'll see how to use the Scale Node in the Blender Compositor to manipulate an image. You'll see how to stretch it, spin/rotate, and have all sorts of fun with uniform linear distortion. The clip discusses the difference between resolution handling between the renderer and the node system. Hence we have the scale node to scale an input image at one resolution to match the render resolution. I discuss using Absolute scaling, and relative/percentage scaling, relative aspect r...

How To: Program using simple code in Java

Java is a wonderful programming language which is widely used all over the world. To do programming in Java you will need a Java Development Kit which is also called as JDK in short. This can be downloaded from the Java Website for free. To improve and assist in your developmental activities you will also need an IDE, which is an Integrated Development Environment where you can develop, compile and test you code at once place. Though Java code can be written in a normal text pad and compiled ...

How To: Translate a sentence into math symbols

We will be translating the sentence "twice y differs from 5 by more than two, “into a mathematical equation. The word twice generally means two times, so 2*y (because y comes next in the sentence). Differs normally means is different and a difference from something in a mathematical sentence means subtraction most of the time, thus minus five. We don't know if we’re talking about below 5 or above 5 on the number line, so we put absolute value around the equation. More than implies a greater t...

How To: Use Excel mixed cell references in formulas

Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same cell, even when you are copying a formula to a different place on the worksheet. Other times, you will want the items in the formula to change as you copy them across the columns. You will see how such actions work thro...

How To: Make three different origami snowflakes

An easy step by step video showing us how to make snow flakes from paper. It shows the ways of making three different types of snow flakes clearly and slowly so that even a little child watching it would be able to make it. This could be a fun activity for the parents along with their kids to spend time effectively. This activity could turn to be a good exercise for the little fingers and add to their pride of learning a new art. So, go ahead and enjoy making snow flakes and decorate your chi...

How To: Create a Facebook group in less than five minutes

Learn how to create a Facebook group in less than 5 minutes with this straightforward video. You will first learn how to navigate your Facebook page and where to set up your group. This is a video that gives you the absolute basics for the first-time Facebook user. After you create your group, you will be able to invite any friends you may have on Facebook. This is an easy way to communicate with people who may have the same interests as you.

How To: Set up an Airport Extreme for outside computer access

This simple video tutorial explains how to use Airport Utility to configure your Airport Extreme so you can access your Apple computer remotely for file and screen sharing. It explains how to setup DHCP IP reservations and port forwarding using Manual Setup option of the Airport Utility. Considering that the tutorial becomes a little bit technical during the second part, this tutorial is aimed at users who already have at least some knowledge and/or experience setting up a network. Absolute b...