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

0
Excel Formula to Copy Cell Value to Another Cell

In this dataset, there are five people’s First Names, Last Names and Ages. Using Excel formulas, we will copy cell value from this dataset to another cell. ...

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

In this sheet, we have a table of 5 people with their ages. Let's auto-generate numbers for each of them. Generally, the serial numbers or IDs go to the left ...

0
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 ...

0
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 ...

0
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 ...

1
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, ...

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

  Method 1 - Using Direct Formula to Subtract Percentage Values in Excel Consider the Percentage of Total and Spent Amount dataset shown in the B4:C13 ...

0
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 ...

0
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? ...

0
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 ...

0
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

 

 

ExcelDemy
Logo