-
Must-Knows for List (Recordset) Management 5
-
Downloadable Lesson File(s)Lecture1.1
-
Automatic OutliningLecture1.2
-
Manually OutliningLecture1.3
-
SortingLecture1.4
-
SubtotalingLecture1.5
-
-
Must-Knows for Pivot Tables 9
-
Turning a List Range into a Table ObjectLecture2.1
-
Looking at the Pivot Table Tabs and Field ListLecture2.2
-
Building out the Pivot TableLecture2.3
-
Changing the Value FieldsLecture2.4
-
Filtering a Pivot TableLecture2.5
-
Changing the layout and style optionsLecture2.6
-
Refreshing a Pivot TableLecture2.7
-
Drilling DownLecture2.8
-
Changing How Values Are Calculated and DisplayedLecture2.9
-
-
Bonus Lessons 2
-
Using the Concatenate FunctionLecture3.1
-
Using Flash FillLecture3.2
-
This content is protected, please login and enroll course to view this content!
1 Comment
This is great – would be neat to see the reverse as well i.e. splitting up the name into or text into 3 cells.