• Share

Discuss in my forum

## Calculate Weighted Average in Excel

Monday July 30, 2012
Calculate Weighted Average© Ted French The AVERAGE Function is handy to know and one that I, as a teacher, use frequently. However, when it comes to student marks, rather than ... Read More

## Excel Database Functions - DMAX Tutorial

Friday July 27, 2012
Excel has a specific group of functions - the database functions - that are designed specifically to work with an Excel database. For the most part, these functions are ... Read More

## Excel MAX IF Array Formula

Wednesday July 25, 2012
Excel MAX IF Array Formula© Ted French The MAX function will find the largest value in a given list of data. The IF function lets you set conditions so that you ... Read More

## Split the Screen using the Split Box in Excel

Monday July 23, 2012
Using the Split Box in Excel© Ted French To see more than one copy of a worksheet in Excel use the split box to divide the screen into ... Read More

## Nesting Function Tutorial

Saturday July 21, 2012
Excel Rolling Dice Tutorial© Ted French Nesting functions is a way to extend Excel's capabilities. Nesting means to place one or more functions inside each other. One of the most commonly nested ... Read More

## Animate an Excel Chart in a PowerPoint Presentation

Wednesday July 18, 2012
Animate Excel Charts in PowerPoint© Wendy Russell It"s common to add Excel charts to other Microsoft Office programs such as PowerPoint. Adding charts to your presentations is an easy and ... Read More

## Remove Extra Spaces From Data in Excel

Monday July 16, 2012
Remove Extra Spaces From Between Data © Ted French Sometimes, when you import data extra spaces show up between the words or numbers. Extra spaces between words can make it difficult ... Read More

## Sort Data by Font Color in Excel

Thursday July 12, 2012
In Excel, it is a common practice to format negative numbers to show up in a different color - usually red - in order to make them stand out ... Read More

Tuesday July 10, 2012
A hyperlink, the blue text in a web page that can be clicked on to jump to different documents, can also be used in Excel to provide quick and easy ... Read More

## Excel Stock Market Chart Tutorial

Friday July 6, 2012
Volume-High-Low-Close Chart © Ted French A Volume-High-Low-Close Stock Market chart is one of several stock market charts available in Excel. In general, stock market charts are used to show changes ... Read More

## Remove Duplicate Data Records in Excel

Wednesday July 4, 2012
Remove Duplicate Data Records in Excel© Ted French Spreadsheet programs such as Excel are often used to create database files for things like parts inventories, catalogs of books or DVD's, ... Read More

## Excel Macro Tutorial

Monday July 2, 2012
When you find yourself repeatedly performing the same actions or tasks in a spreadsheet, it might be time for you to create a macro. A macro is a recording of ... Read More