Excel Formulas - QuadExcel.com

14 Advanced Excel Tips and Tricks for Basic to Intermediate Users

Whether you’re an Excel power user or just reasonably experienced with spreadsheets, there are generally still things you can learn about Microsoft’s program, and points which can be refreshed in your memory. So, we’ve put together this compilation of 14 tips for those of you using Excel 2010, going over some important features – and making sure you’re making the most of them. Also, some of these tips cover essential Intermediate to Advanced-level skills that you should know no matter what version of Excel you use.

How to Define a Named Range in Excel? What are the top 3 uses of Named Ranges?

Another underused feature of Excel is Named Ranges. Named Ranges allow you to assign a meaningful name to a cell or a range of cells and then use that name instead of the actual cell reference in your formulas. A name is easier to remember when you are constructing your formulas.

How to select cells that only contain Text, Number or Error in Microsoft Excel

At times you may want to select the cells that have specified type of data in it, by which you can distinguish between cells that contain different types of data, which allows you to delete, fill or lock cells by the data type for various other reasons.
Bonus Tip: How to use formulas to highlight the cells that only contain Text, Number or Errors

How to Highlight a Row in Excel Using Conditional Formatting

You can use conditional formatting to format or color the cells based on their contents. For example, you have a cell to turn red when it contains text ‘No’ or a value less than 90%. But how do you highlight an entire row? When a cell contain specified content.
This tutorial will help you learn how to highlight other cells based on a cell’s value? To see how this was done, read on.

How to extract initials from names in Excel?

Here I introduce few tricks to quickly extract initials from the name list in Excel, like TCS for Tata Consultancy Service and JFK for John F Kennedy. Check in here to learn how to do it.

How to Convert a Date to Calendar Quarter?

An easy formula that returns the quarter for a given date. There’s no built-in function in Excel that can do this. Check in here to learn how to do it quickly.

How to get the Last Numeric Value in a Column?

Returning the final value in a column is particularly useful for spreadsheets that involve running balances, where you want to reference the final balance regardless of whether it is the smallest or largest value in the column.

How to Calculate Age in Excel Accurately?

Some or the other time, we would want to calculate the Age in Excel, and more often people get frustrated as they show up a little different results than expected with A day more or less and either it shows the months completed or the current running month.

Today I will show few popular Excel Formulas in practice which will calculate the Age between given Start Date and End Date in Excel and learn how accurate they are. And also we will learn those Super Hero Formulas that gives us the accurate results!

How to use SUMIFS with multiple criteria in same column in Excel

SUMIFS() lets you sum values by multiple conditions in multiple columns. But how about applying multiple conditions on single column? For example If you write a formula like =SUMIFS(F:F,B:B,”A”,B:B,”C”) despite the ‘Column B’ having ‘A’ and ‘C’ in it you will get ‘0’ as result. Confused? Do not worry this article will help you learn the trick to over come the SUMIFS limitations.

How to VLOOKUP with Multiple Criteria in Multiple Column

VLOOKUP is definetly a great tool to get the data from tables, however it has limitations: it can only work with one criteria for matching information. What If you need to refer two or more conditions to match a specific piece of data, VLOOKUP will only get the first match in the data. Fortunately Excel has functions called INDEX and MATCH that works same as VLOOKUP but with multiple criteria. Here’s a quick tutorial to help you learn how…