Data Analysis Using Excel

Data Analysis Using Excel

Mobile

Excel has a rich set of built-in functions to help you analyze your data without having to learn a new program. Whether you need to tackle descriptive statistics, standard deviation, variance, pivot tables, correlation, regression, and more, you can build upon the Excel skills you already have and master new ones in this two-day course.

The benefits for mastering these skills can be enormous, both in your current job and in looking for new opportunities.

Course Details
icon iPhone

 

Date: October 7 & 9

Days: 2

Fee: $550.00

Location: 551 5th Avenue, New York, NY

CRN: 90763

icon

Course Description

For advanced users who have a working knowledge in Excel and need instruction in creating simple statistical calculations and representations. You will work with Excel statistical formulas and charts to display and understand data. Work with PivotTables, descriptive statistics, confidence intervals and the Excel Analysis Toolpak is included. Approximately 75% of this class consists of statistical analysis.

Click for Detailed Course Description

icon

You Will Learn To

  • Learn basic Statistics and Pivot tables
  • Installing and using Analysis Toolpak
  • Find Mean, Mode, Median, Minimum and Maximum values in Excel
  • Use more descriptive statistics
  • Use Standard Deviation, Variance, Modifying a chart, Histogram, Intervals
  • Learn Quantiles, Quartiles, Percentiles and Box Plots in Excel
  • Use CrossTabs and Pivot tables efficiently
  • Learn Pivot Table Filters and additional features
  • Learn to create efficiently a stem and leaf display
  • Use Confident intervals.
  • Use Correlation and Regression in Excel
icon

Who Should Enroll

Advanced users who have a working knowledge of Excel.

Prerequisite: Advanced experience using Microsoft Excel.

icon

Course Format

Two Days (9am- 4pm); offered weekdays; Instructor-led.
COST: $500

CPE- 12 CREDIT HOURS

icon

Questions?

Please contact us at (888) 561-7223 or continuinged@pace.edu

Outline for Data Analysis Using Excel

DESCRIPTIVE STATISTICS
Automatic Subtotals and Percents
The COUNTIF() Function
Using the Analysis Toolpak
Replacing Text Values with Numerical Values
Mean, Median, Mode, Maximum, Minimum

MORE DESCRIPTIVE STATISTICS
Charting Standard Deviation and Variance
Intervals Using a Histogram
Quartiles, Percentiles, and Box Plots

CROSSTABS AND PIVOT TABLES
Creating a Pivot Table
“Pivoting” the Table
Grouping Text items in Pivot Tables
Sub Totals, Grand Totals and Sorting
Pivot Charts

CORRELATION AND REGRESSION
Bivariate Statistics
Correlation
Scatter Plots
Regression

CONFIDENCE INTERVALS
Z Scores
Stem and Leaf Display

 

Other Courses That May Interest You

icon

Access

  icon

Excel

icon

Microsoft Project

  icon

Outlook

 

 

icon

PowerPoint

  icon

Windows 8.1

 

 

Word