COURSECA$99
Excel Shortcuts
Tips and Tricks for becoming more productive in Excel
schedule 1 hour4.5(122 ratings)
starstar
starstar
starstar
starstar
star_halfstar
-40%
CA$59
![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
CPA Alberta
CPA British Columbia
CPA Manitoba
CPA New Brunswick
CPA Nova Scotia
CPA Ontario
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 Jul 27, 2024
HomepageBecome an InstructorLatest IntelligenceLearnFormula BusinessTerms of useContact usPrivacy policyReport AbuseHelp Center
Copyright @ 2024 CPDFormula LearnFormula | Professional Development Course Marketplace