In this video tutorial, viewers learn how to print the gridlines with a Microsoft Excel spreadsheet. This task is very fast, easy and simple to do. By default, Microsoft Excel will not print a spreadsheet with the gridlines. Begin by clicking on the Page Layout tab. In the Sheet Options box, under gridlines, check Print. To remove the gridlines, do the reverse of this operation. To view the page with gridlines, click on the Office button, go to Print and select Print Preview. This video will ...
In this video tutorial, viewers learn how to create tables in Microsoft Word 2007. Begin by clicking on the Insert tab and select Table. Then users are able to create a table by dragging the mouse across the squares to determine he amount of columns and rows. Make the final selection by simply clicking. Another option is to click on Tables and select Insert Table. Then users are able to input the number of columns or rows. This video will benefit those viewers who use Microsoft Office 2007, a...
Looking for a primer on how to create and work with array formulas 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 13th installment in his series of Excel array formula series, you'll learn how to do multiple regression and linear algebra problems with Excel's LINEST array function. Also see how to use the SLOPE, INTERCEPT and the FORECAST functions for linear algebra and how to create a s...
Looking for a primer on how to create and work with array formulas 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 10th installment in his series of Excel array formula series, you'll learn how to create an array constant from values in cells. This is a great trick that can save tons of time when you want your array stored in memory.
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 very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. 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 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...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. 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 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
This tutorial shows you how to make a basic Japanese style book. You'll need two different styles of paper, a cutting surface, a ruler, a paper cutter, and a ruler. Watch this video bookbinding tutorial and learn how to make a Japanese stab book.
Play clawhammer style on the ukulele. Clawhammer style is used for banjos but you can apply it to the ukulele for a great sound.
Looking for a cool way to get your lunch to school or the office? Want to stand out from the rest of the lunchroom crowd? Make yourself a lunch box out of duct tape! The duct tape lunchbox is completely customizable and will keep your food nice and cold.
This is a great little rainy day project you can make for almost no money, or a fun party trick you can use at the next office Christmas party! You will need two disposable drinking cups (stiff plastic or paper will work best), a fairly thick straw, a sturdy paper clip, a thick rubber band, a cocktail stick, a bead and a plastic ring you can get from the neck of a soda bottle. Assemble as shown, and then let it go!
Even if you and your office cohorts don't exchange cutesy valentines on Valentine's Day, you can still indulge in the vibrant, lovey dovey holiday by crafting one of these three paper favors for your kid's class.
Steampunk style, which is a funky hybrid of Victorian anachronisms (propellers, vintage watch parts) and industrial design, is sure interesting and cool when it comes to gadget design, but pulling off the whole googles-and-gears look clothing-wise is not quite...becoming.
You don't need a real football in your hand to have fun. In fact, all you need is a piece of paper, some instructions, and a good imagination to play a rough and tumble game.
Learn how to modify your old databases for use in Microsoft Access 2007. Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using old databases in Access 2007 yourself, watch this free video guide.
Learn how to work with Application Parts when using Microsoft Access 2010. Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started working with Application Parts in your own Access projects, watch this free video guide.
Learn how to use custom themes when working in Microsoft SharePoint 2007. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using themes in your own SharePoint projects, watch this free video guide.
Learn how to use the new Paste functions in Microsoft PowerPoint 2010. Whether you're new to Microsoft's popular presentation application or a seasoned MS Office professional just looking to better acquaint yourself with the PowerPoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the new PowerPoint Paste tools yourself, watch this free video guide.
Avatar rose from the box office to become one a cultural phenomenon. In this tutorial, learn how to completely Na'vi yourself so that you look like you should be living on the planet Pandora.
The Renaissance was a beautiful, romantic time in history. You don't have to look dated to grab this classic, story book style. All you need is to update it a little bit and you will look classically gorgeous in any decade.
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 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Ever wish you could embed a YouTube video into a Microsoft Office PowerPoint 2007 presentation? If you have a live Internet connection when designing your presentation, and will have one when showing it, you can. And it's an easy process to boot. For complete instructions on how to put a YouTube clip into a presentation in PowerPoint 2007, watch this helpful video tutorial.
Synchronize and backup your Microsoft Office Documents using Google Docs and Docsyncer. This is a great tutorial from Tinkernut on how to backup your files and Word docs using the free Google software.
How to fool your friends in some time ! You can delete or move away the icons ! Using Paint or any other screenshot or photo editing program swap out the desktop with one covered in images of the icons, rather than actual and clickable program icons. Delete all the icons on the desktop and this is sure to drive yoru friends crazy. Perfect office prank.
This is a Wiggle Walk C-walk dance tutorial. Be sure to click on Chapter 2 and Chapter 3 fo the entire tutorial. Follow along with this demonstration to learn the wiggle walk C-walk moves. This is advanced, not for beginners.
Watch this video to learn a simple cheat that will make your paper longer. Good trick to know when you are in a crunch and need to stretch your class paper. You will need to use your existing term paper and either Microsoft Word or Open Office to use the Find&Replace command. Here's some forums you can post anonymously with other like-minded, less scrupulous people: http://academicdishonesty.net
Want to make bows and arrows with paperclips, tape, a rubber band, and some Q-Tips?
Origami sticky note pad - How to make the Crane!
Origami sticky note pad - How to make the squirrel!
Origami sticky note pad - How to make the pig!
Microsoft Outlook 2007 Tip - Setup Signatures for Multiple Email Accounts - One of the difficulties with using multiple mail accounts is making sure your messages have the correct signature, or sig, attached to them. The new Signatures feature in Microsoft® Office Outlook® 2007 takes the hassle out of creating and applying signatures to your email.
Check out this instructional language video to learn how to take a telephone message at the office. "Telephone Talk" is a series of four short videos that deal with common English telephone situations at Fujikin. This is the second video in the series, and will show you how to take a message from an English-speaking caller.
Check out this instructional language video to learn how to transfer an English business call. "Telephone Talk" is a series of four short videos that deal with common English telephone situations at Fujikin. This is the first video in the series, and will show you how to transfer a call from an English speaker to someone in your office.
Mad at that co-worker who got the big promotion? Or just a little bored in the office? This step by step prank tutorial video shows how to pull a harmless practical joke on a co-worker by building a false bottom for a cup of coffee and filling it will marbles or beans. Use this as inspiration for one of your April Fools Day pranks!
While not as advanced as some of the dedicated graphics packages such as Adobe Photoshop, Open Office Draw still allows you to create nice looking images.
