Advanced Excel Training in Delhi

Advanced Excel Training

What is the correct answer for 26 + 14

Take a Look to Our Advanced Excel Training Course

Certification

Industry-oriented certification Advanced Excel training course to furnish your career to kick-start/grow at MNCs/Non-MNCs Organization & corporate.

Experienced Faculty

Professional expert Sr. Lead Analyst / Technical Analyst With 10+ Years of working experience will provide you industrial level training.

Placement Assistance

Receive placement assistance after completion of 70% training, SLA team will arrange interviews till you’ll get the placement.

LAB Facility

You can attain the practical training session to get the indutrial exposure & prepare for the corporate level challanges.

Workshop Sessions

You’ll attain knowledge on bases of real-time scenarios, live projects & best case study to complete SLA workshop.

Admin Support

SLA’s 7 days working admin team co-ordinates you for the fresh batch schedule/re-scheduling classes/arrange doubt classes.

Advanced Excel Training Programme Details

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:

  • Web / Desktop Base.
  • Instructor-Led Classroom Sessions.
  • Presentations/Demonstration/Practicals of concepts.
  • Handouts/Assignments/Real-time Exposure to work on Clients.

Programme Modules

Advanced Excel Training Course

Module 1 – Basic & Advance Excel

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.

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

Mathematical Functions:- Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct

Pivot Table and Charts, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display

Date & Time Function:- Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time

Data Collection Method With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality

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.

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

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

Advanced Dashboard.

Logical Functions:- And, Or, If, Iferror, Not, Nested If

Report Development – (Real World Data)

Find the course details below.

Duration of Module

Course Module Course Duration
Course Module Course Duration
Advanced Excel 20 – 30 (Hours)

Batch Timings

Course Schedule Batch Timing
Sunday – Thursday 09:00|11:00|2:30|4:30
Saturday & Sunday 09:00|11:00|2:30|4:30
Sunday 09:00|11:00|2:30|4:30

Testimonials

[testimonial_view id=10]