Who it's for: Excel users needing to analyze, summarize, and visualize their data. Basic knowledge of Excel (familiarity with formulas, cell referencing, simple functions like SUM and AVERAGE) is recommended.
What it is: Microsoft Excel is the perfect program for viewing and analyzing data.
What you'll learn: Beyond simple averages and totals, Microsoft Excel offers many features to help you draw insights from your data. Sometimes those observations come from a particular formatting or visualization of the data; other times a specific summary function will generate a surprisingly significant result. In this full-length introductory course, learn all about data analytics in Excel with tools like table formatting, conditional functions, charting, Pivot Tables, and much more.
- Introduction (0:47)
- List Design Basics (3:33)
- Inserting Tables for Analysis (4:58)
- Filtering Data in Tables (5:12)
- Using the Total Row (3:46)
- Conditional Formatting (6:26)
- IF Function (6:28)
- SUMIF and AVERAGEIF (7:30)
- SUMIFS (3:14)
- Inserting Recommended Charts (5:46)
- Updating Chart Data, Design, and Placement (2:17)
- Sparklines (6:44)
- Inserting Pivot Tables (7:53)
- Displaying Data as Count (3:48)
- Filtering Pivot Tables (8:40)
- Inserting Pivot Charts (4:16)
- Conclusion (0:55)