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 3rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Excel's sorting and pivot tables (PivotTables) data analysis tools.
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 335th installment in their series of digital spreadsheet magic tricks, you'll learn how to increment column numbers for a VLOOKUP lookup table when you are copying the formula down across the rows (down a column).
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 86th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a TRUE/FALSE formula to change the function of pivot table as well as how to filter one.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 106th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use two alternatives to pivot tables.
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 253rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data table for what-if analysis. You'll also learn about the PMT and see the formula equivalent to a data table.
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.)
Your average sit and go player will probably stick to the single, 9 or 10 person tables that are commonly found at all the popular online poker rooms. However, your more adventurous players aren’t afraid to try out the multi-table sit and go’s like the 180 man SNGs when they get a chance. But there are a few things players should keep in mind before starting out with the MTT SNG tournaments.
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!
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.
Assembling a gingerbread house is the bread and butter of a lot of Christmas Eve and Christmas Day celebrations, but anyone who has tried to do so on limited time knows it's harder than it looks.
Learn how to use organizational folders on an Apple iPad running iOS 4.2.1 or 4.2! The 4.2 release of Apple's iOS 4 mobile operating system for the iPhone, iPad and iPod Touch brings with it a host of new features. While that's certainly a cause for celebration, there's also, believe it or not, a downside: learning how to take advantage of them. Happily, the web is awash in helpful video tutorials like this one which make the process a pleasure (and a simple one at that).
Learn how to multitask when running iOS 4.2 or 4.2.1! The 4.2 release of Apple's iOS 4 mobile operating system for the iPhone, iPad and iPod Touch brings with it a host of new features. While that's certainly a cause for celebration, there's also, believe it or not, a downside: learning how to take advantage of them. Happily, the web is awash in helpful video tutorials like this one which make the process a pleasure (and a simple one at that).
No self-respecting Halloween celebration would be complete without a fair share of caramel apples and witch-themed goodies for kids and adults alike to nom on.
What are you doing this Cinco de Mayo? If you are celebrating this tequila filled holiday, you will no doubt have tons of fun with these maracas.
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 ...
Giada De Laurentiis shows you how to make a delicious festive Italian Fruit Punch. Mix together two cups of chilled orange juice, two cups of chilled sparkling water, a quarter cup of limoncello lemon liqueur and a half cup of maraschino liqueur. Mix together well. Carefully pour into martini glasses. Garnish each drink with one or two sticks of licorice, perfect for a Halloween celebration. Follow these easy steps to create a deliciously festive Italian fruit punch for your next get-together.
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...
This video shows how to cook Lumpiang Shanghai the panlasangpinoy way.
This easy tutorial will show you how to create fun birthday invitations in a variety of designs. With a few simple steps, you'll be able to invite guests using crafted cards themed after lady bugs, robots, monkeys, dinosaurs, sweet sixteen celebrations, or even a pretty pink tea party. This instructional video also offers tips on material costs and helpful printing hints.
Have an itch for a kumquat? Don't know what a kumquat is? It's a fruit. Venture out of of your everyday apple, and follow these steps to impress your friends with your knowledge of this funnily named fruit.
Give someone his or her own personal ticker tape parade with this easy prank. You Will Need
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...
