If you're building an office model, or are looking to add a little something extra to a street model, you might give this great vending machine model a try! In this detailed video from brickboys518 you will get brief over view of the bricks that you will need for the model and then a great tutorial on the building process and build order.
There he is, your boss wants ANOTHER TPS report, ugh, why do you even want to work this job anyways? And where's your red stapler!? Don't fret, turn your boring work day into a great one with these tips on how to brighten your mood and turn your boring work into something a little more exciting!
For this office prank, you'll need a pen, rubber band, marker, crazy glue and some fake blood. The first thing you'll need to do is take the pen apart and get rid of the ink. Next, you'll need to attach the rubber band to the pen cap. Watch the full instructions from Nextraker to see what comes next for this bloody pen prank.
This video tutorial is in the software category where you will learn how to remove tabs and scroll bars from an Excel spreadsheet. Open a work sheet and you will find scroll bar on the right and at the bottom. But, why should you take them off? If you are making a user form that you want to send to your employees and you don't want them to mess it up, then you may do this. Go to the office button and click on 'excel options' at the bottom. On the next window go to the 'advanced' tab and scrol...
In order to insert Word Art, into your document, using Microsoft Word 2007, you will need to begin by opening your document. Next, find "Insert", at the top of your screen. Click on it. This will take you to the Insert Tool Bar. Find Word Art. Choose the style that you would like to use, from any of the styles in the style gallery. When the window opens, you can choose your font style at the top, if you want to change from the default setting. You can also change the font size. Write the word...
Being passed over for a promotion that you really wanted is one of the toughest things that can happen to you at the office. Reacting to it with proactively, but with poise and grace, is vital to making sure that you get the promotion next time. This video will teach you how to deal with being passed over for promotions in an effective way to make sure that you aren't passed over again.
This video introduces how to use Excel to sort data, perform the Frequency function, and present data in line chart. See how to apply condition formatting when working in Microsoft Excel 2007. Whether you're new to Microsoft's popular word processing application application or a seasoned MS Office professional just looking to better acquaint yourself with the Word 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating your own li...
Okay, so you're probably wondering, first of all, what the heck a TYVEK bag is. Well, dear viewer, TYVEK is a high-density polyethylene blend of fibers that's lightweight and opaque.
Not only is Microsoft Office Excel handy for drafting documents, it can also be used to make simple illustrations. Quite easily at that. The program's drawing tools are so easy to utilize, in fact, that this free video software tutorial can present a complete overview of the process in just under four minutes' time. For detailed instructions, as well as to get started doodling in your own Excel workbooks, take a look.
Want to create a Google Calendar and share it with your entire family or office? It's easy! So easy, in fact, that this free home computing how-to can present a complete (and somewhat talky) overview of the process in just over two minutes' time. For specifics, and to start creating your own networked Google calendars, watch this handy guide.
Trafficmaster vinyl flooring is one of the most exciting types of flooring to hit the market in recent years. It is made of vinyl, but can look like hardwood, tile, or other types of flooring while still maintaining its durability and easy of install. This short video features a man installing just such a floor in his home office, demonstrating how easy it is to put the pieces of Allure flooring together.
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 15th installment in his series of Excel array formula series, you'll learn how to set up, solve and write conclusions for larger-sized mathematical word problems.
Looking for a primer on how to create and work with arrays 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 12th installment in his series of Excel array formula series, you'll learn how to create array formulas for finding the largest improvement in sales from one year to the next.
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 14th installment in his series of Excel array formula series, you'll learn how to create array formulas for individual stock return and standard deviation given different assumed states of the future economy.
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 12th installment in his series of Excel name tricks, you'll learn apply names to formulas using Excel's built-in Apply Name Feature.
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 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.
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 4th installment in his series of Excel name tricks, you'll learn to use short Excel names to expedite the formula creation process. For detailed instructions, watch this free video Excel lesson.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. 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 55th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 remove duplicates tool and the COUNTIF function to count unique records that are greater than $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 43rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use a data validation drop-down list to change conditional formatting in a table. 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 32nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the MATCH & ROW functions to create a logical test to find the first occurrence of items in a list with duplicates.. 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 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...
This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new custom ...
Ever wish you could embed a YouTube video into a Microsoft Office PowerPoint 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 PowerPoint presentation, watch this helpful video tutorial.
Want to set up a wireless network in your home or office? It's simple. So simple, in fact, that this free networking how-to presents a complete overview of the process in just over four minutes. Set up a WiFi network with this video guide.
This video provides step-by-step instructions for how to insert sounds or music into a PowerPoint presentation, using Microsoft Office 2007. The narrator uses the insert sound tool and selects an audio file that, and demonstrates how to make it play automatically when the PowerPoint slide show is played. He also shows how to customize the effect options by using the animations tab, which allows you to choose when the track starts and finishes, for how many slides, and at what volume. After wa...
In this video, the instructor shows how to use Outlook Express in Windows XP. This software comes bundled with Microsoft Windows XP, which is a part of Microsoft Office package. Outlook is an e-mail client that allows you to view your e-mails on your computer without the help of any web interface to your mail host. To use Outlook Express, you need to configure it first. Open the Outlook Express program. Outlook will then take you through a wizard to help you to configure your email host. Ente...
Want a way to dynamically reference the number of instances of a given word in a Microsoft Office Word document from Excel? Who doesn't, am I right? In this Microsoft Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that.
If you want to manage what sort of data is entered into your Excel spreadsheet, data validation will help you to accomplish just that. In this Excel tutorial from ExcelIsFun, the 549th installment in their series of Excel magic tricks, you'll learn how to use data validation to full effect in your Microsoft Office projects.
Have you ever wondered how to make a brochure in Microsoft Word? Is your job requiring you to learn how to create a brochure in Microsoft Word? This tutorial will teach you step by step how to find templates online, transfer them into Word, and how to open the blank template in Word. This will enable you to create a successful brochure with a highly professional look to give to your clients. This step-by-step tutorial is guaranteed to tell you everything you need to know about creating brochu...
Watch this pen spinning video tutorial to learn how to do basic fundamental pen spinning tricks, like the Thumb Around, Thumb Around Reverse, Charge, Pass, Reverse Pass, Fingerpass, Finger Pass Reverse, Sonic, and Sonic Reverse.
Watch this pen spinning video tutorial to learn how to do some basic pen spinning tricks, like the Twisted Sonic, the Reverse Twisted Sonic, Thumb Around, Multiple Thumbspin, Infinity, Shadow, and Back Around.
No time to hit the gym because you're always stuck at the office? Then bring the gym to you with these moves, which you can do right at your desk. Tip: As you get out of your chair throughout the day, try to use only your leg muscles, leaving your arms at your sides and keeping your spine straight. This gives the muscles in your legs a quick workout.
Go ahead and celebrate your individuality—just don't announce to the office that you're a lazy nut-job. You will need: awareness, self restraint, plants, clock, a bowl of candy and personal momentos. Keep politics and religion out of the decor. Keep collectables at home. Interesting not: Plants indicate you are dedicated to your job.
Never again will being out of the office mean you are out of luck when it comes to working with your files. Thanks to the Offline Files and Folders feature in Windows Vista Business, Enterprise, and Ultimate editions, you'll have access to documents, even when you aren't connected to the network. For more on how to work with offline files and folders in Microsoft Windows Vista, watch this video tutorial.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about basic form customization. Specifically, this video addresses the adding a few navigation buttons and a label to a form. Simple stuff! Take a look.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a letter to multiple recipients using one form letter and a table to populate it. For more on using mail merging in Microsoft Access, watch this how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using the DateDiff function to work out age from birth date. For more, including detailed instructions, watch this Access how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a multi-user login form to password protect different areas of your database.
