Industry-oriented certification Advanced Excel training course to furnish your career to kick-start/grow at MNCs/Non-MNCs Organization & corporate.
Professional expert Sr. Lead Analyst / Technical Analyst With 10+ Years of working experience will provide you industrial level training.
Receive placement assistance after completion of 70% training, SLA team will arrange interviews till you’ll get the placement.
You can attain the practical training session to get the indutrial exposure & prepare for the corporate level challanges.
You’ll attain knowledge on bases of real-time scenarios, live projects & best case study to complete SLA workshop.
SLA’s 7 days working admin team co-ordinates you for the fresh batch schedule/re-scheduling classes/arrange doubt classes.
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.Course Duration: 20-30 HRS with Highly Skilled Corporate Trainers (Microsoft Advance Excel Training) for 10 Modules – Weekdays / Weekend
SLA Consultants Delhi – Microsoft Advanced Excel Training Delivery Method:
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
Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
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.
Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen
And, Or, If, Iferror, Not, Nested If
VLookup, HLookup, XLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link
Pivot Table, Power Pivot, What-if Analysis, Data Table –One Variable and Two Variables, Data Analysis Using Statistics, Descriptive Statistics, ANOVA, Moving Average, Testing Hypothesis, Measuring Covariance and Correlation, Distribution, Regression, Graphs & Charts, Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall, Import and Export data, Protect/Unprotect sheets/workbooks, Worksheet formatting and Print Display
With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
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
Overview of Chart types, Chart Formatting, Active X Form Controls, Principle of great dashboard design, Selecting Correct Chart to display data, Interactive Charts with Form Controls, Combo box, Check Box, Scroll Bar and Radio Button, Interactive Dashboard with Form Controls, Form Controls for reports automation, Data Models using Power Pivot
|Advanced Excel Course Module||Duration|
|Basic & Advanced Excel + Any One (Basic SAS/R Programing /Tableau /Power BI)||20 – 30 (Hours)|
|Advanced Excel Course Schedule||Advanced Excel Batch Timing|
|Monday to Friday||8:00 AM – 10:00 AM|
|Monday to Friday||10:00 AM – 12:00 PM|
|Monday to Friday||2:00 PM – 4:00 PM|
|Monday to Friday||4:00 PM – 6:00 PM|
|Saturday/Sunday||8:00 | 12:00 | 2:00 | 4:00|
|Sunday||8:00 AM – 10:00 AM|
|Sunday||10:00 AM – 12:00 PM|
|Sunday||2:00 PM – 4:00 PM|
|Sunday||4:00 PM – 6:00 PM|