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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
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 646th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more
Apple's iWork '09 is full of great features, including a simple and elegant way to add up a column of numbers in a spreadsheet. This detailed video shows you just what to do to get down and add up. The simple task of adding a column of numbers in iWork Numbers can be done ele ...more
When I compare my iPhone 4S to my friend's iPhone 5, I notice that his elongated screen gives him an extra row of applications. Am I jealous? Yes, a little. Unfortunately, we can't alter the physical form of our device, but we can tweak our icon layout to add more apps snugly ...more
Suppose you created a project plan in Microsoft Office Project 2007, and you want to add a new column of information. You also want to be able to choose not to display the new information, but you don't want it to be lost. Take a look at this instructional video and learn how ...more
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 339th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more
Watch this math how to video and learn how to add using the column addition method. This simple addition method will help young students learn how to add. Use the column addition method to help with your homework or tutoring. Do addition using the column addition method. Click ...more
If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software ...more
Don't want to shell out the big bucks for some fancy, expensive budgeting software? Well, if you have Excel 2008 for Mac installed, you can manage your budget right there. Personal financing doesn't get easier than this— even business finances are easy to keep track of. The Mi ...more
Don't want one of your Facebook "friends" knowing your status updates? Prefer to keep a few of those "friends" out of your photo albums? Would you like to prevent a few "friends" from accessing your address? The simple answer would be to remove all of those so-called friends— ...more
New to 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 Excel tutorial from ExcelIsFun, the 264th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a recorded macro ...more
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 558th installment in their series of digital spreadsheet magic tricks, you'll learn how to check i ...more
Why a PDF Portfolio? If you've been wanting to create a PDF (portable document format) portfolio for your photos, art or design work, or wanted to create a PDF magazine that can be read by anyone on the net, then this article will show you how to go about it. I created my PD ...more
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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how ...more
If you've ever used a heating pad or hand warmer, you essentially know what "hot ice" is. It's supersaturated sodium acetate, and it's actually fairly easy to make at home out of sodium acetate crystals. You can also make it out of vinegar and baking soda (directions at the bo ...more
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 81st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to a ch ...more
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 297th installment in their series of digital spreadsheet magic tricks, you'll learn how to select ...more
This ten-part video tutorial series covers all the new features and uses of Fireworks CS4. This is a great introduction to any user new to Fireworks in general, or wanting to learn what changes have happened from Fireworks CS3 to CS4. PART 1: RC talks about the new Fireworks C ...more
Getting Started Steps for Beginners If you are brand new to Expression Web 4, then read the following guide to quickly set up your web site and web pages. Set up an Empty Web Site Click Site and choose New Site. This will open a new dialog window. In the dialog window, Choo ...more
Toss aside that Sudoku. Take a stab at the new craze to hit the Times: KenKen. New York Times puzzle editor Will Shortz introduces KenKen and gives a brief play-by-play demonstration of this new puzzle craze. In this video, Will Shortz speaks about how he found out about and ...more
Guitar Essentials My friends and I would secretly scribble tab in the darkly lit practice rooms in our university even though we were educated musicians. So, being able to read tablature, or tab, is essential for beginning guitarists. Tab is a curious way to write down music ...more
Deadly natural disasters can happen at any moment— earthquakes, hurricanes, tsunamis, floods, fires and especially tornadoes. That's why you have to be prepared. According to Secrets of Survival: The greatest and most frequent tornado occurrences happen in the United States. ...more
This video explains how to easy add decimals. Adding decimals can seem to be a tedious job, and a single mistake can result in a completely different number. In reality, it is quite easy, and with a good method and some practice it can be done quickly. Write the two sets of nu ...more
Are you tired of wasting diamonds and iron on creating hoes? Are you looking for a fun way to farm melons? Or do you simply want to show off to your friends? This tutorial will go over how to make a jaw-dropping semiautomatic melon farm. Not only will you be the talk of the se ...more
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 19th installment in his "Highline Excel Cla ...more
Becoming a chess master is very hard to do, and one of the most important things you need to learn is chess notation. Chess notation will help you study great chess games and learn classic moves and strategies. Check out this video and start studying, and who knows? You may be ...more
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 16th installment in his "Highline Excel Cla ...more
In this tutorial, we learn how to use vocal effects and Auto-Tune in Fruity Loops. First, load on your audio and then set it to a channel FX. Add in the effects that you want and then drag them into the right hand side column for the different effects. From here, you can use t ...more
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 31st installment in his "Highline Exce ...more
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with m ...more
WELCOME & THANKzZz For Your Contribution, Support And Time...! ...Hello, zZz~AKA~StanDP Here...; There are many ways to tweak, change, enhance your internet experience to suite your needs, I will discuss a few things I did to enhance my online experience along with Fire-Fox ...more
In this video, we learn how to create a free Weebly website. First, type a title in that you want for your website. After this, you will be brought to a new page where you can change the elements and designs. The design can easily be changed until you find one that works for y ...more
In this tutorial, we learn how to calculate and add running percentages in Excel. First, write out your value and percentage into the different columns. Next, write the formula in the cell where you want the answer to appear. To have the answer appear, highlight the box and dr ...more
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 21st installment in his "Highline Excel Cla ...more
This video shows how to create a menu with rollover images in Dreamweaver. Open a new document and create a table with one row and one column. To add your rollover images, go to the "Image" tab and select “Rollover Image”. In the “Insert Rollover Image” box, give the i ...more
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 ...more
Professor ElvisZap teaches you about adding consecutive odd numbers. You can learn this faster by drawing squares near the numbers themselves. If you are doing 2x2, draw 4 squares. They will be arranged in columns of two. For 9 you will draw 3 columns of 3. 16 are 4 columns of ...more
In this video tutorial, viewers will learn how to create a table for the VLOOKUP function in Excel. Create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table. Create dynamic ranges using the Exce ...more
The video shows us how to solve a system of equations with the elimination method. First write the two equations one on top of the other, as it is going to be elimination method and it is recommended to write it in that way. Here the 2 equations are x+y=-3 and x-y=1. In the el ...more
MotionTraining gives an overview for using Microsoft Excel for beginners in this video. This video gives a rundown and overview of the basics of this spreadsheet program: from typing in the columns and rows, adding dollar signs to data, and how to make basic calculations. Moti ...more
To sort data in Excel spreadsheets, have each category (for example, first and last names) in a single column. Click on any cell in the column you wish to sort. Be careful not to highlight the entire column, or results will be sorted only in that column. Click on DATA on the r ...more
Wouldn't it be nice to just sit at your buddy's house, plug into his network, and see exactly what he's doing? What if it was as easy as that? What makes packet sniffers like Wireshark such potent tools is that a majority of local area networks (LANs) are based on the shared E ...more
Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of th ...more
In this video the author gives an HTML Website Design tutorial showing how to make a side menu bar. He goes on to show how to write the HTML page, explaining about the different HTML tags like <html>, <head>, <title>, <table> etc., He shows how to set page color and add stylin ...more
Making your own circuit boards can be a daunting challenge. You have to design a schematic, test it on a breadboard, design the board layout, and then after all of that, you still have to print and etch a board! Luckily, we have Fritzing. Fritzing is a free open-source PCB d ...more
How to use trendlines in Excell 2007 In this tutorial I will show you how to use trendlines in microsoft excell 2007. Trendlines can only be used for certain types of charts. Charts that cannot be used for a trendline: Stacked-chart, 3D, Radar, Pie-chart, surface-chart, don ...more
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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Exce ...more
This video is a tutorial on how to create drop-down menus in Excel 2007. Select a cell on your spreadsheet and click on the “Data” tab. Go to the “Data Tools” section and select “Data Validation”. In the window that opens select "Allow" and choose "List". You will ...more
This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the s ...more
Sydus 93 teaches You Tubers how to read a binary clock by demonstrating the following process: A binary clock is made up of four rows and six columns of colored or uncolored dots. The rows, from bottom to top, represent the numbers one, two, four and eight. From left to right, ...more
Sure, buying a quilt is fun, but making your own is much cooler! Learn how to design and sew your own quilt by watching this informative video. With simple sewing skills and a little imagination you can design a quilt that is both beautiful and functional. Step 1: Choose a s ...more
Watch this video from This Old House to learn how to replace your exterior columns. Steps: 1. Cut cedar to width and length to create proper size column. 2. Apply two coats of exterior-grade primer to the interior surfaces of the boards. 3. Join together the cedar boards to f ...more
Jeb just announced a great new feature that will be added in the 1.2 update. This map format, titled "Anvil," will open Minecraft to so many more possibilities with the new update to mod compatibility. "The purpose of the new format is to prepare for modding, especially to al ...more
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 296th installment in their series of digital spreadsheet magic tricks, you'll learn how to add con ...more
If you want to create a Pareto Chart for categorical data in MS Excel you should first have your data input into Excel already. From your data, you should highlight the cells that you want to count the frequency for and in the frequency box you should type in =COUNTIF and high ...more
New to 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 Excel tutorial from ExcelIsFun, the 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the averag ...more
1. The following instruction describes how to generate sub totals in Microsoft Excel Sheet. 2. Take Region as a Primary column and Sales Rep as a Secondary Column. 3. First method to sort: Select a cell in Region and goto Data select A to Z. 4. Second method to sort: Select a ...more
The Department of Biological Sciences at the University of Alberta brings you this video tutorial specifically relevant to your student laboratory courses, specifically microbiology. If you're a student at any school of biology, this information will be helpful for learning ho ...more
Part 2 Welcome back! In my last post I talked about the exterior aspects and techniques of building a great looking house, and now we shall focus on the interiors. Interiors There are a few important prerequisites to look at before starting the interiors of a house: The ge ...more