Professional Institute

Advanced MS Excel Training Courses in Institute Ghaziabad Claim

0 / 5
Compare

Advanced Excel Training Course Programme Modules
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.

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

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

Text Functions & Data Validation in Advanced Excel:-
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 in Advanced Excel:-
Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen

Logical Functions in Advanced Excel:-
And, Or, If, Iferror, Not, Nested If

Lookup & Reference Functions in Advanced Excel:-
VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link

Power Pivot- MIS, Data Analysis & Visualization:-
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

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

Analysis Single/Multidimensional Analysis in Advanced Excel
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 in Excel.
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

Two Live Report Development in Advanced Excel – (Real World Data)

SAS Institute

For More Info Call +91-8860743525 Visit us :-

http://sasinstitute.in/advance-excel-and-mis-training/

You Can Follow some Social Account:

https://www.facebook.com/sasinstitute/

https://plus.google.com/u/0/114218136165655038210

https://www.youtube.com/channel/UC1E9o72c1HDwc7QV-PoZGEA

Read More

http://sasinstitute.in/

  • Price INR 4000
  • Listing categories IT / Microsoft Office / Microsoft Excel
  • Course Location: Add:- F 35 Sec-3 Vaishali Near Chhaya public School Ansal Plaza Vaishali Metro Station

Course Fee

$4,000

Course Name

Advanced MS Excel Training Courses in Institute Ghaziabad

Course Description

Easy to make a report in Excel, graph and statistical presentation in MS Excel, dashboard & power pivot table in Microsoft Advanced Excel Classes and a live project. Enroll for Excel Demo classes in Noida, Vaishali, Indirapuram, Vasundhara, Kaushambi, Sahibabad, Ghaziabad, Delhi

Education Type

Online Training, Classroom

Education level

Beginner, Intermediate, Professional

Education Subject

Graphic Designing

Payment Option

Cash, Installment, Online Payment

Study Material

Yes - Provided by Institute

Hostel Facilities

Not Available

Post New Review

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

Leave the field below empty!

Best Alternatives