Course code: MSEXST1« Back

Microsoft Excel – Data Analysis and Statistic Calculations

At the course participants meet advanced data analysis methods. All standard statistical - analytic functions are discussed especially the Analysis ToolPack Add-Inn which is used for demanding statistical analyses. Listeners learn how to work with tools such as a descriptive statistics, a properties correlation, a values prediction and a work with time series. The course also focuses on clear interpretation of found results.

 DateDurationCourse priceHandbook priceCourse languageLocation 
GTK 9/5/2019 2 8 000 CZK included in course price Český jazyk GOPAS Praha
 
11/11/2019 2 8 000 CZK included in course price Český jazyk GOPAS Praha
 
1/16/2020 2 8 000 CZK included in course price Český jazyk GOPAS Praha
 
3/9/2020 2 8 000 CZK included in course price Český jazyk GOPAS Praha
 
5/14/2020 2 8 000 CZK included in course price Český jazyk GOPAS Praha
 
10/3/2019 2 7 200 CZK included in course price Český jazyk GOPAS Brno
 
GTK 12/16/2019 2 7 200 CZK included in course price Český jazyk GOPAS Brno
 
3/2/2020 2 7 200 CZK included in course price Český jazyk GOPAS Brno
 
5/4/2020 2 7 200 CZK included in course price Český jazyk GOPAS Brno
 
GTK 9/5/2019 2 250,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 
10/21/2019 2 250,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 8 000 CZK included in course price 0
Brno2 7 200 CZK included in course price 0
Bratislava2 250,00 EUR included in course price 0

Who is the course for

The course is for experienced users who work with data and want to analyze them. Participants meet advanced MS Excel 2007 tools.

What we teach you

At the course participants meet advanced data analysis methods. All standard statistical - analytic functions are discussed especially the Analysis ToolPack Add-Inn which is used for demanding statistical analyses. Listeners learn how to work with tools such as a descriptive statistics, a properties correlation, a values prediction and a work with time series. The course also focuses on clear interpretation of found results.

Required skills

Excellent knowledge of MS Excel. Participants should be able to work with functions, formulas and they should have an idea about data analysis principles.

Teaching methods

Professional instruction with practical examples and practices on computers.

Teaching materials

PowerPoint handouts

Course Outline

Analysis of extensive data volumes by helping PivotTable (PT) and PivotTable Chart Report.

  • PT creation principles
  • Total functions in PT
  • Build-in functions for different data views in PT
  • Calculated fields and items
  • Data analysis and data understanding in PT

Basic data analysis

  • Frequency analysis
  • Histogram - frequency chart
  • Level characteristics (Mean, Median, Mode, Quantity)
  • Variable characteristics (Variance, Deviation)
  • Shape allocation characteristics (Kurtosis, Skewness)

Dependence analysis

  • Correlation
  • Regression analysis (appropriate regression model, comparison of two different alternatives, judgment of regression model quality, estimates based on chosen regression model
  • Graphic dependence analysis
  • Multi regression (more independent variables)

Time series analysis

  • Time series characteristics
  • Basic time series description (differences, growth speed - chain, indexes)
  • Time series modeling
  • Time series decomposition (trend, seasonal, cyclic, random item of time series)
  • Time series purge of seasonal component (moving average)
  • Estimates based on time series model
Tištěné nebo elektronické studijní materiály GOPAS

Price:
included in course price
The prices are without VAT.