COURSEUS$127
Excel Shortcuts
Tips and Tricks for becoming more productive in Excel
schedule 1 hour4.4(126 ratings)
starstar
starstar
starstar
starstar
star_halfstar
-54%
US$58
![Course image](/_next/image?url=https%3A%2F%2Fdbtkvjd5m619u.cloudfront.net%2Faccounts%2F275%2Fimages%2Fcourses%2F1647%2F46689c08f05a22263685fd7cacef4dff.jpeg&w=640&q=75)
auto_storiesINSTRUCTOR(S)
![](/_next/image?url=https%3A%2F%2Fdbtkvjd5m619u.cloudfront.net%2Faccounts%2F275%2Fusers%2F9198%2Fd51f255d2ff0c02ebf47efd645af1335.jpeg&w=96&q=75)
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 Jan 16, 2025
HomepageBecome an InstructorLearnFormula PodcastsLatest IntelligenceLearnFormula BusinessTerms of useContact usPrivacy policyReport AbuseHelp Center
Copyright @ 2025 CPE QAS LearnFormula | Professional Development Course Marketplace