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...
A tutorial video that demonstrates how to install Skype on Puppy Lynux 4. It is a very simple and short video at roughly just over 2 minutes. The narrator does a good job illustrating how to install Skype. In just a few easy steps, the video shows how fast and easy Skype can be installed.
Cardcrazy09 presents a video on how to easily make a get-well pedestal card that's perfect for cheering up an ailing friend or relative. She guides us through the process step by step, detailing the proper measurements and techniques she used to make the perfect card. In order to make the card exactly like she has, you'll need a Cricut, a machine that is used for making stylish cards. By following the instructions in the video, you can make a beautiful card yourself without having to go out a...
For anyone who has ever struggled with long division, this video offers some tips on how to perform this seemingly daunting task with relative ease. The example provided in this video is a very useful one and by following the steps of this video, you will be able to do long division easily. Starting from the right side of the number which is being divided, add 0's as place holders until you arrive at a number which can be divided by the number you want to divide by. Perform this one simple di...
This is a tutorial that (tries to) demonstrate the power of the Selective Color dialogue in Photoshop. This video uses the dialogue on absolute instead of relative, but it works out anyway. For better results use relative.
Want to calculate percentage growth rates (also known as the relative rates of change)? Learn how with this free video calculus lesson, which covers calculating the percentage growth rate using a logarithmic derivative, elasticity of demand and the relation between elasticity of demand and revenue. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever t...
No words are needed to show you how to draw this cute and corky squirrel. This video shows you how to draw a simple squirrel from the pattern of the outline and continues to add more detail like adding for realistic looking fur.
The purpose of this video is to show how to become a permanent resident in Canada. Some programs are federal and some are for Quebec. The first program is the skilled worker program. The applicant is accessed under a point system and is awarded points for education level, knowledge of English or French, work experience, age, confirmed job offer, and adaptability and you must have sufficient proof of funds. The next program is Family Class Sponsorship. A citizen or permanent resident can spons...
Has time travel always sparked your interest? Are you weirded out by wormholes? Flummoxed by your flux capacitor? Strap yourself in for this time-travel primer.
The art of floral arrangement is a fun and valuable skill. Dana Plazyk of Flowers by Design lends useful tips and tricks on making simple flower arrangements.
This two-part video tutorial series presents a breakdown of applied music theory on the ukulele. In the key of C major you have the notes CDEFGABC. The notes C to C give you C major(or Ionian). The notes A to A give you A minor (or Locrian). The notes G to G give you Mixolydian and the notes E to E give you E Phrygian.
Check out this home repair tutorial video that demonstrates how to fix and diagnose your appliance. These videos are for information purposes only. A qualified and proficient engineer should be employed to replace any faulty parts on your domestic appliance.
To properly set a table for an informal four course dinner, keep in mind that a soup course, a salad course, an entree and a desert will be served. First, add the service plate or charger to the table. Place it directly in front of the guest two inches from the table. It will serve as the under plate before the entree arrives. Use exactly the amount of silverware needed to accommodate the meal. For this meal, you will need a soup spoon, a salad fork, a salad knife, a dinner fork, a dinner kni...
If even the bats are intimidated by the clutter in your attic, it’s time to tackle the mess. Watch this video to learn how to clean out your attic.
Here's a simple home science experiment to demonstrate to kids the different weight and viscosity of various liquids. The liquids near the bottom are more dense while the liquids on top are less dense. This can also be used to determine the relative density of solid objects. Place them in the container and see where they float.
Need some help weighing the relative pros and cons of the Wacom Bamboo and Bamboo Fun pen tablets? Well, you're in luck, as this brief video guide from Wacom is designed to help you do just that. For complete details, take a look.
The war on dehydration is a commercially burgeoning marketplace. An increasingly sophisticated consumer population hoping to conquer everything from 26-mile marathons to vodka shots is deconstructing every functional remedy in the fight to quell the effects of severe dehydration.
The ability to tune a guitar is a skill every guitar player should possess. With this tutorial, learn how to properly tune a guitar either using a digital tuner or by using the fifth fret rule. Though a digital tuner is by far a more convenient option, certain situations my require the player to tune an instrument by ear. Start by tuning the low E string and use that sound as a reference for the tuning of the other strings. If a tuning fork is unavailable, a guitar can still be tuned relative...
For most automotive applications a battery needs to supply a lot of current for a short period of time to turn over the engine and get the car started. With the engine running, the car's alternator produces all the power the car needs. Thin plates inside a starting battery increase the surface area and produce this relative burst of energy. Thicker plates in a deep cycle battery provide a steady amount of current over a long period of time. Deep cycle batteries excel in reserve capacity (RC),...
This lesson soloing. This chord progression has been used to create many, many hits in just about every genre of popular music. During this lesson, we will investigate the D major pentatonic scale. You may still use the D minor pentatonic scale, but the best players can switch between major and minor pentatonic at will. The D major pentatonic scale is exactly the same as the Bm pentatonic scale. When you play D major pentatonic you are playing Bm pentatonic as well. This is called relative ma...
When computers have vision but people don't, why not have the former help the latter? That's the gist behind the Cognitive Augmented Reality Assistant (CARA), a new HoloLens app developed by the California Institute of Technology.
With the reveal of Magic Leap's developer documentation last week, many questions have been answered—and several new ones have been raised as well. But since the Magic Leap One (ML1) isn't simply called the "Leap One," these are questions that the company probably has no interest (at least for now) in answering. Understandably, Magic Leap wants to keep some of the "magic" under wraps.
Modern medicine utilizes cutting-edge technology more than ever, so it would only make sense that the powerful handheld computers we all carry around these days could play a big role in wellness.
In my first tutorial on Linux basics, I discussed the importance of hackers using Linux and the structure of the directory system. We also looked briefly at the cd command. In this second Linux guide, I'll spend a bit more time with changing directories, listing directories, creating files and directories, and finally, getting help. Let's open up BackTrack and getting started learning more Linux for the aspiring hacker.
Welcome back, my novice hackers! The worst thing that can happen to any hacker is being detected by a security admin, the security technologies (IDS, firewall, etc.), or a forensic investigator.
In the case of Apple Watch v. Fitbit, the winner comes down to the judge at hand. Apple currently offers two smartwatches — the Series 5 and the Series 3 — while Fitbit offers three models — the Fitbit Versa 2, Fitbit Ionic, and Fitbit Versa Lite. Whatever your assumptions about these devices are, throw them out the window, as each has something unique to bring to the table.
It may take practice to get to Carnegie Hall, but a new mobile app gives the average iPhone or iPad owner the experience of walking on stage with a live orchestra.
Arthur van Hoff, former CTO and co-founder of Jaunt, is taking his immersive content talents to Cupertino.
We're still weeks away from a probably HoloLens 2 release, but Microsoft's immersive computing team is still hard at work on other aspects of its "mixed reality" ecosystem.
If you find yourself on the run from the Empire, you no longer need a droid to send a holographic distress message, you just need an iPhone X and the HoloBack app.
Over the past few weeks, a trio of developer lessons (one of which was revealed in Magic Leap's most recent Twitch livestream) have revealed samples of experiences that are possible while using the Magic Leap One.
After previously learning how to make the material of an object change with the focus of an object, we will build on that knowledge by adding new objects through code. We will accomplish this by creating our bounding box, which in the end is not actually a box, as you will see.
Legacy Games, developer of mobile games for children, has just updated Crayola Color Blaster, an augmented reality Android adventure for Google Tango devices, with new content.
If you're an Apple user and want an untethered virtual reality system, you're currently stuck with Google Cardboard, which doesn't hold a candle to the room scale VR provided by the HTC Vive (a headset not compatible with Macs, by the way). But spatial computing company Occipital just figured out how to use their Structure Core 3D Sensor to provide room scale VR to any smartphone headset—whether it's for an iPhone or Android.
One of Android's biggest strengths relative to iOS was the ability to switch to a third-party keyboard. While Apple has finally included this feature in its latest OS and leveled the playing field a bit, the variety of options still pales in comparison to what's available on Android.
When I get weather information, I prefer to receive it in a straight-forward, minimalistic fashion. Living in California, I could care less about wind speeds, humidity, or any other calculations that I can't analyze in a second. I essentially use the information to help decide whether I'll be wearing shorts or pants on a given day, so give it to me bluntly.
Screenshots are all the rage. From sharing high game scores with friends to placing conversation threads online for the world to see to secretly capturing Snapchats, this function of smartphones is prevalent through modern society.
Trying to remember if it's "beer before liquor or liquor before beer" can be too much of a hassle, especially if you've already have had a few too many. While it would be great if one rhyme could determine the amount of pain you will feel the next morning, we must accept that we all react differently to alcohol and that's that.
In an increasingly mobile and globalized world, it’s not uncommon to lose touch with people we were once close with. Juggling between job demands, family responsibilities and our own personal needs, it’s often hard to put the time to keep all of our relationships going. Nevertheless, every now and then we get to reminiscing and feel the time has come for a reunion with people from the past.
Hello! I would like to share some data about the nests that rabbits and dwarf rabbits build. They represent good shelters for them and their babies.
