Videos on YouTube (click here for all)
Transforming Data with a LogNormal Distribution Working with Dates in Excel Interpolation with Formulas and VBA Managing Gradients in Excel Simulation of Election Polls Data Tables for Profit Calculations Matrix Elimination in Excel Monte Carlo Simulation of Buy/Sell Stock Dixon Plots in Excel Lineweaver-Burke Plots in Excel Michaelis-Menten Plots in Excel Dissociation Curves in Excel Optimal Resource Allocation Generating Correlated Distributions Bootstrapping for Non-Normal Distributions The Margin of Error in Polls Interpolation and Extrapolation Testing Significance for Non-Normal Distributions Random Sampling Formulas Monte Carlo Simulation of Waiting Time Fixed Autonumbers A New Great Tool for Curve Fitting Monte Carlo Simulation of Stock Volatility Fitting S-Curves with a Boltzmann Equation Excel Simulation of Ehrenfest's Urn Simulation of Flocking Behavior in Excel What Should Be the Size of My Sample? A Hawk-Dove Simulation Floating Charts in Excel Calculating Group Summaries in Excel A Quick Access to Run Your Macros Monte Carlo Simulation of Integration Filter an Excel List by Selection Combine Various List into One Pivot Table Simulation of Number and Letter Games Find a Cell Range with INDEX and MATCH A Comparison of Two Excel Lists Using Slicers in Pivot Tables Ways to Format Subtotals Differently The Perfect Bell Shape Curve Pivot Table Secrets Multiple Regression with Excel's LINEST The Power of SUMIFS in Excel Reports How to Tackle Some Pivot Table Hurdles Automatic Standard Error Calculations Monte Carlo Simulation of Natural Selection Pie Charts with Automatic Data Changes Pivot Table Calculations: Manually or with VBA Temperature Fluctuations: Results May Vary Frequency Simulations with Memory Montecarlo Simulation of Juror Selection in USA Excel Tricks: Automatic change of chart data Autonumbering of Records in an Excel Spreadsheet A Data Table Simulation with Memory Subtotals with OFFSET, ROWS, ROW, and MOD Curve Fitting for a Hyperbolic Curve Autocorrecting, Autoformatting, and Validation Combined Percentile Markers in an Excel Chart Correlation, Range Names, and INDIRECT SUMIFS and AVERAGEIFS Creating Charts in Excel INDEX and MATCH with Wildcards Dropdown Boxes with Unique Entries in Excel Monte Carlo Simulation of Mendel's Laws in Excel ANOVA or Analysis of Variance in Excel Dropdown Boxes for a Variety of Lists Trouble, When Numbers Are Not Numbers VLOOKUP on Multiple Columns and Tables A Comparative Histogram in Excel Tricks to Create Totals and Filter Them Confidence and Prediction Limits for EC50 and IC50 Confidence Intervals vs. Predictability Intervals A Loan Worksheet with Formulas and VBA 3D Charts or Graphs in Excel Table of Frequency Distributions in Excel Bootstrap Statistics with Excel and VBA VBA and Formulas to Determine the Margin of Error Monte Carlo Simulation of Randow Walk in Evolution A Transfer from Excel to Access Requires Some Work Simulation of DNA Sequencing in Excel Mean, Median, and SD of Grouped Data Simulation of Taking Binomial Samples from Populations Compare a New List with an Old List in Excel The Power of Range Names in Excel Formulas Make Range Names in Your Excel Formulas Dynamic A Custom Function for IC50 or EC50 Determination Monte Carlo Simulations in Excel What-If Analysis with a Data Table Simulating Genetic Drift in Excel Controls for Simulations and What-if Analysis How to Deal with Skewed Data Statistical Testing for Normality in Excel Solving 3 Equations with 3 Unknowns Extrapolation and Forecast How Do I Create Error Bars in Excel Charts? Sampling Sizes and Sampling Tools A Formula for STDEV under Several Conditions LINEST Can Do What TREND Cannot Do Does Excel Have a Broken Axis? Statistical Significance in Excel Allowing Other Users to Change Your Excel Spreadsheets Creating Outlines on Your Spreadsheets w/ and w/o VBA Creating Markers in Your Excel Charts/Graphs Creating Advanced and Calculated Filters in Excel Pivot Table Secrets in Excel Streamlining Data Entry in Excel Creating a Summary Based on Several Spreadsheets SUMIF, SUMIFS, COUNTIF, COUNTIFS Conditional Formatting with Formulas How to Use the FREQUENCY Function in Excel Creating Nested Functions in Excel INDEX beats VLOOKUP in Excel Excel Trends: Moving Averages and Exponential Smoothing Outliers in Research: How to locate them. EC50 and IC50 Determination in Excel: sigmoid or logistic curves Testing for Statistical Significance in Excel: the Chi-Squared Test Curve Fitting in Excel Trends, Interpolation, and Extrapolation in Excel
Transforming Data with a LogNormal Distribution Simulation of Holism and Reductionism Interpolation with Formulas and VBA Managing Gradients with Excel VBA Simulation of Election Polls Excel VBA for Random Sampling Deleting multiple, discontinuous rows with VBA A Progress Counter with VBA Generating Correlated Distributions Bootstrapping for Non-Normal Distributions Make Your Own Password Form with VBA Slotmachine Stimulation with VBA VBA Simulation of Galton's Bean Machine VBA Filter for Columns instead of Rows VBA Simulation of Ehrenfest's Urn Encryption of Confidential Numbers in Excel A Quick Access to Run Your Macros Simulation of Random Games with VBA Extract Address from an Excel List to Print Filter an Excel List by Selection Building a Pivot Table with VBA A Simple Auto-Fill Form in Access Cycling through Percentile Views with VBA Lining Up Multiple Charts with VBA How to Alphabetize Your Spreadsheets Automatic Standard Error Calculations A certain Day of the Week at a Certain Day of the Month VBA Creates a Printout and PDF File of Each Individual Sheet Pivot Table Calculations: Manually or with VBA Interpolation with Graph Insert in XL VBA Splitting a Column with Excel VBA Conditional Formatting Functions in VBA A Monte Carlo Gambling Simulation with VBA Validating and Formatting WHILE You Type VBA Mailmerge with Specific Columns VBA for Data Tables and Conditional Formatting MonteCarlo Simulation of Frequency Distributions with VBA Buttons and Popup Menus for Excel Macros Group Records by Week and Count Them Use VBA to Convert Text Dates into Excel Dates VBA Can Send Emails from Excel through Outlook and Shell A Loan Worksheet with Formulas and VBA Copy Excel Dates into Outlook Calendar with VBA Bootstrap Statistics with Excel and VBA VBA and Formulas to Determine the Margin of Error An Excel Form to Display VBA Info Using Cell Addresses in Excel VBA Let VBA Calculate All Your Totals at a Click Troubleshooting and Debugging Your VBA code Running Macros from a Listbox on your Excel Spreadsheet A Chart Made on the Fly by Excel VBA Scanning Files and Subfolders and Plotting them in Excel Can I Undo Macro Steps? VBA Function to Neatly Format Any Phone Number A Right-Click Menu for Your Macros in VBA Hiding Rows with Excel VBA Sorting Excel Sheets in an Alphabetical Order Updating Range Names with Excel VBA Protecting All Your Sheets or Formulas with Excel VBA Moving Excel Data into Access with VBA Using VBA for Dynamic Filters in Access Tables VBA Mail Merge from Excel to Word Making VBA Script Available to Other Users or Machines Creating Outlines on Your Spreadsheets w/ and w/o VBA Excel VBA Can Make Things Happen at the Right Moment Calling Excel's Dialog Boxes with VBA Using For-Each Loops in Excel VBA Manipulating Date and Time in Excel VBA Creating Calendars with Excel VBA Control Data Entry in Excel with UserForms Creating an Automatic Summary of Multiple Sections with Excel VBA Creating Nested Functions in Excel Using VLOOKUP in VBA to locate and correct missing data A Swift Way of Creating Subtotals with Excel VBA Creating Charts and Pivot Tables on the Fly with VBA Automatic VBA Fix of Messy Records in Excel VBA Scan Your Folders with Dir() in Excel VBA Exporting Access Tables and Queries into Excel by using VBA User-Defined Functions in Excel
Splitting an Access Database A Switchboard for an Access Database Using Update Queries in an Access Database Mail Merge from an Access Database Crosstab Query in an Access Form The Power of Total Queries in Access ComboBoxes Streamline Your Access Forms How to Steer Your Access Queries The Field Settings of an Access Table Several Ways of Summing in Access Creating a Professional Access Table Crosstab Subreport in an Access Report No More Pivot Tables in Access 2013 A Catalogue Report in Access A Tabbed Access Form with Subforms and Sub-Sub-Forms A Transfer from Excel to Access Requires Some Work Queries That Change Your Access Records and Tables Designing an Access Database An Access Subform Based on a Many-to-many Relationship Creating an Access Form with Subforms Creating a Quaterly Report in Access How Do I Get Calculated Overviews out of My Access Database? Parameters in Access Queries Creating Crosstab Queries in MS Access
Users and Passwords with Access VBA Popup Menu for an Access Database How to Email PDF Files of an Access Report VBA Creates an Access Form with Subform from Scratch Protecting Your Access Database with VBA Access VBA to Create Pivot Table Reports Navigation between Access Forms with VBA Button to Backup a Back-End Database Exporting Arrays from Access to Excel Access VBA Can Create a New Table from Excel Data A Switchboard for an Access Daisy Database Drilling-down in Your Database with Access VBA Email PDF files of Access Reports with VBA Automatic Backup of Tables when Access Closes Copy Access Dates into Outlook Calendar with VBA Rolling Back Faulty Transactions with Access VBA Let Forms Popup with Access VBA Long SQL Statements in VBA An auto-backup of ALL your database objects with VBA VBA Filters with Parameters in an Access Database Moving Excel Data into Access with VBA Using VBA for Dynamic Filters in Access Tables Retrieving the Most Recent Shipping Address with Access VBA Drilling Down with SQL and Access VBA Using VBA to Filter Dates in an Access Database Using VBScript to Email Data from Tables, Queries, or Reports An Automatic Backup of your Access Data at Preset Times Merging Access Tables and Removing Duplicate Records Scheduling in Access automatically done with VBA An Appointment Form in Access step-by-step Exporting Access Tables and Queries into Excel by using VBA
Programming with C# (C-Sharp) Text Encryption with VBScript VBScript to Keep Refreshing a Web Page A Financial Calculator with VBScript Using VBScript to Mobilize the Internet Using VBScript to Email Data from Tables, Queries, or Reports Start Using VBScript in NotePad VBScript General CD