Excel | Data Analysis Excel教程(DAuE笔记)
Introduction to Data Analysis Using Excel
这门课还行，对于excel入门或者复习还行，难度低。就是教授的印度口音，听着不习惯 :( 快速过一下还行，这里放下自己整理的笔记: Excel | Data Analysis Excel教程(+Intro2DAUE笔记)
Quiz答案
每周几个lesson，每个lesson都是短视频加上几道题的practice quiz，然后最后一个大quiz，大部分都很简单，放下自己的答案供大家参考~
Week1 Introduction to Spreadsheets
L1 Reading Data
L2 Basic Manipulation
L3 Arithmetic Manipulation
L4 Basic Functions
L5 Absolute and Relative References
L6 Functions Explained
Quiz
Week2 Spreadsheet Functions to Organize Data
L1 The “IF” Command in Excel
L2 The “IF” Command in Excel Using Numerical Data
L3 The “Nested IF” Command in Excel
L4 The “VLOOKUP” Function in Excel
L5 Another “VLOOKUP” Example
L6 The “HLOOKUP” Function in Excel
L7 Professor ‘Know-it-all’ Needs Help!
Quiz
Week3 Introduction to Filtering, Pivot Tables, and Charts
L1 Using the “VLOOKUP” Function Across Worksheets
L2 Data Filtering in Excel
L3 Use of Pivot Tables in Excel
L4 More Pivot Table Options
L5 Application of Pivot Tables to Numeric Data
L6 Introduction to Charts in Excel
Quiz
Week4 Advanced Graphing and Charting
L1 Line Graphs
L2 Bar Graphs and Pie Charts
L3 Pivot Charts
L4 Scatter Plots
L5 Histograms Part 1
L6 Histograms Part 2
Quiz
