tag:blogger.com,1999:blog-41826359806413291042024-03-19T04:41:57.642-07:00excel mania 99excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-4182635980641329104.post-17636319699736935072011-04-25T05:48:00.000-07:002011-04-25T05:48:00.163-07:00Range Name Syntax<p><b>Name syntax rules:</b> <p>The <i>Name</i> string must begin with a text character, not a number, and consists of adjacent characters. <p>Two words can be joined with an underscore (_). For example, to enter the Name "Excel Book", you should type Excel_Book. <p>You cannot use a <i>Name</i> that could otherwise be used as a cell reference. For example, A1 or IS2002. <p><b>Notes:</b> <p>There is no limit on the number of <i>Names</i> you can define. <p>Be sure to define unique <i>Names</i> for a specific workbook. Defining <i>Names</i> that resemble <i>Names</i> in other sheets will only complicate your work. <p><a href="http://lh5.ggpht.com/_ABOR45YRVow/TbIumyi7CFI/AAAAAAAAAFE/XgaVg6deohs/F1GetTheMostOutOfExcelFormulasandFun%5B1%5D.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="205" alt="F1 - Get The Most Out Of Excel Formulas and Functions0033" src="http://lh4.ggpht.com/_ABOR45YRVow/TbIunu0Ts8I/AAAAAAAAAFI/M1Wuyn3n2eE/F1GetTheMostOutOfExcelFormulasandFun%5B2%5D.jpg" width="325" border="0"></a></p> excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-86199546175151101822011-04-25T05:47:00.001-07:002011-04-25T05:47:00.207-07:00Deleting a Range Name<p><b>Why it is highly recommended to delete unnecessary range Names: </b> <p>Large numbers of range <i>Names</i> makes it more difficult to locate a specific <i>Name</i>. <p>Range <i>Names</i><b> </b>create references and unwanted links. <p>To find unnecessary/unwanted range Names: <p>1. Select a cell in a new sheet. <p>2. Press <<b>F3</b>> and click <i>Paste List</i>. A full list of range names and their <p>references is pasted into the new sheet; delete each unwanted <i>Name</i>. <p>To delete a range Name: <p>Press <b><Ctrl+F3></b>, select the <i>Name</i>, and then click <b>Delete</b>.</p> excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-52303669686016558812011-04-25T05:47:00.000-07:002011-04-25T05:47:01.118-07:00Defining a Range Name<p>To define a range Name, use one of the following two techniques: <p><b>Type the text directly into the Name box </b> <ol> <li>Select cell A1. <li>In the <i>Name</i> box, type the text, and then press <<b>Enter</b>>.</li></ol> <p><b>Define a Name using the Define Name dialog box</b> <p>1. Select cell B1. <p>2. Press <<b>Ctrl+F3</b>>. <p>OR <p>From the <i>Insert</i> menu, select <i>Name</i> and then <i>Define</i>. <p>3. Type the text in the <i>Names in workbook</i> box, and then click <b>OK</b>.</p> excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-71131008920575203322011-04-24T05:42:00.000-07:002011-04-24T05:42:00.064-07:00Array Formulas<h3><strong>Understanding Arrays</strong></h3> <p>For those who do not have a background in programming or mathematics, the expression <i>Array</i> may not be familiar. <p>So what exactly is an <i>Array</i>? <p>For our purposes, an <i>Array</i> is simply a set of values which can be stored in a formula, a range of cells, or the computer’s memory. <p>The size of an <i>Array</i> can range from two to thousands of values. <h3><strong>Using Arrays in Formulas</strong></h3> <p>There are several different types of <i>Arrays</i> used by Excel when working with formulas: <p>An <i>Array</i> stored in a Worksheet in a range of cells: For example, when the <b>SUM</b> function sums the values stored in range of cells, it is treating those values as an <i>Array</i>. <p>An <i>Array</i> stored in a formula: <p>Instead of entering cell addresses to enable a formula to operate on the values stored in those locations, you may enter an <i>Array</i> of values into the <b>SUM</b> function arguments: =SUM(1,2,3,4,5). <p>OR <p>Enter an <i>Array</i> enclosed in brackets into the formula argument. For example, use the <b>MATCH</b> function to return the position of the number 10 in an <i>Array</i> of values: =MATCH(10,{3,7,10,15,20}). The result = 3 <p>Excel formulas create <i>Arrays</i> to store values: <p>Formulas such as <b>SUMPRODUCT</b> utilize computer memory to store values temporarily while calculating complicated math problems. <p>These values are stored in an <i>Array</i>. <p>Example: <p>To add the total sales amount of 3 items when the quantities sold are 10, 20, and 30 and the sale prices are $3, $4, and $5 respectively, the <p><b>SUMPRODUCT</b> formula stores each multiplication product in an <i>Array</i> (<i>Array</i> size is 3) and then adds the three values from the <i>Array</i>. <p>The <b>SUMPRODUCT</b> formula: =SUMPRODUCT(A1:A3,B1:B3), <p>Result - total sales=$260. <p>Let Excel create an <i>Array</i> <i>fo</i><i>rmula</i>: <p>As explained in the previous section, many formulas create <i>Arrays </i>when they need to store values during calculations. However, an Excel user may create a formula that deliberately enforces the program to open an <i>Array</i>/<i>Arrays</i> to store values. <p>Example: <p>Use the <b>SUM</b> function to return total sales (see previous example). <p>The formula will now look like this: {=SUM(A1:A3*B1:B3)}, Result total sales=$260. <p>To apply an <i>Array</i> <i>formula</i>: <p>Enter the formula, select the cell, press <<b>F2</b>>, and then simultaneously press <<b>Ctrl+Shift+Enter</b>>. excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com2tag:blogger.com,1999:blog-4182635980641329104.post-78026230431560419222011-04-24T05:38:00.000-07:002011-04-24T05:38:00.477-07:00Printing Formula Syntax<p>To print the formula syntax for a range of cells: <ol> <li>Display the formula syntax by pressing <<b>Ctrl+‘</b>> (the key to the left of the number 1). <li>Print the desired area.</li></ol> excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-62516781881354508882011-04-24T05:37:00.000-07:002011-04-24T05:37:00.470-07:00Adding a Comment to a Formula<p>To add a Comment to a formula: <ol> <li>At the end of the formula, add a + (plus) sign. <li>Type the letter N, and, in parentheses, type your Comment in quotation marks.</li></ol> <p>Example: <p>=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio") <p><a href="http://lh6.ggpht.com/_ABOR45YRVow/TbIv3W-y3lI/AAAAAAAAAFM/Fm67IN3HImY/F1GetTheMostOutOfExcelFormulasandFun%5B1%5D.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="135" alt="F1 - Get The Most Out Of Excel Formulas and Functions0032" src="http://lh3.ggpht.com/_ABOR45YRVow/TbIv4jU2GEI/AAAAAAAAAFQ/pBF-BarQchU/F1GetTheMostOutOfExcelFormulasandFun.jpg" width="381" border="0"></a></p> excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-81078909566038172132011-04-24T05:35:00.000-07:002011-04-24T05:35:00.274-07:00Pasting Values<p>To paste the calculated value of a single formula into a cell (thus overwriting the formula): <p>Press <<b>F2</b>> to edit and then <<b>F9</b>> to calculate. <p>To paste the calculated value of a single formula into the cell below the cell containing the formula: <p>Press <<b>Ctrl+Shift+"</b>>. <p>To paste values in a range of cells, use the Paste Special dialog box: <ol> <li>Copy a range of cells containing formulas, press <<b>Shift+F10</b>> or right-click, and then select <i>Paste Special</i> from the shortcut menu. <li>Select <i>Values</i> and click <b>OK</b>.</li></ol> <p><strong>Use the Paste Values Icon</strong>: <p>Add the<b> </b><i>Paste Values</i> icon from the <i>Edit</i> category in <p>the <i>Customize</i> dialog box. <p><a href="http://lh5.ggpht.com/_ABOR45YRVow/TbIv-edp7mI/AAAAAAAAAFU/m8V--k5KsNE/F1GetTheMostOutOfExcelFormulasandFun%5B1%5D.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="80" alt="F1 - Get The Most Out Of Excel Formulas and Functions0031" src="http://lh5.ggpht.com/_ABOR45YRVow/TbIv_TwB3OI/AAAAAAAAAFY/BfnTnd7n8Tw/F1GetTheMostOutOfExcelFormulasandFun%5B5%5D.jpg" width="157" border="0"></a> <p>New in Excel 2002 and Excel 2003 <p>The <i>Paste</i> icon has been expanded, enabling some options from the <i>Paste </i><i>Special</i> dialog box to be quickly accessed. <p><a href="http://lh6.ggpht.com/_ABOR45YRVow/TbIwAlhRqII/AAAAAAAAAFc/hzKbqn0gth4/F1GetTheMostOutOfExcelFormulasandFun.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="178" alt="F1 - Get The Most Out Of Excel Formulas and Functions0030" src="http://lh3.ggpht.com/_ABOR45YRVow/TbIwB6dt-BI/AAAAAAAAAFg/mOv4untTwpE/F1GetTheMostOutOfExcelFormulasandFun%5B4%5D.jpg" width="182" border="0"></a></p> excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-5604615044685096762011-04-23T05:32:00.000-07:002011-04-23T05:32:00.130-07:00Selecting Cells That Contain FormulasTo select cells containing Formulas in order to color, delete, or protect, use the Go To dialog box: <br />
1. Press <<b>F5</b>>. <br />
OR<a href="http://lh4.ggpht.com/_ABOR45YRVow/TbIx81x23NI/AAAAAAAAAFk/GYgMDOhLcx8/F1GetTheMostOutOfExcelFormulasandFun.jpg"><img alt="F1 - Get The Most Out Of Excel Formulas and Functions0028" border="0" height="244" src="http://lh5.ggpht.com/_ABOR45YRVow/TbIx-P76L3I/AAAAAAAAAFo/Yrv-gbHSwHY/F1GetTheMostOutOfExcelFormulasandFun%5B1%5D.jpg" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; margin: 0px;" width="183" /></a> <br />
From the <i>Edit</i> menu, select <i>Go</i> <i>To</i>. <br />
2. In the <i>Go To</i> dialog box, click <i>Special</i>. <br />
3. Select <i>Formulas</i>, and then click <b>OK</b>.excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-85230898379372876512011-04-22T18:35:00.001-07:002011-04-22T18:35:46.010-07:00Using a Range Name in a Formula<p>To use a range Name in a formula: <ol> <li>Define the following range <i>Names</i> for ranges B2:B11, C2:C11, and D2:D11 respectively: Jan_2004, Feb_2004, and Mar_2004 (see the screenshot below). <li>Select a cell and type the formula =SUM. <li>Press <<b>Ctrl+A</b>>. <li>Select the first argument box and press <<b>F3</b>>. <li>Select the <i>Name</i> Jan_2004, and then click <b>OK</b>. <li>Paste the <i>Names</i> Febr_2004 and Mar_2004 in the next two argument boxes, and then click <b>OK</b>. The following formula has now been inserted into the cell:</li></ol> <p>=SUM(Jan_2004, Feb_2004, Mar_2004) <p><a href="http://lh5.ggpht.com/_ABOR45YRVow/TbIs6yO3OkI/AAAAAAAAAE0/722IIQObd3Q/F1GetTheMostOutOfExcelFormulasandFun%5B1%5D.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="209" alt="F1 - Get The Most Out Of Excel Formulas and Functions0034" src="http://lh5.ggpht.com/_ABOR45YRVow/TbIs8BYi-oI/AAAAAAAAAE4/DisrDz8QL-c/F1GetTheMostOutOfExcelFormulasandFun%5B2%5D.jpg" width="351" border="0"></a></p> excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-25653661418062057172011-04-21T05:27:00.000-07:002011-04-22T18:57:44.293-07:00Displaying Both Formulas and Values for Cells<p>To display both formulas and values for cells: <ol> <li>From the <i>Window</i> menu, select <i>New Window</i>. <li>From the <i>Window</i> menu, select <i>Arrange</i>. <li>Select the <i>Horizontal</i> option button and click <b>OK</b>. <li>Select one of the two windows and press <<b>Ctrl+‘</b>> (the key to the left of the number 1).</li></ol> <p>To move between windows, press <<b>Ctrl+Tab</b>> or <<b>Ctrl+F6</b>>. <p><a href="http://lh6.ggpht.com/_ABOR45YRVow/TbIyEQGKFqI/AAAAAAAAAFs/KRH2NB9qN1I/F1GetTheMostOutOfExcelFormulasandFun.jpg"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="288" alt="F1 - Get The Most Out Of Excel Formulas and Functions0029" src="http://lh4.ggpht.com/_ABOR45YRVow/TbIyFvSP_uI/AAAAAAAAAFw/6ZYaNw26xjY/F1GetTheMostOutOfExcelFormulasandFun%5B2%5D.jpg" width="425" border="0"></a></p> excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-84203742708093178052011-04-20T05:27:00.000-07:002011-04-22T18:58:06.147-07:00Displaying Formula Syntax<p>To display the syntax of all formulas in a sheet: <p>Press <<b>Ctrl+‘</b>> (the ‘ symbol is located to the left of the number 1 on the keyboard). </p> <p>OR </p> <p>From the <i>Tools</i> menu, select <i>Options</i>, the <i>View</i> tab, <i>Formulas</i>, and then click <b>OK</b>. </p> <p>To return to the normal display, press <<b>Ctrl+‘</b>> again (this keyboard shortcut is a toggle).</p> <p><strong>Regular Display :</strong></p> <p><a href="http://excel-mania99.blogspot.com"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="210" alt="F1 - Get The Most Out Of Excel Formulas and Functions0026" src="http://lh4.ggpht.com/_ABOR45YRVow/TbIyJrZ_tUI/AAAAAAAAAF0/ACHgw39Pxe8/F1GetTheMostOutOfExcelFormulasandFun%5B3%5D.jpg" width="422" border="0"></a> </p> <p><strong>Displaying Formulas :</strong></p> <p><a href="http://excel-mania99.blogspot.com"><img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="155" alt="F1 - Get The Most Out Of Excel Formulas and Functions0027" src="http://lh4.ggpht.com/_ABOR45YRVow/TbIyK1D2qFI/AAAAAAAAAF4/aagBZxbRa3Q/F1GetTheMostOutOfExcelFormulasandFun%5B1%5D.jpg" width="426" border="0"></a> </p> <div class="wlWriterSmartContent" id="scid:0767317B-992E-4b12-91E0-4F059A8CECA8:00e0b859-17e7-4bf0-8746-47a8f511a933" style="padding-right: 0px; display: inline; padding-left: 0px; float: none; padding-bottom: 0px; margin: 0px; padding-top: 0px">Technorati Tags: <a href="http://technorati.com/tags/Working%20With%20Formulas" rel="tag">Working With Formulas</a></div> excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-14429194921206905342011-04-05T03:17:00.000-07:002011-04-05T03:17:59.702-07:00Working With Formulas<b>This chapter contains fundamentals, shortcuts, tips, and techniques that are essential when working with Formulas & Functions. It includes the following sections: </b><br />
<ul><li><a href="http://excel-mania99.blogspot.com/2011/04/insertingediting-formulas.html">Inserting</a>, <a href="http://excel-mania99.blogspot.com/2011/04/nesting-formulas.html">Editing</a>, & <a href="http://excel-mania99.blogspot.com/2011/04/copying-formula-from-cell-while-keeping.html">Copying Formulas</a> : This section covers easy techniques on inserting, editing, and copying formulas, understanding the correct use of relative/absolute references, and creating power formulas.</li>
<li>Selecting, Displaying, Printing & Pasting Formulas: In this section you will find techniques on displaying formula syntax, displaying formulas and values, selecting cells containing formulas, pasting values, adding comments to formulas, and printing formula syntax. Array Formulas, page 12: This section provides an explanation of the concept of an Array and how Excel uses Arrays in formulas, You will also learn how to create an Array formula. Using Range Names in Formulas, page 13: In this section, learn about range name rules, how to define range names, and how to use range Names in formulas.</li>
<li>Auditing Formulas: In this section, find essential shortcuts and techniques on tracing and moving between precedent and dependent cells, stepping into formulas, and tracing errors in a formula.</li>
<li>Protecting Formulas: In this section, you will learn how to protect formulas in both protected and unprotected sheets. </li>
</ul>excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-30291788438663214072011-04-05T03:09:00.000-07:002011-04-05T03:09:15.411-07:00Copying Formulas from a Range of Cells without Changing the Absolute or Relative References<b>To copy/paste Formulas from a range of cells without changing the Absolute or Relative references: </b><br />
1. Select the range of cells containing the formulas and press <b><Ctrl+H></b>. <br />
2. In the Find what box, type the = sign. <br />
3. In the Replace with box, type the # symbol (to change the formulas to <br />
text). <br />
4. Click Replace All, and then click Close. <br />
5. Copy and paste the cells to a new location. <br />
6. Repeat steps 1 through 3, reversing the # and = signs (to change the <br />
text to formulas).<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEir5Fb5kdvkh4cHRVie1Zc4UMWJkmcCb_zWYZKHfuz8Ui2epYa750XAlhqn2a14KxWXkpYJ5s3vs_bESsafggY1Po_WpkiqTe8VOC27nKHPyLObn3dMOFzqGnFp_-iOy-54RkqFsuenNf2z/s1600/F1+-+Get+The+Most+Out+Of+Excel+Formulas+and+Functions0025.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="173" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEir5Fb5kdvkh4cHRVie1Zc4UMWJkmcCb_zWYZKHfuz8Ui2epYa750XAlhqn2a14KxWXkpYJ5s3vs_bESsafggY1Po_WpkiqTe8VOC27nKHPyLObn3dMOFzqGnFp_-iOy-54RkqFsuenNf2z/s400/F1+-+Get+The+Most+Out+Of+Excel+Formulas+and+Functions0025.jpg" width="400" /></a></div>excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-40394870219532286262011-04-05T03:06:00.000-07:002011-04-05T03:06:40.947-07:00Copying a Formula from a Cell While Keeping the Absolute Reference or Relative ReferenceAvoid the nightmare of pressing <b><F4></b> multiple times when coping and pasting formulas. <br />
<b>To copy/paste a Formula without changing the Absolute or Relative references:</b><br />
<br />
<b>Option 1:</b> Select a cell under the cell containing a formula and press <b><Ctrl+ ’></b>. <br />
<b>Option 2:</b> Copy and paste the formula from the Formula Bar to a cell, instead of from a cell to another cell. <br />
Example, cell C12 contains a formula: <br />
1. Select the formula string in the Formula Bar and press <b><Ctrl+C></b> to copy it. <br />
2. Leave the Formula Bar by clicking the <b>Enter</b> or <b>Cancel icons</b> to the left of the fx on the Formula Bar. <br />
3. Select another cell and press <b><Ctrl+V></b>.<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://www.blogger.com/goog_474723823" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="210" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggo-J6OG4MyQJeA6Sep1xoNpKNgJejzzipa_6uszj_iWXkl11ejwPeAG1LztwLeOhjWMjcdEQ-JSRhYsZBaOzZc1GoBxOA34r5PMhfkLaKHxn_jPd8tidAlIG5kLZuH-AdDEyco3tVLxAL/s400/F1+-+Get+The+Most+Out+Of+Excel+Formulas+and+Functions0024.jpg" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"> </td></tr>
</tbody></table>excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-89713247784564150762011-04-05T03:02:00.000-07:002011-04-05T03:10:53.735-07:00Nesting FormulasA formula can be copied and pasted into the appropriate place within another formula in the Formula Bar by using the <Ctrl+C> and <Ctrl+V> keyboard shortcuts.<br />
<br />
To combine Formulas into one long nested power Formula: <br />
1. Insert the following formula into a cell: <br />
=SUMIF(TB_DB_Level3,A12,G12) <br />
2. Insert the following formula into an adjacent cell: <br />
=OFFSET(TB_DB_Level3,0,MonthSelectionNumber+2) <br />
3. In the Formula Bar of the second formula, select the formula without the = sign, and then press <Ctrl+C>. <br />
4. Click Cancel or Enter (the two buttons between the Name Box and the formula in the Formula Bar) to exit edit mode. <br />
5. Select the cell containing the first formula, and in the Formula Bar, select the reference G12, and then press <Ctrl+V><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkUyGjO30beEwoXoWyWiGniDA3sv3rt-cM6nBeUnixQvxdT-JIdsgy1niR4AL65zZ55KadavsDBoEer3jKnUVGb4PeBIW9yKhG96RN5-DsVbtLQv2tYPV8-rKCVr5KUGWYAKU2VdP1qQVQ/s1600/F1+-+Get+The+Most+Out+Of+Excel+Formulas+and+Functions0023.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="202" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkUyGjO30beEwoXoWyWiGniDA3sv3rt-cM6nBeUnixQvxdT-JIdsgy1niR4AL65zZ55KadavsDBoEer3jKnUVGb4PeBIW9yKhG96RN5-DsVbtLQv2tYPV8-rKCVr5KUGWYAKU2VdP1qQVQ/s400/F1+-+Get+The+Most+Out+Of+Excel+Formulas+and+Functions0023.jpg" width="400" /></a></div>excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-75700320855547506112011-04-05T02:58:00.000-07:002011-04-05T03:11:13.337-07:00Inserting/Editing FormulasInserting/Editing Formulas<br />
<ul><li>To open the Insert Function dialog box:</li>
</ul>Select an empty cell and press <Shift+F3>.<br />
<br />
<ul><li>To open a Function Arguments dialog box: </li>
</ul>Select a cell containing a formula and press <Shift+F3>.<br />
<br />
<ul><li>To insert a new Formula into a cell using the Function </li>
</ul>Arguments dialog box: <br />
1. Select an empty cell, and then type the = sign. <br />
2. Type the formula name and press <Ctrl+A>. <br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJR2q5Ct8QUsWPUwrDiZpagOZPSaO3qqtbzJllB3jDLmphBG9Rxzc8TAiIAO0tuwEB5LOYA0H0L9Q0D9dtE2OJXkgPRt2GlkxjpHp7YIx0SfsmKWVRn6Av74Q-uhJ7yihFdLkHN9g_S8Tq/s1600/F1+-+Get+The+Most+Out+Of+Excel+Formulas+and+Functions0021.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="235" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJR2q5Ct8QUsWPUwrDiZpagOZPSaO3qqtbzJllB3jDLmphBG9Rxzc8TAiIAO0tuwEB5LOYA0H0L9Q0D9dtE2OJXkgPRt2GlkxjpHp7YIx0SfsmKWVRn6Av74Q-uhJ7yihFdLkHN9g_S8Tq/s400/F1+-+Get+The+Most+Out+Of+Excel+Formulas+and+Functions0021.jpg" width="400" /></a></div><br />
To insert a formula by typing it while being guided by the <br />
formula syntax tooltip: <br />
1. Select an empty cell, and then type the = sign followed by the <br />
formula name and a left parenthesis, i.e. (. <br />
2. Press <Ctrl+Shift+A> (in Excel version 2003 the syntax appears <br />
immediately after step 1 above). <br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5-TNUtVIWsHB751RS5-ofn-SagLYy5f_qBFY-c1aRevAr6q5zXmP67PyDsDmk_GefEMKY5qYoZJJgE8lyQe6Ho8GX4MgAV3bsNVSdXSSWcxS1XUVk2eX4ebHG404G_QdRRJZQp_hiPlux/s1600/F1+-+Get+The+Most+Out+Of+Excel+Formulas+and+Functions0022.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="85" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5-TNUtVIWsHB751RS5-ofn-SagLYy5f_qBFY-c1aRevAr6q5zXmP67PyDsDmk_GefEMKY5qYoZJJgE8lyQe6Ho8GX4MgAV3bsNVSdXSSWcxS1XUVk2eX4ebHG404G_QdRRJZQp_hiPlux/s400/F1+-+Get+The+Most+Out+Of+Excel+Formulas+and+Functions0022.jpg" width="400" /></a></div>excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-56439248600814161362011-04-04T07:58:00.000-07:002011-04-04T07:58:10.416-07:00Adventure Games<span style="font-size: large;">Age of Castles</span> <br />
Battle over 60 enemies throughout the town in this fun strategy game! Goblins, Orcs and the dreaded dragons are all out to destroy your castle!<br />
This is Adventure Games<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGERDVeJEK43gD2o90rI5IaucGvy62Y8JQ_kyG7XmdVk0aeGuOPEnS4tYKruVw8ItKYsZmKEn0TbR0MQkYWI-QjTxhaWwxOQw-io173Er1BJ9Ii9Q_7F6gBz0hlakh_Mf3HOtmLdW-zVEm/s1600/Age+of+Castles.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGERDVeJEK43gD2o90rI5IaucGvy62Y8JQ_kyG7XmdVk0aeGuOPEnS4tYKruVw8ItKYsZmKEn0TbR0MQkYWI-QjTxhaWwxOQw-io173Er1BJ9Ii9Q_7F6gBz0hlakh_Mf3HOtmLdW-zVEm/s1600/Age+of+Castles.jpg" /></a></div><br />
download click <a href="http://www.arcadetown.com/downloads/AgeOfCastles_at.exe">here</a><br />
and <a href="http://www.ziddu.com/download/14464421/AgeofCastles.txt.html">key</a>excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-76161839300552147662011-04-04T06:42:00.000-07:002011-04-04T07:36:35.473-07:00Hidden Object Games<span style="font-size: large;">Abra Academy 2</span> <br />
In Abra Academy 2 the school of magic is under attack - unknown creatures have broken into the campus and are causing havoc! The children are frightened and the monsters are creating a huge mess.<br />
Wanda and her friends have been called in to investigate the attacks and find a way to stop them. Download <i>Abra Academy 2</i> now and help Wanda in her quest!<br />
this is Hidden Object Games<br />
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFKQubpXmc6zfMdIX-nTHvh1ir8sQAqEihPFD4hyphenhyphenfcrusZ0haCDCI5FF-TJz4otJJL-Q_yk-yCRyCUju6FLbFC3O9YaXMHNQhjxIe4EiaF-6NYl_HjpPovwK5g_utjNcFqJ_OYTT1ifF-n/s1600/g1.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFKQubpXmc6zfMdIX-nTHvh1ir8sQAqEihPFD4hyphenhyphenfcrusZ0haCDCI5FF-TJz4otJJL-Q_yk-yCRyCUju6FLbFC3O9YaXMHNQhjxIe4EiaF-6NYl_HjpPovwK5g_utjNcFqJ_OYTT1ifF-n/s1600/g1.jpg" /></a><br />
<br />
Download click <a href="http://d1.arcadetown.com/downloads/abraacademy2_at.exe">here</a><br />
<br />
and <a href="http://www.ziddu.com/downloadlink/14463643/AbraAcademy2.txt">key</a> <br />
<br />
<br />
<br />
<br />
<span style="font-size: large;">Agatha Christie-Death On The Nile</span><br />
A great hidden object adventure brings a whole new way of enjoying the timeless Agatha Christie story Death on the Nile to life. Assume the role of renowned detective Hercule Poirot seeking clues to a mysterious murder aboard a ship cruising the River Nile. <br />
Find needed objects, question suspects and uncover the truth behind the <i>Death on the Nile</i>!<br />
this is Hidden Object Games<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQPvx7Bd_3Ywc6aAGL4BP5vUVwbXJC1E7wVGfN8tRZbkCuqlJEa2vJFVR3NQWcWsshkOzHJEOmrdJxrEdV0BynEcy_dakQx1tosKGjvjmkcSojKf9JnKXHwg8QElRhYstva1VbFxObSmtA/s1600/Agatha+Christie-Death+On+The+Nile.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQPvx7Bd_3Ywc6aAGL4BP5vUVwbXJC1E7wVGfN8tRZbkCuqlJEa2vJFVR3NQWcWsshkOzHJEOmrdJxrEdV0BynEcy_dakQx1tosKGjvjmkcSojKf9JnKXHwg8QElRhYstva1VbFxObSmtA/s1600/Agatha+Christie-Death+On+The+Nile.jpg" /></a></div><br />
Download click <a href="http://dl.arcadetown.com/downloads/deathonthenile_at.exe">here</a><br />
<br />
and <a href="http://www.ziddu.com/downloadlink/14463764/AgathaChristie-DeathOnTheNile.txt">Key</a><br />
<br />
<br />
<br />
<br />
<br />
<span style="font-size: large;">Agatha Christie-Peril at End House</span><br />
<br />
Calling all seek and find fiends - The biggest selling novelist in history is back with Peril at End House - a spine-tingling challenge for Hercule Poirot and his faithful companion Hastings. <br />
Set on the beautiful Cornish coast, there has always been an air of <i>Peril at End House</i> and with three attempts on our heroine Nick Buckley`s life in as many days, it is up to the famous Poirot to unravel the mystery before it's too late.<br />
this is Hidden Object Games<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjj5s2Z91CfffB0jKyZDIIuY3bs5bNnuOdGgkr6rc5fQeqMKI5e6h-3Qdr9U_g-pF_BGc8Yf0NBoOrssndNQzE0_MBKfhyphenhyphenBBVHkkmpGrBHNcHLfNeKtMKcefb4NfMb9jqALjAUqJQLkovoW/s1600/Agatha+Christie-Peril+at+End+House.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjj5s2Z91CfffB0jKyZDIIuY3bs5bNnuOdGgkr6rc5fQeqMKI5e6h-3Qdr9U_g-pF_BGc8Yf0NBoOrssndNQzE0_MBKfhyphenhyphenBBVHkkmpGrBHNcHLfNeKtMKcefb4NfMb9jqALjAUqJQLkovoW/s1600/Agatha+Christie-Peril+at+End+House.jpg" /></a></div><br />
Download click <a href="http://dl.arcadetown.com/downloads/perilatendhouse_at.exe">here</a><span style="font-size: large;"> </span><br />
<span style="font-size: large;"><span style="font-size: small;">and <a href="http://www.ziddu.com/downloadlink/14463857/AgathaChristie-PerilatEndHouse.txt">Key</a></span></span>excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-664806607717896402011-04-01T09:44:00.000-07:002011-04-01T09:44:13.375-07:00What's New in Excel 2007<div class="first-para"><a href="" name="67"></a>Here's a quick and dirty overview of the new features in Excel 2007:</div><ul class="itemizedlist"><li class="first-listitem"> <div class="first-para">A new tab/Ribbon user interface</div></li>
<li class="listitem"> <div class="first-para">New XML file formats</div></li>
<li class="listitem"> <div class="first-para">Worksheet tables</div></li>
<li class="listitem"> <div class="first-para">Significantly larger worksheet grid (1,048,576 rows x 16,384 columns)</div></li>
<li class="listitem"> <div class="first-para">Ability to use more memory</div></li>
<li class="listitem"> <div class="first-para">Unlimited conditional formats per cell</div></li>
<li class="listitem"> <div class="first-para">100 levels of undo</div></li>
<li class="listitem"> <div class="first-para">Maximum formula length increased to 8,000 characters</div></li>
<li class="listitem"> <div class="first-para">Support for 64 levels of nesting in a formula</div></li>
<li class="listitem"> <div class="first-para">Formula autocomplete</div></li>
<li class="listitem"> <div class="first-para">Better-looking charts</div></li>
<li class="listitem"> <div class="first-para">Workbook themes</div></li>
<li class="listitem"> <div class="first-para">Skins</div></li>
<li class="listitem"> <div class="first-para">Page Layout view</div></li>
<li class="listitem"> <div class="first-para">New conditional formatting options</div></li>
<li class="listitem"> <div class="first-para">Less confusing Excel Options dialog box</div></li>
<li class="listitem"> <div class="first-para">New collaboration features (requires SharePoint)</div></li>
<li class="listitem"> <div class="first-para">SmartArt and Improved WordArt</div></li>
<li class="listitem"> <div class="first-para">Compatibility checker</div></li>
<li class="listitem"> <div class="first-para">Easier pivot tables</div></li>
<li class="listitem"> <div class="first-para">Twelve new worksheet functions, plus integration of the Analysis ToolPak functions</div></li>
<li class="listitem"> <div class="first-para">PDF output (via a downloadable add-in)</div></li>
<li class="listitem"> <div class="first-para">Resizable formula bar</div></li>
<li class="listitem"> <div class="first-para">Many new templates</div></li>
<li class="listitem"> <div class="first-para">More control over the status bar</div></li>
</ul>excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-53766488775337961622011-04-01T08:00:00.003-07:002011-04-01T08:23:05.858-07:00The Workings of Workbooks<h2 class="first-section-title"><a href="http://www.blogger.com/post-edit.g?blogID=4182635980641329104&postID=5376648877533796162" name="59"></a><span style="font-size: small;"><span style="font-weight: normal;">The core document of Excel is a workbook. Everything that you do in Excel takes place in a workbook.</span></span></h2><div class="para">Beginning with Excel 2007, workbook "files" are actually compressed folders. You may be familiar with compressed folders if you've ever opened a file with a <tt>.zip</tt> extension. Inside the compressed folders are a number of files that hold all the information about your workbook, including charts, macros, formatting, and the data in its cells.</div><div class="para">An Excel workbook can hold any number of sheets (limited only by memory). The four types of sheets are</div><ul class="itemizedlist"><li class="first-listitem"> <div class="first-para">Worksheets</div></li>
<li class="listitem"> <div class="first-para">Chart sheets<a href="http://www.blogger.com/post-edit.g?blogID=4182635980641329104&postID=5376648877533796162" name="60"></a> </div></li>
<li class="listitem"> <div class="first-para">MS Excel 4.0 macro sheets (obsolete, but still supported)</div></li>
<li class="listitem"> <div class="first-para">MS Excel 5.0 dialog sheets (obsolete, but still supported)</div></li>
</ul><div class="para">You can open or create as many workbooks as you want (each in its own window), but only one workbook is the active workbook at any given time. Similarly, only one sheet in a workbook is the active sheet. To activate a different sheet, click its corresponding tab at the bottom of the window, or press Ctrl+PgUp (for the previous sheet) or Ctrl+PgDn (for the next sheet). To change a sheet's name, double-click its Sheet tab and enter the new text for the name. Right-clicking a tab brings up a shortcut menu with some additional sheet-manipulation options.</div><div class="para">You can also hide the window that contains a workbook by using the View --->Window --->Hide command. A hidden workbook window remains open but not visible. Use the View --->Window ---> Unhide command to make the window visible again. A single workbook can display in multiple windows (choose View --->Window---> New Window). Each window can display a different sheet or a different area of the same sheet.<br />
<br />
<div style="text-align: center;"><span style="font-size: large;">Worksheets</span></div></div><div class="section"><div class="first-para">The most common type of sheet is a worksheet-which you normally think of when you think of a spreadsheet. Every Excel 2007 worksheet has 16,384 columns and 1,048,576 rows. After years of requests from users, Microsoft finally increased the number of rows and columns in a worksheet.</div><div class="sidebar"><br />
<div style="text-align: center;"><span style="font-size: large;">How Big Is a Worksheet?</span></div><table border="0" cellpadding="0" cellspacing="0" class="BlueLine"><tbody>
<tr> </tr>
</tbody></table><br />
<div class="first-para">It's interesting to stop and think about the actual size of a worksheet. Do the arithmetic (16,384 × 1,048,576), and you'll see that a worksheet has 17,179,869,184 cells. Remember that this is in just one worksheet. A single workbook can hold more than one worksheet.</div><div class="para">If you're using a 1024 × 768 video mode with the default row heights and column widths, you can see 15 columns and 25 rows (or 375 cells) at a time-which is about .000002 percent of the entire worksheet. In other words, more than 45 million screens of information reside within a single worksheet.</div><div class="last-para">If you entered a single digit into each cell at the relatively rapid clip of one cell per second, it would take you over 500 years, nonstop, to fill up a worksheet. To print the results of your efforts would require more than 36 million sheets of paper-a stack about 12,000 feet high (that's ten Empire State Buildings stacked on top of each other).</div><table border="0" cellpadding="0" cellspacing="0" class="BlueLine"><tbody>
<tr> <td bgcolor="#000080" class="bluecell"><br />
</td></tr>
</tbody></table></div><table border="0" cellpadding="0" cellspacing="0" class="BlankSpace"><tbody>
<tr> <td height="16"><table border="0" cellpadding="0" cellspacing="0" class="note"><tbody>
<tr><td class="admon-title" valign="top">Note :<br />
<i>Versions prior to Excel 2007 support only 256 columns and 65,536 rows. If you open such a file, Excel 2007 enters compatibility mode to work with the smaller worksheet grid. In order to work with the larger grid, you must save the file in one of the Excel 2007 formats. Then close the workbook and reopen it.</i></td></tr>
</tbody></table></td></tr>
</tbody></table><table border="0" cellpadding="0" cellspacing="0" class="note"><tbody>
<tr> <td class="admon-check" valign="top"><br />
</td> <td class="admon-title" valign="top"><br />
</td> <td class="admon-body" valign="top"><br />
</td></tr>
</tbody></table><div class="para">Having access to more cells isn't the <i class="emphasis">real</i> value of using multiple worksheets in a workbook. Rather, multiple worksheets are valuable because they enable you to organize your work better. Back in the old days, when a spreadsheet file consisted of a single worksheet, developers wasted a lot of time trying to organize the worksheet to hold their information efficiently. Now, you can store information on any number of worksheets and still access it instantly.</div><div class="para">You have complete control over the column widths and row heights, and you can even hide rows and columns (as well as entire worksheets). You can display the contents of a cell vertically (or at an angle) and even wrap around to occupy multiple lines.<br />
Note :<br />
<i>By default, every new workbook starts out with three worksheets. You can easily add a new sheet when necessary, so you really don't need to start with three sheets. You may want to change this default to a single sheet. To change this option, use the Office --->Excel Options command, click the Popular tab, and change the setting for the option labeled Include This Many Sheets.</i></div><table border="0" cellpadding="0" cellspacing="0" class="note"><tbody>
<tr> <td class="admon-check" valign="top"><br />
</td> <td class="admon-title" valign="top"></td><td class="admon-body" valign="top"><br />
</td></tr>
</tbody></table></div><div class="section"><h3 class="sect3-title">Chart Sheets</h3><div class="first-para">A chart sheet holds a single chart. Many users ignore chart sheets, preferring to use embedded charts, which are stored on the worksheet's drawing layer. Using chart sheets is optional, but they make it a bit easier to locate a particular chart, and they prove especially useful for presentations. I discuss embedded charts (or floating charts on a worksheet) later in this chapter.</div></div><div class="section"><h3 class="sect3-title"><a href="http://www.blogger.com/post-edit.g?blogID=4182635980641329104&postID=5376648877533796162" name="65"></a><a href="http://www.blogger.com/post-edit.g?blogID=4182635980641329104&postID=5376648877533796162" name="ch01le"></a>Macro Sheets and Dialog Sheets</h3><div class="first-para">An Excel 4.0 macro sheet is a worksheet that has some different defaults. Its purpose is to hold XLM macros. XLM is the macro system used in Excel version 4.0 and previous versions. This macro system was replaced by VBA in Excel 5.0 and is not discussed in this book.</div><div class="para">An Excel 5.0 dialog sheet is a drawing grid that can hold text and controls. In Excel 5.0 and Excel 95, they were used to make custom dialog boxes. UserForms were introduced in Excel 97 to replace these sheets.</div></div>excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-24155101692164270892011-04-01T05:11:00.000-07:002011-04-01T05:21:20.852-07:00The Object Model Concept<div class="first-para"><a href="http://www.blogger.com/post-edit.g?blogID=4182635980641329104&postID=2415510169216427089" name="58"></a>If you've dealt with computers for any length of time, you've undoubtedly heard the term object-oriented programming. An object essentially represents a software element that a programmer can manipulate. When using Excel, you may find it useful to think in terms of objects, even if you have no intention of becoming a programmer. An object-oriented approach can often help you keep the various elements in perspective.</div><div class="PARA">Excel objects include the following:</div><ul class="itemizedlist"><li class="FIRST-LISTITEM"> <div class="first-para">Excel itself</div></li>
<li class="listitem"> <div class="FIRST-PARA">An Excel workbook</div></li>
<li class="LISTITEM"> <div class="FIRST-PARA">A worksheet in a workbook</div></li>
<li class="listitem"> <div class="first-para">A range in a worksheet</div></li>
<li class="LISTITEM"> <div class="FIRST-PARA">A button on a worksheet</div></li>
<li class="listitem"> <div class="first-para">A ListBox control on a UserForm (a custom dialog box)</div></li>
<li class="LISTITEM"> <div class="FIRST-PARA">A chart sheet</div></li>
<li class="LISTITEM"> <div class="first-para">A chart on a chart sheet</div></li>
<li class="listitem"> <div class="FIRST-PARA">A chart series in a chart</div></li>
</ul><div class="last-para">Notice the existence of an <i class="EMPHASIS">object hierarchy</i>: The Excel object contains workbook objects, which contain worksheet objects, which contain range objects. This hierarchy is called Excel's <i class="EMPHASIS">object model.</i> Other Microsoft Office products have their own object model. The object model concept proves to be vitally important when developing VBA macros. Even if you don't create macros, you may find it helpful to think in terms of objects.</div>excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0tag:blogger.com,1999:blog-4182635980641329104.post-32134582753461539272011-04-01T05:04:00.000-07:002011-04-01T05:16:58.238-07:00The History of Excel<div class="first-para">You probably weren't expecting a history lesson when you bought this book, but you may find this information interesting. At the very least, this section provides fodder for the next office trivia match.</div><div class="para">Spreadsheets comprise a huge business, but most of us tend to take this software for granted. In the pre-spreadsheet days, people relied on clumsy mainframes or calculators and spent hours doing what now takes minutes.</div><div class="section"><h3 class="sect3-title"><a href="" name="39"></a><a href="" name="ch01le"></a>It Started with VisiCalc</h3><div class="first-para">Dan Bricklin and Bob Frankston conjured up VisiCalc, the world's first electronic spread- sheet, back in the late 1970s when personal computers were unheard of in the office environment. They wrote VisiCalc for the Apple II computer, an interesting machine that seems like a toy by today's standards. VisiCalc caught on quickly, and many forward-looking companies purchased the Apple II for the sole purpose of developing their budgets with VisiCalc. Consequently, VisiCalc is often credited for much of Apple II's initial success.</div></div><div class="section"><h3 class="sect3-title"><a href="" name="40"></a><a href="" name="ch01le"></a>Then Came Lotus</h3><div class="first-para">When the IBM PC arrived on the scene in 1982, thus legitimizing personal computers, VisiCorp wasted no time porting VisiCalc to this new hardware environment. Envious of VisiCalc's success, a small group of computer enthusiasts at a start-up company in Cambridge, Massachusetts, refined the spreadsheet concept. Headed by Mitch Kapor and Jonathon Sachs, the company designed a new product and launched the software industry's first full-fledged marketing blitz. Released in January 1983, Lotus Development Corporation's 1-2-3 proved an instant success. Despite its $495 price tag (yes, people really paid that much for a single program), it quickly outsold VisiCalc and rocketed to the top of the sales charts, where it remained for many years. Lotus 1-2-3 was, perhaps, the most popular application ever.</div></div><div class="section"><h3 class="sect3-title"><a href="" name="41"></a><a href="" name="ch01le"></a>Microsoft Enters the Picture</h3><div class="first-para"><a href="" name="42"></a>Most people don't realize that Microsoft's experience with spreadsheets extends back to the early 1980s. In 1982, Microsoft released its first spreadsheet-MultiPlan. Designed for computers running the CP/M operating system, the product was subsequently ported to several other platforms, including Apple II, Apple III, XENIX, and MS-DOS. MultiPlan essentially ignored existing software user-interface standards. Difficult to learn and use, it never earned much of a following in the United States. Not surprisingly, Lotus 1-2-3 pretty much left MultiPlan in the dust.</div><div class="last-para">Excel partly evolved from MultiPlan, first surfacing in 1985 on the Macintosh. Like all Mac applications, Excel was a graphics-based program (unlike the character-based MultiPlan). In November 1987, Microsoft released the first version of Excel for Windows (labeled Excel 2 to correspond with the Macintosh version). Excel didn't catch on right away, but as Windows gained popularity, so did Excel. Lotus eventually released a Windows version of 1-2-3, and Excel had additional competition from Quattro Pro-originally a DOS program developed by Borland International, then sold to Novell, and then sold again to Corel (its current owner).</div></div><div class="section"><h3 class="sect3-title"><a href="" name="43"></a><a href="" name="ch01le"></a>Excel Versions</h3><div class="first-para">Excel 2007 is actually Excel 12 in disguise. You may think that this name represents the twelfth version of Excel. Think again. Microsoft may be a successful company, but its version-naming techniques can prove quite confusing. As you'll see, Excel 2007 actually represents the tenth Windows version of Excel. In the following sections, I briefly describe the major Windows versions of Excel.</div><div class="section"><h4 class="sect4-title"><a href="" name="44"></a><a href="" name="ch01le"></a>EXCEL 2</h4><div class="first-para">The original version of Excel for Windows, Excel 2 first appeared in late 1987. It was labeled Version 2 to correspond to the Macintosh version (the original Excel). Because Windows wasn't in widespread use at the time, this version included a <i class="emphasis">runtime</i> version of Windows-a special version with just enough features to run Excel and nothing else. This version appears quite crude by today's standards</div><div class="first-para"><br />
</div><div class="section"><h4 class="sect4-title"><a href="" name="46"></a><a href="" name="ch01le"></a>EXCEL 3</h4><div class="first-para">At the end of 1990, Microsoft released Excel 3 for Windows. This version offered a significant improvement in both appearance and features. It included toolbars, drawing capabilities, worksheet outlining, add-in support, 3-D charts, workgroup editing, and lots more.</div></div><div class="section"><h4 class="sect4-title"><a href="" name="47"></a><a href="" name="ch01le"></a>EXCEL 4</h4><div class="first-para">Excel 4 hit the streets in the spring of 1992. This version made quite an impact on the marketplace as Windows increased in popularity. It boasted lots of new features and usability enhancements that made it easier for beginners to get up to speed quickly.</div></div><div class="section"><h4 class="sect4-title"><a href="" name="48"></a><a href="" name="ch01le"></a>EXCEL 5</h4><div class="first-para"><a href="" name="49"></a>In early 1994, Excel 5 appeared on the scene. This version introduced tons of new features, including multisheet workbooks and the new Visual Basic for Applications (VBA) macro language. Like its predecessor, Excel 5 took top honors in just about every spreadsheet comparison published in the trade magazines.</div></div><div class="section"><h4 class="sect4-title"><a href="" name="50"></a><a href="" name="ch01le"></a>EXCEL 95</h4><div class="first-para">Excel 95 (also known as Excel 7) shipped in the summer of 1995. On the surface, it resembled Excel 5 (this version included only a few major new features). However, Excel 95 proved to be significant because it presented the first version to use more advanced 32-bit code. Excel 95 and Excel 5 use the same file format.</div></div><div class="section"><h4 class="sect4-title"><a href="" name="51"></a><a href="" name="ch01le"></a>EXCEL 97</h4><div class="first-para">Excel 97 (also known as Excel 8) probably offered the most significant upgrade ever. The toolbars and menus took on a great new look, online help moved a dramatic step forward, and the number of rows available in a worksheet quadrupled. And if you're a macro developer, you may have noticed that Excel's programming environment (VBA) moved up several notches on the scale. Excel 97 also introduced a new file format.</div></div><div class="section"><h4 class="sect4-title"><a href="" name="52"></a><a href="" name="ch01le"></a>EXCEL 2000</h4><div class="first-para"><a href="" name="53"></a>Excel 2000 (also known as Excel 9) was released in June of 1999. Excel 2000 offered several minor enhancements, but the most significant advancement was the ability to use HTML as an alternative file format. Excel 2000 still supported the standard binary file format, of course, which is compatible with Excel 97.</div></div><div class="section"><h4 class="sect4-title"><a href="" name="54"></a><a href="" name="ch01le"></a>EXCEL 2002</h4><div class="first-para">Excel 2002 (also known as Excel 10) was released in June of 2001 and is part of Microsoft Office XP. This version offered several new features, most of which are fairly minor and were designed to appeal to novice users. Perhaps the most significant new feature was the capability to save your work when Excel crashes and also recover corrupt workbook files that you may have abandoned long ago. Excel 2002 also added background formula error checking and a new formula-debugging tool.</div></div><div class="section"><h4 class="sect4-title"><a href="" name="55"></a><a href="" name="ch01le"></a>EXCEL 2003</h4><div class="first-para">Excel 2003 (also known as Excel 11) was released in the fall of 2003. This version had very few new features. Perhaps the most significant new feature was the ability to import and export XML files and map the data to specific cells in a worksheet. It also introduced the concept of the List, a specially designated range of cells. Both of these features would prove to be precursors to future enhancements.</div></div><div class="section"><h4 class="sect4-title"><a href="" name="56"></a><a href="" name="ch01lev"></a>EXCEL 2007</h4><div class="first-para">Excel 2007 (also known as Excel 12) was released in early 2007. Its official name is Microsoft Office Excel 2007. This latest Excel release represents the most significant change since Excel 97, including a change to Excel's default file format. The new format is XML based although a binary format is still available. Another major change is the Ribbon, a new type of user interface that replaces the Excel menu and toolbar system. In addition to these two major changes, Microsoft has enhanced the List concept introduced in Excel 2003 (a List is now known as a Table), improved the look of charts, significantly increased the number of rows and columns, and added some new worksheet functions. For more, see the sidebar</div></div><div class="first-para"><br />
</div></div></div>excelhttp://www.blogger.com/profile/06924471227027833694noreply@blogger.com0