011-47519207

+91-9873140018

hr@slaconsultantsindia.com

Follow Us


Most Updated Practical Training With Interview Guarantee(PG Available)@ +91-9999491895

Advanced Excel Reporting & Analysis

Inquiry for Advanced Excel Reporting & Analysis Training

SLA Consultants India, has been steadily rising as a corporate training & development leader to take care of all client’s & learners needs in a comprehensive framework. We have maintained consistency and stability in providing quality training & interviews since inception and this is all what makes us stand a name in the industry. Utmost professionalism in covering up for client’s training & development requirement with improbable methodologies in analyzing quality of training & development and timely assessment are some of our tools that we adopt in encouraging our proficiency in delivering quality services.

Programme Highlights

Certification

Industry acceptable certification for all training which help fresher/Experienced to up-skill at corporate.

Experienced Faculty

Only Working Professions/Sr. Consultant/CA/CS/Best Freelancer with 10-15+ years deliver training

Placement Assistance

After completion of 70% training our dedicated placement team arrange interview till placement.

Lab Facility

Practical Training help to gain exposure like corporate level with technical test series.

Workshop Sessions

Real time projects & best case study makes SLA workshop very unique and lively for learners.

Admin Support

For Learner's, Our admin team 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.

SLA Consultants Microsoft Advanced Excel Training Course Review & Delivery Method:

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

Why Learn Advanced Excel Reporting & Analysis

PROGRAMME DETAILS

programme modules

Advanced Excel Reporting & Analysis Training

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

Advanced Dashboard.

Report Development – (Real World Data)

Please find the course and fee details.

Fee According to Module:-
Course     Course Duration   Current fee
Advanced Excel 20 – 30 (Hours) Rs 7,500/-
         Note: Service Tax Applicable on all Course Module

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

DOWNLOAD BROCHURE

FAQ

Beginners & Fresher

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Freelancer Accountant

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Why Should I Join Training

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Working Professional

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Small Business Owners

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

To Whom I Contact

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Testimonials

Latest Blogs

Get In Touch