An Introduction to Microsoft Excel: Top Features for the Excel Novice
Tue 4th July 2006
Microsoft Excel offers extremely powerful numerical and statistical data manipulation. However, such a powerful program can seem a little intimidating when all you need are some simple statistical results.
If you are new to Excel, why not take time out to fully explore your Excel window? If you are familiar with Microsoft Word, you will be pleasantly surprised by the similar 'look and feel'.
You will also recognise the menu bar, formatting toolbar and the help box environment. Slightly less familiar features will include column headings, row headings, cell ranges and worksheet selection tabs. These helpful additions provide much of the back bone to Excel's success.
Each Excel workbook is divided into worksheets. By default there are three sheets, with sheet one initially active. These sheets can be selected by clicking on the name of the sheet located at the bottom of the booklet.
Each sheet consists of many rows horizontally and columns vertically. Columns are named as alphabetical headings, while rows are numerical. Each row or column consists of a range of cells where data is stored and/or manipulated.
Once you are happy with the Excel layout, we can then delve into the features most useful to the novice user:
1) Basic Formatting
Rows and rows of data can be pretty bland if nothing really stands out. The presentation of data can be as important as the results themselves. An inventory report submitted to a new customer or potential client may only be reviewed initially for a matter of seconds. With a little thought, basic formatting can be used to highlight important areas and automate simple tasks.
If you are familiar with other Microsoft Office programs, you will have seen the formatting toolbar usually found at the top of the application's screen. You can use this to select a cell range and apply whatever formatting you like.
Simple formatting allows the alteration of cell content. This includes applying different styles and sizes to data. You can also apply default Excel styles such as adding pound (
Author is a trainer with a Microsoft Office training company, the UK industry leader in its sector. For more information on Microsoft Excel training, visit www.stl-training.co.ukhttps://www.stl-training.co.uk[/url].
You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
If you do not agree to these terms, please do not use this article.
Estate Research Client Relationship Manager Matt McLoughlin
"Very enjoyable and useful course. Well thought out content and a valuable aid to our sales toolkit."
Platina Partners LLP Admin
"The trainer's way of teaching was excellent because it was not too rigid and subjects and topics were tailored as we progressed through the day. Great!"
"Fantastic experience with excellent educational content delivered in a professional and understandable way. Gregory was patient and understanding adapting examples and situations to be most useful to our company."
Excel articles
