$475 (USD)

Add To Cart
microsoft excel 2019 and statistics suite

Introduction to Microsoft Excel 2019/Office 365

  1. Excel Basics
  2. Creating a Worksheet
  3. TimeSavers
  4. Relative, Absolute, Mixed, and Circular References
  5. 3Dimensional Workbooks
  6. Sorting, Subtotaling, and Filtering
  7. Charting Basics
  8. Advanced Charting Techniques
  9. Intro to Excel's Statistical Functions
  10. Financial Functions
  11. Worksheet Automation
  12. Mastering Excel's IF Function

Intermediate Microsoft Excel 2019/Office 365

  1. Excel Charts and Graphs
  2. More Excel Charts
  3. AutoFilter and Sorting
  4. Goal Seeking
  5. Pivot Tables
  6. Advanced PivotTables
  7. Solver
  8. Sparklines
  9. Macros
  10. Introduction to Functions
  11. Math/Trig Functions
  12. VLOOKUP, INDEX, and MATCH Functions

Advanced Microsoft Excel 2019/Office 365

  1. Customizing Excel
  2. Table Management
  3. Data Validation
  4. Custom Controls
  5. Conditional Formatting
  6. Consolidating and Outlining
  7. Excel Functions and Nesting
  8. Import External Data
  9. Data Tables
  10. What-If Analysis Tools
  11. Advanced PivotTables
  12. Analysis ToolPak, Advanced Filter, Array Formulas, and More!

Introduction to Statistics

  1. What Is Statistics, Anyway?
  2. Quantitative Data: From Averages to Z-Scores
  3. Displaying Quantitative Data: Dots, Plots, and Histograms
  4. Displaying Qualitative Data: Percentages, Charts, and Graphs
  5. Is There a Link? Scatterplots and Correlation
  6. Linear Regression: How Can You Predict the Future?
  7. What's the Chance of That? Probability Concepts
  8. Probability Models: What's Normal?
  9. The Key to Inference: Sampling Distributions
  10. How Certain Are You? Confidence Intervals for Proportions
  11. Trial by Data: Testing Hypotheses About Proportions
  12. Inference About Means

 
  Close Nav
  • Learn a new skill or enhance existing skills for professional development or personal enrichment.
  • New sessions starting monthly with lessons and assignments released weekly.
  • 2-4 hours a week in a convenient six-week format.
  • Interactive learning environment. Classroom built around discussion areas where you can engage with classmates and instructors.
  • Expert instructors develop, lead, and interact with students in each course.
  • Award of completion from your learning institution with passing score.
  • Gain the knowledge needed to move forward with your education.
  • Start anytime. Access Granted upon registration.
  • Courses are designed to be completed within 6-12 weeks.
  • Interactive multi-media instruction with integrated assessment, allowing you to work at your own pace.
  • Professional instructors support you throughout your learning experience.
  • Confirmation of successful course completion.
  • Build industry skills or earn continuing education credits in a variety of fields.
  • Start Anytime. Access to all course material and assessments from day one.
  • Many tutorials can be completed in just a few hours.
  • Quick independent study. Learn something new or expand your knowledge while working at your own pace.
  • Material developed by industry leaders and student support offered.
  • Certificate of completion awarded with passing score.

Forgot Password?