ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Microsoft Excel for Beginners

Updated on August 27, 2012

Microsoft Excel is spreadsheet application that can be an excellent tool to calculate financial and statistical information. It’s a tool that is used in many companies as well as households. But it can be very frustrating and confusing to someone who has never used any type of spreadsheet software. In this hub, I will explain some basic knowledge that is needed to use Microsoft Excel and give you a few tips and tricks that I find useful when using Microsoft Excel.

NOTICE: It is important to inform you that all the instructions that I have put in my Hub are for versions of Microsoft Excel 2007 or higher.

What are Spreadsheets?

Spreadsheets simulate an accounting worksheet. They are made up of a grid of rows and columns. In the following image, you can see the different parts that make up a spreadsheet. In a cell you can type text, numbers, or formulas, which uses content from other cells. Spreadsheets are useful because when you enter a new data, the formulas are automatically updated.

Using the Help Option

If you are unsure of anything, Microsoft Office already provides you with numerous of answers in the Help Option. You can type your specific question or you can browse the most common questions asked in Microsoft Excel, like formulas, or charts. You can access Excel Help by pressing F1 on your keyboard or by clicking on the question mark icon on the top right corner.

How to enter data?

When entering data, it is important to know how to do it correctly. A tiny mistake in typing can be catastrophic, so one must be careful. It is also important to know which operators to use to perform the basic mathematical operations. We use the plus sign (+) for addition (2+2= 4), we use the minus sign (-) for subtraction (5-3= 2) and negation (-1), we use the asterisk (*) for multiplication (3*3= 9), we use the forward slash (/) for division (2/2= 1) and we use the caret (^) for exponential (4^2 = 16).

When typing an equation or formula, the first thing that must be entered is an equal sign (=). The equal sign makes it possible for Excel to calculate your equation. Another thing that you must know is that the use of parenthesis is extremely important. If you don’t place a parenthesis in the right position, you will end up with an entirely different answer than the one you desire. For example, 5+2*3 (= 11) is not the same as (5+2)*3 (=21). To correctly use the parenthesis, you must remember the Order of Operations. First, you perform the calculations inside the parenthesis, then all the multiplications and divisions (from left to right), and finally all the additions and subtractions (from left to right).

How to use Formulas?

To correctly insert a formula, you must first know a few basic rules. There are two ways in which you can create a formula, by typing or by clicking. When clicking, you just select with your mouse the cells that you want to use. When typing, it is important to learn how to refer to the cell that you want. For example, if you want to add cells B1 and C1, you type =B1+C1, press enter and the cell provides you with the answer. When referring to cells, you use the colon (:). Here is a little table to understand how to refer to cells.

To Select
Type In
Click On
Click on A1
A1, A2, A3
Click on A1, and drag to A3
A1, B1
Click on A1, and drag to B1
A1, B3
A1, B3
Click on A1, type in comma or hold down control key, and click on B3
A1, A2, B1, B2
Click on A1 and drag to B2

Microsoft Excel even provides us with a set of predetermined formulas that make calculating data even simpler. You can look over these formulas in the Formulas Tab (it’s even divided it by categories). But sometimes it is easier to just type in the formula. To make things a little easier for you, here is a screencap of a spreadsheet that I created, where you can find some of the formulas that I find are the most common and how to use them.

Now, let’s put what we learned into practice!

Let’s suppose that you have opened a brand new store, let’s call it YadiraE’s Place, and you need to know how much money you are making on its first quarter. Well, you create a chart with the earnings of each product for the first 3 months. You add the columns and to determine the total for product and add the rows to determine the monthly revenue. Once you have added all your information, it’s time to create a chart so that you compare your total revenue.

Spreadsheet with original data
Spreadsheet with original data
Spreadsheet with formulas
Spreadsheet with formulas
Spreadsheet with Total Revenues
Spreadsheet with Total Revenues
Bar Chart: Earnings per month
Bar Chart: Earnings per month
Pie Chart: Total Percentage
Pie Chart: Total Percentage
Column Chart: Total Earnings per product
Column Chart: Total Earnings per product

Creating Charts

For creating a chart, all you have to do is select the data and go to the Insert Tab and select the type of chart that most suits you. Here are a few examples of the type of charts that you can create using Microsoft Excel.

