Browse Windows Platform by microsoft excel

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

Five of the Best Ever Microsoft Office Apps for Windows
Microsoft has brought us a succession of superb Microsoft Office releases since the mid 1990s, each with a standout version of some of the most famous names in office software.

Published by Christian Cawley (18,531 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
Generating Random Numbers in Excel
Need to generate a random number in Excel? There are two functions, RAND and RANDBETWEEN, capable of this task. Read on to find about how to use each one.

Published by Michele McDonough (78,942 pts ) on Nov 17, 2009 to
Windows Platform Articles
Microsoft Excel's LOOKUP Function
In this Microsoft Excel tutorial, we'll take a look at the construction of a basic LOOKUP function and how to use it to locate information in a table.

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