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
  • 10 Hours
  • Publisher: Holy Macro! Books
  • 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

Amazon

DVD from Amazon

Buy Now ยป

Related Products


Excel 2013 for Scientists

March 2014

You're a Scientist! Aren't you tired of trying to learn Excel from an accountant's perspective? This book will cover the topics truly important to science as well as engineering professionals. Learn about sampling distributions and regressions and graphing.


100 Excel Simulations

November 2016

Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.