Single Table Search Results

How To: Create a dynamic frequency table & chart in MS 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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....

How To: Build frequency tables & histogram charts 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 31st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to build frequency tables and simple histogram charts in Microsoft Excel. Specifically, this video addresses the following subjects:

How To: Use Excel names with pivot tables & data validation

Looking for a primer on how to create and work with names 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 5th installment in his series of Excel name tricks, you'll learn to use names with pivot tables, data validation & the VLOOKUP & COUNTIF functions and formulas.

How To: Retrieve data from many tables on many sheets in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...

How To: Automatically create pivot tables in Excel 2007

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 218th installment in their series of digital spreadsheet magic tricks, you'll learn how to an Excel 2007 table to create a dynamic range so a macro to create a pivot table will work even when new records are added.

How To: Create an Excel pivot table with 4-variable tabulation

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 216th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pivot table (PivotTable) with 4-variable cross tabulation. Learn to use multiple fields in a pivot table with this free video tutorial.

How To: Summarize survey results with a pivot table in 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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize survey results with a pivot table (PivotTable) or a formula. See how to create a Pivot Table in Excel 2003 or 2007.

How To: Prove side-side-side congruency

In this "Math Made Easy" geometry episode, you learn how to prove that two triangles are congruent (equal) by using the "side-side-side" evidence. By using "side-side-side" to prove that two triangles are congruent, you are stating that all the respective corresponding sides of two triangles are equal in length thus proving the triangles are congruent. The narrator in this tutorial provides you with definitions about statements, proofs, and congruency. This becomes useful when setting up a ta...

How To: Origami a table and chair

Watch this origami how to video and learn how to make an origami table and chair. If you are a fan or origami, this instructional video will surely satisfy your origami needs. This origami video goes a little fast, but the table and chair are really cute! Just pause the video as you go along.

How To: Set up a formal dinner place setting

Ever wonder which side of the plate to put a fork? This video will show you piece-by-piece how to create a formal place setting for two different meal sizes. This is useful if you are hosting a fancy dinner, or are just having friends over for a nice meal. Some people even enjoy having a formal setting on their dining room table all the time.

How To: Get the Happy Birthday trophy in Heavy Rain

In this video, we learn how to get the Happy Birthday trophy in Heavy Rain. To start, you will first need to complete your drawing, set the table, and then play with your kids. You play the game as an architect, so this will be fun if you like to draw. Draw in the picture by pressing the buttons on the remote as they come up on the screen. Do the draw over and over until it's final. Then, as you set the table press the buttons on the remote to correspond. When you finish playing with the kids...

How To: Create a free website from scratch

You can create a free website using HTML. HTML is hyper text mark up language. Create a folder "my webpage" with all of the images and information for the webpage. Use notepad to write the HTML for the website. Notepad plus is the best which can be found on Sourceforge. Open the browser and the notepad and begin to construct. These codes will help in the creation of the page: <html> opens instructions </html> closes instructions. These are called tags. One opens the commands or instructions a...

How To: Use SSLStrip to remove encryption from browser

You should encrypt everything. These are what you need: BackTrack 4,0, modify IP tables, Python and ARPspoofing. Program the PC to flip to forwarding mode. Adjust the programming in the IP tables. You are convincing the host and the client that the man (PC) in the middle is the host and capture passwords, user names and other information from unsuspecting clients. This program strips the "S" from "https" which make your computer vulnerable to hackers. You need to observe the address bar and m...

How To: Prank roommates with a table, a toilet, and a balloon under their car tire

Great pranks, like death and various other phenomena, come in threes. This video is a perfect example of that, and will teach you three awesome pranks that you can pull on a roommate, friend, or mortal enemy. First, you'll learn about placing a table over a sleeping persons head and waking them with an airhorn. Second, you'll learn how to rig a squirting toilet. Lastly, there's the fake tire explosion balloon trick. All classics, all easy, all things you should go try.

How To: Play the Carom pool billiard game

Pool is an amazingly challenging game that one can spend a lifetime mastering. If you're bored with it, however, and want to try a new game on your pool table that uses the same skills, this video will show you one. It explains the rules to a game called Carom Pool, which is a hybrid between pocket pool and more traditionally carom billiard games. Even if you don't' enjoy the game, the spread-out nature of the table makes it great for working on your long shots and banks, so rack 'em up!

How To: Create a quantitative freq. distribution 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 24th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data frequency distributions with pivot tables. See how to create the correct unambiguous labels ...

How To: Tie dye the spider design on your t-shirt

This video shows the viewers how to create a wicked spider pattern on a tie dyed shirt. Our instructor starts by demonstrating on a square piece of fabric. Start by folding your shirt in half sleeve to sleeve. Next, choose the placement of your spider design by picking the twist point, either in the center or slightly higher. Then, start twisting your fabric into a tight spiral using either your fingers or rotating around your table. After tightly tying your finished spiral, prepare your dyes...

How To: Do a jumping gemini with a three card monte throw

This video shows the viewer how to do a ‘Jumping Gemini’ card trick. In this trick three different cards of your choice appear to continuously find their way back to the top of the pack. This seems impossible as the cards are both placed on the table as well as being placed at the back of the pack. The trick uses a series of breaks and lifts to work. Essentially it involves continuously appearing to place the chose card at the back of the pack or on the table whilst actually keeping the card ...

How To: Perform the "oil and water" card trick

In this short, fun and informative tutorial, Andy Field demonstrates the Oil and Water trick using four black cards and four red cards. Four cards are placed on one side of the table and the four red cards are placed on the opposite side of the table. He then mixes the cards, pulling one card from each side to make a new pile of cards with alternating colors. One red, one black, one red and so on and so forth with each of the eight cards. After letting the cards sit for just a few seconds he ...

How To: Create and edit tables in Pages '09

Check out this informative video tutorial from Apple on how to create and edit tables in Pages '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.

How To: Get started using Numbers '09

Check out this informative video tutorial from Apple on how to get started using Numbers '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.