Advanced Excel Training
These training is to develop practical working knowledge about accounts and Excel Training, to support in job & work

Course Features

Overview of the Basics

  • Customizing common options in Excel
  • Absolute and relative cells
  • Protecting and un-protecting worksheets and cells

Working with Templates

  • Designing the structure of a template
  • Using templates for standardization of worksheets

Working with Functions

  • Designing the structure of a template
  • Using templates for standardization of worksheets

Data Validations

  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell

Sorting and Filtering Data

  • Sorting tables
  • Using multiple-level sorting
  • Using custom sorting

Duration : 4 Months 1 hrs. daily

ELIGIBILITY : 12th+ Having basic knowledge of Computer

CERTIFICATION : From AIAT Pvt. Ltd, the Associate with.