Skip to content
Data Analytics Logo
  • Home
  • About Us
  • Course Portfolio
    • Microsoft Excel for Professionals
    • Microsoft Excel Advanced Master Class
    • Power BI
  • Blog
  • Photo Gallery
  • Register
  • Menu

Tag Archives: PivotTable

Sort Numeric Values in PivotTable in Two Ways

Posted on February 14, 2020April 5, 2020 by Abiola David | No Comments

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to sort numeric values in PivotTable in two ways. Let’s get started In the caption below, we have data to work with First Method We want to sort the Sum of Total in Descending Oder in the first PivotTable Report Click on the Account Manager […]

Continue reading→

Distinct Count In Pivot Table: Sales Example

Posted on December 16, 2019December 16, 2019 by Abiola David | No Comments

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to count distinctive values in Pivot Table. Let’s get started In the caption below, we have a data set of 1040 transaction records. In addition, the data set is formatted in Excel Table using CTRL + T We want to ascertain how many unique Customers purchased […]

Continue reading→

Blog Posts

  • Convert Numbers to Proper Time Format in Power Query
  • Transform Report to Dataset using Power Query
  • Combining TEXTBEFORE & TEXTAFTER Function with SUMIFS in Excel
  • APPEND Data From Multiple Sheets & Get Total Row using VSTACK & HSTACK
  • Brand New TEXTSPLIT, TEXTAFTER & TEXTBEFORE Functions
  • How SWITCH Function will make you the “Go-to Person”
  • Dynamic Array FILTER by Month & Quarter
  • ADVANCED Filter Super Trick to Reorder Entire Columns without Criteria
  • 3 Hidden Tips & Tricks You Probably Don’t Know About ADVANCED Filter
  • Author LAMBDA Custom Function using New Advanced Formula Editor
  • Calculate Sales Commission for Weekdays & Weekends using Power Query M Code
  • New Automatic Searchable Dropdown in Excel [No More Formula-Based Solution]
  • Conditional Formatting using XLOOKUP and FILTERS Functions in Excel for the Web
  • Create Workbooks from Worksheets using VBA
  • Power Query Classic COUNTIFS | SUMIFS | AVERAGEIFS | MAXIFS | MINIFS Calculations [Simply Amazing]

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme