Present

Remember the time when after your report is completed you go to every sheet in your file and do CRTL+ Home.

Though it may be a boring task to do when you have many sheets, it is an important task to make your report presentable. 

Now with the below addin you just need to click on the addin and it will do the same for you.

Click here to download Addin

To know how to add Addin Click Here.

Countifs()

Countif is used when you have multiple criteria to count in a single go.

In below example there are two columns "Region" and "Products" sold. Management wants to know how much quantity is sold in a region for a specific product. 

In the formula first you have to select Criteria1 range (Column D) then Criteria1 (cell h5) and then select Criteria2 (Column E) range then Criteria2 (cell I5). You can select any number of criteria, but sometimes if number of criteria are too many excel might crash. 

 Example:

How to add Developer Tab in Excel

Developer tab is require to see options for macros, to create macros and for macro related features.

Developer tab is just like an ordinary tab such as "Home" tab, can be added  by below 3 simple steps.

Step 1: Go to "File" tab then "Options"
Step 2: In "Options" go to "Custom Ribbon"
Step 3: To your right hand side under "Customize the Ribbon" check on developer tab and press OK.

You can now see it next to "View" tab.