Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn the essential fundamentals of Microsoft Excel in this 16-minute beginner tutorial video that progresses from basic data entry and formatting to advanced features like pivot tables. Master core spreadsheet concepts including cells, columns, and rows, while developing practical skills in data formatting, table creation, and formula usage. Explore powerful data analysis tools through hands-on demonstrations of conditional formatting, sorting, filtering, charting, and pivot table creation. Discover collaboration features and productivity-enhancing techniques like auto-fitting contents, column/row management, and function implementation that will transform you from Excel novice to confident user.
Syllabus
Introduction
Get Excel
Start page
Cells, columns, and rows
Adjust zoom
Enter data
Format cells
Auto fit contents
Hide and unhide
Move columns and rows
Tables
Insert columns and rows
Conditional formatting
Status bar
Analyze data
Formulas
Functions
Sorting and filtering
Charts
Pivot tables
Collaborate with others
Wrap up
Taught by
Kevin Stratvert