Sunday, August 7, 2016

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.

23 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
  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

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Contact Form

Name

Email *

Message *

Mad About Computer. Powered by Blogger.