Series Enlarges Search Results

How To: 13 Unexpected to Downright Crazy Uses for Mason Jars

Invented by Philadelphia tinsmith John L. Manson in 1858 for canning and preserving perishables, mason jars are experiencing a major resurgence in the DIY community. In addition to being a handy storage device for both food and non-food items, its old-timey, quaintly antiquated look also makes for good drinking glasses, candle holders, flower vases and eye-pleasing decorations.

How To: Brew Your Own Sun Tea

Assuming that you are living north of the equator, ‘tis the summer season for brewing your own sun tea. Unlike the conventional method of dunking tea bags in boiling hot water for several minutes, sun tea is brewed over the course of several hours through the natural heat of direct sunlight.

How to Watch Star Trek: The Original Series online for free

In this video tutorial, viewers learn how to watch Star Trek: The Original Series online for free. Begin by opening your internet web browser and go to the You Tube website. Then click on the Shows tab on the top of the page. Now click on the Most Popular tab and select Science Fiction under Shows in the sidebar. Then select Star Trek: Original Series and select the episode that you wish to watch. This video will benefit those viewers who are Star Trek fans, and would like to learn how to wat...

How To: Use Excel formulas with cell references

If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 3rd installment in said basics series, you'll learn how to use formulas that make reference to the values of a cell or multiple cells.

Use MS Excel cell references: relative & absolute

If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 8th installment in said basics series, you'll learn how to use both relative and absolute cell references in MS Excel.

How To: Use pivot tables for data analysis in Microsoft Excel

If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 20th installment in said basics series, you'll learn how to use pivot tables (PivotTables) to analyze and summarize data.

How To: Use IF function formulas in MIcrosoft Excel

If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 22nd installment in said basics series, you'll learn how to write and use basic IF function formulas in Microsoft Excel.

How To: Use VLOOKUP function formula in MS Excel

If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the nth installment in said basics series, you'll learn how to work with VLOOKUP function formulas.

How To: Chart cross-sectional and time series data in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 11th installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with, and create charts for, cross-sectional and time-series data.

How To: Add data series to a chart in Microsoft Excel

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 92nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data series to a chart, change the chart type for just one data series and see an excellent copy data to chart trick.

How To: Install a 233 PowerForce G4 accelerator in a Mac Tower

The PowerForce G4 Series 233 is the versatile single processor upgrade for PowerMac G4 AGP towers, G4 Cubes, PowerMac G4 Digital Audio, QuickSilver, and QuickSilver 2002 models. It features the G4-7451 and G4-7455 processors, with speeds up to 1.2GHz. The PowerForce G4 Series 233 processor card, like its predecessors - the Series 100 and 133 upgrades - is the most advanced, highest performance CPU card available on the market today. It's also easy to install Feature List: PowerPC 7451 or 7455...

How To: Train a Dog the Basics

Dogs need to be trained to understand a few basic commands for their own safety and for your own happiness and peace of mind. Learn basic dog training commands with tips and advice from a professional dog obedience trainer in this free dog training video series.

How To: Paint a Pet Portrait

If you want to capture your pet in an oil-based portrait, this video series will help guide you along the way as you paint your animal masterpiece. In the video below, get started by learning about all of the supplies you'll need for drawing pet portraits. To see the other videos in this series, make sure to hit up the link below the video.

How To: Tone your arms with a pilates arm series

In this pilates how-to video, Diane Preusch demonstrates a Pilates arm series. Diane tries to adopt exercises that use things from around the house to do these pilates exercises. This series of exercises is adopted from the reformer machine. You will need arm weights but if you don't have weights you can use cans of soup.

How To: Delete Telegram Messages & Whole Conversations for Everyone in the Chat

If you're looking to keep your conversations private, look no further than Telegram. Its cloud-based chats are secure and its optional end-to-end encrypted chats even more so, but you can't really prevent someone in the conversation from sharing your messages. However, you can lessen that chance by taking back your messages, deleting them for both you and the other end of the discussion.

How To: Make Samus Arans arm canon from the Metroid series for your costume

In the Metroid series you play as the inter-galactic, female bounty hunter known as Samus Aran and follow her adventures against Mother Brain and more! Guess this kid didn't mind being a female for Halloween, but more importantly, he was luck enough to have a super cool dad to help him build the arm canon from Samus' Varia suit! Interested in making it yourself? Details lie within!

How To: Master playing as Guile in Street Fighter 4

Guile has been a part of Street Fighter for the duration of the series, and in Street Fighter 4 he is as awesome as ever. This video for those new to the series but with some Street Fighter experience will show the basics of playing as Guile in SF2, and should have you winning some fights in no time. It focuses on using pokes and special moves to control spacing.

How To: Find the common ratio of a geometric series

Interested in knowing how to find the ratio of a geometric series? See how it's done with this free geometer's guide. 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 to follow in their footsteps (or just finish your homework or study for that next big test).

How To: Find the sum of an infinite geometric series

Need some help finding the sum of an infinite geometric series? See how it's done with this free geometer's guide. 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 to follow in their footsteps (or just finish your homework or study for that next big test).

How To: Use Maclaurin/Taylor series to find accurate integrals

See how to approximate a definite integral to a desired accuracy using Maclaurin/Taylor series and the alternating series estimation theorem with this free video calculus lesson. See how it's done with this free video algebra lesson. 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 to follow in their footsteps (or just finish your homework or study...

How To: Add consecutive integers in math

Want to know how to sum a series of consecutive integer numbers (e.g., 1+2+3+4+5)? You're in luck. 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 to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll...

How To: Create a formula timer in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Formula Efficiency" series, you'll learn how to compare alternative formulas to see which is faster.

How To: Create a basic array formula in Microsoft Excel

Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the very first installment in his series of Excel array formula series, you'll learn how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by Excel.

How To: Count the number of characters in an Excel cell range

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 9th installment in his series of Excel array formula series, you'll learn create array formula that counts all the characters in a range of cells.

How To: Multiply matrices with the MMULT function in MS Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)

How To: Do the pilates stomach series

The Pilates Stomach Series is also known as the “fabulous five,” because of the wonderful way the five movements tone the tummy. You will need a mat, floor space, and some flexibility. Pilates tip: If at any time your lower back comes off the mat, bring your legs higher as you extend. If your neck begins to hurt at any point during these exercises, simply lower it to the mat.

How To: Remove the front bumper on a Saturn S-Series car

One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...

How To: Make a video podcast using iMovie

If you're creating a series of movies, you can use a video podcast to share your movie with team members and friends. A video podcast can be a series of videos you post to a website over time. Others can subscribe to your podcast and watch your latest movies whenever you add new episodes. Preparing a movie to be a video podcast is easy to do from iMovie.

How To: Create a flashing lightning effect in Apple iMovie

If you're a fan of "Avatar" - the animated Nickelodeon series, not the M. Night Shayamalan epic fail of the movie - or any sort of supernatural action series, then you've probably witnessed the awesome flash of lightning effect before. Whether emanating from the hands of a superhero - or supervillain - or shooting out of a mutant's eyes, the lightning effect is super cool and also super doable at home using Apple iMovie.

How To: Make a Halloween themed waterfall card

A waterfall card is a cute and clever interactive card you can give your friends. Pull the tab at the bottom, and watch a series of small cards cascade down the card. Starting with a series of card stock and your own stamp collection, this explains how to make a lovely waterfall card using Halloween stamps.

How To: Speed up calculations with custom Excel formulas

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" series, you'll learn how a custom function (i.e., a user-defined function) can speed up calculations.