Data Analysis Essentials Using Excel

Learn to apply the important concepts and techniques of data analysis using Excel.

Created by: Symon He
Author | Investor | MBA

Created by: Travis Chow
Tech Veteran Mentoring & Teaching for 20+ Years

What Will I Learn?

• Confidently use the most crucial Excel functions and techniques for analysis
• Correctly use the appropriate charts in Excel
• Apply analysis techniques to datasets in Excel
• Manipulate and prep datasets in Excel
• Build presentation ready dashboards in Excel
• Create your own formulas in Excel
• Turn real world data into business insights in Excel

Requirements

• You should be able to use a PC or Mac at the beginner level
• Microsoft Excel 2013+

Target audience

• Anyone who wants to learn the core concepts of data analysis in the Excel environment
• Anyone who wants to learn to apply data analysis techniques using Excel
• Anyone who wants to become proficient at using Excel for data/business analysis
• Anyone who wants to be able to turn data into business insights in Excel
• Anyone who wants to be able to run simple to sophisticated analysis on data using Excel
• Anyone who wants to learn the most frequently used Excel functions and techniques used by analysts