Join Dennis Taylor for an in-depth discussion in this video Grouping by other factors, part of Excel 2013 Essential Training.
In addition to grouping data by date and time factors, Pivot Tables also gives…us the possibility to pretty much create grouping on our own, sort of an ad hoc way.…We're looking at the worksheet called OtherGrouping in our file 13-PivotTables.…Imagine if somebody asks us to group data by the east region.…Now, we don't really have an east region, we've got a northeast, we've got a southeast.…You can move fields.…For example, if we want to move southeast next to northeast, just click that…cell, drag its bottom edge.…
Those two fields are now adjacent, northeast and southeast.…The date is together.…Suppose we want to create a grouping called East.…Select just the two labels, Right-Click Group.…Suddenly, we see a new row in the term GROUP 1.…That's not very meaningful, so let's just call it East.…Recognize there's a minus in front of it.…Let's click the minus and before doing that, look at the total.…We got a northeast and a southeast.…This total here is going to be about 4000 or so.…Let's just click the minus, what happens?…
Author
Dennis Taylor
Released
1/29/2013- What is Excel and what is it used for?
- Using the menus
- Working with dates and times
- Creating simple formulas
- Formatting fonts, row and column sizes, borders, and more
- Inserting shapes, arrows, and other graphics
- Adding and deleting rows and columns
- Hiding data
- Moving, copying, and pasting
- Sorting and filtering data
- Printing your worksheet
- Securing your workbooks
- Tracking changes
Skill Level Appropriate for all
Duration
Views
-
Introduction
-
Welcome39s
-
-
1. Getting Started with Excel 2013
-
What is Excel used for?1m 49s
-
Using the menu system4m 30s
-
The Quick Access Toolbar4m 41s
-
Using the Formula bar1m 43s
-
Using the Status bar2m 24s
-
Using the built-in help2m 54s
-
Creating new files2m 11s
-
-
2. Entering Data
-
Working with dates and times3m 32s
-
Using Undo and Redo4m 50s
-
Adding comments2m 55s
-
Using Save or Save As3m 57s
-
3. Creating Formulas and Functions
-
Using SUM and AVERAGE3m 25s
-
4. Formatting
-
Designing borders3m 26s
-
Formatting numbers and dates4m 31s
-
Conditional formatting4m 21s
-
Creating and using tables9m 59s
-
5. Adjusting Worksheet Layout and Data
-
6. Printing
-
Previewing page breaks4m 56s
-
7. Introduction to Charting
-
Creating charts4m 36s
-
Exploring chart types7m 47s
-
Formatting charts5m 42s
-
-
8. Adjusting Worksheet Views
-
9. Multiple Worksheets and Workbooks
-
10. IF, VLOOKUP, and Power Functions
-
11. Security and Sharing
-
Protecting workbooks2m 40s
-
Sharing workbooks4m 7s
-
Tracking changes4m 32s
-
12. Database Features
-
Sorting data6m 9s
-
Using filters6m 16s
-
Removing duplicate records2m 38s
-
-
13. PivotTables
-
Creating PivotTables8m 36s
-
Manipulating PivotTable data9m 47s
-
Grouping by other factors2m 33s
-
Using PivotCharts3m 59s
-
-
14. Data Analysis Tools
-
Using Goal Seek6m 8s
-
Using Solver6m 34s
-
Using Scenario Manager6m 11s
-
Using Data Tables4m 36s
-
-
15. Introduction to Macros
-
Definition and examples6m 48s
-
Running a macro10m 43s
-
-
Conclusion
-
Next steps29s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Grouping by other factors