Learning the Basics of Microsoft Excel

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.

10 Most Recent Articles Written by Joe Cleland

Microsoft Excel For Online Marketers
Written by: Joe Cleland |
Distributed: 2008-10-07 |
Word Count: 749 |
Page Views: 2742
| Votes: 5 |
Rating: 3.60
Many folks mistakenly believe that Microsoft Excel is strictly
for accountants and bookkeepers, but it is really so much more.
The fine programmers at Microsoft have tried to think ahead to
how people would like to use spreadsheets, and they incorporated
most of that additional functionality into Microsoft Excel.

2003 Microsoft Excel Is Still In Wide Use
Written by: Joe Cleland |
Distributed: 2008-09-24 |
Word Count: 751 |
Page Views: 4412
| Votes: 8 |
Rating: 2.75
When preparing for the job market, it simply does not make sense
to get up to speed with only the most up-to-date software
packages from Microsoft. It is nice to think that your next or
current employer should be using Microsoft's 2007 Office
package. But, this is the real world.

Microsoft Excel Is No Longer Just a Business Application
Written by: Joe Cleland |
Distributed: 2008-09-18 |
Word Count: 2006 |
Page Views: 3989
| Votes: 10 |
Rating: 2.10
Back in the 1990's, the only people who had a need to learn to
use Microsoft Excel product, were those who used accounting
spreadsheets in the course of their work. But, this is 2008 and
the need for MS Excel is so much more than it was just a decade
ago.

Most Recent "Computers" Articles

To IPhone Or To IPad, That Is The Question
Written by: Dawn Carey |
Distributed: 2011-06-24 |
Word Count: 658 |
Page Views: 3378
| Votes: 2 |
Rating: 0.00
If your iPhone experience has ever left you wanting more,
then the iPad may just be the scratch your itch is looking
for.

Learn How to Identify, Diagnose and Replace Damaged Laptop LCD Screens
Written by: Erwin Leona |
Distributed: 2010-10-26 |
Word Count: 508 |
Page Views: 4328
| Votes: 3 |
Rating: 3.67
Consumers with broken laptop screens will usually take their
computer to an electronics repair store or replace the
laptop altogether. A broken laptop screen still has a
perfectly functioning machine underneath and with just a
screwdriver and a manual you can replace the screen yourself
and save. This task is much easier than it sounds and the
job can be done in less than an hour with the proper set of
instructions.

Is The Apple IPad The Perfect Student Laptop?
Written by: Titus Hoskins |
Distributed: 2010-08-03 |
Word Count: 816 |
Page Views: 3654
| Votes: 4 |
Rating: 3.00
Will the new Apple iPad turn out to be the perfect student
laptop? Only a close examination of the iPad features (and
missing features) will give you the answer.

Is Nvidia Optimus The Future Of Gaming Laptops?
Written by: Titus Hoskins |
Distributed: 2010-07-29 |
Word Count: 874 |
Page Views: 3153
New Nvidia Optimus technology gives you switchable graphics
for enhanced visuals and longer battery life for your
laptop. But what will this new Optimus technology mean for
the future of gaming laptops?

Has 3D Gaming Finally Arrived?
Written by: Titus Hoskins |
Distributed: 2010-04-20 |
Word Count: 970 |
Page Views: 3037
| Votes: 5 |
Rating: 2.20
Dazzle them and they will come, or will they? We all know
the new 3D technology as seen in the popular film Avatar has
everyone enthralled, but will 3D have the same impact on
computer gaming? Are we on the verge of a visual gaming
revolution?

Roles and Responsibilities of a SAP MM Consultant
Written by: Varsha Vilankar |
Distributed: 2010-04-20 |
Word Count: 1255 |
Page Views: 10895
| Votes: 61 |
Rating: 3.00
Everyday there are thousands of people who discover the
prospects of a career in SAP. However, lack of knowledge
often takes them to mushroom schools that have sprung up due
to the high demand of SAP training. Varsha has attempted to
give an easy to follow roadmap that is drawn on a timeline.
Following this roadmap will ensure that students don't end
up as hit-and-run victims of mushroom schools that are run
by unethical businessmen and not educators. Midst of the
weakening economy and employment uncertainty, the last thing
you want is for someone to rob you of your savings and
precious time. Read this article to stay in touch for an
amazing career in SAP.

New Trends In Gaming Laptops
Written by: Titus Hoskins |
Distributed: 2010-03-10 |
Word Count: 695 |
Page Views: 3757
Just what are the latest new trends in gaming laptops? Will
greater portability and 3D features become the latest trends
in gaming laptop design... read to find out.

Gaming Laptops - 5 Reasons To Put Them On Your Christmas List
Written by: Titus Hoskins |
Distributed: 2009-12-30 |
Word Count: 840 |
Page Views: 2749
| Votes: 3 |
Rating: 3.00
The Holiday Season is just around the corner and everyone
will be considering what to give as gifts this Christmas. If
you have more than a little cash to spare and you're
operating in a Non-Scrooge mode, here are 5 reasons why
giving a gaming laptop should be high on your list.

Most Viewed "Computers" Articles

SAP HR Training
Written by: David Sholmire |
Distributed: 2008-04-30 |
Word Count: 716 |
Page Views: 15234
| Votes: 74 |
Rating: 2.30
Learning SAP HR or (new name HCM - Human Capital Management)
module is not difficult at all if you have a qualified and
experienced instructor who loves to teach; If you have the best
of material that is geared towards certification; If you have
system that is carefully tweaked for optimal performance and if
you have an environment that is conducive to total learning.

