• My account

OUR TRAINING COURSES

Advance Excel

Review (3)

7,000.00

Our Advance Excel Program is designed by the industry experts. These skills fulfill the requirements of jobs related to data. Now a days there are huge requirements of advance excel skill set in the industry.

8 Sessions
24 Hours



Skills you will master

VLOOKUP
HLOOKUP
MATCH
INDEX
Dashboards
Pivot
Charts
Data Mining
Logical Functions
Statistical Functions

UPCOMING BATCHES

12
May
Weekends
10:00 AM - 01:00 PM
14
Jul
Weekends
01:00 PM - 04:00 PM
Mob : +91-9810600764
Address : M8, Lower ground Floor, Sector 14 OLD DLF Gurgaon 122001
Email : info@palin.co.in

7,000.00

Category:
About The Program

Our Advance Excel Program is designed by the industry experts. These skills fulfill the requirements of jobs related to data. Now a days there are huge requirements of advance excel skill set in the industry. This program gives you high quality content to clean the raw data. Training includes Industry specific data as well as assignments, case study, project.

During the training participants will get:

After the completion of the course you will be able to crack the interviews with most of the renowned organizations like Accenture, IBM, WNS, EXL, Bank of America, American Express, Fractal Analytics, British Telecom, Cognizant and many more.

Career Advisor
Vinay Mishra, Consultant
Palin Delivers real world relevance with activities and assignments that helps students build critical thinking and analytic skills that will transfer to other courses and professional life.
Program Description
Advance Excel includes Data Mining, Data Cleaning, Advance Excel Techniques with Formulas & Tips, Advance Excel Functions, Excel Pivot Table for Analysis and Pivot Charts & Dashboards for Reporting & Analysis. Real Cases to get hands on working experience on Advance Excel.
Curriculum
Click Here to Preview

   Session 1 - Mathematical Functions:

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

   Session 2 - Date & Time Functions

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

   Session 3 - 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.

   Session 4 - Statistical Functions & Other Functions

Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen

   Session 5 - Logical Functions

And, Or, If, Iferror, Not, Nested If

   Session 6 - Lookup & Reference Functions:

VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Paste Special, Paste link

   Session 7 - Pivot Table and Charts:

Pivot Table and Charts Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display and Pie Chart, Area Chart, Scatter Chart, Gantt Chart, Pareto Chart etc.

   Session 8 - Data Collectionand Dashboards

Data Collection Method with Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality and Dashboards.

Read More
Program Highlights
Instructor-led
Live interactive and classroom training will include the practical approach and assessments on regular basis.
Live Case Study
Case study using industry specific data helps you to get hands on with a good exposure.
Assignments
Assignments which helps in conceptual understanding, Prepared for interview training & techniques.
Lifetime Access
Class recording, Study material ppt’s, pdf, assignments, datasets, case studies can be accessed through out the lifetime.
24 X 7 Support
We will support If any concern is raised related to the training, assignments, projects, case studies & interview questions.
Certification
After successful completion of the training and case study Palin will certify you as Palin certified Advance Excel Expert.
Career Counselor
Avail career guidance and Professional guidance for resume building, unlimited opportunities and interviews.
Trainers

Highly motivated with leadership skills having Master’s Degree. Holds good working experience in different domains like Retail, Banking, Healthcare FMCG, Financial Modeling using Excel.
FAQ's
   Who can go for Advance Excel Training?
Any Graduate who’s willing to work on Excel as Data Analyst, MIS Analyst, Business Analyst etc can go for advance excel training.
   What is Advance Excel?
Advance Excel is a skill set which helps participants to use Pivot Table, Analyses worksheet data, data mining & data cleaning, utilize data tools, import & export data & collaborate with others
   What is future of Advance Excel Experts?
Learning anything advance will precisely boost your career. Advance Excel is required for many job profiles. An advance excel expert knows how to present his/her data & reports in an impressive manner.
   Pre-requisite for Advance Excel?
There’s no pre-requisites as such to learn advance excel. Any Graduate/diploma candidate can apply for this training and get mentored by the experts of the industry
   Is this a classroom training or online?
In both of the modes Palin arrange classes, can go in either of that classroom as well as online.
   What all topics will be covered in Advance Excel?
Fetching Data for data mining, data cleaning or data preparation processes , Advance Excel Techniques with Formulas & Tips, Advance Excel Functions, Excel Pivot Table for Analysis, and Pivot Charts & Dashboards for Reporting & Analysis. Real Cases to get hands on working experience on Advance Excel.
   Which one is better classroom or online?
Everyone have their own opinion towards classroom or online training. In my point of view online classes are far better than classroom session. Online trainings have more much benefits comparative to classroom like we can easily record the session we can access that session whenever we want. In online session we just need a laptop and internet connection can easily access the classroom.
   After the course for which companies I can apply for?
Every company uses Excel. There are number of companies we are empanelled with as Accenture, IBM, WNS, EXL, Bank of America, American Express, Fractal Analytics, British Telecom, and Cognizant etc.
   What are pay packages for fresher in Advance Excel?
On an average a fresher gets 3-4 LPA with a skill set of advance excel.
   What is the process for Advance Excel Training?
An end to end excel training will be delivered. we'll cover both basic & advance excel module in the training. Our real time assignments will help you to learn the tool with a great exposure.
Reviews

Reviews

    My experience with Palin institute was quite good and faculty is also very cooperative. Good to gain knowledge for analytical skills👍

    I was looking for MS Excel & VBA Training. One of my friend suggested me to get enrolled with Palin Analytics. I’ve joined Palin Analytics for MIS training. They have the best trainer in industry their assignments helped to crack interview for the MIS profile. Finally I got placed in an mnc.
    Thanks Team !!

    Best Training organisation in Delhi/NCR

Your email address will not be published. Required fields are marked *



Latest News

Emerging Future of Data Scientists
Data scientists will live one of the accomplished and encouraging careers prospective of all IT employment through 2020. Healthcare, Banking and Telecom industries are the...Read More
Average Salary of A data scientist and related profiles
The national average salary offered to data scientists and their related position is ₹ 6,50,000.Read More
Benefits of Data Science using SAS & R
Banking and Healthcare industry has been using SAS for years because SAS is licensed software which guarantees the accuracy of its results and its safer...Read More
Python Overtakes R
Python overtakes R, becomes the leader in Data Science, Machine Learning platforms. While in 2016 Python was in 2nd place ("Mainly Python" had 34% share...Read More
What are benefits of python
Simple and easy to learn and understand. Performance is very fast and attractive. Python works with all different data formats. We can directly import SQL...Read More
Python Data Scientists Average Salary
The average salary offered to data scientists in the past year was £47,000, with Python being the most desirable programming language, according to an analysis...Read More
Python Vs Julia
Python vs Julia Python is a general-purpose computing language that is easy to learn, and that has developed into a leading language for scientific computing....Read More
Quick Enquiry
close slider