+91 91525 74715 | info@excelinstitute.co.in

Reset Password

Advance Excel – Beginner

Information Technology Council Certification. In Advanced Excel Short term program you will learn the most advanced formulas, functions and types of financial analysis which will help you be power user of MS Excel. This Advanced MS Excel training course will build on MS Excel Crash Course and is designed specifically for Excel Spreadsheet users who are already proficient and looking to take their skills to an advanced level. This advanced tutorial will help you become a great MS Excel user. Our instructors will build all the formulas and functions right on for you and, you can easily learn them and master within the time span.

Our instructors will build all the formulas and functions right on for you and, you can easily learn them and master within the time span.

Overview

Our instructors will build all the formulas and functions right on for you and, you can easily learn them and master within the time span.

BEGINNER LEVEL 1

Overview of the Basics of Excel
Designing the structure of a template
Sorting and Filtering Data
Multiple-level sorting
Custom sorting
Auto Filter
Advanced Filter
Multiple-level subtotal
Working with Reports
Data Validations
Custom validations based on formula
Protecting and unprotecting worksheets and cells
Conditional expressions

BEGINNER LEVEL 2

Vlookup
Vlookup with Exact Match, Approximate Match
VLookUP to consolidate Data
Hlookup
Xlookup
Pivot Table
Pivot charts
Formatting and customizing Pivot tables
Viewing Subtotal under Pivot
Charts
Formatting Charts

Eligibility

  1. 10th Standard
  2. 12th Standard
  3. Graduation in Any Stream

Certification

  1. ITC : Information Technology Council Certification.
  2. DiTRP ( Digital Information Technology & Research For Professional)

Duration

1.5 Months
×