Sumit

Sumit is a Google Sheets and Microsoft Excel Expert. He provides spreadsheet training to corporates and has been awarded the prestigious Excel MVP award by Microsoft for his contributions in sharing his Excel knowledge and helping people.

Articles by Sumit

Browse all posts and insights written by Sumit.

59811Both slicer filter conditions are satisfied

How to Use a Google Sheets Slicer

The slicer is a really handy feature of Google Sheets. It enhances the power of Pivot Tablesย and Pivot Charts in Google Sheets. With a Google Sheets Slicer, you can analyze your data much more interactively. You can create really amazing-looking and interactive reports and dashboards right within your Google Sheets worksheet! In fact, once youโ€™ve […]

59784 Computer with spreadsheet

How To Group Columns in Google Sheets (Easy 2024 Guide)

Why do you group columns in Google Sheets? Grouping columns in Google Sheets is a great way to organize your spreadsheet and make it easier to navigate. You can do this by selecting your cells and then going to โ€œViewโ€ > โ€œGroupโ€ in the menu bar. This differs from merging cellsย because it allows you to […]

59737Convert to hours using TIMEVALUE

How to Convert Time to Decimal in Google Sheets

If your dataset contains date and time values, there might be situations where you need to convert them to decimal numbers. For example, you might want to convert the difference between the start and end time of a particular task, into a decimal number. This can act as an indicator of the number of hours […]

59739Operator in COUNTIF

Comparison Operators in Google Sheets (A Complete Guide)

Google Sheets lets you use six comparison operators to make comparisons between values and return a TRUE or FALSE value. These operators can be easily incorporated into IF statements or used as they are. They are also used in filters, conditional formatting operations, comparing columns, and datasets, and much more. In this article, we will […]

59699 formula parse error guide

Google Sheetsโ€™ Formula Parse Error: 9 Easy Fixes

Whether youโ€™re a beginner or an expert spreadsheet user, youโ€™ve come across a formula parse error at some point. While these issues are frustrating, Iโ€™m here to walk you through solving and preventing common formula parse errors like #REF, #DIV, #ERROR, and #NUM. Letโ€™s get started!ย  What Is a Formula Parse Error? A formula parse […]

59665 Click on Add Values button

How to Add & Use Calculated Fields in Google Sheets Pivot Tables

If youโ€™ve worked with Pivot tables, you would know that they are a great way to summarize large sets of data. One, because they let you group data in a wide range of ways, and two, they let you use a number of summarizing metrics to analyze your data. To add to their versatility, pivot […]

59640Data grouped by month and year in Google Sheets Pivot Table

How to Group by Month in Pivot Table in Google Sheets

You can never understand the true power of spreadsheet tools such as Google Sheets and Excel until you master the use of Pivot tables. These tables can bend and turn your data to squeeze out just the information you want to know. In this way, you get to understand your data in ways that simple […]

59633How to Refresh Pivot Table in Google Sheets

How to Refresh Pivot Table in Google Sheets

Pivot tables are powerful tools that let you gain very useful insights into your data. A common question on a lot of Google Sheets forums is โ€œHow to Refresh Pivot Tables in Google Sheets?โ€ How to Refresh Pivot Table in Google Sheets In general, Pivot tables donโ€™t need to be manually refreshed. They get automatically […]

59498Every fouth row is hidden

How to Delete Every Other Row in Google Sheets (Easy Formula Trick)

The Google Sheets filter is a powerful tool that can help you manipulate how your spreadsheet data displays nondestructively. For example, you can use this feature to delete (or hide) every other row in Google Sheets. By using the correct filter, you can use Google Sheets to delete every other row or take it a […]

59473Bell Curve in Google Sheets

How to Make a Bell Curve in Google Sheets?

A bell curve is a useful graph for comparing how data points compare to the rest of the data. I am sure you have heard of people talking about getting an appraisal based on the bell curve.   This graph helps demonstrate where the majority of data points exist in a graph, how close those […]

59428CSV file in Text Editor

How to Import CSV into Google Sheets – An Easy Guide

Comma-separated value, or CSV, is a non-standardized plain text data file format used to store and exchange tabular or spreadsheet information. While CSV files omit any sort of formatting information, their plain text nature makes them very easy for any program to interpret. What makes CSVs so useful is they provide a practical way to […]

59398 Apply the formula to the entire column

How to Use The Google Sheets SWITCH Function [Easy Guide]

The Google Sheets SWITCH function is a helpful tool for changing how a cell behaves based on the value in another cell. It’s incredibly useful in data interpretation and presentation. To understand the SWITCH function, think of it as a function that can check multiple IF conditions. For example, you can check whether is a […]

Access All

Free Templates

Enjoy our custom-made Google Sheets templates for free via email access