Witness a variety of common Excel features used in a somewhat uncommon way to solicit input from the user and improve the querying and reporting process.
File Download Link:
www.bcti.com//...
The previous video showcases the typical approach:
• Excel - Overcoming "St...
02:37 Activating the Developer Ribbon
02:59 Naming the Data Set to "Sales"
03:24 Inserting Option Buttons for "Range"
06:01 Inserting a Group Box Control
06:30 Grouping Controls Together
06:46 Creating Option Buttons for Aggregation Type
08:06 Inserting A Spin Button Control
09:31 Mid-Project Recap
09:42 Creating the Sideline Calculations
09:47 Naming the User-Input
10:50 Calculating LARGE/SMALL for "N-Value"
11:34 Calculating PERCENTILE for Grouping
12:35 Creating the "Master Cutoff" Formula
13:12 Naming the "Cutoff" Result
13:20 Conditionally Format the Sales Values
15:19 Create a Dynamic Title
16:29 Create Custom Error Messages
21:24 Suppressing "Natural" Errors
21:48 Conditionally Format Error Messages
23:55 Color Match Input Cell to Error Messages
25:40 Setting a Lower Limit for User Input Using Data Validation
26:14 Creating Custom Error Messages in Data Validation
26:57 Final Touches
11 сен 2024