COURSEUS$131
Excel Shortcuts
Tips and Tricks for becoming more productive in Excel
schedule 1 hour4.5(122 ratings)
starstar
starstar
starstar
starstar
star_halfstar
Created By Tom Fragale
-54%
US$60
auto_storiesINSTRUCTOR(S)
Tom Fragale
Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
About this course
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
This course includes:
schedule1 hours on-demand video
signal_cellular_altIntermediate level
task_altNo preparation required
calendar_todayPublished At Apr 30, 2020
workspace_premiumCertificate of completion
errorNo prerequisites
lock1 year access
calendar_todayUpdated At Aug 8, 2024
HomepageBecome an InstructorLearnFormula PodcastsLatest IntelligenceLearnFormula BusinessTerms of useContact usPrivacy policyReport AbuseHelp Center
Copyright @ 2024 CPE QAS LearnFormula | Professional Development Course Marketplace