Designed Table Search Results

How To: Filter data using MS Excel 2010's PivotTable slicer

This video shows how to make a quick pivot table data filtering by using Excel 2010's ‘Slicer’ functionality. ‘Slicer’ delivers enhanced visual filtering method to allow you to get the data you need more quickly. When selecting a cell in the pivot table you will find ‘Slicer’ in the filter group of the ‘Insert’ tab. Click on ‘Slicer’ and an 'Insert Slicer' dialogue shows up where you can pick particular data fields from the slider list. Once you click on ‘OK’, the ‘Slicer’ objects with filter...

How To: Create a custom membership provider in ASP.Net

A Membership Provider allows a web application to store and retrieve membership data for a user, and the standard ASP.NET Membership Provider uses pre-defined SQL Server tables. In this video tutorial, Chris Pels shows how to create a custom membership provider that uses custom SQL Server tables separate from the pre-defined tables used by the standard provider. The principles covered in the video will apply to creating custom membership providers using other databases such as Access or Oracl...

How To: Add document elements in Microsoft Word: Mac 2008

There's a lot you can do in Word 2008 for Mac, and with all of the possibilities, it can be hard to figure out what you can and can't do. Well, you can add cover pages. You can add headers. And you can add bibliographies easy. The Microsoft Office for Mac team shows you just how to add cover pages, headers, and other document elements in this how-to video.

How To: Build an Awesome Hall Table!

How to build a Hall Table from recycled wood pallets. I love pallet furniture and this wooden pallet project is no exception. It's easy to build and costs very little money. The hall stand is made entirely from old pallets and hardwood fence palings. Hall tables are very practical and are suited for those narrow areas where a normal table would be to big. My hall table, or hall stand also includes drawers which makes it a handy spot to put your car keys or mail.

How To: Build a Rustic Timber Table

These three videos will show you how to build a rustic, distressed kitchen table. I'll be walking you through the process of selecting some recycled timber from a junk pile, and with a little care and some simple joinery techniques, transform that waste timber into a distressed timber kitchen or dining table. In fact, you could use the table for whatever you wanted really.

How To: Create dynamic tables with PHP & MySQL in Adobe Dreamweaver CS5

In this clip, you'll learn how to generate dynamic tables with PHP & MySQL in Dreamweaver CS5. Whether you're new to Adobe's popular WYSIWYG HTML editor or a seasoned web development professional just looking to better acquaint yourself with the CS5 workflow, you're sure to be well served by this video tutorial. For more information, include detailed, step-by-step instructions, watch this free video guide.

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: Make a pool table in Minecraft

Trying to make your Minecraft world the fun, hangout Minecraft world? Watch this video to learn how to build a pool table in Minecraft. You may not be able to shark your friends on this pool table, but it makes a great addition to your Minecraft world.

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: 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: 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.