In this article we’ll discuss categories of functions – what they do and various examples – and to illustrate how they work, we’ll show you several example spreadsheets. We encourage you to follow along by creating your own spreadsheets.
Articles Tagged: Logical Formulas
Top 4 Most Important Financial Excel Formulas Explained
Top four important Excel formulas to help you get your finances under control.
Excel Tip: How to do Calculations on a Filtered List?
Auto filter is a wonderful thing isn’t it?
How to Decide Which Excel Lookup Formula to Use
If your intent is to someday become an Excel power user, you will need a solid understanding of all the lookup formulas available to you. Below is list of the most popular Excel lookup formulas with tutorials linked as reference.
Use SUMIFS to sum cells that match multiple criteria in Excel
Excel’s SUMIFS function extends SUMIF so you can add up values in a range of cells that meet multiple criteria. Learn to use the SUMIFS function here
How to Use INDEX MATCH
INDEX MATCH is one of several lookup formulas available in Excel. It has certain features that make it superior to VLOOKUP in many situations
Why INDEX-MATCH Is Far Better Than VLOOKUP or HLOOKUP in Excel
I believe, one should ever use LOOKUP functions is you might not know how to use INDEX-MATCH or you might be working with beginners or freshers who sort of understand VLOOKUP but who know nothing about INDEX-MATCH. If that’s the problem, I hope this post will help.
Why Do You Need Formulas and Functions?
If you are an office administrator, you probably use Excel. Ditto if you are a salesman. If you are a financial analyst, of course, you need Excel. For these and many other professions, working with spreadsheets is an essential tool in the daily routine.
Simple Excel Tips and Tricks
Excel is software developed by Microsoft and is one of the most essential parts of Microsoft Office. It is a spreadsheet application capable of performing mathematical calculations, storing data in form of rows and columns and a lot of business applications.
Excel Formulas: 10 Formulas That Helped Me Keep My Job
Don’t waste any more hours in Microsoft Excel doing things manually. There are many ways to use Excel formulas to decrease the amount of time you spend in Excel and increase the accuracy of your data and your reports.