In Business Since 2001 We accept Paypal
Home for Writers for Publishers Article Directory Article Search
Guides
Article Marketing Secrets
20-Min Article Writing
Author Resource Box
35 Traffic Strategies
Kindle Uploads 101
Fantastic Fiction Decoded


Click Here to
see on Amazon


Site Navigation
Home

Writing Services
+ FAQ

FAQ

+ About Us
+ Blogs
Search Tools
+ Search Our Articles
Article Directory
+ Authors
+ Articles
Other Sites We Own
Writing Puzzle

Professional Book Marketing

Platt Publishing

Marketing Help


 
Article Teaser: 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.

Keep reading below...

Learning the Basics of Microsoft Excel

Copyright (c) 2008-2017

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.


    About The Author: Shop Amazon - Top Gift Ideas
    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

    Follow "The Phantom Writers" on Twitter (@phantomwriters)
    to be notified when new articles are made available.


    VOTE ON THIS ARTICLE
    Needs Work >> 0 - 1 - 2 - 3 - 4 - 5 << Excellent Article

    Tell our authors what you think about their article.



    Top-Level Category: Computers Articles

    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: 2607 | 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: 4203 | 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: 3850 | 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.

    All of Author's Articles on this site:

    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: 3045 | 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.

    Are Alienware Gaming Laptops Worth Buying?
    Written by: Titus Hoskins | Distributed: 2010-12-09 | Word Count: 540 | Page Views: 5505 | Votes: 10 | Rating: 3.50
    Alienware laptops have gained a large devoted fanbase, but are these high-priced gaming laptops worth buying? Discover why there are many angles to this question which you must consider before buying that Alienware laptop.

    Learn How to Identify, Diagnose and Replace Damaged Laptop LCD Screens
    Written by: Erwin Leona | Distributed: 2010-10-26 | Word Count: 508 | Page Views: 4153 | 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: 3411 | 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: 2978
    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: 2811 | 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: 10692 | 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: 3526
    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 Goes Mini-Me (Dell Intros Alienware M11x - The World's First Gaming Netbook)
    Written by: Titus Hoskins | Distributed: 2010-02-10 | Word Count: 601 | Page Views: 2646
    The whole concept of a gaming netbook is an intriguing idea - take your gaming with you, no matter where you go. But can the Dell Alienware M11x, which is being described as the World's First Gaming Netbook, really capture the hearts and pocketbooks of serious gamers?

    Gaming Laptops - 5 Reasons To Put Them On Your Christmas List
    Written by: Titus Hoskins | Distributed: 2009-12-30 | Word Count: 840 | Page Views: 2548 | 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: 15092 | 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: 10692 | 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.

    Are Alienware Gaming Laptops Worth Buying?
    Written by: Titus Hoskins | Distributed: 2010-12-09 | Word Count: 540 | Page Views: 5505 | Votes: 10 | Rating: 3.50
    Alienware laptops have gained a large devoted fanbase, but are these high-priced gaming laptops worth buying? Discover why there are many angles to this question which you must consider before buying that Alienware laptop.

    2008 Application Development Trends: 'Building for Change' To Accommodate Today's Shifting Business Conditions
    Written by: Anne Sych | Distributed: 2008-02-06 | Word Count: 441 | Page Views: 4682 | Votes: 16 | Rating: 2.50
    Software developers and businesses alike can expect to see significant changes in the year ahead in how applications are developed. Research analysts are projecting that 2008 will reveal a shift in the conventional development process, resulting in more flexible solutions that can evolve with a company's changing needs.

    How To Choose The Best Student Laptop?
    Written by: Titus Hoskins | Distributed: 2007-07-20 | Word Count: 861 | Page Views: 4542 | 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...

    CISSP Advanced Security Certification Can Lead to a Lucrative Career for the Committed Computer Security Professional
    Written by: Frank Pines | Distributed: 2009-07-07 | Word Count: 623 | Page Views: 4516 | Votes: 12 | Rating: 2.50
    Within months of 9/11, computer security became one of the hottest career choices in Information Technology (IT) departments around the world.

    Top 5 Gaming Laptops - Quick Roundup
    Written by: Titus Hoskins | Distributed: 2008-11-10 | Word Count: 1313 | Page Views: 4386 | Votes: 9 | Rating: 3.11
    In the market for a gaming laptop? Here are 5 Top Gaming Laptops you might want to put on your short list. Quick round-up of the latest gaming rigs...

    2003 Microsoft Excel Is Still In Wide Use
    Written by: Joe Cleland | Distributed: 2008-09-24 | Word Count: 751 | Page Views: 4203 | 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: 4153 | 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.

    What Do Chuzzle, Jewel Quest And Fairies Have In Common And Why Are They So Fun?
    Written by: Jon Wuebben | Distributed: 2006-06-15 | Word Count: 770 | Page Views: 4148 | Votes: 12 | Rating: 1.83
    Three of the most popular online games out there, Chuzzle, Jewel Quest and Fairies, may appear to be quite different, but in reality, share a very similar game architecture and strategy component. What's different?

    Highest Ranked "Computers" Articles

    Microsoft Excel For Online Marketers
    Written by: Joe Cleland | Distributed: 2008-10-07 | Word Count: 749 | Page Views: 2607 | 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.

    Toshiba Infuses Gaming Laptops With Triple Nvidia GPUs
    Written by: Titus Hoskins | Distributed: 2008-12-18 | Word Count: 597 | Page Views: 2469 | Votes: 6 | Rating: 3.50
    Toshiba stirs up the laptop gaming world with the first laptop sporting triple NVIDIA GPUs or graphics cards. Have the best of both worlds - powerful gaming performance and quiet operations in one gaming laptop... read more.

    Are Alienware Gaming Laptops Worth Buying?
    Written by: Titus Hoskins | Distributed: 2010-12-09 | Word Count: 540 | Page Views: 5505 | Votes: 10 | Rating: 3.50
    Alienware laptops have gained a large devoted fanbase, but are these high-priced gaming laptops worth buying? Discover why there are many angles to this question which you must consider before buying that Alienware laptop.

    Top 5 Gaming Laptops - Quick Roundup
    Written by: Titus Hoskins | Distributed: 2008-11-10 | Word Count: 1313 | Page Views: 4386 | Votes: 9 | Rating: 3.11
    In the market for a gaming laptop? Here are 5 Top Gaming Laptops you might want to put on your short list. Quick round-up of the latest gaming rigs...

    Maintaining and Troubleshooting Your Laptop Battery
    Written by: Bill Platt | Distributed: 2008-06-17 | Word Count: 1038 | Page Views: 3474 | 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: 3766 | 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: 10692 | 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: 2734 | 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: 3475 | 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: 4203 | 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.












    Download an eBook today
     
    Directory Navigation
    Locate By Author

    Locate By Category:
    ALL Categories
    Arts & Crafts
    Arts & Entertainment
    Automotive
    Business - Offline
    Business - Online
    Career
    Computers
    Education
    Family
    Finance
    Food & Drink
    Health & Wellness
    Home & Garden
    Humor
    Internet
    Nature & Pets
    Real Estate
    Religion
    Self Improvement
    Shopping
    Society
    Sports & Recreation
    Technology
    Travel & Leisure
    Uncategorized
    World Events
    Writing & Speaking

    Change Number of Results:
    50 - 100 - 200 - 500
    Article Reprint Rights
    Creative Commons License

    This work is
    licensed under a
    Creative Commons
    License


    You are not required to show the creative commons license notice when you reprint this work.
    Article Publishing Tools
    Print Article
    Email-to-Blog
    HTML Source Code
    Text Newsletter Format
    Link Back HTML

    Blog Publishing Tools

    Internal ID: #6311
    Article Statistics
    Word Count: 1006

    Total Views: 2537

    Article Rating: 2.89 of 5
    Votes Cast: 9

    More Articles By Author:




    Article Title Search:

    Widow Search
    Right Blinker
    Google
    Yahoo!
    Zuula
    Bing
    Cuil

    Last Distribution Date:
    2008-09-30 11:12:00






    All Articles are Copyright © 2001-2017 of the Defined Authors.

    All other material and images on this site are:
    Copyright © 2001-2017, ThePhantomWriters.com