O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Excel 2013 Data Analysis Essentials

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

  1. Building Formulas for Data Analysis
    1. Building a Formula 00:04:43
    2. Moving or Copying a Formula 00:03:56
    3. Creating an Array Formula 00:02:53
    4. Adding a Function to a Formula 00:02:08
    5. Creating a Conditional Formula 00:04:39
    6. Looking Up Values 00:05:09
    7. Performing Date and Time Calculations 00:06:24
  2. Analyzing Financial Data
    1. Calculating the Future Value 00:04:00
    2. Calculating the Present Value 00:02:21
    3. Determining the Loan Payments 00:02:21
    4. Calculating the Principal or Interest 00:03:58
    5. Finding the Required Interest Rate 00:03:14
    6. Determining the Internal Rate of Return 00:02:07
  3. Analyzing Statistical Data
    1. Calculating an Average 00:05:42
    2. Finding the Rank 00:03:24
    3. Determining the Nth Largest or Smallest Value 00:02:16
    4. Creating a Grouped Frequency Distribution 00:02:34
    5. Calculating the Variance and Standard Deviation 00:03:33
    6. Finding the Correlation 00:02:31
  4. Sorting and Filtering Data
    1. Performing a Simple Sort or Filter 00:04:58
    2. Performing a Multilevel Sort 00:02:53
    3. Creating a Custom Sort 00:03:16
    4. Sorting by Cell Color, Font Color, or Cell Icon 00:02:31
    5. Usinging Quick Filters for Complex Filtering 00:03:27
    6. Creating an Advanced Filter 00:03:27
  5. Learning Data Analysis Techniques
    1. Highlighting Cells That Meet Some Criteria 00:05:39
    2. Analyzing Cell Values with Data Bars, Color Scales, and Icon Sets 00:05:11
    3. Creating a Custom Conditional Formatting Rule 00:04:08
    4. Setting Data Validation Rules 00:03:01
    5. Creating a Data Table 00:05:00
    6. Analyzing Data with Goal Seek 00:03:24
    7. Analyzing Data with Scenarios 00:04:32
    8. Optimizing a Result with Solver 00:05:55
  6. Tracking Trends and Making Forecasts
    1. Plotting a Best-Fit Trendline 00:05:37
    2. Plotting Forecasted Values 00:03:20
    3. Extending a Linear Trend 00:02:30
    4. Plotting an Exponential Trendline 00:05:12
    5. Plotting a Logarithmic Trendline 00:02:20
    6. Plotting a Power Trendline 00:02:22
  7. Working with the Analysis ToolPak
    1. Loading Excel's Analysis ToolPak 00:03:26
    2. Calculating a Moving Average 00:02:36
    3. Comparing Variances 00:03:48
    4. Calculating Correlation 00:03:17
    5. Running a Regression Analysis 00:03:45
    6. Determining Rank and Percentile 00:03:03
    7. Calculating Descriptive Statistics 00:03:54
  8. Analyzing Data with PivotTables
    1. Building a PivotTable from an Excel Range or Table 00:05:23
    2. Creating a PivotTable From External Data 00:03:26
    3. Adding Multiple Fields to a Pivot Table Area 00:04:17
    4. Grouping PivotTable Values 00:03:03
    5. Changing the PivotTable Summary Calculation 00:02:11
    6. Inserting a Custom Calculated Field or Item 00:04:05