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 so that subsequent formulas, functions and charts update beautifully. See Efficient Excel Spreadsheet Construction Guidelines. Learn how to build Excel spreadsheets that are efficient. What is the beauty of Excel? Excel's Beauty is its ability to allow users to put formula input numbers in cells, refer to those cells in formulas using cell references so that everything updates automatically!
Channel: Science & Technology
Uploaded: March 19, 2008 at 7:45 pm
Author: ExcelIsFun
Length: 10:03
Rating: 4.76
Views: 2658
Tags: Cell College CommunityCommunity conditional Excel format Formula Function Gel Girvin Highline Mike Reference Scatter
Video Comments
|
