New to Microsoft Excel? Get up to speed fast with the world’s #1 spreadsheet program and apply your new skills to a real-world work experience.
In this course, you can learn how to:
- Create and Analyze data in Excel. To unlock the power of Excel, you need to use formulas and functions.
- You can use a PivotTable to summarize, analyze, explore, and present summary data.
- Visualize data using Pivot charts
- Filter data using slicers and timelines
- Analyze and visualize data to design compelling dashboard
Course Curriculum
Excel Foundations
Available in
days
days
after you enroll
- Practice files
- Introduction (0:53)
- Introduction to Excel Interface (7:37)
- Summing Values (4:10)
- Copying Formulas (7:13)
- Manipulating Text with Flashfill (6:37)
- Summary Statistics (2:25)
- Transpose (4:00)
- Sort and Filter Data (8:23)
- Excel Tables (8:01)
- Creating Drop Down (5:55)
- Excel Charts (6:48)
- Quick analysis (4:58)
Excel Functions and Formulas
Available in
days
days
after you enroll
- Practice File
- The SUM Function (9:02)
- The AVERAGE Function (4:39)
- The MAX,MIN,SMALL and LARGE Functions (4:45)
- The CONCATENATE Function (6:13)
- Date and Time Functions (5:58)
- The IF Function (7:30)
- NESTED IF (6:41)
- The VLOOKUP Function (5:55)
- VLOOKUP Application (7:35)
- SUMIFS Function (10:55)
- COUNTIFS Function (7:45)
Pivot Tables
Available in
days
days
after you enroll
Qualified Assessment
Available in
days
days
after you enroll
Upgrade for Digital Certificate
You will earn a verifiable digital certificate upon successful completion of this course. This can be verified by employers and anyone who wants to verify the authenticity. Certificate can be shared on LinkedIn, Facebook, WhatsApp and other platforms include email.
Are you an advanced Excel user? Try
Data Analytics Virtual Experience
Be ready to apply your analytics skills to solve business problems using Data.
Try Now →
