Advanced Excel and Power BI
This course is aimed at exposing participants to the use of excel and Power BI tools, formulas and features in intensive data analysis
COURSE OUTCOMES
At the end of the course, students should be able to
- Apply advanced formulas to lay data in readiness for analysis
- Use advanced techniques for report visualizations in Excel and Power BI
- Leverage on various methodologies of summarizing data
- Understand and apply basic principles of laying out Excel and Power BI models for decision making
- Understanding the Power BI environment and its three Views.
- Designing Power BI visuals and reports.
OBJECTIVES OF THE COURSE:
- To equip students with the ability to use complex Excel functions and formulas for data analysis, financial modelling, and decision-making.
- To teach students how to create dynamic and visually appealing dashboards and reports in Power BI
- To enable students to efficiently manage, clean, and manipulate large datasets using both Excel and Power BI tools.
- To introduce techniques for integrating Excel with other applications and automating repetitive tasks using VBA (Visual Basic for Applications) and Power Query.
- To provide hands-on experience with real-world datasets to prepare students for practical challenges they will face in professional settings.