Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an array formula to find the vendor with the maximum rating and the lowest cost Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
This time on the show, bypassing restrictive firewalls with a free and open source virtual private network server for Windows and Linux that will have you connecting back to the home or office with just a web browser! Best of all? It's free! Check out this video for detailed information on how to build an SSL VPN.
This video covers the steps for creating USB Christmas lights. Take battery powered Christmas lights and convert them to USB powered to decorate your office. Take apart the battery casing. You have to rewire this. You also need to cut open a USB cord and do some soldering.
This origami video shows you how to make a paper football (American rules football). This is probably one of the first folds I ever learned to make, and I don't really consider it origami... but at the same time, I thought it might be fun since the BCS football bowl games and NFL playoffs are just around the corner. So make your own paper football and have a little fun playing office football while the boss isn't around.
The dolly zoom shot is also known as the Vertigo Effect in filming. It's that dizzying, slightly unstable camera effect you see in shows like "Glee" and sometimes "The Office." It creates audience confusion, thus forcing them to keep watching in interest.
Looking for an easy way to consolidate and view your email messages conversations into easy-to-ready threads? This clip will teach you everything you'll need to know. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video g...
Before you can work in MS Access 2010, you'll need to learn how to work with it. See how to navigate the Ribbon interface when working in Microsoft Access 2010 with this guide. Whether you're new to Microsoft's popular database 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 using the Backstage view in your own Acces...
Before you can work in Word 2010, you'll need to learn how to work with it. See how to change and style fonts within the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using custom font settings in Word 2010 yourself, take a look.
Before you can work in Word 2010, you'll need to learn how to work with it. See how to undo and redo actions the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started undoing and redoing actions with ease in Word 2010 UI, take a look.
Before you can work in Word 2010, you'll need to learn how to work with it. See how to use the Microsoft Word 2010 Ribbon interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started navigating the Word 2010 Ribbon UI yourself, take a look.
Want to use an Illustrator CS5 illustration in a Microsoft PowerPoint presentation or Word document? This video clip will show you how it's done. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, wat...
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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). 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 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this Microsoft Excel 2007 for Dummies video the instructor shows how to record a Macro. Macros let you create a shortcut to perform a sequence of commands all at once. For example you can create a macro to quickly build a sales report template that you frequently use. When ever you run that macro the Word will automatically build the template for you based on the recorded commands. To write macros you need to have the developer tab enabled. To enable it click on the office button and at th...
David Rivers shows us how to create navigation forms in Microsoft Office 2010 without writing codes or using logic. A navigation form is kind of like a homepage that will give you a list of reports. There are pre-designed layouts you can choose from to make your navigation form. You will just need to customize your form by adding reports to the navigation pane. What this means for business owners is that you can see customer orders and store reports just by looking at one page. Simple to make...
When filtered through the prism of the top stories of the year, the business of augmented reality 2019 was defined as much by epic failures of AR startups as it was by the promising developments that propelled the industry forward into 2020.
Mobile augmented reality pioneer Blippar has now completed its fall from hopeful AR startup to the immersive computing history books.
In a previous tutorial, we were able to place the Mona Lisa on vertical surfaces such as walls, books, and monitors using ARKit 1.5. By combining the power of Scene Kit and Sprite Kit (Apple's 2D graphics engine), we can play a video on a flat surface in ARKit.
The best part about April Fool's Day is that everyone is fair game. Even big tech companies like Google and Twitter get in on the action every year. It encourages even the most uptight, unfunny party-poopers among us to have a little fun driving each other crazy with pranks — even at work.
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!
The classic pin up makeup look coined by Old Hollywood stars like Marilyn Monroe and Ava Gardner will never go out of style, and for good reason: It looks good anytime, any place.
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.
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 use CSS (cascading style sheets) to style pages created in Adobe Dreamweaver CS5. 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 applying CSS formatting to your own pages, watch this free video guide.
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.
This look is gorgeous and based on the Red Queen from Tim Burton's new Alice in Wonderland movie. The film was a box office smash and now you can capture some of the magic for yourself. Follow this video and use this style anytime you need a mischevious, dramatic, devilish look.
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.
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.
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!