Free-Reprint Article Written by: Joe Cleland See Terms of Reprint Below.
***************************************************************** * * This email is being delivered directly to members of the group: * * [email protected] * ***************************************************************** We have moved our TERMS OF REPRINT to the end of the article. Be certain to read our TERMS OF REPRINT and honor our TERMS OF REPRINT when you use this article. Thank you. This article has been distributed by: http://Article-Distribution.com Helpful Link: The Digital Millennium Copyright Act - Overview http://www.gseis.ucla.edu/iclp/dmca1.htm --------------------------------------------------------------------- Article Title: ============== Learning the Basics of Microsoft Excel Article Description: ==================== If you have never used Microsoft Excel before, it is a computer application that is part of the Microsoft Office package. Many people think of MS Excel as simply a spreadsheet application that is to be used by accountants and other number crunchers, but the truth is that it is an application that can be so much more than just a spreadsheet application. Additional Article Information: =============================== 1006 Words; formatted to 65 Characters per Line Distribution Date and Time: 2008-09-30 11:12:00 Written By: Joe Cleland Copyright: 2008 Contact Email: mailto:[EMAIL PROTECTED] For more free-reprint articles by Joe Cleland, please visit: http://www.thePhantomWriters.com/recent/author/joe-cleland.html ============================================= Special Notice For Publishers and Webmasters: ============================================= If you use this article on your website or in your ezine, We Want To Know About It. Use the following URL to let us know where you have used this article, and we will include a link to your website on thePhantomWriters.com: http://thephantomwriters.com/notify.php?id=6311&p=load HTML Copy-and-Paste and TEXT Copy-and-Paste Versions Of Article Are Available at: http://thePhantomWriters.com/free_content/db/c/basics-of-microsoft-excel.shtml#get_code --------------------------------------------------------------------- Learning the Basics of Microsoft Excel Copyright (c) 2008 Joe Cleland K Alliance, LLC http://www.cbtplanet.com If you have never used Microsoft Excel before, it is a computer application that is part of the Microsoft Office package. Many people think of MS Excel as simply a spreadsheet application that is to be used by accountants and other number crunchers, but the truth is that it is an application that can be so much more than just a spreadsheet application. Some people use Microsoft Excel to build reports, with beautiful, well-formatted tables that can easily convey information in an attractive manner. For this reason, many people in marketing and sales use MS Excel as a tool in their works as well. I have even known people to use an Excel spreadsheet to build work schedules for their employees. Managers with the knowledge of Microsoft Excels advanced features and tools, can utilize the functionality of MS Excel to process functions to keep track of the hours assigned to each employee to ensure that people are not over-scheduled, such as in a restaurant environment where an employee may a few short shifts in the day, as opposed to a straight eight-hour day. Simply put, the range and functionality of Microsoft Excel is so varied that many people can find new uses for it, once they understand how to best utilize its built-in advanced tools and features. Getting Started When you first open Microsoft Excel for the first time, it will seem such a plain and simple computer application, with columns and rows. If you plan to use Excel to build reports, you can actually put your mouse on the black line dividing rows and columns, hold down your mouse key, and resize the rows and columns to match your actual display needs. With the icons on the toolbars, you can set font size, color and styles in very short order. To apply one of the toolbar features to a data cell (a single box), just click that cell and then select the feature you want added to that cell. You can actually choose to apply settings to rows or columns, as opposed to just cells. To do so for the row, just click the number to the left of the form, and it will highlight the entire row you wish to adjust the settings. To do the same for a column, simply click the alphabet letter above the form to highlight the full column, and then apply your choice settings to it. Editing Information The hardest thing to get used to when using Microsoft Excel, for the first few times, is how to edit information easily. When you add data to a data cell, the brain naturally wants to do all editing in that little box on the form. But, every time you click a data cell, the cell will be highlighted with a dark black line, and the data inside that box will be shown at the top of the form, in the long text box below the menu bar. You only need to teach yourself to click a data cell on the form, then to click on the text box at the top of the form, so that you can easily highlight text or edit it as you need to do. Inserting New Information If you have set up an entire spreadsheet, only to realize that you left some information out of your form, you can add rows and columns to your form on the fly, with only a few clicks. It is so easy to do. You actually have more than one method available to you to do most functions, including this one. For example, if you need to add another column: * You can select a data cell, right-click your mouse, click insert, then tell it to shift right or shift down to insert either a row or a column. * You can also select the column head (where the alphabet letter is at the top), then right click, and select insert. The software will automatically insert a new column for you. * If your right-click is not working on your mouse, you can either select the data cell or column head as previously mentioned, then click insert on your menu bar at the top of the application. The truth is that Microsoft has made Microsoft Offices Excel so intuitive that even John McCain, who claims he has never used a computer, could figure out how to use it well in only a few days. The same processes used to add information to a spreadsheet can be used to also delete information (cells, rows, and columns) from the form. Introducing Advanced Capabilities In the example of the restaurant manager, who uses Microsoft Excel to build a schedule for his or her employees, one advanced feature really pays for itself in no time at all. Suppose the manager put the employee name in Column A, and then sets Columns B to H to represent each of the seven days in a calendar week. On the menu bar, under Insert, there is a feature there called functions. One can actually set up their spreadsheet to run calculations on the data in the form. For the restaurant manager seeking to use MS Excel as a scheduling tool, he or she can set up a function to calculate the number of hours worked during the workweek, by taking advantage of Excels internal functions. Telling you exactly how to do this is a bit beyond the scope of this article, but with some hands-on Excel Training, it is something that you can learn to do within a few uses. You might need to refer back to the training materials for the first couple weeks, but once you have done it a few times, it will be like second nature to you. One thing that many users really appreciate about the Microsoft Excel package, is that you can actually set up functions on your spreadsheet and save the basic template to be opened at a later date, with all of the formatting and functions built right into your spread sheet. --------------------------------------------------------------------- My name is Joe Cleland, and I work with K Alliance, LLC. You can visit our website to learn more about our Excel Training program program at: http://www.cbtplanet.com/excel.htm We can also be reached by phone toll-free at: 866-718-7246 --- END ARTICLE --- Get HTML or TEXT Copy-and-Paste Versions Of This Article at: http://thePhantomWriters.com/free_content/db/c/basics-of-microsoft-excel.shtml#get_code ..................................... TERMS OF REPRINT - Publication Rules (Last Updated: May 11, 2006) Our TERMS OF REPRINT are fully enforcable under the terms of: The Digital Millennium Copyright Act http://thomas.loc.gov/cgi-bin/query/z?c105:H.R.2281.ENR: ..................................... *** Digital Reprint Rights *** * If you publish this article in a website/forum/blog, You Must Set All URL's or Mailto Addresses in the body of the article AND in the Author's Resource Box as Hyperlinks (clickable links). * Links must remain in the form that we published them. Clean links should point to the Author's links without redirects having been inserted into the copy. * You are not allowed to Change or Delete any Words or Links in the Article or Resource Box. Paragraph breaks must be retained with articles. You can change where the paragraph breaks fall, but you cannot eliminate all paragraph breaks as some have chosen to do. * Email Distribution of this article Must be done through Opt-in Email Only. No Unsolicited Commercial Email. * You Are Allowed to format the layout of the article for proper display of the article in your website or in your ezine, so long as you can maintain the author's interests within the article. * You may not use sentences from this article as an input for any software that steals sentences from others in order to build an article with software. The copyright on this article applies to the "WHOLE" article. *** Author Notification *** We ask that you notify the author of publication of his or her work. Joe Cleland can be reached at: [EMAIL PROTECTED] *** Print Publication Reprint Rights *** If you desire to publish this article in a PRINT publication, you must contact the author directly for Print Permission at: mailto:[EMAIL PROTECTED] ..................................... If you need help converting this text article for proper hyperlinked placement in your webpage, please use this free tool: http://thephantomwriters.com/link-builder.pl ===================================================================== ABOUT THIS ARTICLE SUBMISSION http://thePhantomWriters.com is a paid article distribution service. thePhantomWriters.com and Article-Distribution.com are owned and operated by Bill Platt of Stillwater, Oklahoma USA. Learn more about our article distribution services by visiting: http://thephantomwriters.com/x.pl/tpw/info/article-distribution/index.html The content of this article is solely the property and opinion of its author, Joe Cleland http://www.cbtplanet.com --------------------------------------------------------------------- XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX --------------------------------------------------------------------- ------------------------------------ *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* To have your article appear in this distribution list, you must absolutely be a client of thePhantomWriters. We offer a paid article distribution service, and this is one of the more than 60 groups where we submit our client articles. To learn more about our program, visit: http://thePhantomWriters.com/x.pl/tpw/index.htmYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/thePhantomWriters/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/thePhantomWriters/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
