Skip to content
Excelgraduate Site Logo

Excelgraduate

Learn, Excel, Succeed

  • Home
  • Blog
  • CategoriesExpand
    • Basic Excel
    • Advanced Excel
    • Excel Functions
    • Excel Formulas
    • Pivot Table
    • Power Query
    • Visual Basic
    • Excel for Business
    • Excel Glossary
  • About
  • Contact
Excelgraduate Site Logo
Excelgraduate
Learn, Excel, Succeed
Power Query IF Statements with Multiple Criteria
Power Query

Power Query IF Statements with Multiple Criteria [2 Examples]

Rhidi Barma December 18, 2023 Power Query

IF statements in Power Query can be used with multiple criteria. This feature allows you to apply conditional logic in…

Read More Power Query IF Statements with Multiple Criteria [2 Examples]Continue

Custom Column Nested IF statement Formula
Power Query

How to Use Nested IF Statements in Power Query [5 Examples]

Rhidi Barma December 18, 2023 Power Query

In Power Query, a nested IF statement involves embedding one or more IF statements within another. This allows for the…

Read More How to Use Nested IF Statements in Power Query [5 Examples]Continue

Ungrouped Date in Pivot Table from Ribbon option to ungroup date
Pivot Table

How to Ungroup Date in Pivot Table in Excel [2 Methods]

Rhidi Barma December 16, 2023 Pivot Table

Excel Pivot Tables are powerful tools for organizing and analyzing data, especially when dealing with date-related information. Occasionally, you may…

Read More How to Ungroup Date in Pivot Table in Excel [2 Methods]Continue

Selected Years and Months from Grouping dialog box in Excel Pivot Table
Pivot Table

How to Group Dates by Month and Year in Excel Pivot Table

Rhidi Barma December 16, 2023 Pivot Table

When dealing with date-related data, grouping dates by month and year can provide a clearer picture of trends and patterns….

Read More How to Group Dates by Month and Year in Excel Pivot TableContinue

Grouped by different intervals in Excel Pivot Table
Pivot Table

2 Ways to Group By Different Intervals in Excel Pivot Table

Rhidi Barma December 16, 2023December 16, 2023 Pivot Table

Excel Pivot Tables are renowned for their versatility in data analysis, offering users the ability to unravel insights from complex…

Read More 2 Ways to Group By Different Intervals in Excel Pivot TableContinue

Entered new group name in the formula bar to rename group
Pivot Table

2 Ways to Rename Group in Pivot Table in Excel

Rhidi Barma December 16, 2023 Pivot Table

To rename a group in Pivot Table in Excel, go through the steps below: Click on the cell containing the…

Read More 2 Ways to Rename Group in Pivot Table in ExcelContinue

Displaying error message of "Cannot group that selection" in Excel Pivot Table
Pivot Table

How to Fix “Cannot group that selection” in Excel Pivot Table

Rhidi Barma December 16, 2023December 16, 2023 Pivot Table

In a Pivot Table, you will need to group selections in Excel. While trying to group a specific selection in…

Read More How to Fix “Cannot group that selection” in Excel Pivot TableContinue

Grouping dialog box to group Pivot Table by month in Excel
Pivot Table

How to Group Pivot Table by Month in Excel [Step-by-Step]

Rhidi Barma December 16, 2023December 16, 2023 Pivot Table

Pivot Table in Excel is a powerful tool to organize and summarize data by date and month. This functionality allows…

Read More How to Group Pivot Table by Month in Excel [Step-by-Step]Continue

Right-clicked on the grand total column to sort by grand total in Excel Pivot Table
Pivot Table

How to Sort Pivot Table by Grand Total [Step-by-Step]

Rhidi Barma December 16, 2023 Pivot Table

One essential feature of pivot tables is the ability to sort data, and while sorting individual columns is a common…

Read More How to Sort Pivot Table by Grand Total [Step-by-Step]Continue

Excel Pivot Table Sort by sum
Pivot Table

How to Sort Pivot Table by Sum in Excel [2 Cases]

Rhidi Barma December 16, 2023December 16, 2023 Pivot Table

By sorting the Pivot Table by sum in Excel in descending or ascending order, users can quickly identify the highest…

Read More How to Sort Pivot Table by Sum in Excel [2 Cases]Continue

Page navigation

Previous PagePrevious 1 … 11 12 13 14 15 … 35 Next PageNext
  • About
  • Blog
  • Contact

Excelgraduate

A to Z Solution Provider

DMCA.com Protection Status
  • Disclaimer
  • Privacy Policy
  • Terms & Conditions
YouTube YouTubeFacebook FacebookTwitter TwitterLinkedin LinkedinPinterest Pinterest

Copyright © 2025 Excelgraduate | All Rights Reserved.

Scroll to top
  • Home
  • Blog
  • Categories
    • Basic Excel
    • Advanced Excel
    • Excel Functions
    • Excel Formulas
    • Pivot Table
    • Power Query
    • Visual Basic
    • Excel for Business
    • Excel Glossary
  • About
  • Contact
Purchase
Search