-
Data Validation 17
-
Introduction to data validationLecture1.1
-
Limiting values to whole numbersLecture1.2
-
Copying data validation rulesLecture1.3
-
Editing and deleting data validation rulesLecture1.4
-
Finding data validation rules using Go To SpecialLecture1.5
-
Limiting entries to whole numbers using a formulaLecture1.6
-
Limiting entries to decimal valuesLecture1.7
-
Limiting entries to date valuesLecture1.8
-
Limiting entries to list values – Part 1Lecture1.9
-
Limiting entries to list values – Part 2Lecture1.10
-
Limiting values to a specific lengthLecture1.11
-
Introduction on creating custom data validation rulesLecture1.12
-
Limiting values to unique entriesLecture1.13
-
Limiting values to email addresses – Part 1Lecture1.14
-
Limiting values to email addresses – Part 2Lecture1.15
-
Limiting values to dates within 30 days of todayLecture1.16
-
Limiting values to custom text stringsLecture1.17
-
-
Pivot Tables 33
-
Introduction to Pivot TablesLecture2.1
-
Structure of a Pivot Table – Part 1Lecture2.2
-
Structure of a Pivot Table – Part 2Lecture2.3
-
Creating a Pivot TableLecture2.4
-
Moving and deleting a Pivot TableLecture2.5
-
Working with the Field ListLecture2.6
-
Pivot Table Layout – Part 1Lecture2.7
-
Pivot Table Layout – Part 2Lecture2.8
-
Showing or hiding totalsLecture2.9
-
Pivot Table stylesLecture2.10
-
Automatically sorting field itemsLecture2.11
-
Manually sorting field itemsLecture2.12
-
Sorting by total valuesLecture2.13
-
Changing the summary calculationLecture2.14
-
Showing values as a percentage of grand total – Part 1Lecture2.15
-
Showing values as a percentage of grand total – Part 2Lecture2.16
-
Showing values as a percentage of the row or column totalsLecture2.17
-
Changing the number format of value area fieldsLecture2.18
-
Displaying source records for a summarized valueLecture2.19
-
Selecting item labels and valuesLecture2.20
-
Manually formatting the Pivot TableLecture2.21
-
Grouping items – Part 1Lecture2.22
-
Grouping items – Part 2Lecture2.23
-
Filtering items in the row or column areaLecture2.24
-
Filtering items using the Filter areaLecture2.25
-
Filtering row or column items using SlicersLecture2.26
-
Filtering value area using SlicersLecture2.27
-
Filtering using a timelineLecture2.28
-
Grouping dates by a time unitLecture2.29
-
Grouping dates by multiple time unitsLecture2.30
-
Grouping dates by day units – Part 1Lecture2.31
-
Grouping dates by day units – Part 2Lecture2.32
-
Grouping numbersLecture2.33
-
-
Primer on Macros 10
-
What is a macro?Lecture3.1
-
Example of a macroLecture3.2
-
Macros are stored in modulesLecture3.3
-
Macro-enabled file typesLecture3.4
-
Accessing and running macrosLecture3.5
-
The PERSONAL.XLSB workbookLecture3.6
-
The Developer tabLecture3.7
-
The Visual Basic EditorLecture3.8
-
Creating a moduleLecture3.9
-
Creating a macroLecture3.10
-
This content is protected, please login and enroll course to view this content!