Microsoft Advanced Excel Training in Delhi

Advanced Excel Reporting & Analysis

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
• Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table
• Advanced Chat Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart
• 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)