We start off with basic usage of all the.
#Data analysis excel functions how to#
And how to combine these functions for various practical situations in your line of work. In this course you will learn how to use Excel formulas like VLookup x lookup, index match, HLookup filter. Topics covered: Charts, including: line, column, bar, and scatter charts trend lines (both linear and quadratic), linear regression, time series, multiple regression.Įxcel 5: Inference (Statistical Significance) Welcome to the Lookups Course: Welcome to Excel lookups for data analysis course.
Topics covered: Two way pivot (contingency) tables and three way pivot (contingency) tables, including: Absolute count, percentage count, and averages refreshing data in contingency tables and categorizing data with contingency tables. Topics covered: Weighted Average If Statement central tendency dispersion (variance, standard deviation, quartiles and interquartile range) frequency distributions descriptive statistics ranking data correlation (Pearson's correlation coefficient) and rank correlation (Spearman's rank correlation coefficient).Įxcel 3: Contingency Tables (Cross Tabulation) Topics covered: Excel preliminaries, including: definitions and data types customizing, sheet operations (inserting sheets, naming sheets, linking sheets, selecting areas of sheets) saving and printing naming cells copying (fully relative copying and dollar fixing) IF statements vlookup function and sumproduct function.
0 kommentar(er)
