Archive for May, 2008

The Beauty Of Excel #1: Formulas & Functions

Also, see how to use Input areas; create formulas; use functions; use the TRANSPOSE function; Relative, Absolute and Mixed Cell References; TRUE FALSE Formula Conditional Formatting to highlight a Row; X Y Scatter diagrams; Add data to chart; Fixed Cost Variable Cost Sales Analysis.
See how to set up the input / assumption area for formulas […]

Microsoft Excel - Adding an in-cell dropdown menu

http://Excelopedia.com presents a tutorial explaining how to add a dropdown menu to an individual cell in a Microsoft Excel spreadsheet. Applies to Excel 2003 or earlier versions.

E1.3 MIN MAX and AVERAGE in an Excel Spreadsheet

Using Excel to calculate average values and to pick max and min values

Manual for Calc

This video is an introduction manual for Calc. Calc is an Open Office equivalent for the Excel spreadsheet program. In this introduction we make a simple cashbook. (The voice over is in Dutch!)

Excel demo

This is a video of an Excel Spreadsheet Demo

excel practice test

Practice Test for excel

Using Extensio Extender for Microsoft Excel

1. Adding “live” information cells in your Excel Spreadsheet
2. Refreshing your Excel spreadsheet with real time data from data stores
3. Updating back-end information stores from Excel

FDI Excel Spreadsheet Compensation Walkthru

Contact Paul Yang at TCNPaul@GMail.com
Go to NOW: www.FDIMax.net/Webinar
Financial Destination, Inc.
FDI Excel Spreadsheet Compensation Walkthru

The Beauty Of Excel #2: Formulas, Functions & Charts

Also, see how to use Input areas; create formulas; use functions; use the TRANSPOSE function; Relative, Absolute and Mixed Cell References; TRUE FALSE Formula Conditional Formatting to highlight a Row; X Y Scatter diagrams; Add data to chart; Fixed Cost Variable Cost Sales Analysis.
See how to set up the input / assumption area for formulas […]

Excel Spreadsheet help

Get the help you need today for less.