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