Welcome to Excel.net


  Student           Admin

Send

Enquire Now

Send

Message

×
img

CPP Course Content

Introduction

  • C++ Characteristics
  • Nested If Function
  • And, Or, Not Compound If Function
  • Advance Lookup, V lookup, H lookup
  • Match Index, Sum Ifs, Count Ifs
  • If Error & Is Error Formulas

Array & DB Function in Advance Excel

  • Stored Array
  • Operator
  • Array Constant
  • Array Formulas of Single Result
  • Array Formulas of Multiple Result
  • D average, D count, D product, D sum

Sorting & Filtering in Advance Excel

  • Sorting Table
  • Multiple Level Sorting
  • Custom Sorting
  • Filtering Data for Selected View
  • Advance Filter
  • Multiple Sheet Filtering

Report MIS

  • Creating Sub Total
  • Creating & Customizing Pivot Table
  • Advance Options of Pivot Table
  • Consolidating Multiple Sheet
  • Using Pivot Table, Pivot Charts
  • Using External Data Source

View & Protection

  • Protection & Un-Protecting Worksheet
  • Custom View
  • Edit, Switch & Delete Custom View
  • Grouping & Outline
  • Freeze Panes

Templates

  • Designing Templates
  • Using Predefine Template
  • Worksheet Standardization
  • Planers
  • Budgets
  • Inventory

CPP Course Highlights

Course Duration

  • 2 Months / 3 Months

Course Fees

  • To know fees details contact us now.

Class Mode

  • Monday to Friday

Course Placement

  • Now a days Advance excel is being used in every organization. So there is no problem in placement.

After Course Completion

  • After Completing this Course you can create any type of automation with Excel and become excel expert. After This Course you can work as MIS Executive also.

Advance Excel Course C

  • To Know Complete Advance Excel Course Content and Advance Excel fees contact us now.