Automating Worksheet Functionality Using Excel Macros Validation and Auditing tools

BY
Simpliv Learning

Mode

Online

Duration

3 Hours

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video Based

Course and certificate fees

certificate availability

Yes

certificate providing authority

Simpliv Learning

The syllabus

Automating Worksheet Functionality

  • Update Workbook Properties   
  • Create and Edit a Macro   
  • Apply Conditional Formatting   
  • Add Data Validation Criteria

Auditing Worksheets

  • Trace Cells   
  • Troubleshoot Invalid Data and Formula Errors   
  • Watch and Evaluate Formulas 

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses