Hot Microsoft Office Posts
How To: Create formulas with table nomenclature on Excel 2007
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 200th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel 2007 Table Nomenclature in formulas. See 9 examples of how to create formulas with table nomenclature in this free Excel video tutorial.
How To: Extract digits to the right of a decimal in MS Excel
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 580th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE, MID, COLUMNS and SEARCH functions to extract numbers to the right of a decimal into their individual cells.
How To: Analyze a CM statement with a data table in MS Excel
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 254th installment in their series of digital spreadsheet magic tricks, you'll learn how to do contribution margin income statement analysis across various units using a one-variable data table.
How To: Create nested unique lists in Excel via array formulas
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 251st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales reps using a series of standard formulas in tandem with a few array formulas.
How To: Make a shrinking data validation list in MS Excel
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 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.
How To: Create a sudoku puzzle in Excel with array formulas
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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.
How To: Dump data from an Excel pivot table with a macro
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 229th installment in their series of digital spreadsheet magic tricks, you'll learn how to dump data from a pivot table by macro in Microsoft Excel.
How To: Create a simple database in Excel with a list or table
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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple dynamic database in Excel using lists in Excel 2003 and tables in 2007.
How To: Pin recent Excel documents to the office button menu
This video helps you to Pin Recent Documents in Excel to the Start Menu or Office Button Menu in Excel 2007. When you click the office button on the left corner, your recent documents will appear by default. If you open a new document, it will push the other documents down and it will appear on the top. So, if you want a particular document to open whenever you open the excel, you have to click that particular document by clicking the pin that appears in the right side of it. This will turn t...
How To: Insert, format, resize & crop pictures in MS Word
This video is a Microsoft Word 2007 tutorial on working with pictures. To insert a picture in your document, click on Insert and select Picture, then find the picture, select and insert it. To resize the picture without distorting it, click and hold on the corner circles. You can adjust Brightness and Contrast by using the various choices within these settings. The Recolor setting gives you a number of options for changing the coloring of the picture, such as sepia, black and white, or graysc...
How To: Pull names associated with a date range 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 165th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a logical formula to extract values associated with dates occurring in the next two weeks.
How To: Generate a dynamic list from a table 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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
How To: Calculate vacation days with TODAY, YEAR & IF in Excel
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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF functions.
How To: Turn off AutoCorrect symbols in Excel
In this Excel magic trick video the instructor shows how to stop automatic copyright symbol ©. While using Microsoft Excel when you type the letter c in between a pair of curved braces Excel automatically turns it into the copy symbol © even if we did not intend to use it. Now to get rid of this feature go to the file menu and then to the options menu. In the options window that pops up go to the proofing sub menu and there is a button for auto correct options. Go into it and it shows the lis...
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: Use Boolean operators in Microsoft Access queries
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 Boolean logical operators AND OR and NOT in queries in Access. To get started using Boolean operators in your own Access queries, take a look.
How To: Add a clock to a form in Microsoft Office Access 2007
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 a tiny bit of VBA to add a clock to a given form. For step-by-step instructions, take a look!
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: Change the Default Font in Excel 2010
Some people may don't like the default word or hyperlink font in their Excel. Though you can change the word font of the whole sheet by using the font tools in the Home menu, but the default font still remains when you create a new Excel file. So, here is the solution.
How To: Use the if Function in Excel
Video: . IF function
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: 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: Use the Excel Vlookup function in Microsoft Excel 2007
Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel.