MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Video Medley


April 2016

Excel Video Medley

71 Excel Videos on Two DVD-ROM

Just over 10 hours of content on Excel Formulas, Charts, Pivot Tables, Statistics & Simulations


category: Spreadsheets
covers: Excel 2013 - 2016, Office 365

Product Details
  • 2 DVD-ROM: 71 Videos
  • Publisher: Holy Macro! Books
  • Print ISBN: 978-1-61547-046-4

Excel Video Medley covers everything from Pivot Tables to VLOOKUP to VBA. Learn how to create scientific graphs. Use Excel for statistics.

Each video runs from 4 to 14 minutes.

  1. Manipulating Date and Time in Excel (12:53)
  2. Dropdown Boxes for a Variety of Lists (9:53)
  3. Dropdown Boxes with Unique Entries in Excel (7:04)
  4. Trouble When Numbers Are Not Numbers (13:36)
  5. Autonumbering of Records in an Excel Spreadsheet (8:30)
  6. Creating Advanced and Calculated Filters in Excel (10:42)
  7. Allowing Other Users to Change Your Excel Spreadsheets (5:59)
  8. How to Use the FREQUENCY Function in Excel (11:25)
  9. Nested Functions in Excel (12:06)
  10. VLOOKUP on Multiple Columns or Tables (9:53)
  11. INDEX beats VLOOKUP in Excel (13:51)
  12. INDEX and MATCH with Wildcards (4:43)
  13. Streamlining Data Entry in Excel (10:57)
  14. The Power of SUMIFS in Excel Reports (9:53)
  15. SUMIFS and AVERAGEIFS (7:32)
  16. SUMIF, SUMIFS, COUNTIF, COUNTIFS (12:32)
  17. An Array Formula for STDEV-IFS (9:19)
  18. Mean, Median, and SD for Grouped Data (7:47)
  19. Solving 3 Equations with 3 Unknown X's (5:00)
  20. Subtotals with OFFSET, ROWS, ROW, and MOD (6:16)
  21. The Power of Range Names in Excel Formulas (7:06)
  22. Make Range Names in Your Excel Formulas Dynamic (5:32)
  23. Conditional Formatting with Formulas (11:55)
  24. Creating Charts in Excel (6:38)
  25. Creating Markers in Your Excel Charts-Graphs (11:50)
  26. Percentile Markers in an Excel Chart (9:19)
  27. How Do I Create Error Bars in Excel Charts (6:39)
  28. Does Excel Have a Broken Axis (3:19)
  29. 3D Charts and Graphs in Excel (7:02)
  30. A Comparative Histogram in Excel (5:19)
  31. Extrapolation and Forecast (11:43)
  32. Excel Tricks - Automatic change of chart data (6:23)
  33. Pie Charts with Automatic Data Changes (7:45)
  34. The Perfect Bell Shape Curve (7:01)
  35. If Analysis with a Data Table (7:30)
  36. Table of Frequency Distributions in Excel (7:40)
  37. Tricks to Create Totals and Filter Them (10:00)
  38. Creating a Summary Based on Several Spreadsheets (11:04)
  39. Compare a New List with an Old List in Excel (7:53)
  40. Pivot Table Secrets (11:13)
  41. Pivot Table Secrets in Excel (12:23)
  42. How to Tackle Some Pivot Table Hurdles (7:00)
  43. Pivot Table Calculations - Manually or with VBA (8:41)
  44. Table Structure and Calculations (10:38)
  45. Sampling Sizes and Sampling Tools (12:15)
  46. Statistical Testing for Normality in Excel (8:07)
  47. How to Deal with Skewed Data (6:19)
  48. Outliers in Research (11:45)
  49. Trends, interpolation, and extrapolation (9:38)
  50. Curve Fitting in Excel (12:46)
  51. Curve Fitting for a Hyperbolic Curve (9:17)
  52. LINEST Can Do What TREND Cannot Do (9:09)
  53. Multiple Regression with Excel's LINEST (6:43)
  54. Correlation, Range Names, and INDIRECT (4:47)
  55. Confidence Intervals vs. Prediction Intervals (9:15)
  56. EC50 and IC50 Determination in Excel (11:51)
  57. Confidence and Prediction Limits for EC50 and IC50 (12:51)
  58. Testing for Statistical Significance in Excel (11:54)
  59. Squared Significance Test (13:29)
  60. ANOVA or Analysis of Variance in Excel (12:32)
  61. Temperature Fluctuations - Results May Vary (5:53)
  62. A Data Table Simulation with Memory (6:42)
  63. Frequency Simulations with Memory (7:51)
  64. Monte Carlo Simulations in Excel (6:37)
  65. Simulation of Taking Binomial Samples from Populations (5:17)
  66. Simulating Genetic Drift in Excel (8:24)
  67. Monte Carlo Simulation of Random Walk in Evolution (6:05)
  68. Monte Carlo Simulation of Mendel's Laws in Excel (11:32)
  69. Monte Carlo Simulation of Natural Selection (7:34)
  70. Monte VCarlo Simulation of Juror Selection in USA (8:34)
  71. Monte Carlo Simulation of DNA Sequencing in Excel (5:53)

Where to Buy

MrExcel Store

DVD from MrExcel

DVD from MrExcel »

Amazon.com

DVD from Amazon

DVD from Amazon »

Related Products