tag:blogger.com,1999:blog-73296732945907482972024-03-19T09:06:18.118+05:30My Information LibraryMy Information Library content Reiki, Vastu, Technology, Computer, Software, Information Communication, Tips, Tricks, Internet, Library Science and other knowledge sharing data.Unknownhttps://www.blogger.com/profile/05840907406285501861noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7329673294590748297.post-65685673030493437252009-02-04T15:34:00.001+05:302009-04-01T01:28:26.998+05:30Add Two Cells in Excel Step By Step<p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3">One of the best things about a spreadsheet is using formulas to calculate values automatically. When you tell Microsoft Excel to add two cells (perhaps the cells that represent the number of men and women in a class that you are teaching), the program will automatically recalculate the answer if the values of the cells being added change. These steps work with Microsoft Excel 97.</font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Cambria"><font size="3"> </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><u><span style="FONT-SIZE: 13pt; FONT-FAMILY: Cambria">Instructions</span></u></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Cambria"><font size="3"> </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Cambria"><font size="3">Step1<span style="mso-tab-count: 1"> </span>Start Microsoft Excel, and open the file you want to use. </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Cambria"><font size="3">Step2<span style="mso-tab-count: 1"> </span>Click on the cell in which you want the total to appear. </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in"><span style="FONT-FAMILY: Cambria"><font size="3">Step3<span style="mso-tab-count: 1"> </span>Press the + key on the keyboard, this character will appear in the cell and in the Formula Bar. </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in"><span style="FONT-FAMILY: Cambria"><font size="3">Step4<span style="mso-tab-count: 1"> </span>Click on the first cell you want to add. That cell's name, such as B6, appears in the Formula Bar after the + sign. </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Cambria"><font size="3">Step5<span style="mso-tab-count: 1"> </span>Press the + key again. </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in"><span style="FONT-FAMILY: Cambria"><font size="3">Step6<span style="mso-tab-count: 1"> </span>Click on the second cell you want to add. That cell's name appears in the Formula Bar. </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in"><span style="FONT-FAMILY: Cambria"><font size="3">Step7<span style="mso-tab-count: 1"> </span>Press Enter to complete the equation. The total will appear in the initial cell.</font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in"><span style="FONT-FAMILY: Cambria"><font size="3"> </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in"><u><span style="FONT-SIZE: 13pt; FONT-FAMILY: Cambria">Important Tips</span></u></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in"><u><span style="FONT-SIZE: 13pt; FONT-FAMILY: Cambria"><span style="TEXT-DECORATION: none"> </span></span></u></p> <ul style="MARGIN-TOP: 0in" type="disc"> <li class="MsoNormal" style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><span style="FONT-FAMILY: Cambria"><font size="3">To view the resulting formula, click on the cell that contains the total. The equation is displayed in the Formula Bar.</font></span></li> </ul> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Cambria"><font size="3"><span style="mso-spacerun: yes"> </span></font></span></p> <ul style="MARGIN-TOP: 0in" type="disc"> <li class="MsoNormal" style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><span style="FONT-FAMILY: Cambria"><font size="3">The cells being added can be anywhere in the spreadsheet. You can also add more than two cells or add the total cell to another cell. </font></span></li> </ul> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt 0.25in"><span style="FONT-FAMILY: Cambria"><font size="3"> </font></span></p> <ul style="MARGIN-TOP: 0in" type="disc"> <li class="MsoNormal" style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><span style="FONT-FAMILY: Cambria"><font size="3">The Formula Bar is located between the toolbar and the column heads.</font></span></li> </ul> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Cambria"><font size="3"><span style="mso-spacerun: yes"> </span></font></span></p> <ul style="MARGIN-TOP: 0in" type="disc"> <li class="MsoNormal" style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><span style="FONT-FAMILY: Cambria"><font size="3">To delete your current change, open the Edit menu, and select Undo.</font></span></li> </ul> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.5in"><span style="FONT-FAMILY: Cambria"><font size="3"> </font></span></p><span style="FONT-FAMILY: Cambria"><span style="mso-tab-count: 1"><font size="3"> <div style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 4pt; PADDING-BOTTOM: 1pt; BORDER-LEFT: windowtext 1pt solid; PADDING-TOP: 1pt; BORDER-BOTTOM: windowtext 1pt solid; mso-element: para-border-div; mso-border-shadow: yes"> <p class="MsoNormal" style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; TEXT-ALIGN: justify; mso-border-shadow: yes; mso-border-alt: solid windowtext 1.0pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"> <b style="mso-bidi-font-weight: normal"><span style="FONT-SIZE: 14pt; mso-bidi-font-size: 11.0pt"><a href="http://feedburner.google.com/fb/a/mailverify?uri=AmazingNewsPhoto"><font face="Century Schoolbook">Click To get free article</font></a></span></b></p> <p class="MsoNormal" style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; TEXT-ALIGN: justify; mso-border-shadow: yes; mso-border-alt: solid windowtext 1.0pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"> <b style="mso-bidi-font-weight: normal"><span style="FONT-SIZE: 14pt; mso-bidi-font-size: 11.0pt"><font face="Century Schoolbook" size="2"></font></span></b> </p> <p class="MsoNormal" style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; TEXT-ALIGN: justify; mso-border-shadow: yes; mso-border-alt: solid windowtext 1.0pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"> <b style="mso-bidi-font-weight: normal"><span style="FONT-SIZE: 14pt; mso-bidi-font-size: 11.0pt"><font face="Century Schoolbook" size="2">1 Tips of Excel</font></span></b></p> <p class="MsoNormal" style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; TEXT-ALIGN: justify; mso-border-shadow: yes; mso-border-alt: solid windowtext 1.0pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"> <b style="mso-bidi-font-weight: normal"><span style="FONT-SIZE: 14pt; mso-bidi-font-size: 11.0pt"><font face="Century Schoolbook" size="2">2 Tips of Word</font></span></b></p> <p class="MsoNormal" style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; TEXT-ALIGN: justify; mso-border-shadow: yes; mso-border-alt: solid windowtext 1.0pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"> <b style="mso-bidi-font-weight: normal"><span style="FONT-SIZE: 14pt; mso-bidi-font-size: 11.0pt"><font face="Century Schoolbook" size="2">3 Tips of Power Point</font></span></b></p></div> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; tab-stops: 108.75pt"> </p></font></span></span> <p> </p> <div class="blogger-post-footer">Thank you for visiting my feed. To read more articles go to the site http://www.myilibrary.blogspot.com</div>Unknownhttps://www.blogger.com/profile/05840907406285501861noreply@blogger.com0tag:blogger.com,1999:blog-7329673294590748297.post-52377709854498465052009-02-04T15:24:00.001+05:302009-04-01T01:29:12.684+05:30Excel Macros Function-Creating-Saving-Sharing<p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3">Excel Macros Function-Creating-Saving-Sharing</font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"> </font></span></p> <div class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"><u>About Macros</u></font></span></div> <div class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3">Excel macros are a special feature in Microsoft Excel that allows you to perform common tasks automatically. They work by "recording" your keystrokes, mouse movements and settings during a given session, and are then able to be "played back" when a common action needs to be taken. Although it may take some time to learn how to make and share macros, it is worth the effort as these macros can save the serious Excel user lots of valuable time.</font></span></div> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"> </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"><u>Function</u></font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3">The primary function of Excel macros is to reduce time for those who spend a lot of time using Excel. These macros automate frequent or repeated actions. The latest version of Excel has several pre-loaded macros, but the most useful are those that are user-generated using Excel's unique macro-recording function. </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"> </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"><u>Creating Macros</u></font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3">To create a macro, simply go to the "Tools" menu, and select the "Macros" sub-menu. From here, click on the "Record New Macro" option. Form here a "Record Macro" pop up will appear, asking you to name your macro. You will also need to set a keyboard shortcut and choose a location to save it. Once you have entered all your information, click "OK" and a new little pop-up will appear. This is the recording module, which allows you to pause, stop and resume recording. </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"> </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"><u>Saving Macros</u></font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3">It is very important that you keep your macros saved in a place that you will remember; otherwise you will not be able to access or edit them at a later date. Although there is a default "My Macros" folder, if you use many different macros, then it is best to set up several macro folders by usage. </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"> </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"><u>Sharing Macros</u></font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3">One of the best features of Excel macros is the ability to share them between computers. If you are working on a networked computer, simply enabling all macros on your computer will give you access to others' created macros. However, if you want to send a macro to someone, you can share it by uploading it to a server or attaching it to an email. As long as the recipient has a compatible version of Excel, she can save it to a designated macro folder and use it any time she likes. </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"> </font></span></p> <p class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"><u>Creating a Toolbar Icon</u></font></span></p> <div class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3">For your most frequently used macros, you can create a toolbar icon that allows for one-click access. To do this, simply go to the "Tools" menu and click "Customize." Then go to the "Commands" tab and under "Categories," find the "Macros" tab. Then drag a custom button to your toolbar and then click "Modify Selection." Click on "Assign Macro" to bring up the "Assign Macro" dialog box, choose a name for your macro, and then click "OK." You will now be able to click on this button one time to enable your macro.</font></span></div> <div class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"></font></span> </div> <div class="MsoNormal" style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"><span style="FONT-FAMILY: Cambria"><font size="3"> <div style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 4pt; PADDING-BOTTOM: 1pt; BORDER-LEFT: windowtext 1pt solid; PADDING-TOP: 1pt; BORDER-BOTTOM: windowtext 1pt solid; mso-element: para-border-div; mso-border-shadow: yes"> <p class="MsoNormal" style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; TEXT-ALIGN: justify; mso-border-shadow: yes; mso-border-alt: solid windowtext 1.0pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"> <b style="mso-bidi-font-weight: normal"><span style="FONT-SIZE: 14pt; mso-bidi-font-size: 11.0pt"><font face="Century Schoolbook"></font></span></b></p><b style="mso-bidi-font-weight: normal"><span style="FONT-SIZE: 14pt; mso-bidi-font-size: 11.0pt"><a href="http://feedburner.google.com/fb/a/mailverify?uri=myilibrary"><font face="Century Schoolbook">Click To get free article</font></a></span></b> <p class="MsoNormal" style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; TEXT-ALIGN: justify; mso-border-shadow: yes; mso-border-alt: solid windowtext 1.0pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"> <b style="mso-bidi-font-weight: normal"><span style="FONT-SIZE: 14pt; mso-bidi-font-size: 11.0pt"><font face="Century Schoolbook" size="2">1 Tips of Computer</font></span></b></p> <p class="MsoNormal" style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; TEXT-ALIGN: justify; mso-border-shadow: yes; mso-border-alt: solid windowtext 1.0pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"> <b style="mso-bidi-font-weight: normal"><span style="FONT-SIZE: 14pt; mso-bidi-font-size: 11.0pt"><font face="Century Schoolbook" size="2">2 Tips of Blogging</font></span></b></p> <p class="MsoNormal" style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; TEXT-ALIGN: justify; mso-border-shadow: yes; mso-border-alt: solid windowtext 1.0pt; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"> <b style="mso-bidi-font-weight: normal"><span style="FONT-SIZE: 14pt; mso-bidi-font-size: 11.0pt"><font face="Century Schoolbook" size="2">3 Tips of Internet</font></span></b></p></div></font></span></div> <div class="blogger-post-footer">Thank you for visiting my feed. To read more articles go to the site http://www.myilibrary.blogspot.com</div>Unknownhttps://www.blogger.com/profile/05840907406285501861noreply@blogger.com0