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: Sort

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→

Blog Posts

  • Linear Equation Computation and Graph in Excel
  • Get & Append Data From GOOGLE SHEETS and MICROSOFT ACCESS to Create Excel PivotTable Report
  • Dynamic FILTER BETWEEN YEARS using Power Query and Data Validation
  • Merry Christmas in Random Font Colors
  • CONDITIONALFORMATTING Custom Function using XLOOKUP & LAMBDA Functions
  • SUMBETWEENMONTH Custom Function using SUMIFS | LET | LAMBDA Functions
  • TEXTSPLIT Custom Function using New LAMBDA Function
  • Spearman’s Rank Correlation Coefficient in Excel with Geography Data Type
  • New Auto-expand Drop-down List Technique in Excel
  • Stunning Stacked Column Chart with Heart
  • Send Bulk Email in Excel using Power Automate
  • Cross Tabular Report using VLOOKUP Function
  • 5 Keyboard Shortcuts To Format Data As Excel Tables
  • Power Query Data Types [The Game Changer]
  • VLOOKUP with Array Constants

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme