Skip to content
ExcelProf.com
  • Home
  • Analytics Blog
  • Energy Blog
  • Book
  • Videos
  • Close Search Form     Open Search Form
Tag

Filtering

analytics
data
tutorial
video

Filter Data Right in your Pivot Table Fields!

One of the ‘hidden treasure’ in Pivot Table a lot of people do not know about is that you can filter data right in your Pivot Table Fields. This is extremely...

Contact

Email: justinren AT excelprof.com

Recent Posts

  • The American Civil War was a War on Supply Chains
  • The Transportation sector is much larger than the entertainment industry… but why do people think the other way?
  • How the consulting world screwed up the ‘Lean’ Idea
  • Excel trick: Search for multiple keywords from a list
  • Sometimes change is good just for change’s sake
  • Google Colab is an awesome Python programming tool for AI and data analysis
  • An successful entrepreneur is a technician, manager and entrepreneur in one
  • Shakespear in Business
  • Google NotebookLM is a great tool
  • Why China’s Economy is in Trouble
  • Platform or Specialization? Maybe it is both
  • Value Investing is about learning about everything
  • He was rejected by 90% of the investors
  • Why is Africa Poor? Social Intuitions
  • Will Robots kill human jobs? Yes and No
  • EV has come a long way but US is falling behind
  • The US Economy is Changing in its structure
  • Democracy and Prosperity
  • Decarbonizing Last-mile Logistics: A quick summary
  • EVs with 500+mile range? Maybe a hybrid with a large battery and small engine is better for the market
  • Vacation is a state of mind
  • You just have to hustle
  • Why should we improve public transit?
  • Why do we need to fix the T?
  • Should I Buy or Lease a Tesla Part 6: The Saga Continues
  • India has the potential to overtake China as the world’s manufacturing hub, even though it may take a while
  • How has the work-from-home world affected the environment?
  • How do sustainable supply chains improve the continuity of supply and protect the environment?
  • Tesla’s ticking time bomb?
  • China’s recent covid debacle reveals incompetent and factious management
  • Top 10 Bio-pharmaceutical Regions in the US by Numbers
  • Electric airplane makes sense for one simple reason
  • EV Charging Networks: The Top 8
  • EV prices 2022 (I): The Distribution
  • Choosing the right fuel (III): Whose perspective?
  • Choosing the right fuel (II): Total cost
  • Choosing the right fuel (I): fuel and carbon cost
  • Steps to calculate the carbon footprint of a supply chain
  • EV Fast Charging in the US is becoming better but still has a long way to go
  • The Multiplier Effect of Manufacturing: Where Jobs Come From
  • How large is the supply chain economy? The answer may surprise you
  • So Ford Wants to Do Away with its Dealers…
  • How much do you pay charging an EV on a monthly basis?
  • Excel Trick: Import Data From a Picture!
  • EV in 2022 and Beyond: More Good News, but Uncertainties Too
  • What will happen to Zoom?
  • If Facebook (Meta) disappeared 3 years from today (in 2025), I will not be surprised
  • Clustered bar chart and stacked barcharts, switch rows/columns, overlap and customize shapes
  • Are we still ignoring data in making covid-related decisions?
  • Do you really need a Power button for an electric car?
  • How to think about the user cases for Blockchains: A whole spectrum of access control
  • The fundamental problem of governance with DApps (Distributed apps)
  • A Great Discussion on International Trade and Blockchain
  • A Fascinating Recount of the US Semiconductor History
  • A Small Innovation, A Big Saving for the Environment
  • Things I learned When Lighting a Fire
  • Zillow’s Failure in Housing Flipping is a Classic Example of Ignoring Bottlenecks and Variabilities
  • How to Revive the Semiconductor Manufacturing Industry in the US
  • What is the Supply Chains of the Future?
  • A Tale of Two Chains: Supply Chain and Blockchain
  • Port of LA: Storage Space is the culprit?
  • Why Additive Manufacturing (or 3D Printing)?
  • Why Supply Chain Delays are Multi-faceted: A Mathematical Explanations (Without the Heavy Math)
  • Green Ammonia is a promising renewable marine fuel
  • EV is not just about making cars. It is about the Supply Chain.
  • Understanding CO2 Emissions for different freight transport modes (renewable as well as non-renewable)
  • The One and Only Michael Dell
  • Tesla Lease Mileage Limit and the Central Limit Theorem
  • Daniel Pink’s “When” is an Illuminating Book Towards High Productivity and Better Living
  • SHOULD I BUY OR LEASE A TESLA? PART 4: It all comes down to your apetities towards risk
  • SHOULD I BUY OR LEASE A TESLA? PART 3: It is not black-and-white (because we do not know the future)
  • SHOULD I BUY OR LEASE A TESLA? PART 2: Total loan cost (when you are sure about the depreciation)
  • Should I Buy or Lease a Tesla? Part 1: Leasing Cost
  • A great article on this thing called “supply chain shortage”
  • How to draw ranking data properly
  • Simulation: Is demand equal to sales? (Part II, and why is there a Loch Ness Monster?)
  • Simulation: Is demand equal to sales? (Part I)
  • Simulation: It all starts with a coin toss
  • Carbon foot-printing problem is first of all an information problem
  • Last-mile Transport is the Key Driver in Supply Chain Carbon Footprint
  • Elon Musk Gets Manufacturing
  • Road Transportation is the Single Largest Decarbonization Opportunity with a Clear Path Forward
  • Carbon Foot printing: Devil is in its details…
  • The Sustainability Perils of E-commerce (II): Fast and Furious (Fuming)?
  • Excel Pivot Table Trick: Drawing Charts Using Only Part of the Pivot Table
  • The Carbon-reducing Effect of E-commerce Delivery
  • The sustainability peril of E-commerce (I): Small batches lead to more emissions
  • Two-way Data Table in Excel is a great tool for sensitivity analysis
  • The Dawn of the Modern Power Grid Started Right Here in Massachusetts (and It was Clean Energy!)
  • Measuring the Carbon Footprint of a Supply Chain: 3 Scopes
  • Zero-Carbon Economy: A Grand -and Necessary – Vision
  • More power lines, or rooftop solar panels? There is no easy answer (but here is a way to think about it)
  • ICCT’s Report on the Lifecycle Comparisons of GHG Emissions of Gas Cars vs. EV is Filling a Void
  • The Most Factual and Poignant Article on the Failure on COVID Data Collection and Interpretation (So Far)
  • Modeling Driving Distances (3)
  • Modeling Driving Distances (2)
  • Modeling Driving Distances (1)
  • Digital Technology and Clean Energy
  • Range Anxiety for Electric Vehicles (EV) – Part I
  • Small change in mean can result in big change in extremes
  • Why Hasn’t Anybody Done This Graph about COVID-19?
  • Wow What a Great Data Site
  • Excel Shortcut Keys (2020 Edition)
  • How to Provide Electricity Access to Rural Africa: An Example
  • Why is Chick-Fil-A Picking up Market Share (and Why is McDonalds Testing Robot Fryers and Voice-Activated Drive-Through)?
  • Filter Data Right in your Pivot Table Fields!
  • Sensitivity Study (or Scenarios) with Data Table
  • PivotTable: Calculated Fields
  • Dashboard with PivotTable
  • Data Slicer and Timeline are Useful Reporting Tools in PivotTable
  • How to Draw a Combo Chart, i.e. Chart with 2 Y-axis, and Change Chart Type on a Mac
  • How much gasoline do we American consumers buy each week? An Example of Excel Modeling
  • Most Used Excel Shortcut Keys – Mac and PC
  • How to Draw a 3-D Chart
  • Chance of Nothing Happening? The Power of Joint Probabilities
  • This Site Has Abundant Climate Data
  • Here is Another Example on Why Excel will Never Go Away – Julia Computing
  • Tesla Needs to Be More Rigorous in Discussing Numbers
  • What (and when) are the most popular US cities to visit?
  • Google Sheets is Catching up with Excel in Charting
ExcelProf.com

©2018 Excelprof.com All Rights Reserved.

Facebook