Tips and Tricks for Using Microsoft Excel

  • Always save the files in Excel 2003-97 compatible mode. This is just in case the file is open in a computer that doesn’t have Microsoft Excel 2007 or higher.

  • Inserting Rows and Columns – There are a few ways to do this, but the easiest way is to select the column (or row) that will go after the desired column (or row) and select Insert on the Home Tab, or simply right click and press Insert.

  • Hide rows (or columns) – Select the row (or column) that you want to hide and select Format and select Hide or Unhide (Home>Format>Hide/Unhide). Even easier, simply right click and press Hide or Unhide.
  • Autofill – Instead of entering data manually, you have an option where Autofill does it for you. NOTE: This option is for data with a pattern, like a sequence of numbers or the months of the year, etc. You select the data that you want to Autofill and move your cursor to the bottom right corner where you will see a little cross, and then you will drag down until the desired input.

  • Sort and Filter– If you need to sort data, either from smallest to largest, from A to Z, or a custom sort, or create a Filter, all you need to do is select the data and select the Sort and Filter Button (Home>Sort & Filter). When you use the Filter option, in addition to sorting data, you can also sort and filter by color, and you can filter the data by what it contains, if its equal or not equal to a certain number, greater than or less than a certain number, and many others.

  • Freeze Panes – When you have a spreadsheet with numerous rows or columns, it can be annoying to be constantly going back and forth from top to bottom. This is where the Freeze Pane option comes in handy. (View Tab>Freeze Pane)

  • Format Painter – The format painter is an option to match format of a cell to those of another cell. This option can be found on the Home Tab.


    0 of 8192 characters used
    Post Comment
    • profile image

      Joseph Chegere 

      10 months ago

      Good enough

    • Nahid Sharif profile image

      Nahid Sharif Komol 

      17 months ago from Uttara, Dhaka-1230, Bangladesh

      Many Many thanks for sharing steps of Microsoft Excel to us.

      I had a serious lack of this software but you made it very clear to me.

    • profile image

      Kamran Habib 

      2 years ago from Houston,Texas

      very good article.I aslo wrote a step by step tutoriol on it.visit here to get step by step Excel tutoriol.Follow the link below

    • profile image


      2 years ago

      Very Good work, thanks alot.

    • profile image


      2 years ago

      Somebody know where I find the code to VBA?

    • profile image


      3 years ago

      I have some very basic knowledge of Excel but lacking in making a spreadsheet using formulas. I am trying to create a spread sheet showing the pay down of a bill. At the top is the total I owe and as I make a payment in that column, I want the total at top to reduce every time I make an entry. What would be the formula?

    • profile image


      4 years ago

      When I use Auto Sum, sometimes I can only get hash tags! Help please.

    • YadiraE profile imageAUTHOR


      4 years ago from Puerto Rico

      I am glad you have found these tips useful! I hope to create a new article soon!

    • mediaamel profile image

      Belajar Microsoft Word 

      4 years ago from Indonesia

      wow... nice tutorial

      long time i'm fine this tutorial ms excell...


    • profile image


      5 years ago

      very thanku

    • Niko Linni profile image

      Nicholas Leonard 

      5 years ago from Las Vegas, Nevada

      Nice! I'm pretty familiar with Excel myself but popped in to see if there's some tricks I don't know (Because hey, you never know this day and age if you've missed something). But this is very informative, and does a nice job of walking people through the basics of Excel, which itself is a very useful tool for almost anyone. Good work!

    • Nasir Syaran profile image

      Nasir Syar'an 

      6 years ago from Jepara

      Yes Excel is great, @yadiraE. Excel can make complex program like accounting that automatically process from journal to financial and analysis report. Excel have macro that can do anything include create catalog or price list quickly with picture. I write tutorial about create catalog quickly here...

    • serialkisser4u profile image


      8 years ago

      Pretty informative & written logical. Do post on power point tips if u hve one .... :)

    • YadiraE profile imageAUTHOR


      9 years ago from Puerto Rico

      You are welcomed! Excel is really great. If there are any questions about anything that I didn't answer in the hub, feel free to ask me!

    • applecsmith profile image

      Carrie Smith 

      9 years ago from Dallas, Texas

      Thank you so much for posting this hub. Very easy to follow your explanations/examples, and I have bookmarked this for future reference. I learned several new tips for my daily work with Excel. Voted up and useful!

    • YadiraE profile imageAUTHOR


      9 years ago from Puerto Rico

      Thank you! I love Excel and it really is simple to use. Happy that I actually taught you something!

    • sammyfiction profile image


      9 years ago from Australia

      Nice work on the excel tips :) learnt a couple new formulas to add to my arsenal. :) great and informative hub for only your first few!! weldone and keep it up.


    • YadiraE profile imageAUTHOR


      9 years ago from Puerto Rico

      Thank you! My pleasure! Glad to be of service.

    • agvulpes profile image


      9 years ago from Australia

      Thank you for this reference! I will bookmark for future reference ! Rated up :-)


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
    ClickscoThis is a data management platform studying reader behavior (Privacy Policy)