During our recent vacation to New York City my wife and I loved eating tacos at TACOMBI. However, when I saw the menu it reminded me of a common data challenge! Continue reading
Excel Pivot Tables Analyze Taco Data!
Posts Tagged → Pivot Table
Create Your First Pivot Table in 5 Minutes
One of Microsoft Excel’s most prolific features is the Pivot Table. Pivot Tables offer an efficiency and effectiveness in making sense of large amounts of data in almost no time. With that in mind, we now turn our attention to a scenario where we will create a Pivot Table in five minutes. Continue reading
Video 00159 Create unique and sorted text list
We have a bunch of names in a column. We need to create a unique and alphabetically sorted list. BE CAREFUL! Before we jump into a solution we should ask a couple of key questions. Does the solution need to be dynamic? Do we need to teach the solution to our co-worker or client? Continue reading
National Electronic Injury Surveillance System (NEISS)
This is my first post about exploring free public data sources. Knowledge really is powerful and knowing how people get injured is important in order to learn from it and avoid future accidents.
Continue reading
00127 All Combinations No Formulas No VBA
This was weird. I stumbled across my video and I thought “WHAT? Get all text combinations using just a pivot? How did I do that?” It seemed like ‘Back To The Future’ as I re-watched my own video. Continue reading
Video 00014 Pivot Table: Extend the data range
If you’ve created a pivot table and later added more data then you’ll need to expand the pivot’s data range. Continue reading
Video 00013 Pivot Table: Introduction
If you work with data in Microsoft Excel then you have to learn about Pivot Tables!
Learning Pivot Tables will change the way you work with Excel! Continue reading