Hot Microsoft Office Posts
How To: Measure the spread of a data set with Excel's AVEDEV
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVEDEV function to measure the spread (variation) in a data set. Also see the STDEV function and learn how to measure whether a mean represents its data points fairly.
How To: Change columns from letters to numbers in Excel 2007
Teach Excel demonstrates how to change the columns from letters to numbers in Excel 2007. The first step is to click on the Office button in the top left part of the window. Next, you click on Excel Options and click on the Formulas tab. There should be a heading labeled "Working with Formulas." The checkbox for R1C1 reference style should be unchecked by default. Check that box and click OK. This changes the column headers from letters to numbers. In order to change back to letters, simply g...
How To: Calculate the vest date for a contract in MS Excel
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to
How To: Extract records that meet certain criteria in Excel
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
How To: Use the IF function with letter grades in Excel
This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...
How To: Embed a YouTube video in PowerPoint 2007
This video shows how to embed a YouTube video in a PowerPoint presentation in Microsoft Office PowerPoint 2007. First you want to copy the URL of the YouTube video that you want to embed in your PowerPoint. Then, open PowerPoint 2007 and click the office button in the top left corner (circular button with office logo). Then click "PowerPoint options" and check "show developer tab in ribbon". Then click "OK". Click on the developer tab, and click on "more controls". Then scroll down to "Shockw...
How To: Calculate total savings in Excel
This video will show you how to calculate the total savings on a transaction where there are two percentage series discounts and two dollar discounts. This video shows frugal bargain hunters how to simplify with an Excel sheet and find the total saving percentage. It teaches functions that can be used in the Excel sheet, plus useful tweaks and formulas.
How To: Use the sparkline function in Microsoft Excel 2010
There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. After you enter the data range and location range, the Sparkline will show up indicating the trend based on the data range you identified earlier. You can change the types and styles of your Sparkline easily. As the video demonstrates, whenever you use E...
How To: Compare two lists and extract the new values in Excel
Excel dilettantes and seasoned Microsoft Office Pros alike are sure to delight in this tip, which comes to us by way of the 540th installment of ExcelIsFun's series of Excel magic tricks.
How To: Use INDIRECT, TEXT, and SUBSTITUTE in Excel
ExcelIsFun will show you how to use indirect text and substitute in Excel. Select any date and product and create an intersession. Use Vlookup to look up your columns. Use the match function to find the value range. To do the same thing with dates, highlight the dates and names. You then let the name look for indirect. Your space operator tells you two ranges to find the intercept. Take the text and substitute for the dashes. Use the text function on the value and format it.
How To: Make NeoOffice documents Microsoft Word compatible
Microsoft Office is the defacto standard for document creation, but you can get that functionality and compatibility without paying a dime. For Macintosh users, use NeoOffice and learn to save your docs automatically in the MS Office formats.
How To: Create a background and watermark in Visio 2007
Take a look at this instructional video and learn how to include your company logo in the background and add a watermark in just a few quick steps with Microsoft Visio 2007. And you can reuse this background on every page in your Visio drawing.
How To: Make a PowerPoint multiple choice quiz
Need to give your students a jolt of unexpected fun tomorrow morning? Then there's nothing more exciting than giving your students a pop quiz. One of the easiest ways to write a quiz while conserving paper is to create a PowerPoint presentation.
How To: Schedule Meetings in MS Outlook
In this tutorial First, we will discuss what a meeting is, How can we schedule it in Outlook. A meeting can be defined as a mass of two or more people have a common motive. All the people present in a meeting can share their ideas and exchange information, to carry out the actions to achieve their goal. This tutorial helps those people who are looking for the steps to Schedule a Meeting in MS Outlook.
How To: Use MS Excel Effectively
Welcome to the first chapter of Excel is Simple, a place where we will burst all myths around excel and try to make it simpler and fun to use.
How To: Create 3D Effect Object in MS Word
This video will provide an idea how to create 3D effect object in ms word. Create 3D effect with the help of this video. So please watch the video and follow all the steps carefully. Employ the technique in your PC.
How To: Make Digital Signature in MS Word
This video will guide you how to make digital signature in MS Word. The digital signature will allow to secure your document from tampering. When you set digital signature in your word text then you can't insert anything in the document anymore. You could add your image of signature with text.
How To: Create a Watermark MS Word Document
This video will provide an idea about the watermark which is a background effect of either text or graphics that prints in a lighter shade behind the content of your MS Word 2007 document. Watch the tutorial video and employ it yourself.
How To: Customize Quick Access Toolbar and Delete Mini Toolbar in MS Word 2007
This video will show you how to customize quick access toolbar and delete mini toolbar in MS Word 2007. These 2 things are very useful. Watch the video and follow all the steps to employ it yourself.
How To: Disable or Remove Recent Document List in MS Word or Excel
This video will guide you how to disable or delete recent document list in MS Word 2007. The same procedure is also applicable for MS excel also. Follow the steps and employ the technique in your PC.
How To: Protect MS Word Document with Password
This video will provide an idea how to protect your ms word document with password. Whenever anyone wants to open the document it will ask for password.
Cozy How To: Microsoft Office Ribbon Interface & Work Space
PowerPoint Tutorials for Microsoft PowerPoint presentation software. In this introduction tutorial we will be using PowerPoint 2010 and will focus on the interface workspace by reviewing the ribbon, slide pane and slide tabs. The ribbon is designed much like a website navigation menu bar and has multiple categories to separate all of the tools into an organized bar. By default the Home tab is selected and will include most of the tools that are commonly used when editing and creating a PowerP...
How To: PowerPoint Ribbon & Interface Introduction
Learn the and understand the mechanics of the PowerPoint interface. This tutorial will explain the Ribbon, Slides Pane and Slides Tab. Throughout this tutorial it is assumed that you are a complete beginner however as new tutorials are added the complexity will slowly increase from basics to advance. This tutorial is brought to you by Cozy HowTo your place for a snugly warm learning experience.
How To: Customize Quick Access Toolbar in MS Word
This video will show you how to customize Quick Access Toolbar in MS Work. You could add, delete commands and can set the placement of the bar.
How To: Watermark a MS Work Document
Video: .
How To: Score a Full Version of Microsoft Office for Only $10
When it comes to text documents and spreadsheets, Microsoft Office is the be-all and end-all office suite—but it's not cheap. Paying anywhere from $140 to $400 puts a big dent in your bank account, especially if you're a broke college student eating ramen for breakfast, lunch, and dinner. Something that I wish I would've known about during college is Microsoft's HUP (Home Use Program). With HUP, any employee or student of an organization that has a Microsoft volume license is eligible to purc...
How To: Protect Word Doc with Password
If you want to protect your word doc from other, you can give it a password. When anybody wants to open, it will ask a password. This way your valuable document will be secured from unauthorized access.
How To: Make Sure People Will Understand Your Writing by Testing Your Readability Score
There is a substantial number of helpful tools at your disposal in Microsoft Word when it comes to writing; grammar check, word count, dictionary, thesaurus, and tons more. One tool that doesn't necessarily make itself obvious is testing your document's readability. With this built-in tool, you can not only check your spelling and grammar, but also the reading level of your document.
How To: Add Calculating Expression in MS Word 2007
Step 1: Calculating Expression in MS Word Step 2:
How To: Check 2nd Spreadsheet, if Data Is in Both, Copy Informaiton
Hello! I am working on merging two databases. The first has 1,500 contacts - just first name, last name, and company. The second has 5,000+, with first, last, company and email. I want to search the 5,000 email list, if the name appears on the 1500 list, I want to copy the email address from the 5,000 list.
News: "Ghost Protocol", Plus 4 More Reasons to Download the New Microsoft Office 365
Yesterday, Microsoft released the customer preview of its newest version of Office, the first version optimized for both touchscreens and desktop systems. The entire suite got a much-needed facelift and a few new cool features. Here are some of the most notable changes.
How To: Create and Edit Tasks in Microsoft Project 2007
In this video tutorial, we will go through the basics of setting up and editing tasks in MS Project 2007. Project is a great application for time management, planning and scheduling. It's really a must for any business—small or large.
How To: Download a Free, 30-Day Trial of Office for Mac 2011
If you're a Mac user, it's fair to assume that you may be a little skeptical when it comes to Microsoft products. Microsoft knows this, of course. Which is why the company has decided to offer Mac users a free, one-month trial of the latest version of their popular Office productivity suite, Microsoft Office for Mac 2011. They're betting you'll like it so much you'll buy it. And, if you're already a Office for Mac 2008 user, they may be right! Think you're tough enough to resist Steve Ballmer...
How To: Work with common and preferred stocks in Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 62nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to work with common and preffered stocks in MS Excel.
How To: Value a stock with predictable dividends in Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 63rd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to value a stock with predictable dividents in Excel.
How To: Chart assumed constant growth rate changes in Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 64th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to chart assumed constant growth rate changes in Excel.
How To: Calculate stock prices with the dividend growth model in Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 65th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate stock prices using the dividend growth model.
How To: Calculate implied return using the dividend growth model in MS Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 66th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate implied return with dividend growth in Excel.
How To: Value a stock with irregular dividend payments in Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 67th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the value of a stock with irregular dividend payments,