Data Analysis with Excel

1.Overview - Data Analysis with Excel
Data Mining
Business Intelligence
Statistical Analysis
Predictive Analytics
Text Analytics

2.Data Analysis  -  Process
Data Requirements Specification
Data Collection
Data Processing
Data Cleaning
Data Analysis
Communication

3.Working with Range Names
Copying Name using Formula Autocomplete
Range Name Syntax Rules

4.Tables
Difference between Tables and Ranges
Create Table
Table Name

5.Working with Time Values
Time Formats
Time in Hour-Minute-Second Format
Obtaining Time from Hour, Minute and Second
Extracting Hour, Minute and Second from Time

6.Sorting
Sort by Text
Sort by Numbers
Sort by Dates or Times
Sort by Cell Color
Sort by Font Color
Sort by Cell Icon
Sort by a Custom List
Sort by Rows
Sort by more than one Column or Row

7.Conditional Formatting
Highlight Cells Rules
Top / Bottom Rules
Data Bars
Color Scales
Icon Sets
New Rule
Clear Rules

8.Filtering
Filter by Selected Values
Filter by Text
Filter by Date
Filter by Numbers
Filter by Cell Color
Filter by Cell Icon
Reapply Filter
Filter Using Slicers

9.Subtotals with Ranges
Subtotals

10.Quick Analysis
Formatting
Charts
Totals
Sparklines
Sum
Average
Count

11.Financial Analysis
What is Annuity?
What is EMI?
Calculating Interest Rate
Decisions on Investments
Internal Rate of Return (IRR)

1.Overview - Data Analysis with Excel
Data Mining
Business Intelligence
Statistical Analysis
Predictive Analytics
Text Analytics

2.Data Analysis  -  Process
Data Requirements Specification
Data Collection
Data Processing
Data Cleaning
Data Analysis
Communication

3.Working with Range Names
Copying Name using Formula Autocomplete
Range Name Syntax Rules

4.Tables
Difference between Tables and Ranges
Create Table
Table Name

5.Working with Time Values
Time Formats
Time in Hour-Minute-Second Format
Obtaining Time from Hour, Minute and Second
Extracting Hour, Minute and Second from Time

6.Sorting
Sort by Text
Sort by Numbers
Sort by Dates or Times
Sort by Cell Color
Sort by Font Color
Sort by Cell Icon
Sort by a Custom List
Sort by Rows
Sort by more than one Column or Row

7.Conditional Formatting
Highlight Cells Rules
Top / Bottom Rules
Data Bars
Color Scales
Icon Sets
New Rule
Clear Rules

8.Filtering
Filter by Selected Values
Filter by Text
Filter by Date
Filter by Numbers
Filter by Cell Color
Filter by Cell Icon
Reapply Filter
Filter Using Slicers

9.Subtotals with Ranges
Subtotals

10.Quick Analysis
Formatting
Charts
Totals
Sparklines
Sum
Average
Count

11.Financial Analysis
What is Annuity?
What is EMI?
Calculating Interest Rate
Decisions on Investments
Internal Rate of Return (IRR)