Video description
Master data analysis with Excel 2013 on your terms with this one-of-a-kind video training course. Excel 2013 is Microsofts industry leading spreadsheet application that allows you to organize, visualize and calculate your data. Our instructors provide expert, straight-forward, user-friendly training to help you understand the various ways to use Excel 2013 to analyze data for your personal, small, or large business needs. Build formulas and add functions and conditions to them Analyze financial data to determine loan payments and interest rates Sort and filter data and build PivotTables Work with Goal Seek and Scenarios and the Analysis ToolPack Includes over 3 hours of Excel Data Analysis video training. If youre looking for real-world instruction on analyzing data with Excel 2013, you'll find it here.
http://www.wiley.com/WileyCDA/Section/id-825413.html
Table of Contents
Building Formulas for Data Analysis
Building a Formula
00:04:43
Moving or Copying a Formula
00:03:56
Creating an Array Formula
00:02:53
Adding a Function to a Formula
00:02:08
Creating a Conditional Formula
00:04:39
Looking Up Values
00:05:09
Performing Date and Time Calculations
00:06:24
Analyzing Financial Data
Calculating the Future Value
00:04:00
Calculating the Present Value
00:02:21
Determining the Loan Payments
00:02:21
Calculating the Principal or Interest
00:03:58
Finding the Required Interest Rate
00:03:14
Determining the Internal Rate of Return
00:02:07
Analyzing Statistical Data
Calculating an Average
00:05:42
Finding the Rank
00:03:24
Determining the Nth Largest or Smallest Value
00:02:16
Creating a Grouped Frequency Distribution
00:02:34
Calculating the Variance and Standard Deviation
00:03:33
Finding the Correlation
00:02:31
Sorting and Filtering Data
Performing a Simple Sort or Filter
00:04:58
Performing a Multilevel Sort
00:02:53
Creating a Custom Sort
00:03:16
Sorting by Cell Color, Font Color, or Cell Icon
00:02:31
Usinging Quick Filters for Complex Filtering
00:03:27
Creating an Advanced Filter
00:03:27
Learning Data Analysis Techniques
Highlighting Cells That Meet Some Criteria
00:05:39
Analyzing Cell Values with Data Bars, Color Scales, and Icon Sets
00:05:11
Creating a Custom Conditional Formatting Rule
00:04:08
Setting Data Validation Rules
00:03:01
Creating a Data Table
00:05:00
Analyzing Data with Goal Seek
00:03:24
Analyzing Data with Scenarios
00:04:32
Optimizing a Result with Solver
00:05:55
Tracking Trends and Making Forecasts
Plotting a Best-Fit Trendline
00:05:37
Plotting Forecasted Values
00:03:20
Extending a Linear Trend
00:02:30
Plotting an Exponential Trendline
00:05:12
Plotting a Logarithmic Trendline
00:02:20
Plotting a Power Trendline
00:02:22
Working with the Analysis ToolPak
Loading Excel’s Analysis ToolPak
00:03:26
Calculating a Moving Average
00:02:36
Comparing Variances
00:03:48
Calculating Correlation
00:03:17
Running a Regression Analysis
00:03:45
Determining Rank and Percentile
00:03:03
Calculating Descriptive Statistics
00:03:54
Analyzing Data with PivotTables
Building a PivotTable from an Excel Range or Table
00:05:23
Creating a PivotTable From External Data
00:03:26
Adding Multiple Fields to a Pivot Table Area
00:04:17
Grouping PivotTable Values
00:03:03
Changing the PivotTable Summary Calculation
00:02:11
Inserting a Custom Calculated Field or Item
00:04:05