Informed Predictions Search Results

How To: Add comments to cells in Microsoft Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about adding hidden comments (and metadata more generally) to data cells. For more information on commenting, watch this Microsoft Office Excel how-to.

How To: Use COUNTIF in Microsoft Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about Using COUNTIF function to count the number of As, Bs and Cs. For more on using the Microsoft Excel COUNTIF fucntion, watch this how-to.

How To: Use HLOOKUP across two worksheets in Microsoft Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using the HLOOKUP function to generate adaptable grades from marks. For more on using HLOOKUP across multiple documents, watch this Microsoft Office how-to.

How To: Concatenate in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about stringing text and data together by using an ampersand (&) concatenation. To learn more, watch this MS Office how-to.

How To: Use conditional formatting in Microsoft Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using conditional formatting in Excel to change background color. To get started learning about conditional formatting, watch this MS Office how-to.

How To: Use VLOOKUP across worksheets in MS Excel 2007

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using VLOOKUP in one worksheet to look up values located in a second worksheet. For more on using VLOOKUP across Excel worksheets, watch this MS Office how-to.

How To: Use VLOOKUP in Microsoft Office Excel 2007

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using VLOOKUP to look up values located in a table. To learn more about VLOOKUP, watch this MS Office Excel how-to.

How To: Use nested IF statements in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using nested IF functions to calculate a grade from an average mark. For more information on using conditional statements, watch this MS Excel how-to.

How To: Use absolute ($) cell referencing in Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using '$' to prevent excel from changing formulae when copying or filling ranges. For more on absolute cell referencing, watch this Microsoft Excel how-to.

How To: Calculate averages in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using Excel to calculate average values and to pick max and min values. For more on this handy feature of Excel, watch this how-to.

How To: Use simple formulae in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about simple addition, subtraction, multiplication and division in Excel. For more on using simple formulae, watch this video how-to.

How To: Format spreadsheets in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this Excel tutorial, you'll learn about simple formatting, background colour, gridlines, alignment. For more information on formatting spreadsheets within MS Excel, watch this helpful how-to.

How To: Get started using Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. This Microsoft Office video tutorial presents an extremely introduction to Excel. In it, you'll learn about names of bits and really simple formatting. To get started using Excel for yourself, take a look.

How To: Use British slang

Check out this instructional language video to learn a few definitions of British English slang words. Slang is the use of highly informed words and expressions that are not considered standard in the language. Understand and be able to use some informal British English words with this tutorial video.

How To: Enable blocked macros in Office 2007

Not sure what to do when you get a security warning about a macro? What are macro security settings, the Trust Center, and Trusted Locations anyway? Watch this instructional video to learn how to enable macros and make informed security decisions that can help you keep your computer safer while you work in Microsoft Office Excel, Outlook, Word, Publisher, PowerPoint, and Visio 2007.

How To: Make homemade dessert icing

While topping your cake or cupcake with icing is easiest done using storebought icing, we're sorry to inform you that most grocery store icing has high amounts of saturated fat and even trans fat, both of which clog your arteries and contribute to heart disease. Not so appetizing now, is it?

How To: Get 52% Off This Game-Changing AI Typing Software That Will Cut Your Typing Time in Half

If you do a lot of typing every day — writing reports, essays, emails, and whatnot — we can guarantee your day would be improved by taking less time to do it. Thankfully, we've found a super-smart AI-powered tool that will do just that, and right now, you can get an amazing 52% off a Lightkey Pro Text Prediction Software: Lifetime Subscription for the sale price of just $79.99 (regular price $169).

How To: Do Power Drift achievement in Sonic & Sega All-Stars

Achievement Hunter presents how to do power drift in Sonic & Sega All-Stars Cart Racing Part 1. To pick up the drifting achievement, all you have to do is drift for 15 seconds continuously. In order to drift, you hold down the left trigger. The narrator informs us that you can switch from drifting to the left to drifting to the right if you bounce off the wall, so it does not have to be all one direction. He said that the first time he did it, he drifted on the last few turns of the race. Tha...

How To: Listen to music with your whole body

In this soaring demonstration, deaf percussionist Evelyn Glennie leads the audience through an exploration of music not as notes on a page, but as an expression of the human experience. Playing with sensitivity and nuance informed by a soul-deep understanding of and connection to music, she talks about a music that is more than sound waves perceived by the human ear. She illustrates a richer picture that begins with listening to yourself, and includes emotion and intent as well as the complex...

How To: Prioritize Frequent Contacts with This KitKat-Style Dialer on Your Samsung Galaxy S3

It's a done deal. KitKat is the shit, and everyone wants in on it. Unfortunately, the Samsung Galaxy S3 won't see any of Android 4.4's features incorporated into TouchWiz for some time, as we're still on a 4.1 version. Still, we can throw a few of KitKat's features onto the device ourselves, like the home launcher and new keyboard. And now, we can even get a feel for its smarter phone app.

How To: Perform a "How'd you do that" card trick

This is a video that demonstrates how a card trick is done. It shows a trick in which the presenter does a card trick and then explains how it is done. The trick is one where the person guesses a card and it deals with a red deck and a blue card. The person guesses a number in the deck and that number is the card. In this case it was the queen of hearts. The card is then placed back into the deck and when the presenter lays out the cards, the blue card becomes the queen of hearts. The trick i...

How To: Survive in a Falling Elevator

The tragedy of a falling elevator is not unheard of. This could happen to you at any time, and you will most likely not be expecting it. Who would step into an elevator if they had an idea it might plummet to the ground? The best thing you can do is be prepared. First you want to stay calm. Next you want to lie, belly down, on the elevator floor with your hands behind your head. Make sure you do not panic. This is crucial in times of crisis. When all is over, you'll notice that you're still a...

How To: Search graphics, tables, and charts in MS Word 2010

This is an informative video tutorial on how to search graphics, tables and charts using MS Word 2010. The author informs that the earlier MS Word editions had fast and easy search options, but the same feature built into the 2010 edition is vastly improved. One simply has to click the ‘Find’ option at the top right-hand corner and a navigation pane opens on the left-hand side. In the search box, the keyword is typed in and all the instances of that word in the document are highlighted, while...

How To: Make a summery Suntan Lotion cocktail with rum

Bartending expert Derrick Schommer gives a graphic demonstration on how to make a Suntan Lotion cocktail with rum. Derrick informs us that this is a very simple cocktail, its ingredients being 1 oz. each of coconut rum, amaretto and cream. All three are shaken well together with ice, and then strained into a lowball glass full of ice cubes. In closing Derrick advises that instead of the regular thick cream, it would be better to use the thinner lye cream, since regular cream would make the co...

How To: Do stomach flattening exercises at home

This fitness video shows how to do stomach-flattening exercises at home. Our host, Kathy, Kaehler, informs us that the best exercise is a yoga-based exercise called the plank, because it focuses on your core. Your core is where your abs are. This exercise is best done on soft surfaces. Start out at 15 seconds, and build up to a minute or more. To do the plank, rest on your knees and 1 forearm, with your side facing the ground. Make sure your body is straight. If you want to make the exercise ...