Udemy - Excel for Financial Modelling

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 -Introduction.mp4 (34.4 MB)
• 2 -Course Overview.mp4 (24.8 MB)
• 2 -Excel Training Base.xlsb (64.8 KB)
• 3 -Connection to Financial Modelling.mp4 (31.6 MB)
10 - Graphs
• 1 -Creating basic chart.mp4 (60.5 MB)
• 2 -Changing the Graph type.mp4 (18.7 MB)
• 3 -Customizing Graph.mp4 (21.0 MB)
• 4 -Advance Chart Formatting.mp4 (55.2 MB)
• 5 -Specialized Charts.mp4 (45.3 MB)
• 6 -Dynamic Graphs.mp4 (101.3 MB)
11 - Conditional Formatting
• 1 -Introduction.mp4 (30.6 MB)
• 2 -Different Options.mp4 (51.3 MB)
• 3 -Flags.mp4 (54.3 MB)
• 4 -Using Formula.mp4 (47.4 MB)
• 5 -Conditional Formatting in Scenarios.mp4 (36.5 MB)
12 - Data Validation
• 1 -Introduction.mp4 (24.1 MB)
• 2 -Different Data Validation Options.mp4 (82.0 MB)
• 3 -List.mp4 (39.1 MB)
• 4 -Configurations.mp4 (34.8 MB)
13 - Goal Seek
• 1 -Simple Example.mp4 (39.3 MB)
• 2 -Goal Seek Configuration.mp4 (53.4 MB)
• 3 -Goal Seek VBA.mp4 (68.5 MB)
• 4 -Data Solver.mp4 (74.8 MB)
14 - Other Functionality
• 1 -Introduction.mp4 (21.5 MB)
• 2 -Dynamic Arrays.mp4 (104.8 MB)
• 3 -Let.mp4 (90.2 MB)
• 4 -Lambda.mp4 (53.8 MB)
15 - The use of AI
• 1 -Different AI options.mp4 (11.6 MB)
• 2 -Excel Function.mp4 (46.7 MB)
• 3 -VBA.mp4 (53.4 MB)
• 4 -Copilot.mp4 (76.2 MB)
16 - The Conclusion
• 1 -Your Achievments.mp4 (8.9 MB)
• 2 -Bonus Lecture.mp4 (15.7 MB)
2 - General Efficiency
• 1 -Keyboard Shortcuts and Navigation.mp4 (48.2 MB)
• 2 -Access to Ribbon.mp4 (30.1 MB)
• 3 -When Mouse is Better.mp4 (25.3 MB)
• 4 -Most common keyboard shortcuts.mp4 (59.4 MB)
3 - FIrst Steps
• 1 -How to write a Formula.mp4 (32.7 MB)
• 2 -Populating Formula.mp4 (84.6 MB)
• 3 -Absolute Reference.mp4 (32.0 MB)
• 4 -Range Names.mp4 (44.1 MB)
• 5 -Powers.mp4 (41.3 MB)
• 6 -Number Formats.mp4 (42.2 MB)
• 7 -Number Formats Trick.mp4 (24.4 MB)
4 - Basic Formulas
• 1 -Sum.mp4 (64.7 MB)
• 2 -Average.mp4 (24.8 MB)
• 3 -Min Max.mp4 (22.4 MB)
• 4 -Count.mp4 (42.1 MB)
• 5 -Copy Paste.mp4 (48.9 MB)
5 - Date Manipulation
• 1 -Dates Intro.mp4 (14.7 MB)
• 2 -Day, Month, Year.mp4 (116.5 MB)
• 3 -End of Month.mp4 (49.9 MB)
• 4 -Days 360.mp4 (34.1 MB)
6 - Conditional Formulas
• 1 -Simple If Statement.mp4 (36.7 MB)
• 2 -If Statement vs Conditions.mp4 (44.0 MB)
• 3 -Nested If Statements.mp4 (46.2 MB)
• 4 -AverageIf and CountIf.mp4 (87.2 MB)
• 5 -SumIf and MaxIf.mp4 (49.6 MB)
7 - Connecting Formulas
• 1 -Vlookup and Hlookup.mp4 (70.0 MB)
• 2 -Index and Match.mp4 (69.3 MB)
• 3 -Xlookup.mp4 (17.8 MB)
• 4 -Offset.mp4 (52.0 MB)
8 - Data Clensing
• 1 -Substitute.mp4 (48.2 MB)
• 2 -Len.mp4 (25.2 MB)
• 3 -Left and Right.mp4 (35.0 MB)
• 4 -Mid.mp4 (66.5 MB)
• 5 -Round.mp4 (28.6 MB)
• 6 -Data Types.mp4 (71.7 MB)
9 - Pivot Tables
• 1 -Intro and creating Pivot Table.mp4 (57.9 MB)
• 2 -Sorting and Filtering.mp4 (36.1 MB)
• 3 -Grouping Data.mp4 (19.0 MB)
• 4 -Summarising and Analyzing.mp4 (36.0 MB)
• 5 -Pivot Charts.mp4 (42.0 MB)
• 6 -Pivot Conclusion.mp4 (26.8 MB)
• Bonus Resources.txt (0.1 KB)