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.
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
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)
Please find the course and fee details.
|| Course Duration
|| Current fee
||20 - 30 (Hours)
| Note: Service Tax Applicable on all Course Module
Batch Timings -
|| Class Available Between
|| Class Duration
|| Course Duration
| Monday to Friday
|| 09:00 to 02:30 PM
||3 - 4 Weeks
|Saturday & Sunday
||09:00 to 04:00 PM
|| 2 - 2.5 Months
||09:00 to 05:00 PM
|| 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.