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.
Thanks for sharing this excel formulas.It is really useful.Continue sharing more like this.
ReplyDeleteRegards,
Excel Advanced Training | MS excel Training in Chennai | Excel Macro Training in chennai
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
DeleteSpring 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
The Walking Dead Season 7 Episode 9
ReplyDeleteWatch The Walking Dead Season 7 Episode9
The Walking Dead Season 7 Episode 9 Online
The Simpsons Season 28 Episode 14
The Simpsons Season 28 Episode 14 Online
Zumanity Cirque du Soleil
Zumanity Cirque du Soleil Las Vegas
Grammy Awards 2017
ReplyDeleteGrammy Awards 2017 Live
Grammy Awards 2017 Stream
Grammy Awards 2017 Online
Watch Grammy Awards 2017
Grammy 2017
Hi, like you post its more informative and thanks for sharing with us.
ReplyDeleteDigital marketing course in chennai
ReplyDeleteWrestleMania 33
WWE WrestleMania 33
WrestleMania 33 live
WrestleMania 33
WWE WrestleMania 33
WrestleMania 33 live
Masters 2017
ReplyDeleteThe Masters Golf
The Masters 2017
Masters 2017 Live
Masters 2017 Live Stream
Kentucky Derby 2017
ReplyDeleteWatch Kentucky Derby 2017
2017 Kentucky Derby
Kentucky Derby
Kentucky Derby 2017 Live
Canelo vs Chavez
Canelo vs Chavez jr
Alvarez vs Chavez
ReplyDeleteAlien Covenant
Alien Covenant 2017
Alien Covenant Download
Download Alien Covenant
Watch Alien Covenant
Watch Alien Covenant Online
Alien Covenant Full movie Free
Alien Covenant Free Full movie
Alien Covenant Full movie Free Download
Download Alien Covenant Full Movie
ReplyDeleteAlien Covenant
Alien Covenant 2017
Watch Alien Covenant Online
Alien Covenant Full Movie
Watch Alien Covenant
Alien Covenant Full movie Free
Alien Covenant Free Full movie
Alien Covenant Full movie Free online
Alien Covenant Full movie Free Download
Download Alien Covenant Full Movie
Alien Covenant Download
Download Alien Covenant
Pirates of the Caribbean Dead Men Tell No Tales
ReplyDeletePirates of the Caribbean
Watch Pirates of the Caribbean Dead Men Tell No Tales
Watch Pirates of the Caribbean
Pirates of the Caribbean Dead Men Tell No Tales Full Movie
Pirates of the Caribbean Dead Men Tell No Tales Full Movie Download
Pirates of the Caribbean Full movie
Pirates of the Caribbean Full movie Download
Pirates of the Caribbean Dead Men Tell No Tales 2017
Pirates of the Caribbean 2017
Nice Blog.Thank you for Sharing. I'm working in erp software solution in chennaiwe are leading cloud erp software solution in chennai
ReplyDeleteUFC 213
ReplyDeleteUFC 213 Live
213 UFC
Watch UFC 213
UFC 213 Fight
UFC 213 Live Stream
Watch UFC 213 Live
Nunes vs. Shevchenko 2
UFC 213 Nunes vs. Shevchenko 2 Live
UFC 210 Fight Card
Thanks this worked Filesidaly
ReplyDeleteThanks for these excel formulas. Computer Software Download
ReplyDeleteYour website content nice nice and interesting to observe.
ReplyDeletejobbörse Neunkirchen
ReplyDeleteNeeded to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.
SELENIUM TRAINING IN CHENNAI
I read our full content was really amazing,then the this more important in my part of life.
ReplyDeleteThe given information very impressed for me really so nice content.
white label website builder
Nice post.
ReplyDeleteDigital Marketing Course In Chennai
Digital marketing Courses
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.
ReplyDeleteMicrosoft Azure Admin Training in Chennai
Microsoft Azure Admin Training
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.
ReplyDeleteUFC 229 Live Free
Great information you have been shared and it will be useful to everyone.
ReplyDeleteSpoken English Classes in Chennai
Best Spoken English Classes in Chennai
German Language Classes in Chennai
Japanese Classes in Chennai
spanish language in chennai
IELTS Coaching centre in Chennai
Spoken English Classes in Porur
Spoken English Classes in Adyar
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/
ReplyDeleteMy 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
ReplyDeleteThis post is so interactive and informative.keep update more information...
German Classes in Chennai
German Classes in Bangalore
German Classes in Coimbatore
German Classes in Madurai
German Language Course in Hyderabad
German language classes in bangalore
German language course in bangalore
German courses in bangalore
Selenium Training in Bangalore
Software Testing Course in Bangalore
I am inspired to read this blog. keep sharing more informaive blog.
ReplyDeleteData Science Course in Chennai
Data Science Courses in Bangalore
Data Science Course in coimbatore
Data Science Course in Hyderabad
Data Science Training in Bangalore
Best Data Science Courses in Bangalore
Data Science Institute in Bangalore
Data Science Training Institutes in Bangalore
AWS Training in Bangalore
DevOps Training in Bangalore
شرکت تلکا هاست پیشرو در میزبانی انواع وب سایت و هم چنین دارای انواع خرید هاست ارزان با کنترل پنل سی پنل میباشد.حتما از سایت ما دیدن کنید و از قیمت های مناسب برای انواع سرویس های وب و ثبت انواع دامنه شگفت زده شوید.
ReplyDeleteI 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
ReplyDeleteI 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
ReplyDeleteNice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision.
ReplyDeleteDigital Marketing Course in Chennai
Digital Marketing Courses in Bangalore
Digital Marketing Course in Delhi
Digital Marketing Online Course
Wonderful blog. Keep on blogging to get new information.
ReplyDeletestrategic crm
importance of artificial intelligence
where is python language used
why cloud computing is used
oracle interview questions and answers
data science questions and answers pdf
Great post and I am very happy to see this blog. Good job...!
ReplyDeletePrimavera Training in Chennai
Embedded System Course in Chennai
Embedded Training in Coimbatore
Spark Training Institute in Chennai
Primavera Course in Chennai
This is the best post and Keep doing it. Thank you for your valuable efforts...!
ReplyDeleteOnline Content Writing Course
Content Writing Training in Chennai
Google Analytics Training in Chennai
Google Analytics Online Training
Đặt vé máy bay tại Aivivu, tham khảo
ReplyDeleteLịch bay từ Hàn Quốc về Việt Nam hôm nay
đặt vé máy bay hải phòng hồ chí minh
đặt vé máy bay từ huế đi hà nội
từ đà nẵng đi nha trang bao nhiêu km
vé máy bay đi đà lạt vietnam airline
taxi sân bay nội bài