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 ...
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...
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.
Microsoft Office Excel 2007 has a new design that makes your work easier, faster, and more efficient. The new Ribbon puts the commands you use most often in plain sight on your work surface instead of hidden in menus or dialog boxes. Ready-made cell styles let you quickly format your worksheet to make it easier to read and interpret. The new Page Layout view shows how your printed worksheet will look as you're creating it.
Microsoft Office PowerPoint 2007 has a new design. The new Ribbon keeps the commands that you use most often visible while you're working instead of hiding under menus or toolbars that you have to hunt for. Also, commands that you may not have known about before are now very easy to discover. When it comes to designing your slides, live preview of style galleries lets you see how things such as backgrounds and shape formatting will look before you apply them. A new SmartArt graphics feature o...
You don't have to be a professional designer to create a professional-looking slide show. Check out this tutorial and learn how to grab the audience's attention by adding a background to your slides. Microsoft Office PowerPoint 2007 design themes include an array of coordinated choices for background colors and textures. You can even use a picture as a background. See your choices displayed instantly in a live preview, so no guesswork involved!
With PivotTable reports in Microsoft Office Excel 2007, your sales report will sparkle with power, flair, and functionality. Take a look at this instructional video to learn how to show the big picture, show all the details, or show anything in between. Easily create multiple worksheets to switch back and forth between the various versions of your report. Sort, filter, and summarize your data any way you like. Show the details of any summary value in your report.
Check out this tutorial and learn how to create chars in Excel 2007. In Office Excel 2007, you just select data in your worksheet, choose a chart type that best suits your purpose, and click. Want to try a different chart type? Just click again and select a new chart type from a huge range of possibilities. Then work with the new Chart Tools to customize the design, layout, and formatting of your chart. You can see how various options would look just by pointing at them.
Now that we've had our hands on the Magic Leap One for almost a year and early adopter developers have had the opportunity to publish apps for the AR headset, it's time to see how it stands up against the rigors of a day at the office. We did just that, and we wrote about it!
Trimble is integrating its mixed reality applications into the DAQRI Smart Helmet to enable outdoor and on-site support for design, construction, and heavy industry as part of a collaboration the companies announced today.
Once you've designed some holograms with HoloLens, you'll need to get them to interact with the environment. That's where Spatial Mapping comes in. There are five basic purposes for using HoloLens's Spatial Mapping with your app:
When it's time to get down to work, a clean, organized workstation is key to accomplishing tasks and being more productive. Or, so we thought.
The video game Terraria presents an incredible world to be discovered as you play. Watch this video to learn how to find floating islands in Terraria. Floating islands are a whole new environment to explore when you are playing Terraria.
Produce and mix drums using Pro Tools in this video tutorial. Pro Tools is used in this project to begin with several drum tracks, add effects, add compression and mix down to a final stereo drum track all within the Pro Tools software environment.
For this tutorial, you will need the stapler you intend to booby trap and then a few paper party snaps. Open the stapler and put one or two party snaps inside. Then just sit back and wait for someone to come by and use the stapler!
Parrot Trainer Chet Wombach shows how to use 'positive imprinting' to get rid of negative feelings towards objects, people, or things. Exotic birds may not immediately adapt to a domestic situation and may find household life unnecessarily threatening or stressful. Watch this video training tutorial and learn how to use the technique of positive imprinting to better acclimate a pet parrot, cockatiel, Macaw, or any exotic bird into the household environment and to be a happier, healthier, and ...
There's a fantastic armory in Vault 34 you can raid for weapons and more. You will need to make sure that you are either very high level or already have a potent weapon to successfully complete the Vault 34 run. Unlock the Overseer's office, too!
So you've created your first account and designed your first avatar. Now it's time to actually play the game! This video tutorial shows you all the basics when it comes to moving, acting and interacting with your environment when playing the science fiction MMO Entropia Universe.
In this video tutorial, we learn how to create documents for the web in Microsoft Office Publisher 2010. Whether you're new to Microsoft's popular desktop publishing application or are a seasoned pro merely looking to brush up on Publisher 2010, you're sure to be well served by this clip. For more information, and to get started employing the lessons imparted by this free video software tutorial in your own Publisher projects, take a look.
In this video tutorial, we learn how to select and manipulate objects when working in Microsoft Office Publisher 2010. Whether you're new to Microsoft's popular desktop publishing application or are a seasoned pro merely looking to brush up on Publisher 2010, you're sure to be well served by this clip. For more information, and to get started employing the lessons imparted by this free video software tutorial in your own Publisher projects, take a look.
In this video tutorial, we learn how to create a new publication when working in Microsoft Office Publisher 2010. Whether you're new to Microsoft's popular desktop publishing application or are a seasoned pro merely looking to brush up on Publisher 2010, you're sure to be well served by this clip. For more information, and to get started employing the lessons imparted by this free video software tutorial in your own Publisher projects, take a look.
Dogs can be very susceptible to distractions, but you can train your dog to focus only on you no matter what else is going on around him. This tutorial shows you how to use clicker training to train a dog to focus on you.
In this tutorial, you'll learn about the cables required for setting up a small home or office network. Fortunately, cable selection is an easy process and this video presents a complete guide. For more information, including a full demonstration and detailed, step-by-step instructions, watch this helpful home-computing how-to.
This isn't so much of an evil mouse prank as it is an annoying mouse prank. By following the instructions in this video you'll learn how to take control of your co-worker's mouse so that no matter where he moves it, the cursor will always slant to the side and stay there.
Business casual is a popular style for men in modern business environments, but it's very difficult to pin down. How casual can I go? How businessy is too businessy? Watch this video to learn how business casual works and how you can rock it yourself.
Growing your own vegetables are a cheap alternative to going out to the grocery store and buying it. Plus, it will taste much better and you will feel better about yourself as you eat them! If you're looking to grow Asparagus but aren't really sure where to start, check out this video. In it you will learn the best environment to grow them in and what the fastest way is to get the best result.
Some models of Nikon camera may experience an issue where light leaks through a distance panel and onto the images during a long exposure in extremely bright environments. This short tutorial explains how to tell if you might have a camera susceptible to light leak, and how to fix it if you do.
In this clip, you'll learn everything you'll need to know to add buttons and states to your Flash Builder projects. Whether you're new to Adobe's popular Eclipse-based integrated development environment (formerly known as Flex Builder) or are a seasoned developer merely looking to improve you're chops, you're sure to benefit from this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.
In this clip, you'll learn how to set up PV3D for hacking the Number3D class. Whether you're new to Adobe's popular Eclipse-based integrated development environment (formerly known as Flex Builder) or are a seasoned developer merely looking to improve you're chops, you're sure to benefit from this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.
Interested in learning how to display HTML content with Adobe AIR 2? It's easier than you'd think. It's so easy, in fact, that this video tutorial can present a complete, step-by-step overview of the process in jsut over six minutes. For more information, including step-by-step instructions, watch this helpful video guide.
Want to create a basic slideshow presentation in Microsoft Office PowerPoint 2010? Let this video be your guide. It's easy and this clip presents a complete, step-by-step overview of the process. For more information, including detailed instructions, and to get started creating your own PowerPoint shows with simple animations and lside transitions, take a look.
Taking care of houseplants is a tough job, especially if you have more than one kind, because the proper, healthy growing conditions can become muddled. If one of your houseplants is a African violet, which is a saintpaulia flowering plant, then this video will help you take care of it for a thriving plant that will surely brighten up any room. Learn about picking the right environment, watering, fertilizing and keeping pests away.
Need a hand figuring out how to set up a wired home LAN network? It's easy. And this brief video tutorial from the folks at Butterscotch will teach you everything you need to know. For more information, including detailed, step-by-step instructions, and to get started managing your own web pages with Google Sites, take a look.
If you usually wind up playing Warhammer 40k on the same type of board pretty consistently, you should consider spicing up your pieces by giving them bases that look like the sort of terrain your favor. This video will show you how to make an urban environment base for Warhammer 40k miniatures that will make your pieces look that much better. And look account for so much in Warhammer games don't they?
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.
