Browse Windows Platform by software tutorials

RSS

Comparing Excel’s Lookup and Reference Functions
There are quite a few lookup and reference functions in Microsoft Excel, several of which seem to do the exact same thing. When should you use which?

Published by Michele McDonough (78,942 pts ) on Nov 20, 2009 to
Windows Platform Articles
Automatic Calculation Options in Excel 2007
If you’re having trouble with Excel recalculating formulas too often (or not often enough), you can modify the calculation settings to fix this problem. These changes are especially helpful if the calculation process is taking too much time and slowing down productivity.

Published by Michele McDonough (78,942 pts ) on Nov 20, 2009 to
Windows Platform Articles
Using Excel’s TRANSPOSE Function to Turn Rows into Columns
In this Microsoft Excel tutorial, we’ll explain how the TRANSPOSE function can be used to transform rows of data into columns.

Published by Michele McDonough (78,942 pts ) on Nov 20, 2009 to
Windows Platform Articles
Use Excel’s CONCATENATE Function to Combine Cells
In this Microsoft Excel tutorial, we’ll cover how to use the CONCATENATE function to merge multiple cells and text strings into one cell.

Published by Michele McDonough (78,942 pts ) on Nov 20, 2009 to
Windows Platform Articles
VLOOKUP and HLOOKUP Functions in Microsoft Excel
The VLOOKUP and HLOOKUP functions in Microsoft Excel are powerful tools that can be used to query a lookup table, but many get confused when it comes to actually constructing formulas containing these functions. In this article, we'll explain how to do this and give concrete examples.

Published by Michele McDonough (78,942 pts ) on Nov 18, 2009 to
Windows Platform Articles

How to Create Outlook Rules
You might think that parents, schools, bosses and governments are the only ones who need to create rules. However, by creating rules in Outlook, you can have messages practically sort, forward, and respond to themselves.

Published by Tricia Goss (10,822 pts ) on Nov 18, 2009 to
Windows Platform Articles
Make Your Own Word Templates
You might know that a Word template can define things such as the default font style, size and color, headers and footers, margins, columns and more. But did you know that you can create a template that has the exact features you need?

Published by Tricia Goss (10,822 pts ) on Nov 18, 2009 to
Windows Platform Articles
How to Customize Outlook Notes
Outlook notes can help you stay organized and on task. While notes are a practical feature, you can have a little fun with them, too. This article will show you how to customize them to your liking.

Published by Tricia Goss (10,822 pts ) on Nov 18, 2009 to
Windows Platform Articles
How to Save an Excel Object as an Image
With Microsoft Excel you can create lists, databases, and eye-catching charts. You may not realize that you can save these and other Excel objects as images.You can then insert these images into your email messages, PowerPoint presentations, and Word documents.

Published by Tricia Goss (10,822 pts ) on Nov 18, 2009 to
Windows Platform Articles
Customizing the Error Value for a LOOKUP Function
Tired of seeing #N/A as an error message in Microsoft Excel when a LOOKUP function is unable to calculate a valid result? With the help of the IFERROR function, this error message can be customized and give a more meaningful message.

Published by Michele McDonough (78,942 pts ) on Nov 17, 2009 to
Windows Platform Articles