EXCEL DATA ANALYSIS TRAINING (e-DAT)
EXCEL DATA ANALYSIS TRAINING
(e-DAT)
Redefine Your Analytics Journey with Data Discovery & Analytics
Duration 12 - 15 Days
Taught By Excel Analytics
Fees INR 8500
DESCRIPTION Learn Analytics from start, through detailed discussions on topics & working on live industry projects using Excel tools & Functions.
ASK TO YOURSELF Analysis of data is a process of inspecting, cleaning, transforming, and modeling data with the goal of discovering useful information, suggesting conclusions, and supporting decision-making
ELIGIBILITY Basic understanding of statistics (like mean, median) Basic understanding of excel formulas (like sum function) Most important: Love for numbers and data!
AUDIENCE
Working Professionals Young Entrepreneurs Students
TOOLS AND TECHNIQUES
MS Excel Analysis ToolPak - Add-Ins SAS data analytics tools X Business analytics R tool X Tableau data analytics tool X Google Fusion Tables etc. X
TRAINING PROGRAM STRUCTURE: EXCEL DATA ANALYSIS This section illustrates the powerful features Excel has to offer to analyze data.
MIS & Data Analysis
Process Analysis
Management Analysis
Business Analyst
Statistical Analysis
PART: A ? TOOLS
Sorting: You can sort your Excel data on one column or multiple columns. You can sort in ascending
or descending order. Filter: Filter your Excel data if you only want to display records that meet certain criteria. Conditional Formatting: Conditional formatting in Excel enables you to highlight cells with a certain
color, depending on the cell's value. Tables: Tables allow you to analyze your data in Excel quickly and easily. Charts: A simple Excel chart can say more than a sheet full of numbers. As you'll see, creating charts
is very easy. Pivot Tables: Pivot tables are one of Excel's most powerful features. A pivot table allows you to
extract the significance from a large, detailed data set. What-If Analysis: What-If Analysis in Excel allows you to try out different values (scenarios) for
formulas. Solver: Excel includes a tool called solver that uses techniques from the operations research to find
optimal solutions for all kind of decision problems. Analysis ToolPak: The Analysis ToolPak is an Excel add-in program that provides data analysis tools
for financial, statistical and engineering data analysis.
PART: B - STATISTICAL FUNCTIONS
SUBTOTAL SMALL COUNTIF
VLOOKUP STDEVP
ROUND LARGE COUNTIFS MATCH STDEVPA
MEDIAN IF
AVERAGE LOGNORMDIST
TDIST
MODE AND COUNTA POISSON VAR
MIN OR RANK STANDARDIZE VARA
MAX SUMIF DATEDIF STEDV VARP
F9 KEY SUMIFS EDATE STDEVA VARPA
ANALYSES
?Descriptive
A
B
?Exploratory
?Inferential
C
D
?Predictive
?Causal
E
F
?Mechanistic
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- quattro pro formulas functions and macros
- nested ifs if and if or
- excel data analysis training e dat
- summarize and analyze data ms excel 2016
- microsoft excel 2013 king county library system
- microsoft excel advanced towson university
- countif function in excel syntax and usage
- one on one computer help computer classes techtutor
Related searches
- excel data analysis t test
- data analysis training ppt
- excel data analysis regression tool
- data analysis with excel examples
- excel data analysis tutorial pdf
- data analysis tool excel 365
- excel data analysis add on
- data analysis training courses
- excel data analysis for dummies
- excel data analysis add in
- excel data analysis missing
- excel data analysis toolpak missing