Must Read

Browse by microsoft excel

Microsoft Excel Six Sigma Histogram - Example and Description
When analyzing data in the Six Sigma quality process, a histogram can be used as a valuable tool. In the opening segment of this series, we'll discuss the usage of this type of chart and how to prepare the data that is to be represented in the histogram as well as give an example.

Published by Michele McDonough (79,057 pts ) on Nov 26, 2009 to
Project Management Articles
Microsoft Excel’s MATCH Function
In this Microsoft Excel tutorial, we’ll describe the MATCH function and how it can be used to determine the position of an item in a list or table.

Published by Michele McDonough (79,057 pts ) on Nov 23, 2009 to
Windows Platform Articles
Nested IF Functions in Excel 2007
With the 2007 version of Microsoft Excel, nested IF functions became a lot more powerful. We’ll explain more about this type of function and give a specific case when one can be used when assigning letter grades.

Published by Michele McDonough (79,057 pts ) on Nov 23, 2009 to
Windows Platform Articles
Using the IF Function in Excel 2007
If you’re still sorting through spreadsheet data manually, it’s time to learn how some of the functions in Excel can increase your productivity. In this article, we’ll take a look at the IF function and give an example of how it can be used.

Published by Michele McDonough (79,057 pts ) on Nov 23, 2009 to
Windows Platform Articles
Formatting a Histogram in Microsoft Excel 2007
After creating a histogram, or any other chart, in Microsoft Excel 2007, there are several ways you can modify it to make it even more visually attractive to your audience.

Published by Michele McDonough (79,057 pts ) on Nov 23, 2009 to
Windows Platform Articles

Importing Excel Data into Microsoft Word 2007
Sometimes, it’s a lot easier to create your initial tables and charts in Microsoft Excel, and then insert the results into your Microsoft Word document. We’ll walk through how to perform such a data import in this step-by-step guide.

Published by Michele McDonough (79,057 pts ) on Nov 23, 2009 to
Windows Platform Articles
Creating Fishbone Diagrams in Excel 2007
Fishbone diagrams are great tools when trying to analyze inefficiencies in workflow processes. In this tutorial, we’ll show how to create a fishbone diagram in Excel 2007 that can be adapted to almost any project.

Published by Michele McDonough (79,057 pts ) on Nov 23, 2009 to
Project Management Articles
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 (79,057 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 (79,057 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 (79,057 pts ) on Nov 20, 2009 to
Windows Platform Articles

showing 1-10 of 128 < Previous | page: 1 2 3 4 5 ... | Next >

Narrow by tag

Sorry, but there are no more tags available to filter with.

Related Channels