Buffet 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: 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 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: 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: 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: Use table styles in Microsoft Word for Mac 2011

Want to know how to style tables in Microsoft Word for Mac 2011? It's easy and this video will show you how it's done. Whether you're new to Microsoft's popular word processing application, new to MS Word 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using table styles in your own Office for Mac 2011 projects, watch the video.

How To: Build your own lunar city model

In this tutorial, we learn how to build your own lunar city model. You will need: toilet paper tube, bottle caps, CDs, sheets, and scissors. Now, cover your table area with the bed sheet so it's completely covered. Now, star tot arrange your lunar city model. Place the CDs on the table and stack them, placing bottle caps in between. After this, cut the toilet paper rolls in half and lay them flat on the ground. After this, place cups lid down on the table and then add CDs on top of them. Now ...

How To: Create a drawing space

In this video tutorial, viewers learn how to create a drawing space. A good drawing table has an incline and plenty of space for drawing on. But if you can't afford or don't have enough room for a drawing table, buy a piece of Masonite from the hardware store. Then simply lean the board on a desk or table. To hold the paper onto the board, use some tape and stick it onto the board. This video will benefit those viewers who are interested in art and drawing, and would like to learn how to crea...

How To: Make easy kid placemats and set the table

Now when it comes to setting the table you just need three things: fork, plate, and a napkin. But for some, things are more complicated than that. Sometimes they feature the soup spoon , salad fork, and so on and so forth. Although this video doesn't cover every single utensil, it does cover some of the basics. Find out how to make placemats for kids as well as teach them how to set the table. Enjoy!

How To: Create formulas with table nomenclature on 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 200th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel 2007 Table Nomenclature in formulas. See 9 examples of how to create formulas with table nomenclature in this free Excel video tutorial.

How To: Make a Christmas table centerpiece from an antler

Danielle Proud shows you how to make a beautiful Christmas table centerpiece for your Christmas dinner! Your guests will be amazed at how incredible your table looks. This amazing display catches light and looks simply magical. All you need is an old pair of deer or elk antlers, some sticky-backed crystals, and a little time and creativity! First, take your antlers and sand them until they are smooth and the color you like. Then, take different sized crystals, even different colors if you pre...

How To: Build a table out of LEGOs

In this tutorial from brickboy518, viewers are shown how to construct a table out of fourteen LEGO bricks. The following bricks are required: 4 1x1 spokes, two 4x1 strips, a 4x6 thin, a 2x4 thin, two 4x1 thins from the LEGO Racing Legacy sets, and 4 1x1 spokes. First, the builder must apply the 2x4 thin to the center of the of the 4x6 then. Next, they must attach one of the spokes on each corner of the 4x6. Then, the car strips must be applied face-inwards to the sides of the 4x6. Thus, this ...

How to Play pool: The Double Drifter

Use this tutorial for a simple and shot accuracy improving technique in pool! The steps for this tutorial are simple, yet effective in improving shot accuracy in pool. Align pool balls in a triangular formation at the far side of the table. Note that this is not the standard triangular formation for pool. Two lines are to be made diagonally from the center back of the table outward. Similar to this formation: \/ where the point would be directed to the back of the table. Leave space in betwee...

How To: Calculate the percentage of a number

This video presented by Cris Ippolite makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing flat files, which programs like Microsoft Excel use. Flat files have a big disadvantage: they cannot communicate with other files, even those with related data. If you wish to make your job easier, you should use relational databases. With databases, the tables communicate between one another. Once you store an entry in a table, you can use it i...

How To: Do a reverse two way look up in Excel

In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...

How To: Reverse two way lookup for date & time in Excel

In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...

How To: Graph a line using an x-y table

In this video the instructor shows how to graph a line using X-Y table values. He specifies a four step approach. In the first step he picks numbers for the value of x. In the next step he substitutes the values of x in the equation of the line to obtain the corresponding y values, in the third step he plots these ordered pairs on a graph sheet. Finally in the fourth step he joins them resulting in a straight line for the given equation. This video clearly shows how to graph a line using an X...

How To: Use PivotTable to group data in Excel

Excel Fun will show you how to get the most out of your Excel experience by learning about pivot tables. With Excel and the latest Excel 2010 you can learn how to create a pivot table. Learn where in the system to go to find the table. Learn how to add our numbers and create a calculation and watch it being solved. Your instructor will go through a detailed equation so that you can see how to do your own calculation.

How To: Use flat files vs. relational databases with FileMaker

This video, presented by Cris Ippolite, makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing that programs like Microsoft Excel uses, what in the databases circles, are called flat files. This flat files have a big disadvantage: it cannot communicate with other files even those have related data. So, instead of using those, if you want to ease your job, you should use relational databases. With databases, the tables communicate betwee...

How To: Magically push a coin through a table

Try some real magic out, or real illusionary... watch to see how to magically push a coin through a table. For this magic trick, you'll need a quarter (or other 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. Also, try some ways to make it not so obvious if you can.

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