Excel RSQ Function Tips

Two dimensional lookup is obvious – we have a header row and a column and we want to look at the intersection of the two criteria’s.

Let’s assume you are a math’s teacher interested in finding the average of the math’s score of last five students – he is interested in finding why they are performing poor. How will he proceed?

Whenever we have data, we are interested in getting some meaningful insights from it.

Shortcut to include today Just press control key and semicolon (Ctrl + ;) in any cell, enter. This will enter today’s date in to the cell.

One of the most versatile and highly used functions is VLOOKUP. Whenever we have a table and want to quickly retrieve a value, we have to revert to VLOOKUP. Let’s take a quick dive into its use and how we can get maximum out of its use.

SUMIF() functions is among the most commonly used functions in excel. Whenever ever we have to sum against a given criteria we revert to this function, be the criteria be only one or more then one (for more then one criteria’s we use SUMIFS(), just another function of this family).

There several ways to create in cell and that includes Excel’s built in Sparklines or using a third party Sparkline Add in, But there are ways to produce bar charts by using Excel without using these feature.

When we are developing a model or trying to test some formula, we need data and when we don’t have one, we have to create it to suit our needs. This is frequently called dummy data.

**Excel** has pivot tables that offer different types of calculations. You can start off with it by selecting the ‘Show Values As’ option. Then you can get the calculation of the **‘Percent of Row Total’** as well.

**Microsoft Excel’s VLOOKUP function is a popular feature amongst office personnel and data processor positions. **

A data set’s comparative view can easily be represented visually with the aid of a heat map

In Excel, spell checker is a tool that used to recognize errors incorrectly-spelled words. Which is highly useful since you don’t have to manually check all the words that you typed in excel.

VLOOKUP stands for Vertical Lookup. Learning vlookup is very easy but let’s first understand how VLOOKUP works?

When you have some **data columns** that you don’t want to display can be hidden from the sheet.