Shakil Ahmed

About author

My name’s Shakil. My articles are targeted to support you in enriching knowledge regarding different features related to Microsoft Excel. I am fond of literature, hope some knowledge from them will help me providing you some engaging articles even though some weary technical terms.

Latest Posts From Shakil Ahmed

Excel Formula to Copy Cell Value to Another Cell

Copying might be a monotonous phase while using Excel. Using formulas can bring some life to this copy task. The agenda for today’s tutorial is how to use ...

How to Auto Generate Number Sequence in Excel (9 Examples)

Often, serializing a lot of elements manually in Excel is boring. Fortunately, it is pretty easy to auto-generate number sequences in Excel. To get rid of this ...

How to Calculate Average Tenure of Employees in Excel

When you are calculating tenure or average tenure, Excel can be a handy tool for you. Today I am going to show you two easy and suitable methods to calculate ...

How to Calculate Age on a Specific Date with Formula in Excel

Excel can be handy while calculating age, you may wonder how you can do that easily. In this article, I will show you how to calculate age on a specific date ...

How to Convert Percentage to Basis Points in Excel

In the financial world, you may encounter the term Basis Points. It’s the usual hearing percentage and basis point simultaneously. Today In this article, we ...

How to Calculate Overdue Days in Excel (4 Easy Ways)

Today I’m going to show you how to calculate overdue days in Excel. Calculating overdue is a staple for any form of resource management. For this session, ...

How to Subtract a Percentage in Excel (3 Quick Ways)

Certainly, calculating percentages is a common task in our day-to-day lives. In countless situations, you may need to subtract a percentage, and this is where ...

How to Calculate Year over Year Percentage Change in Excel (with Advanced Technique)

Need to calculate year over year percentage change for your company? You can do that easily with Microsoft Excel. In today’s session, we will show you how to ...

How to Calculate Discount Percentage with Formula in Excel

Microsoft Excel is a powerful tool for basic and complicated calculations. With the help of it, you can easily calculate the percentage value, like a discount ...

How Do You Calculate Percentage Increase or Decrease in Excel

Microsoft Excel is a great tool for basic and complicated calculations. In today’s article, how do you calculate the percentage increase or decrease in Excel? ...

Selecting Non-Adjacent or Non-Contiguous Cells in Excel (5 Easy Ways)

In Excel, you can select adjacent cells very easily. It is a straightforward one. But selecting non-adjacent cells (you may also refer to them as ...

How to Print Selected Cells in Excel (6 Effective Ways)

As the use of Excel increases on a daily basis, we may need to have a printed hardcopy of our Excel spreadsheet. Varying on your work, you may want to print ...

Browsing All Comments By: Shakil Ahmed
  1. Bob, PivotTable is one of the prime features of Excel, so regardless of the version (contemporary versions) you should get it inside the “Insert” tab of the ribbon. But if you don’t find that there you may need to customize your ribbon. Click on File > Options, then follow the image pivottable to ribbon

    And if counting unique is your main goal right now you might get that using the UNIQUE function (and COUNT family function for counting).

  2. Thanks for commenting Merle, glad to hear that it helped you.

Advanced Excel Exercises with Solutions PDF