Advanced Excel Training Institute in Faridabad


Advance Excel Training is provided by JLJ Group in Faridabad. We are a leading Industrial training institute for latest technologies in Delhi/NCR since 1990. We provide effective learning environment for best practical and projects in Advance Excel at affordable price. The institute offers IT training & BCA. MCA degrees program through IGNOU. At JLJ Training is conducted by industry experts having more than 10 Years’ Experience

Why Choose JLJ Group for Advanced Excel Training

  • Institute is running Since 1990
  • 25+Years of Academic Excellence
  • ISO 9001-2000 certified
  • Received Awards for best run institute all over India
  • Trained more than 25000 Students till now
  • Training by Corporate trainers and Industry leaders.
  • TCS Certified Computer Labs
  • More than 200 Computers
  • Demo/classes on LCD/ Projector.
  • Library with more than 10000 books
  • Multi-storey Building with 12,000 Sq. Ft. covered area
  • Facility to conduct on-Line Exams

Advanced Excel Course Fee and Duration:

Track Regular Weekend Fees
Course Duration 4 Weeks 4 weekend Call us
Hours 1.5 Hours a day 3 hours a Day Call us
Training Mode Live & Classroom Live & Classroom Call us


Advanced Excel Course - Overview of the Basics of Excel

  • Customizing common options in Excel
  • Absolute and relative cells
  • Protecting and un-protecting worksheets and cells
  • Protecting Workbook
  • Protecting and un-protecting worksheets and cells
  • Number formatting
  • Basic and Advance Condition formatting

Advanced Excel Course - Formatting

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

Advanced Excel Course - Sorting and Filtering Data

  • Sorting tables
  • Using multiple-level sorting
  • Using custom sorting
  • Filtering data for selected view (AutoFilter)
  • Using advanced filter options
  • 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

Consolidating data from multiple sheets and files using Pivot tables

  • Creating subtotals
  • Multiple-level subtotals
  • Creating Pivot tables
  • Formatting and customizing Pivot tables
  • Using advanced options of Pivot tables and Pivot charts
  • Using data consolidation feature to consolidate data
  • Viewing Subtotal under Pivot
  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT

Advanced Excel Course – FORMULA

  • Maths and trigonometric function
  • Statistical Function
  • Engineering Function
  • Sparklines, Inline Charts, data Charts

FUNCTION LOOKUP AND REFRENCE

  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • VLOOKUP with Exact Match, Approximate Match
  • Nested VLOOKUP with Exact Match
  • VLOOKUP with Tables, Dynamic Ranges
  • Nested VLOOKUP with Exact Match
  • Using VLOOKUP to consolidate Data from Multiple Sheets
  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS) etc

Advanced Excel Course - WhatIf Analysis

  • Goal Seek
  • Data Tables
  • Scenario Manager
  • Insert developer or design tab in Excel for working
  • Data analysis option for analysing different type of data

Advanced Excel Course - Charts & Macros

  • Using Charts
  • Formatting Charts
  • Using 3D Graphs
  • Using Bar and Line Chart together
  • Using Secondary Axis in Graphs
  • Sharing Charts with PowerPoint / MS Word, Dynamically
  • (Data Modified in Excel, Chart would automatically get updated)
  • Relative & Absolute Macros

Advance excel course-Macros with VBA

  • Overview of VBA
  • Properties of VBA
  • Active X Control in VBA
  • Create Form using VBA and connect with Excel
  • Create calculator using VBA
  • Data insert using VBA Form in Excel

JLJ Group Location:

JLJ Group is located in Huda Market Sector 16A Faridabad (Delhi NCR), opposite GOVT. Nehru College which is surrounded by Sector 16 Faridabad, SurajKund, Sarai khawaja, Palwal, Friends colony, Old Faridabad, NHPC Chowk, Badarpur Border, Nahar Par, Ballabgarh, Badkal Mod, Mewla maharajpur, YMCA Chowk, Neelam Chowk, Greater Faridabad, Sainik Colony, Sanjay Colony, Hodal and more.

For Any Query Call

+91 8810217350   +91 8287304900