In this article, I discuss using Outlook's functionality from within an Excel application. With Automation, you can manipulate Outlook's objects using Visual Basic for Applications in Excel.
Added: 06/05/2005,
Hits: 383,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
Drop down lists are a great addition to a worksheet making data more efficient and also restricting what values can be entered into a cell.
Added: 07/03/2009,
Hits: 264,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
Excel includes many different functions that help you complete calculations, but have you ever wished for a function that that doesn’t exist in Excel? If you have, this tutorial will explain how to create a function DIY style.
Added: 07/10/2009,
Hits: 269,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
This tutorial explains how to troubleshoot a failed DDE connection to Microsoft Excel.
Added: 08/26/2009,
Hits: 229,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
This tutorial includes step-by-step exercises and several test to evaluate your acquired knowledge. Completely suitable for basic, medium and advanced level users. Try their video-tutorials, they will help you show you how to handle the theory with a clear-cut example.
Added: 03/27/2006,
Hits: 701,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
Important information on using array formulas in your Spreadsheets. Arrays can let you specify more then one criteria to Sum, Average, Count etc by. Many examples of how to...
Added: 09/21/2001,
Hits: 346,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
Excel 2007 offers the COUNTIFS function. Like the COUNTIF function it allows you to count the number of records that meet a specified criteria. The COUNTIFS function unlike COUNTIF allow you to specify more than one criteria on one or more fields.
Added: 06/11/2009,
Hits: 187,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
This tutorial explains how to troubleshoot corrupted Excel files when storing files outside the storage pool.
Added: 08/31/2009,
Hits: 369,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
A walk through for the PMT function in Excel which allows you to calculate repayments on a mortgage.
Added: 06/22/2009,
Hits: 373,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
SUMIFS is a function that first appears in Excel 2007. You may have previously used SUMIF to sum up values in a list based on criteria in another column. SUMIFS works the same way but allows you to use multiple criteria either in different columns or the same column.
Added: 07/03/2009,
Hits: 148,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
This is a basic tutorial of Excel. Specific examples may refer to Excel (but most items discussed should work in other spreadsheets).
Added: 05/19/2000,
Hits: 429,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
This course will teach you to filter an existing Microsoft Excel database and extract records meeting your criteria. It will cover Data Form Searches, AutoFiltering, Filtering to Match a Selection, and Advanced Filters. A Live Database is provided to practice with.
Added: 05/22/2002,
Hits: 179,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
For next looping works by using a counter variable. The counter states the number of times a specific piece of code should be repeated.
Added: 07/10/2009,
Hits: 189,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating