Mastering Data Analysis in Excel

Unlock the power of Excel to utilize its analytical tools from Vlookup to Pivot Table - no matter your experience level

Created by: Vardges Zardaryan
Data Analyst, Instructor and Expert of MS Excel

What Will I Learn?

• Learn different techniques for data analysis that can be easily implemented in Excel 2010, 2013, 2016, and 2019
• Transform Data into insight using powerful methods of analysis, techniques and tools
• Bring your skills of Excel from Beginner or Intermediate levels to Expert level
• Work with real-world data sets and solve real-world tasks
• Learn 60+ frequently used functions in Excel (Logical, Text, Date, Math, Statistical, Financial)
• Execute aggregation commands (SUM, COUNT, SUBTOTAL, etc.) and their conditional variants (SUMIFS, COUNTIFS, AVERAGEIFS, etc.) to summarize data sets
• Combine data from multiply worksheets by VLOOKUP, INDEX and MATCH functions
• Perform scenario and sensitivity analysis by Goal Seek, Data Table and Scenario Manager tools
• Learn best practices for data analysis and data presentation using PivotTable and PivotChart tools
• Perform statistical analysis by using Data Analysis ToolPak including Linear Regression
• Learn best practices for the design and setup of interactive dashboards
• Work in Excel faster by using hot key shortcuts

Requirements

• Basic knowledge of Excel is a plus, but not required
• Microsoft Excel 2010, 2013, 2016, 2019
• Passion for Excel and online learning

Target audience

• Anyone looking for a hands-on course on MS Excel
• Excel users looking to discover new tools to help them do more in less time
• Business professionals looking to become more confident in Excel
• Data analysts hoping to develop advanced data modeling, dashboard design, and business intelligence skills
• Students who want a comprehensive, engaging, and highly interactive approach to training
• Anyone looking to pursue a career in data analysis, business intelligence, financial modeling, marketing researches, reporting