Tier One Services Learning Center

Tier One Services panel on leading organizations through the C-19 crisis and subsequent economic ripple effects

Course

Hangout: How to Add % of Grand Total to a Pivot Table

Course

Technique: How to Add % of Grand Total to a Pivot Table | Why: Create a % formula that will update automatically | Step 1: Insert a Pivot Table | Step 2: Insert the total twice in the Values box in the Pivot Table fields list

Hangout: How to Protect Your Excel Worksheet with Data Validation

Course

Technique: How to Protect Your Excel Worksheet with Data Validation | Why: Protect cells from being overwritten | Step 1: Highlight cells you want to protect | Step 2: Set data validation rules

Hangout: How to Use a Spin Button in Excel

Course

Technique: How to Use a Spin Button in Excel | Why: Creates a user friendly way to update values in a formula | Step 1: Create your formula | Step 2: Insert the Spin Button from the Developer Tab

Hangout: How to Use a Scroll Bar in Excel

Course

Technique: How to Use a Scroll Bar in Excel | Why: Creates a user friendly way to update values in a formula | Step 1: Create your formula | Step 2: Insert the Scroll Bar from the Developer Tab

Hangout: How to Use Dynamic Rounding for a Professional Presentation

Course

Technique: How to Use Dynamic Rounding for a Professional Presentation | Why: Universally change rounding on the fly for your entire presentation | Step 1: Create and name a rounding cell | Step 2: Reference the rounding cell in all formulas