Excel – Shortcuts , Tips and Tricks

Tips and Tricks for becoming more productive in Excel



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