• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • SALE 20% Off All Courses
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Logout
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel Analysis ToolPak Course

You are here: Home / Excel Analysis ToolPak Course

with Dr Isaac Gottlieb.

Excel Analysis Toolpak course

This is statistics for a non-statistician.

This course is ideal for executives or analysts who need to calculate and report the statistics of data, or make decisions based on statistical output. This course will show you how to do it fast and efficiently without the burden of using calculators or the lengthy procedures necessary with conventional Excel functions.

Dr Gottlieb will teach you how you can use the Excel Analysis Toolpak add-in to quickly and easily generate complex statistical analysis, including:

  • Descriptive Statistics - Generatie most of the statistical functions in a couple of clicks: Mean, Standard Error, Median, Mode, Standard Deviation, Sample Variance, Kurtosis, Skewness, Range, Minimum, Maximum, Sum, Count, the Largest, Smallest and Confidence Level Interval.

  • Histograms - Easily create frequency distributions and charts.

  • Correlation - Calculate numerous correlations between a number of data sets at once.

  • Regression - Generate single and multi-regressions with up to 12 independent variables.

  • Rank and Percentile - Use the rank and percentile feature of the toolPak that will easily rank all the values in the range as well as the percentiles of all the values.

  • Random Number Generation - Generate random numbers from a variety of distributions if you have to create a Monte Carlo simulation.

  • Sampling - The Sampling analysis tool creates a sample from a population by treating the input range as a population. When the population is too large to process or chart, you can use a representative sample. You can also create a sample that contains only the values from a particular part of a cycle if you believe that the input data is periodic.

Each topic comes with a practice exercise so you can solidify your understanding before moving on to the next one.

And when you're finished we'll send you a Certificate of Completion to add to your résumé.

Who is teaching the course

Isaac Gottlieb Dr. Isaac Gottlieb earned his PhD in Management Engineering from Columbia University. He is a clinical professor at the Fox Business School of Temple University and has over 15 years of industrial experience.

He was awarded a Microsoft Excel Most valuable Professional (MVP) for 2014 - 2016.

Dr. Gottlieb has taught Excel over the last 15 years to over 30,000 MBA, executive MBA, MS, PhD and undergraduate students at Columbia, NYU, Temple, and other universities. He has conducted numerous corporate seminars in the United States and abroad.

He is also the author of Next Generation Excel: Modeling in Excel for Analysts and MBA’s.

Course Prerequisites

  • This course is for any Excel user that needs to calculate statistical results in a fast and efficient way without worrying about the actual statistics and the functionality of Excel.
  • Introductory high school or college level statistics. This is NOT for you if you are not familiar with the foundations of statistics like standard deviation, correlation, mode, median or regressions.
  • Excel 2007 or later.

Course Syllabus

The course contains the following sessions:

  1. Descritptive Statistics
  2. Histograms
  3. Correlation
  4. Regression
  5. Rank and Percentile
  6. Random Number Generation
  7. Sampling
  8. Moving Average
  9. Exponential Smoothing
  10. Capstone Case Study
Excel Analysis ToolPak Course Syllabus

Choose Your Membership Level

These Prices Already Have The 20% Discount Applied
Currency
Choose Currency
Excel Analysis ToolPak Online Excel Analysis ToolPak Download
30 Day Guarantee
Note: prices are +GST for Australian customers.

$19 $15Add to cart

$19 $15Add to cart

12 Months Online

$19 $15Add to cart

$39 $31Add to cart

$39 $31Add to cart

12 Months Online + Download

$39 $31Add to cart

Excel Analysis ToolPak Videos
1hr 33min
One Payment for 12 Months Online Access
Download Videos * See Notes
Unlimited 24/7 access
Pause, rewind, replay
Download Workbooks
and Practice Data
30 Day Money Back Guarantee

Notes

  • Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  • Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  • Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  • You can request a refund provided that no more than 30% of the course videos have been watched.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
trustpilot excellent rating
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.