Free-Reprint Article Written by: Joe Cleland
See Terms of Reprint Below.
*****************************************************************
*
* This email is being delivered directly to members of the group:
*
*
computer_tips_4_reprint@yahoogroups.com
*
*****************************************************************
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:
joe.cleland@...
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#g\
et_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 Excel’s 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 Office’s 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 Excel’s 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#g\
et_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:
joe.cleland@...
*** 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:
joe.cleland@...
.....................................
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
---------------------------------------------------------------------