Ads

Sunday, 7 April 2019

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.



Saturday, 30 March 2019

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.



Saturday, 26 May 2018

Number Formats

This Addin will help you to change the format of the selected range to number formats listed below by just one click.

No Decimal: Number with no decimal.
Million: Number format will change to million.
Billion: Number format will change to billion.

Click Here to Download Addin

To know how to add Addin Click Here.



Monday, 21 May 2018

How to Add an Addin

Below steps will help you add Excel Addin to an Excel. (I am using Excel 2010 screenshot may differ in other versions)

1. Copy the Addin.

2. Go to File and click on Options.


3, Now Click on Addin at the bottom click on Go

4. Click on Browse, a Folder will open. Paste the Addin in the folder and click on open.

5. Now Go to File-Option-Customize-Choose command from(Select Macros)- Customize the Ribbon( Select Main Tabs)  

6. In Customize the Ribbon go to home and select the last option. Now click on New Group and Name the group.

7. Now click on the group and select the Addin you want to add in Choose Command From section and click on add.

8. After the macro is added in the new group click ok. Now the Addin will be visible in Home Ribbons.

For any queries drop a comment.

Sunday, 20 May 2018

Expand & Collapse Addin


Below is an Excel Addin that you can add to your excel.

To know how to add Addin Click Here.

This Addin will help you to Expand Or Collapse columns and rows grouped in all the sheets in an Excel Workbook/File.


Thursday, 10 May 2018

If(And())

If with And helps to add multiple conditions where all condition are required to be meet/fulfilled.
In the below example if first cell name is yellow and the other is green then the formula with return value as true or false.