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 250th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales representatives using a pivot table (PivotTable).
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 231st installment in their series of digital spreadsheet magic tricks, you'll learn how to run a VLOOKUP on 3 tables on 3 different sheets.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS functions.
This how-to video is a vibrant and animated tutorial on how to paint children’s furniture: in particular, a little girl’s tea table and chairs. It’s fast paced yet easy to follow. The video couple takes you from the taping and preparation of the table and chairs to the completed and professional quality finished product, which would thrill any little girl. Their method of communicating the most important steps is to race to the camera and speak to the audience, in an amusing sort of wink, whi...
This is an informative video tutorial on how to search graphics, tables and charts using MS Word 2010. The author informs that the earlier MS Word editions had fast and easy search options, but the same feature built into the 2010 edition is vastly improved. One simply has to click the ‘Find’ option at the top right-hand corner and a navigation pane opens on the left-hand side. In the search box, the keyword is typed in and all the instances of that word in the document are highlighted, while...
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...
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...
Learn to calculate fast with your body parts. Amazing trick to learn easily multiplication table or times tables (in just 2 min.)
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.
IngletonPottery demonstrates how to create a giant clay pottery novelty goblet in less than eight minutes in this video. The goblet can be used as a decorative piece or it can be used to drink from. The choices are endless for this giant piece of art. The giant goblet begins as a big blob of clay. A portion of the clay is wet and the spinning table begins. While the clay is wet it is placed on the spinning table and then the molding process begins. To mold the clay requires concentration and ...
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 styling to the page. He shows how to align the page elements and does the font settings. He goes on and makes a HTML table. Next he shows how to make a menu bar using the table element and shows how to do the various settings ...
It is not that hard to make your own drill press table. Start with a 3/4-inch piece of plywood. Cut a 3/4-inch dado cut on both ends of the 3/4-inch board about two inches from the end. Top the 3/4-inch plywood with a 1/4-inch piece of oak cut into three pieces. When you cut the board into three pieces cut the center piece out with a 10-degree angle so that when you glue the two end pieces down the center piece will slide in and out but be held in place by the angle. This allows you to change...
With Tim Burton's revival of Alice in Wonderland, throw one of the hottest parties in town with a "mad tea party" themed party. Recreating one of Alice in Wonderland's most famous adventures is a great theme for all kinds of celebrations. Set the scene with these suggestions.
Learn how to play gin rummy: knocking variation. In this version of Gin, you can end a game by "Knocking."
Check out this woodworking video from Eagle Lake Woodworking. Learn how to build a table saw crosscut and miter sled by watching this five-part series.
In this tutorial, we learn how to design a fall table centerpiece with mini pumpkins. First, place three mini pumpkins on the side of a basket. Then, place peppers around them and throughout the basket. Take a bare branch and stick that in the middle of the centerpiece. From here, take some fall type of flowers and place them on the other side of the basket to decorate with. Use different colors with oranges, purples, and greens to make it look more like fall. From here, add in some fall leav...
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.
In this clip, you'll learn how to create XML tables with InDesign CS5. Whether you're new to Adobe InDesign or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by free video software tutorial. For more information, take a look.
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....
There are numerous tools that can be added to a collection that make house projects so easy to complete. One of those tools is a router. This device is perfect for making your own crown molding, grooves, and indents. But carrying it can be a pain.
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:
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 88th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to remove rows of a table where the row has a blank in column A using a macro.
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...
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.
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.
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.
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...
This screencast tutorial from Chris Grover, author of Word 2007: The Missing Manual, guides you through working with tables in a Microsoft Word 2007 document.
A rainbow table can be thought of like a dictionary, except instead of words and their definitions, it holds combinations of characters on one side and their hashed form on the other. What is a hash and why would you want to know what random combinations of characters are hashed into?
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.
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.
There are loads of reasons for somebody to want to recover a Windows password, and there are lots of different ways of doing it. My favorite of all of these ways is to use a piece of software called Ophcrack because:
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.
Involve your kids in the Thanksgiving festivities by having them make the centerpieces to be hosted on your table! This tutorial shows you a few fun crafts you can do with your kids to make some fun centerpieces and table decorations.
In this clip, the Napkin Lady shows you how to take an ordinary cloth dinner napkin and fold it into the shape of a brassiere. This clip is quick and easy and you will have everyone at the table laughing in just a few simple steps. This bra napkin design is also great for bachelorette parties, showers and anywhere else where you need a little lighthearted napkin folding!
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.
Microsoft Word tables serve as an attractive way to organize information. See how to create and edit tables in Word.
Expand your arsenal of Table Tennis serves. Watch this video to learn the technique behind many of the most effective serves in Ping Pong. This video will show you how to put topsin, backspin, spidespin, all kinds of spin on the Table Tennis ball.
Got the winter blahs? We dont' blame you. After all, getting snowed in with four feet of snow outside your front door gets old, fast.