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:50)
- Preparing Data for Tables (2:12)
- Removing Blank Rows and Duplicates (4:16)
- Using Flash Fill to Apply Table Styles (2:48)
- Applying Table Styles (3:14)
- Auto Sorting and Filtering in Tables (4:12)
- Applying a Custom AutoFilter in Excel Tables (3:28)
- Adjusting Table Style Formats and Options (2:37)
- Applying Total Rows (2:50)
- Adding New Data and Turning Off Table Styles (2:48)
- Applying Conditional Formats (3:45)
- Editing and Turning Off Conditional Formats (2:23)
- IF Functions (4:45)
- SUMIF Functions (4:06)
- COUNTIF Functions (3:32)
- AVERAGEIF Functions (3:31)
- Creating Charts (3:56)
- Editing and Reformatting Charts (4:26)
- Creating Sparklines (3:05)
- Creating Win-Loss Sparklines (1:53)
- Creating Pivot Tables Using the Recommended Pivot Tables Button (3:05)
- Creating Pivot Tables from Scratch (3:28)
- Editing Summary Function and Format of Pivot Table Value Fields (3:08)
- Filtering, Sorting, and Editing Pivot Table Fields (4:14)
- Grouping Column Labels in Pivot Tables (2:52)
- Creating Slicers (2:35)
- Refreshing Pivot Table Data (1:44)
- Creating and Updating Pivot Charts (4:57)
- Conclusion (0:30)