In a fast-changing corporate world with high demand for technical and analytical skills, we believe equipping students with practical problem-solving IT skills are very important in positioning them for a rewarding career.
Financial modeling, Analytics, and Proficiency in general IT tools have become sought-after skills in today’s corporate world and demand for people with these skills continues to outstrip supply. With this insight, leading business schools across the world are proactively integrating these skills into various courses to make it more rewarding for their students.
As Finex Skills Hub, we buy into this vision. In June 2018 we started the journey to offer practical IT skills to students and workers to enable them to learn, connect, and grow their potential in these areas.
The session is held over 3 months to allow students more time to practice and offer feedback on their learning experiences.
Our typical study topics include:
Excel for Work Intermediate and Advanced Microsoft Excel Topics to help you improve productivity at the office.
INTERMEDIATE • Formulas and Function tools • Absolute and Relative References • Database Features • IF, VLOOKUP, and POWER Functions • Date and Time Functions • Pivot Tables • Statistical Functions • Math Functions • Security and Sharing • Introduction to Macros ADVANCED • Advanced Logic Functions (AND, OR, NOT) •. Lookup and Reference Functions (INDEX + MATCH) • Advanced Filters for Reports • Sensitivity Analysis • Goal Seek Command • Scenario Manager • Conditional Formatting • Charting Tricks • Reporting with Dashboards • Consolidating Data
Practical Financial Modeling sessions to give you the skill and confidence to stand out from the crowd.
• Modeling as a Discipline
• Model Attributes
• Model Planning
• Tab Structure
• Model Construction Tips
• Model Components
• Understanding the structure of Financial Statements
• Tips for building Scenario Analysis, Schedules, and Summary Pages
• Formatting and Printing tips
• Designing an efficient layout
• Excel Shortcuts and Functions for Modeling
• Modeling Profit and Loss, Balance Sheet & Cash Flow Statements
• Model plugs, revolver, and cash
• Dealing with circularities in financial models
• Modeling interest income/expense
• Linking it all together
Analytics with POWER BI
Section 1: INTRODUCTION
• Transitioning from Excel to Power BI (Understanding similarities and differences)
• Introduction to PowerBI Desktop
Section 2: CONNECTING & SHAPING DATA
• Understanding POWERBI’s Query Editor (Power Query)
• Data cleaning examples with Power Query
• Grouping, Appending, Merging, Creating Hierarchies, etc.
SECTION 3: CREATING RELATIONSHIPS AND DATA MODELS
• Understanding Table relationships
• Creating and Managing Table relationships
• Understanding relationship Cardinality
SECTION 4: ANALYZING DATA WITH DAX
• Introduction to DAX measures
• Implicit and Explicit DAX measures
• Understanding DAX Syntax and Operators
• Example of some DAX Functions
SECTION 5: VISUALIZING DATA WITH POWER BI REPORTS
• Understanding the Report View in Power BI
• Designing appropriates layouts for your reports
• Themes and color combinations best practices
• Visualization data with Artificial Intelligence features
• Publishing and collaboration