Topics Include:
- Detailed assessment of the most productive Excel formulas and functions
- Pre-formatting Date Columns for Easy Data Entry
- Creating Custom Number Formatting
- Using Conditional Formatting for Real-Time Feedback
- Color-Coding Automatically
- Recording Page Layout Macros for automating page setup
- Nesting an Error-Handling Function
- Automatic Date-and-Time Deadline Calculation
- Creating Range-Based Validation for Cells
- Using Relative References to Automate Analysis
- Managing Sloppy Data with Text Functions
- Customize the Ribbon
- Customize the Quick Access Toolbar
- Creating Custom Keyboard Shortcuts
schedule1 hours on-demand video
signal_cellular_altIntermediate level
task_altNo preparation required
calendar_todayPublished At Apr 30, 2020
workspace_premiumCertificate of completion
calendar_todayUpdated At Jan 16, 2025