Advanced Excel Reporting & Analysis Course Delhi / Gurgaon
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
Date & Time Function:- Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.
Statistical Function & Other Functions:- Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen
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, Past Special, Past link
Pivot Table and Charts, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display
Data Collection Method With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
Analysis 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
Report Development – (Real World Data)
Inquiry for Advanced Excel Reporting & Analysis Training
Please find the Advanced Excel Training Course Duration Details.
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
Is learning advanced excel beneficial for my career?
What are the best Excel practices?
What Excel skills are most valuable for finance and accounting?
How can I make Excel Reports interesting?
Will learning advance MS Excel going to help me in getting good job?
What is the best way to learn Excel?
You can drop in an email or leave us a message or simply call us @ 9873140018 | 9999340200 . You can also walk into any of our corporate offices in NCR to get the details of the program that interests you. Use the link http://www.slaconsultantsindia.com/contactus.aspx
Microsoft Excel is anything that we work on the regular basis be it a student or an accounJune 8, 2017
The popularity of SAS has significantly risen up in the last few years as it encompasses aJune 19, 2017
A management information systems (MIS) training program is basically planned for people plJune 10, 2017
Hiring will only take place at the top end of the technology spectrum. The need for theseFebruary 28, 2017