011-47519207   +91-9873140018
hr@slaconsultantsindia.com
Most Updated Practical Training With Interview Guarantee@ +91-9999491895
 

Advanced Excel Training

Microsoft Advanced Excel Training in Delhi is a general purpose electronic spreadsheet to use to organize, calculate, and analyze data. The task you can complete with Excel ranges from preparing a simple family budget, preparing a purchase order, create an elaborate graph/chart, or managing a complex accounting ledger for a medium size business

Provide Basic/MS Advanced Excel Training Institute in Delhi, make user familiar to create formula and give platform to make good analysis and introduce Powerful tools of VBA Excel Coaching Classes so that user can make advance analysis with the help of those tools.

Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.
 
  • Mathematical Functions:-
Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal,
Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
 
  • Text Functions:-
Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value
 
  • Date & Time Function:-
Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
 
  • Logical Functions:-
And, Or, If, Iferror, Not, Nested If
 
  • Lookup & Reference Functions:-
VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s 
 
  • Other Functions:-
Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min
 
  • Data Collection Method With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
  • Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables
  • Advanced Chat Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart,  Speedometer Chart, Gantt Chart
  • Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table
  • Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.
  • Pivot Table and Charts, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display
  • Report Development - (Live Project)

 

Please find the course and fee details.

  Course     Course Duration       Current fee 
Advanced Excel 20 - 30 (Hours) Rs 7,500/-
         Note:                 Service Tax Applicable on all Course Module  

Batch Timings -

Days   Class Available Between     Class Duration    Course Duration  
  Monday to Friday     09:00 to 02:30 PM    2 (Hours) 3 - 4 Weeks
Saturday & Sunday 09:00 to 04:00 PM  2 (Hours)  2 - 2.5 Months  
Sunday 09:00 to 05:00 PM  2 (Hours)      4 - 5 Months  

 

If you wish to work on the databases smoothly then do sign up for this course today. Contact us to know how soon you can get started.

 

Placed Learners

Go Top