8/7/16

Basic Excel Formulas


In this tutorial I will teach you some basic excel formulas which is help to prepare your data and also save your time. Why we use or learn excel. Microsoft Excel is an easy way to create your data and it save your time. In Excel, you can use more than two hundred formulas which are very helpful to prepare data. In this tutorial, I will teach you five basic excels formula which is ever used. These Formulas you should definitely know. I hope will you really enjoy this.
People Also Read:- How to crack excel password?

SUM FORMULA:-   Sum formula is a most used formula in excel. When you work on excel spreadsheet, you must have to use this formula in excel. Sum formula allows adding two or more cells. For example you have to add 4 + 5 in excel, then you have to write in excel cell =4+5 then press enter and excel displayed 9 as answer.
SUBTRACT FORMULA:-   Subtract formula is a most used formula in excel. Subtract formula allows subtracting two or more cells. For example you have to add 20 - 5 in excel, then you have to write in excel cell =20-5 then press enter and excel displayed 15 as answer.
LEN FORMULA:-  when we have to count the words including space in a cell, then we will use this formula. Suppose you have write MAHESH MISHRA in a cell and put the Len formula in next cell =Len(cell no) and enter, excel displayed 13.
DATE OR TIME FORMULA:-  when we want to displayed  time or date on spreadsheet. We have to use date or time formula in excel. it is one of the most important formula in excel. See below image to better description about this formula.
COUNT OR COUNTA FORMULA:-  when you want to count the numerical cells then we have to use count formula. Note count formula always count the numerical cells, it never count alphabetical or blank cells.
When you want to count the whole cell data, do not matter cells are alphabetically, numerical or special character then we have to use counta formula? Note counta formula never count blank cells.
Data Consolidate by Using Category, and Using Position, Sumif or Average formula, Conditional formatting.
In this tutorial you have learned about some basic excel formulas. If you have any doubt related this post please let me know through your comment and if you like my post doesn’t forget to share Facebook or Twitter.

34 comments:

  1. Thanks for sharing this excel formulas.It is really useful.Continue sharing more like this.
    Regards,
    Excel Advanced Training | MS excel Training in Chennai | Excel Macro Training in chennai

    ReplyDelete
    Replies
    1. Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important.Project Center in Chennai

      Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.

      Spring Training in Chennai

      The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. Hi, like you post its more informative and thanks for sharing with us.
    Digital marketing course in chennai

    ReplyDelete
  3. Your website content nice nice and interesting to observe.
    jobbörse Neunkirchen

    ReplyDelete

  4. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.

    SELENIUM TRAINING IN CHENNAI

    ReplyDelete
  5. I read our full content was really amazing,then the this more important in my part of life.
    The given information very impressed for me really so nice content.


    white label website builder

    ReplyDelete
  6. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.

    Microsoft Azure Admin Training in Chennai
    Microsoft Azure Admin Training

    ReplyDelete
  7. Fast forward to the finish of Jedrzejczyk's scrum alongside a reporter reunite into asking her to receive a prediction. When Jedrzejczyk disclosed she had been 50/50, the reporter then shifted to asking her about McGregor's behavior.
    UFC 229 Live Free

    ReplyDelete
  8. Its my great pleasure to visit your blog and to enjoy your great posts here. I like it a lot. I can feel that you paid much attention for those articles, as all of them make sense and are very useful.  https://kissenglishcenter.com/tu-vung-tieng-anh/

    ReplyDelete
  9. My first time to visit here in the blog. I am reading the all point of in the blog review is very good. Thanks for sharing in the information. Download free anything you like on instagram with site picbear

    ReplyDelete
  10. شرکت تلکا هاست پیشرو در میزبانی انواع وب سایت و هم چنین دارای انواع خرید هاست ارزان با کنترل پنل سی پنل میباشد.حتما از سایت ما دیدن کنید و از قیمت های مناسب برای انواع سرویس های وب و ثبت انواع دامنه شگفت زده شوید.

    ReplyDelete
  11. I appreciate this article for the well-researched content and excellent wording. I got so interested in this material that I couldn’t stop reading. Your blog is really impressive. Deepnude download

    ReplyDelete
  12. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. monthly budget templates

    ReplyDelete
  13. Nice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision. 
    Digital Marketing Course in Chennai
    Digital Marketing Courses in Bangalore
    Digital Marketing Course in Delhi
    Digital Marketing Online Course

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Contact Form

Name

Email *

Message *

Mad About Computer. Powered by Blogger.