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 if a record is in a table using VLOOKUP. See how to do this for a 2 column (field) table and a 4 column (field) table. See also how to add a concatenated column and concatenate lookup_value in VLOOKUP function.
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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
Box Seats! Put the art back in party furniture with collapsible tables and stools.
With Christmas coming up in a little more than a week, it's prime time to start thinking about how you'll be adorning your holiday table. While we know you're probably focused on getting together the perfect menu, what good is sumptuous turkey and beautiful sugar cookies if they're arranged messily on the table?
Looking for ideas to create a unique table setting for your upcoming Thanksgiving meal? This video shows you how to create a lovely table with a leaf theme and done up in autumn colors. The best thing is that you can create this setting without breaking your budget!
In this video, Todd McClure will teach you how to maintain and keep up your indoor shuffleboard table. In the video, learn how to use silicone, wax and how to adjust the climate adjusters on a shuffleboard table.
Use the Quick Table view to quickly create databases within FileMaker Pro. Whether you're new to the FileMaker Pro database management program or just want to learn how to take advantage of FileMaker Pro 11's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. Specifically, this software tutorial provides a complete overview of how to use FileMaker's new Quick Table tool.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 58th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 table dynamic range feature with a data validation drop-down list without using the table name!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 43rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use a data validation drop-down list to change conditional formatting in a table. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 556th installment in their series of digital spreadsheet magic tricks, you'll learn how to change the source data for a pivot table (PivotTable).
In this video the author describes how to design a centerpiece for your table with a holiday or winter type theme. The author uses different types of foliage including cedar, pine, sugar pine cones, roses, and twigs to accomplish this masterpiece. This is a step-by-step video and is easy to follow along with. The author starts with floral foam and explains the process from start to finish with enthusiasm and detail. The finished product would decorate a large table for a party or gathering an...
In this tutorial the author shows how to derive a slope-intercept equation of a line given an X-Y table. He explains that the general form of slope intercept form which is y = m*x + b. Now he intends to find value of slope, i.e. m first. Now slope is change in y over change in x. He computes the slope using the X-Y values from the table. Next he substitutes a pair of x, y value in the equation to compute the value of y intercept b. Now finally substituting the values in the equation the slop-...
Learn how to say & correctly pronunciate the word "chicken" in the Polish language with help from this short instructional video. On a trip to Poland, it might just come in handy while dining!
Every vacation involves a lot of eating & dining. In this video, you will learn how to say a very important phrase in Polish: "Can I have the bill, please?"
Not sure how to safely clean your wood table without ruining it? In this video tutorial, learn how to properly wipe off your table and how to protect it with a sealant called, Pastewax. This substance dries and does not attract dust making your table look shiny & new, like a piece out of a museum!
Check out this tutorial video from Sessions Online Schools of Art & Design's "Dreamweaver I" course. This is part of Sessions' Web Design certificate programs.
Try some real magic out, or real illusionary... watch to see how to magically push a pepper shaker through a table. For this magic trick, you'll need a pepper shaker, a large napkin, a coin, and of course... a table. This video will show you the magic revealed, and it's quite simple, and definitely an illusion with a sleight of hand.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about basic table setup in MS Access. Several different fields used and lookup wizard used are used in this tutorial. For more information, and to get started creating your own tables in Access, watch this how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn how to add and modifying fields to a pre-existing table, and applying these changes to an associated form. To get started adding and modifying fields, tables and forms in Access, take a look!
How to make a table floral centerpiece; get professional tips and advice from an expert on making your own floral arrangements in this free instructional video.
Check out this video from the Handy Goddess to see how to make sure you have the right frame for your artwork. Make sure you choose the right frame for your artwork or painting is important for the design of your living room or dining room or wherever. One way to get the right frame for your environment is to take a photograph of the picture where it will stay. Then, use the photo as reference when searching for that perfect frame to accommodate that perfect piece of artwork.
Learn a few methods of evaluating the playability of a pool table. Many different factors affect the way a pool table plays.
The Woodworking Underground shows in this video tutorial a quick and inexpensive way to repair the slot in your Festool MFT (multi-function table) work table, from pro Joseph Fusco. This how-to video is a must watch for all furniture and woodwork enthusiasts.
Learn how to model a carved table in Rhino 3D. This is a more intermediate tutorial involving Filleted Edges, Spiral, Pipe, Truncated Cones, Differences, etc. This will get you a completed model of a carved table.
The Wood Whisperer takes you through the appropriate steps to evaluate an antique wooden table and refinish it properly.
This tutorial goes over how to create a table of contents for your document in Pages '08. The table is created automatically based on the headings used in your document but you can also go in further and customize the final outcome.
Whether you're at a bar or just with a group of friends, this is a great illusion that makes it look as though you are sending a large object right through a table!
When you're making a restaurant, or a house, or any other somewhat modern Lego model, one way to make the interior (or exterior for that matter) come to life is by making furniture, and what better way to start than with a table with a striped table cloth on it? In this great video you will find out what parts he uses and then go through the assembly process all the way to the final project! Pay close attention though as the placing of some of the bricks are absolutely crucial to the model co...
This video describes how to set a basic table. First we have to set the placement on a table with a napkin. Next keep a dinner fork, salad fork, and sea food fork on the right side of the placement. Next keep a dinner knife, tea spoon, and soup spoon on the left side of the placement. Next keep desert spoon, desert fork, and bread plate on the other side of the placement. Next keep the dinner plate on the middle of the placement. Next place the soup bowl on that dinner plate. Next put the wat...
The College Forums.com explains how to play the drinking game Flip Cup. The guys demonstrate a one-on-one match, but the game is normally played using teams, with one team on one end of a table and the other team on the other end. Every player starts off with a cup full of beer. To start, two players, one from each team, tap their cups on the table, tap their cups together, tap it on the table, then down the whole beer. They then take their empty cups, put them on the side of the table, and f...
Placemats are an important piece when it comes to setting the table. Not only can it add a certain sense of style to the table, but it can help keep your table top nice and clean! Usually placemats have only one particluar side where it is going to be used the most. In this video tutorial, you'll find out how to make reversible placemats so you have another option to choose from. Enjoy!
In this video tutorial, viewers learn how to detach and attach a database in SQL Server 2005. Microsoft SQL Server is a relational model database server. Begin by opening the Database and show all the tables. To detach the table, right-click the database and select Detach. Make sure that the database is not opened or it will not detach. To attach a database, right-click on Database and select Attach. Click on Add and find the table. Select the table and press OK. This video will benefit those...
The author teaches us how to graph the linear equations with tables. Given a set of linear equations in terms of "x and y", first we have to draw a table having a column each for x and y. We have to enter an arbitrary value of x in that table and substitute that value in the given equation to get the corresponding y value. Once you obtain both x and y values, the next step is to plot them in a graph. Consider an example: in the linear equation x=2y,on substituting an arbitrary value of x=2,we...
Want to get more from the raw data you're entering into your Excel worksheets? Now you can create two distinct pivot tables in Excel comparing, for example, monthly and quarterly sales data. Not familiar with the pivot table? Pivot tables summarize spreadsheet input by counting, sorting and totaling data within a list and providing at-a-glance computations within the same sheet. Become an expert on the subject within 5 minutes and 24 seconds by following easy to understand instructions narrat...
Eagle Lake Woodworking, hosted by John Nixon, offers great do-it-yourself guides for building your own furniture, especially in the American Arts and Crafts style, and turning your garage into an amateur woodshop. Search Eagle Lake on WonderHowTo for more carpentry tutorial videos. From Eagle Lake Woodworking on this specific lesson:
Need an outdoor patio table or perhaps a decorative indoor table for a child's room? Thanks to this video from Lowe's, learn how to build a custom table and attach legs that would be perfect for a child's or toddler's room. Give your home décor a little boost with this creative idea from Lowe's!
To fill a gouge on a table edge you start by using auto body filler. Auto body filler is a two part substance. The catalyst is red and the resin is grey. When they are properly mixed it will be a uniform pink color. To keep the substance from spilling out of the damaged area put a piece of tape on the side of the table. Take some filler and force it down into the cavity formed by the tape along the side of the table. Let it dry for 3-4 minutes. Take the tape off and use a knife to trim off th...
Why have a plain old barbecue when you can host an Oktoberfest? Make it authentic with these tips. You Will Need
The table saw is the most efficient way to cut long pieces of wood. This Home & Garden how to video demonstrates the proper operation and use of a table saw for cutting wood. Use these table saw tips next time you are working on a home project.