×
Phoenix TS

Manipulating and Understanding Data in Excel Training

This 2-day instructor-led training covers critical skills and techniques for data analysis, visualization, and manipulation in Excel.

BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!

Course Overview

This two-day training will take attendees from performing basic data analyses in Excel to cleaning and processing data and creating regression models and visualizations. The course will introduce statistical concepts and train students in key data operations in Excel. Students will become comfortable with data manipulation, formatting, and visualization in Excel. The workshop optimizes learning by integrating practice time and discussion time in class to improve retention and provide individualized support throughout the session. The course will also include pre-work videos and exercises, as well as take-home exercises that reinforce the concepts taught in the course.

Schedule

Currently, there are no public classes scheduled. Please contact a Phoenix TS Training Consultant to discuss hosting a private class at 301-258-8200.

[image]

Not seeing a good fit?

Let us know. Our team of instructional designers, curriculum developers, and subject matter experts can create a custom course for you.

Contact Us

Learn more about custom training

Course Outline

Overview of Data Science and Excel

  • What is data science?
  • Excel basics – tool capabilities

Data Manipulation in Excel

  • Data sorting, aggregation, and cleaning
  • Filtering data
  • Pivot tables
  • If-statements and formulas vlookups and hlookups
  • Introductory text cleanup

Basic Visualizations and Best Practices

  • Formula lookup
  • Introductory data formatting
  • Exploratory data visualization
  • Shortcut keys

Introduction to Statistics

  • Basic statistics
  • Summary statistics
  • Data distribution and variance
  • Covariance and correlation
  • Introduction to regression
  • Distribution of errors: Q-Q plot, heteroscedasticity
  • R2
  • p-values and t-test

FAQs

Who should take this course?

This course is designed for Analysts (any junior person doing basic analysis, data entry, etc.) and Contracting officers. eThe material is applicable for any professional responsible for:
– Cleaning dirty data and order disorganized and disparate data sources
– Data exploration in Excel efficiently
– Data visualization in Excel
– Data analysis in Excel

BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!

Phoenix TS is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints re-garding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: www.nasbaregistry.org

Subscribe now

Get new class alerts, promotions, and blog posts

Phoenix TS needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at anytime. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, check out our Privacy Policy.

Download Course Brochure

Enter your information below to download this brochure!

Name(Required)