Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

MS Excel - Automating Workbook

( Duration: 1 Day )

This MS Excel - Automating Workbook training course will help you master Excel's automation features so that you can save valuable time and keep your data intact.

By attending MS Excel - Automating Workbook workshop, attendees will learn:

  • Applying Data Validation
  • Searching for Invalid Data and Formulas with Errors
  • Working with Macros

  • Knowledge of PivotTables

The MS Excel - Automating Workbook class is ideal for:

  • Experienced Excel users who have a desire or need to advance their skills in working with some of the more advanced Excel features.

COURSE AGENDA

1

Apply Data Validation

  • Data Validation
  • The Data Validation Dialog Box
  • Data Validation Criteria
  • Input Messages
  • Error Alerts
  • How to Apply Data Validation Criteria
  • Applying Data Validation
2

Search for Invalid Data and Formulas with Errors

  • Invalid Data
  • The Circle Invalid Data Command
  • The Error Checking Command
  • Error Types
  • How to Search for Invalid Data and Formulas with Errors
  • Searching for Invalid Data and Formulas with Errors
3

Work with Macros

  • Macros
  • Macro Security Settings
  • Microsoft Visual Basic for Applications
  • The Record Macro Dialog Box
  • The Use Relative References Command
  • The Macro Dialog Box
  • Macro Names
  • The Personal Workbook
  • Copying Macros
  • How to Work with Macros
  • Creating a Macro
  • Editing a Macro

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X