CFI - Fundamentals of Data Analysis in Excel
- Offered byCoursera
Fundamentals of Data Analysis in Excel at Coursera Overview
Duration | 5 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Fundamentals of Data Analysis in Excel at Coursera Highlights
- Earn a certificate from Coursera
- Add to your LinkedIn profile
- 3 assignments
Fundamentals of Data Analysis in Excel at Coursera Course details
- Excel is the most widely used analysis tool in the world and a great starting point for diving into data analysis.
- In this course, you'll apply Excel's native tools to structure your data into spreadsheets and tables
- You'll then analyze and produce insights from that data using pivot tables
- Finally, you'll visualize those insights by building a dashboard in Excel
- You'll apply these skills using modern functionality like dynamic array formulas, linked data types, and Ideas in Excel
- You'll work hands-on with real-world scenarios, using datasets pulled from financial statements and retail sales
Fundamentals of Data Analysis in Excel at Coursera Curriculum
Getting Started
Course Overview
Downloads
Analyze Data
Introduction
Sorting & Filtering
Conditional Formatting
Conditional Logic - IF() & SWITCH()
Conditional Logic - IF() & IFS()
SUMPRODUCT() Function
Defining Variables - LET()
Defining Names - Name Manager
Defining Functions - LAMBDA()
Review
Transform Data
Introduction
Text to Columns
Removing Duplicate Values
String Functions for Text Values
Working with Date Values
Looking Up Data - VLOOKUP()
Using HLOOKUP() with VLOOKUP()
Looking Up Data - INDEX() & MATCH()
Dealing with Errors - IFNA() & IFERROR()
Chapter Review - Transform Data in Excel
Week 1 Challenge
Excel Tables
Excel Tables
Calculated Columns in Excel Tables
Special Item Specifiers in Excel Tables
Power Query - Introduction
Power Query - Filtered Table
Power Query - Group & Aggregate Data
Linked Data Types
Expand Power Query Data with Linked Data Types
Linked Data Types as a Power Query Source
Chapter Review - Excel Tables
Dynamic Arrays
Chapter Introduction - Dynamic Arrays
Dynamic Array Formulas
Dynamic Array Functions
Combining Dynamic Arrays & Excel Functions
XLOOKUP()
Chapter Review - Dynamic Arrays
Week 2 Challenge
Pivot Tables
Chapter Introduction - Pivot Tables
Summarize Data with a PivotTable
Update & Sort a PivotTable
PivotTable Analyze Options
PivotTable Design Options
Filtering with Slicers & Timelines
Pivot Charts
Analyze Data - Ideas in Excel
Power Pivot
Chapter Review - Pivot Tables
Visualize Data
Chapter Introduction - Visualize Data in Excel
Excel Visuals
Excel Visuals Continued
Dashboard Preview
Net Earnings Waterfall
Combo Chart - Cash Flow & Cash Balance
Bullet Chart - Introduction
Creating Bullet Chart
Formatting Bullet Chart
Setting up Data Table for Bullet Chart
Excel vs Dashboard Tools
Chapter Review - Visualize Data in Excel
Course Conclusion
Summary
Week 3 Challenge
Fundamentals of Data Analysis in Excel at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?