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...
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...
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.
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...
Forcefollow will explain how to make practicing a break more efficient. To practice the break, place one ball on the rear center of the table and strike it as hard as you can to make the cue ball stop dead.
This video shows you how to prepare a sweet, creamy coleslaw. . This is a simple way to make coleslaw it is not that hard coleslaw is better when it is made fresh.
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.
The card trick shown in this how-to video is quite possible responsible for more free beers than any other in history. It's not just a magic trick, it's a cleverly-laid trap guaranteed to win you a frosty cold one.
Nothing decorates a dinner table better than a napkin swan. It's cute and it makes dinnertime feel like a celebratory event. So, if you want to learn how to make a napkin swan, just follow the folding instructions in the video. Follow along and see what your napkin swan looks like!
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...
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...
Party centerpieces are something of a lost art, but this video will show you how to make a really original one quickly and easily. It looks like a hot air balloon, and requires only a basket, a balloon, some ribbon, and flowers.
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...
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.
If you enjoy spending your time outdoors and tend to a garden, then you need a workspace to call your own. Don't have one, then either buy one or build it. Buying one may be easy, but if you build it you'll appreaciate more.
There's no better time to hang outdoors than during the summer. Hanging out indoors can cause you to sweat up a storm and spend quite a bit of money thanks to constant use of your AC.
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!
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 ...
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 ...
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 ...
Check out this informative video tutorial from Apple on how to create a table of contents 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.
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.
Check out this informative video tutorial from Apple on how to format data values with the format bar in Numbers '09.
Check out this informative video tutorial from Apple on how to create formulas with Quick Formula in Numbers '09.
Check out this informative video tutorial from Apple on how to group rows into categories in Numbers '09.
Check out this informative video tutorial from Apple on how to highlight values with Conditional Formatting in Numbers '09.
Check out this informative video tutorial from Apple on how to print spreadsheets in 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.
Check out this informative video tutorial from Apple on how to create and edit charts in Numbers '09.
Check out this informative video tutorial from Apple on how to work with Excel users in Numbers '09.
Check out this informative video tutorial from Apple on how to create and edit tables in Keynote '09.
This video tutorial shows you step by step how to fold a cloth napkin into a chicken. No, it's not a live chicken, it looks like one you would buy at the grocery store. Just grab your napkin and follow along to impress your friends at the dinner table.
Face, meet table. Another great practical joke video by PrankVote where they attack Ernie in his sleep. Find your sleeping friend, place a small table over his sleeping face and blow an air horn in his ear. Be assured this will result in a very angry and delusional roommate. However this is a great way to pull a face smash practical joke on any sleeping roomate. Use this as inspiration for one of your April Fools Day pranks!
Having a dinner party or just want to impress a date? Use this video to show your good manners and find out how to properly set the table and fold a paper napkin.
Junk is not usually known for its usefulness. That's why it's called junk. If it were called anything else, it might have a purpose, but junk… well… it's junk.
Don't make people around you wish that cell phones had never been invented. Mind your manners by following a few simple rules.
The check just arrived; now what? Whether you sipped tap water all night or ordered a rare bottle of wine, we have an answer. Learn how to avoid over paying. Follow proper bill splitting etiquette with this how to video.
As my fellow cheapskates know, Groupon is an oasis. From discounted vacations to reduced-price massages, it has — nearly — anything and everything. It's great for discounts on dining and travel, but I've never thought of it as a place to shop for smartphones ... until now.
At their annual I/O event, Google introduced their latest app to the public: Allo. The messaging app is the company's latest and most powerful entry into the expanding world of similar apps, with one twist—the inclusion of artificial intelligence.
How to make a rustic coffee table from reclaimed pallet wood. My coffee table is a combination of pallet wood for the legs and frame, and an old painters plank for the top. The coffee table has a drawer which is perfect for the remote controls or the TV Guide. You could even use this coffee table as a TV Stand. I tried it and it looks really good.
