Author: Faraz Shaikh

Faraz ShaikhLeave a Comment on Correct duplicate count in Microsoft Excel PivotTable (Cell Reference Method)

Correct duplicate count in Microsoft Excel PivotTable (Cell Reference Method)

PivotTables are an essential tool for data analysis in Excel, but when working with repetitive values, they may count all occurrences instead of unique records. This isn’t an issue with Excel itself but rather how the dataset is structured. In this blog, we’ll explore how to correctly count unique values in PivotTables using the COUNTIFS function, ensuring accurate reporting and analysis. Follow this simple step-by-step guide to fix duplicate count issues and enhance your Excel skills!

Faraz ShaikhLeave a Comment on Say Goodbye to Manual Filtering: Excel List Filter Add-in Made It Easy!

Say Goodbye to Manual Filtering: Excel List Filter Add-in Made It Easy!

Filtering data in Excel can be a repetitive and time-consuming task, especially when working with large datasets. If you’ve ever found yourself scrolling through long dropdown menus to select multiple values, you’ll know how frustrating it can get. The List Filter Add-In is designed to solve this problem by introducing a simple, efficient way to filter data.

Faraz ShaikhLeave a Comment on Power Platform: Transforming Business with Low-Code Apps with Charven Ligan

Power Platform: Transforming Business with Low-Code Apps with Charven Ligan

Video Tutorial About the Meetup Session Join us at this Excel Meetup to hear from Charven Ligan Philippines 🇵🇭 about Power Platform: Transforming Business with Low-Code Apps. In this insightful session, we’ll explore the significant business value that Microsoft Power Platform brings to organizations. We’ll begin by highlighting how Power Platform’s suite of tools can…

Faraz ShaikhLeave a Comment on Let the custom functions, in Power Query, do the work for you with Alejandra Horvath

Let the custom functions, in Power Query, do the work for you with Alejandra Horvath

About the Meetup Session Join us at this Excel Meetup to hear from Alejandra Horvath from Canada 🇨🇦 about Let the custom functions, in Power Query, do the work for you. In this session we will clean files with different structure and different amount of columns. We will create a custom function to process the…

Faraz ShaikhLeave a Comment on Troubleshooting Windows Blue Screen after CrowdStrike Update

Troubleshooting Windows Blue Screen after CrowdStrike Update

What is the Blue Screen of Death? The “Blue Screen of Death” (BSOD) is an error screen on Windows computers. It appears when the system encounters a serious problem it can’t fix on its own. Common causes of the BSOD include hardware failures, driver issues, and software conflicts. When this happens, your computer will need…

Faraz ShaikhLeave a Comment on How to Add Totals to a Clustered Column Chart in Excel [Step-by-Step Tutorial]

How to Add Totals to a Clustered Column Chart in Excel [Step-by-Step Tutorial]

Clustered column charts are a powerful tool for visualizing data comparisons in a concise and organized manner. However, sometimes it’s necessary to display not only individual values but also their totals within the chart itself. In this tutorial, we will walk you through the process of adding totals to a clustered column chart using Excel…

Faraz Shaikh1 Comment on Change mouse pointer color and size on Microsoft Windows 11

Change mouse pointer color and size on Microsoft Windows 11

Is it hard to find on your PC mouse finder, or sometimes while a presentation you need your audience’s eyes to follow with your mouse pointer then here is the trick. Under Related Settings click on the Mouse pointer We are done !!!