Roles and Responsibilities of a SAP MM Consultant
Written by: Varsha Vilankar |
Distributed: 2010-04-20 |
Word Count: 1255 |
Page Views: 10895
| Votes: 61 |
Rating: 3.00
Everyday there are thousands of people who discover the
prospects of a career in SAP. However, lack of knowledge
often takes them to mushroom schools that have sprung up due
to the high demand of SAP training. Varsha has attempted to
give an easy to follow roadmap that is drawn on a timeline.
Following this roadmap will ensure that students don't end
up as hit-and-run victims of mushroom schools that are run
by unethical businessmen and not educators. Midst of the
weakening economy and employment uncertainty, the last thing
you want is for someone to rob you of your savings and
precious time. Read this article to stay in touch for an
amazing career in SAP.

How To Choose The Best Student Laptop?
Written by: Titus Hoskins |
Distributed: 2007-07-20 |
Word Count: 861 |
Page Views: 4798
| Votes: 6 |
Rating: 1.33
This article lists the different factors which make up the
perfect student laptop. If you're considering purchasing a
student notebook or laptop in the very near future, read this
article first...

2003 Microsoft Excel Is Still In Wide Use
Written by: Joe Cleland |
Distributed: 2008-09-24 |
Word Count: 751 |
Page Views: 4412
| Votes: 8 |
Rating: 2.75
When preparing for the job market, it simply does not make sense
to get up to speed with only the most up-to-date software
packages from Microsoft. It is nice to think that your next or
current employer should be using Microsoft's 2007 Office
package. But, this is the real world.

Learn How to Identify, Diagnose and Replace Damaged Laptop LCD Screens
Written by: Erwin Leona |
Distributed: 2010-10-26 |
Word Count: 508 |
Page Views: 4328
| Votes: 3 |
Rating: 3.67
Consumers with broken laptop screens will usually take their
computer to an electronics repair store or replace the
laptop altogether. A broken laptop screen still has a
perfectly functioning machine underneath and with just a
screwdriver and a manual you can replace the screen yourself
and save. This task is much easier than it sounds and the
job can be done in less than an hour with the proper set of
instructions.

Highest Ranked "Computers" Articles

Microsoft Excel For Online Marketers
Written by: Joe Cleland |
Distributed: 2008-10-07 |
Word Count: 749 |
Page Views: 2742
| Votes: 5 |
Rating: 3.60
Many folks mistakenly believe that Microsoft Excel is strictly
for accountants and bookkeepers, but it is really so much more.
The fine programmers at Microsoft have tried to think ahead to
how people would like to use spreadsheets, and they incorporated
most of that additional functionality into Microsoft Excel.

Maintaining and Troubleshooting Your Laptop Battery
Written by: Bill Platt |
Distributed: 2008-06-17 |
Word Count: 1038 |
Page Views: 3609
| Votes: 13 |
Rating: 3.08
The actual life of a laptop battery will vary with computer usage
habits. For most users, it is not uncommon to experience
differences in battery life, of anywhere from just under one hour
to over two hours in each sitting. If you are experiencing
shorter battery life cycles, say 10 to 15 minutes, it may not yet
be time to order that new battery.

The Check Point Certified Security Administrator (CCSA) Certification Will Prove Your Worth
Written by: Frank Pines |
Distributed: 2009-07-15 |
Word Count: 500 |
Page Views: 3988
| Votes: 13 |
Rating: 3.08
Are you looking for a career in Information Technology? The Check
Point Certified Security Administrator (CCSA) certification is a
good choice to add to your credentials as a Network Security
specialist. The CCSA has not only become a highly recognized and
sought after credential to help you get the job, it verifies your
knowledge and improves your practical application skills to help
you keep the job.

Roles and Responsibilities of a SAP MM Consultant
Written by: Varsha Vilankar |
Distributed: 2010-04-20 |
Word Count: 1255 |
Page Views: 10895
| Votes: 61 |
Rating: 3.00
Everyday there are thousands of people who discover the
prospects of a career in SAP. However, lack of knowledge
often takes them to mushroom schools that have sprung up due
to the high demand of SAP training. Varsha has attempted to
give an easy to follow roadmap that is drawn on a timeline.
Following this roadmap will ensure that students don't end
up as hit-and-run victims of mushroom schools that are run
by unethical businessmen and not educators. Midst of the
weakening economy and employment uncertainty, the last thing
you want is for someone to rob you of your savings and
precious time. Read this article to stay in touch for an
amazing career in SAP.

Automated Trading Systems For Financial Markets And Recommendations For Their Usage
Written by: Nikita Laukhin |
Distributed: 2007-07-31 |
Word Count: 2011 |
Page Views: 2859
| Votes: 10 |
Rating: 2.90
Today, using information and trading platforms has become a de
facto requirement for successful trading in the financial
markets. Their advantages as compared to conventional trading
schemes include, for example, an unprecedented speed of
processing and delivery of information to end users, the level of
integration with data providers, and a wide array of built-in
technical analysis instruments.

What Makes Online Games more Fun?
Written by: Jon Wuebben |
Distributed: 2006-05-25 |
Word Count: 679 |
Page Views: 3627
| Votes: 12 |
Rating: 2.83
Role playing games, puzzle games, traditional games like chess
and backgammon - they are all becoming big in the online world,
with more and more people playing every day. So, what makes
online games more fun and what are the specific benefits one
can enjoy?

2003 Microsoft Excel Is Still In Wide Use
Written by: Joe Cleland |
Distributed: 2008-09-24 |
Word Count: 751 |
Page Views: 4412
| Votes: 8 |
Rating: 2.75
When preparing for the job market, it simply does not make sense
to get up to speed with only the most up-to-date software
packages from Microsoft. It is nice to think that your next or
current employer should be using Microsoft's 2007 Office
package. But, this is the real world.