[1] Registered Under MSME Govt. of India [2] Registered Under NCT New Delhi [3] Registered as Autonomous Body ,Under Govt Of West Bengal based on Central govt.TR Act,1882,Govt.Of India.(Registration No:IV-06540) [4] An ISO 9001:2015 certified autonomous body. [5] AN ISO 9001: 2015 Certified India's Largest Computer Educational Organization [6] (A National Education Programme of Information Technology & Development)

CERTIFICATE IN ADVANCE EXCEL
(CIAE)

Duration: 3 Months

Govt.of India Recognized & ISO 9001:2015 Certified institution

NETAJI YOUTH COMPUTER TRAINING CENTRE

ADVANCE EXCEL EXPERT COURSE/MIS (DURATION: 06 MONTH)

 

 

Advanced Excel Expert –Overview of the Basics of Excel

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

 

Advanced Excel Expert- Working with Functions

  • Writing conditional expressions (using IF) .
  • Using logical function (AND,OR,NOT) .
  • Using lookup and reference function (Vlookup ,Hlookup, Match,Index) .
  • Vlookup with Exact Match , Approximate Match .
  • Nested Vlookup with Exact Match .
  • VlookUP with Tables, Dynamic Ranges .
  • Nested VlooUP with Exact Match .
  • Using VLookup to consolidate Data from Multiple Sheets .

 

Advanced Excel Expert –Data Validations

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

 

Advanced Excel Expert –Working with Templates

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

 

Advanced Excel Expert –Sorting and Filtering Data

  • Sorting tables .
  • Using multiple –level sorting
  • Using custom sorting
  • Filtering data for selected view (Auto Filter)
  • Using advanced filter options

 

Advanced Excel Expert –Working with Reports

  • Creating subtotals
  • Multiple – level subtotals

 

Advanced Excel Expert –Creating Pivot Tables

  • Formatting and customizing Pivot Tables .
  • Using advanced options of Pivot tables .
  • Pivot charts .
  • Consolidating data from multiple sheets and files using Pivot tables .
  • Using external data sources .
  • Using data consolidation feature to consolidate data .
  • Show value as (% of Row ,% of Column , Running total ,Compare with Specific Field
  • Viewing subtotal under Pivot .
  • Creating Slicers (Version 2010 & Above)

 

 

Advanced Excel Expert –Working with More Function

  • Date and time function .
  • Text function .
  • Database function .
  • Power function ( CountIF, CountIFS, SumIF ,SumIFS ) .

 

Advanced Excel Expert –Working with Formatting

  • Using auto formatting option for worksheets .
  • Using conditionl formatting option for rows,columns and cells .

 

Advanced Excel Expert –WhatIF Analysis

  • Goal seek .
  • Data tables .
  • Scenario Manager .

 

Advanced Excel Expert –Working with Charts

  • Formatting Charts .
  • Using charts .
  • Using 3D Graphs
  • Using Bar and Line chart together .
  • Using secondary Axis in Graphs .
  • Sharing Charts with Power Point /MS word ,Dynamically

(Data modified in Excel, Chart, would automatically get updated)

 

Advanced Excel Expert –New features of Excel

  • Sparklines, Inline Charts, Data Charts
  • Overview of all the new features
 

 

Contact Your Nearest Classic Computer Study Center for Fess, Class and other details.