Advanced Excel Training IN MATHURA

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 : 2 Months 1 hrs. Daily

ELIGIBILITY : 12th+ Having basic knowledge of Computer

CERTIFICATION : From NBCE, the Associate with.

CONTACT US: IITM INSTITUTE MATHURA MOB. 8899251616, 8273607812