# Excel Video Medley

April 2016 ## 71 Excel Videos on Two DVD-ROM

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

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)
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)