Excel ứng dụng trong phân tích tài chính

Master Excel for Data Analysis & Finance

This comprehensive course guides you from Excel basics to advanced data analysis, empowering you to solve real-world problems. By the end, you'll be proficient in using Excel and applying its power to your daily work. While focused on financial data analysis, the skills learned are applicable to any role requiring Excel proficiency.

Here's a detailed look at what you'll learn:

• Excel Fundamentals: Master essential Excel skills, including keyboard shortcuts, cell naming conventions, and basic navigation techniques.
• Data Formatting: Enhance your spreadsheets with professional formatting options: color formatting, date formatting, conditional formatting, and grouping/ungrouping features. Learn to freeze panes for easy navigation.
• Powerful Formulas: Become adept at using key Excel functions like VLOOKUP, HLOOKUP, INDEX, MATCH, Goal Seek, and Solver to extract and manipulate data.
• Data Manipulation & Analysis: Gain expertise in data tables, pivot tables, and Power Query for efficient data processing and insightful analysis.
• Data Visualization: Create compelling charts and graphs – from simple charts to advanced combo charts, football field charts, radar charts, waterfall charts, and dynamic charts – to effectively communicate your findings.
• Introduction to VBA: Explore the fundamentals of Visual Basic for Applications (VBA) to automate tasks and extend Excel's capabilities.

Throughout the course, you'll apply these skills using practical Excel files based on financial models, such as DCF (Discounted Cash Flow) models and CAMEL (Commercial, Accounting, Management, Economic, and Legal) analysis for the banking industry.

Who is this course for? If your job demands strong data analysis and data processing skills using Excel, this course is designed for you.

Time Commitment: Allocate approximately 30 minutes per day for learning and practice.

System Requirements: A computer with a Windows operating system and Microsoft Excel (version 2016 or later) is required.

Support: Feel free to ask questions in the discussion section.

We wish you great success in your Excel journey!