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.
Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal,
Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value
Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
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
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)
“SLA Consultants India™ Microsoft Advanced Excel Training in Delhi NCR, Noida ,Gurgaon, Faridabad , Meerut ”
