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 ...
Head massages are great releases after a long day. They are easy to learn and easy to give once you know how. When giving a head massage, it's important to remember that personal preference for the amount of pressure used varies greatly from person to person. Learn about giving a good head massage with help from Gretchen Rivas, a massage therapist from Relax Wilmington in Wilmington, NC. Learn these professional secrets from a masseuse in one of America's loveliest cities.
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.
Create your own head turning magic by creating the easy to make paper toy in this how-to video. Make two paper dunce caps, cut out face holes, and stick the prop onto an assistant for this trick. Spinning the paper hats around creates a creepy illusion that the assistant's head is spinning around on their neck like magic. Check out this instructional video and learn how to perform this head-turning illusion.
Now, instead of leaving Post-It notes on a monitor screen, you can create virtual Post-It notes in Adobe Photoshop! This is a quick tutorial for the intermediate to advanced user of Photoshop, showing you how to create a square, yellow graphic that looks strikingly like the Post-It notes you can find at office supply stores! Add to your website, incorporate in PowerPoint presentations, or use wherever you see a need for a virtual sticky note!
Notepads are some of the most banal objects on your office desk. Usually you don't think twice about them other than to check when your dentist appointment is.
Got a case of the wintertime blues? Then use a snow day or just a boring Sunday afternoon to put together this simple and inexpensive skinny notepad. Yeah, we realize you can purchase notepads at just about any office supply store, but these pretty, beribboned notes will cheer up your day every time you write on them.
If you love braids and you love updo hairstyles, the you have to try this one on for size! It's an elegant braided low bun, with a lot of character, perfect for everyday wear, office hair and even as a bridesmaid! It's definitely worth trying on for size. If you have long hair, this low bun will get your plenty of compliments.
We hear so much these days about expensive microdermabrasion and facial treatments at doctors' offices that we forget we forget we have many of the same moisturizing and exfoliating ingredients at home, including avocados, lemons, and oatmeal.
In this clip, you'll learn how to enable and use the automatic tidying feature in MS Outlook 2010. 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 guide.
Need some help figuring out how to make a new notebook within OneNote? This guide will show you how it's done. Whether you're new to Microsoft's popular notetaking application or a seasoned MS Office pressional just looking to better acquaint yourself with the OneNote 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating notebooks yourself, watch this free video guide.
Learn how to share OpenOffice.org Draw files via email from within OOo. More than just a free, open-source clone of the Microsoft Office productivity suite, OpenOffice has its own unique feature set and its own unique way of doing things. Happily, the Internet is awash in free video software tutorials like this one, which make learning the application a breeze. For complete details, watch this OpenOffice.org video guide.
Learn how to create simple drawings in the OOo graphical editor, Draw. More than just a free, open-source clone of the Microsoft Office productivity suite, OpenOffice has its own unique feature set and its own unique way of doing things. Happily, the Internet is awash in free video software tutorials like this one, which make learning the application a breeze. For complete details, watch this OpenOffice.org video guide.
Learn how to create, edit and otherwise work with vector and bitmap graphics in OpenOffice Draw. More than just a free, open-source clone of the Microsoft Office productivity suite, OpenOffice has its own unique feature set and its own unique way of doing things. Happily, the Internet is awash in free video software tutorials like this one, which make learning the application a breeze. For complete details, watch this OpenOffice.org video guide.
Learn how to navigate the OOo Calc graphical user interface or GUI with this video guide. More than just a free, open-source clone of the Microsoft Office productivity suite, OpenOffice has its own unique feature set and its own unique way of doing things. Happily, the Internet is awash in free video software tutorials like this one, which make learning the application a breeze. For complete details, watch this OpenOffice.org video guide.
Interested in creating a site collection within Microsoft SharePoint 2010? This guide will show you how it's done. 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 2010 workflow, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
Learn how to use the new Backstage view feature in Microsoft PowerPoint 2010 to better manage your slideshows. 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 creating and using the Backstage view in your own PowerPoint projects, watch this free video guide.
Learn how to add use text wrapping in your Microsoft Word 2010 documents. 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 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started wrapping text around images in your own Word documents, watch this free video guide.
There are so many computers available today, from laptops to desktops to netbooks and everywhere in between. If you are considering going the stationary route, check out this tutorial. In this video, learn how to choose a desktop PC that is right for you. The experts at PCWorld will walk you through brands, capabilities and price ranges so that you can walk into your local office store with confidence and pick out your model.
Learn how to quickly import data into Microsoft OneNote 2010 with the Quick Filing tool. Whether you're new to Microsoft's popular note-taking application or a seasoned MS Office professional just looking to better acquaint yourself with the OneNote 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started quickly importing data into your own OneNote projects, watch this free video guide.
This video will surely perplex math teachers everywhere who have always made it an unbreakable rule that all rectangles are squares and that not all squares are rectangles, but neither squares nor rectangles are hexagons.
This makeup look is perfect for any girl. In this tutorial you will learn exactly how to apply Taylor Swift's youthful and neutral makeup style on your own. This look is inspired by Taylor's video for "Fifteen". This look is great for everyday, school, the office and anywhere else you want to look beautiful but not made up. Have fun!
If you want to add a little shimmer to your evening, check out this tutorial. In this video, learn how to touch up your makeup or remove it altogether if you have used sticky glitter. You don't want to be that girl or guy in the office Monday morning who still has specks of the weekend on their face, do you?
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 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.
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.
