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

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books