Yes! Your Personal Productivity is Now Expanded
FINANCIAL ANALYST Ex Plus Bundle [3 Training Videos]
FINANCIAL MODELLING
Actual Price:=₦27,450:00
Promo Price: N20,000
BUSINESS PLAN
Actual Price:=₦20,000:00
Promo Price: N15,000
COURSEWORK
Actual Price:=₦20,450:00
Promo Price: N15,000
Plus: Working and Practicing Files, Templates etc
TOTAL
Massive Discount Price=₦34, 950
FINANCIAL MODELING TABLE OF CONTENT
- Video 1: Introduction and Overview
- Video 2: Understanding Financial Modelling
- Video 3: Components and Structure of a Financial Model
- Video 4: Quality Control in Financial Modelling
- Video 5: Formula Rules in Financial Modelling
- Video 6: Logical Functions for a Financial Modeler
- Video 7: The Index and the Match Function in Modelling
- Video 8: Chose Function- a Useful function in Financial Modelling
- Video 9: Vlookup Function- a Useful function in Financial Modelling
- Video 10: Combining Vlookup and Choose Functions
- Video 11: Running Scenarios with the Index Function
- Video 12: Finance Functions for the Modeler-Intro
- Video 13: Financial Functions-Timeline Calculations
- Video 14: Financial Functions for the Modeler-Amortization Schedule
- Video 15: Finance Functions-Calculating CAGR
- Video 16: Date Functions for every Financial Modeler
- Video 17: Restricting Data Entry-Custom protection and Data Validation
- Video 18: Using Sheet Properties to Hide Sheets
- Video 19: Controlled Data Restriction with a List Box
- Video 20: Sensitivity Analysis- Data table use in a Financial Model
- Video 21: Sensitivity Analysis- Goal Seek use in Financial Model
- Video 22: Exploring the need for Macros
- Video 23 Financial Modelling Advice
- Video 24: Why Value a Company
- Video 25: Determinants of Cashflows
- Video 26: Reason for Discounting
- Video 27: Reason for Discounting-WACC
- Video 28: How to Find the Cost of Capital
- Video 29: The 2 Stages of the DCF Model
- Video 30: Calculating the Cost of Equity- CAPM
- Video 31: The Methodology of Forecasting P or L
- Video 32: The Methodology of Forecasting BS Item
- Video 33: Discounted Cash flow Example
- Video 34: The Enterprise and Equity Value
- Video 35: Overall Description of the Valuation Exercise
- Video 36: Structure of a DCF Model
- Video 37: Practical Preview of Workbook
- Video 38: Forecasting your Revenue
- Video 39: Preparing the forecast for P and L Items
- Video 40: Performing the forecast-COGS and OPEX
- Video 41: Performing the Forecast- Other P and L Items
- Video 42: Modelling BS Items-DSO,DIO and DPO
- Video 43: Modelling BS Items- Other Assets, Liabilities and PPE
- Video 44: Building the Historical P and L
- Video 45: Building the forecast Balance Sheet
- Video 46: Financial Modelling Advice
- Video 47: Building the forecast for P or L
- Video 48: Building the historical BS
- Video 49: Reviewing the structure of the CFS
- Video 50: Building the historical CFS 1
- Video 51: Building the historical CFS 2
- Video 52: Completing the Forecast CFS
- Video 53: Calculate the Equity Value and Share Price
- Video 54: Calculate PVOf CF and Enterprise Value
- Video 55: Valuation sensitivity Analysis
- Video 56: General Structure of the real Life
- Video 57: Examining the Input Structure and Relationships
- Video 58: Examining the Working Sheet
- Video 59: Quality Control in Financial Modelling
- Video 60: Examining the Working Sheet 2
- Video 61: Examining tieing everthing to the monthly income
- Video 62: The Output Structure
- Video 63 Airline Business Financial Model
FINANCIAL MODELING TABLE OF CONTENT
ADVANCED EXCEL TABLE OF CONTENT
- Video 1. Applying auto filter on record.
- Video 2. Using Advance Filter features on Excel
- Video 3. Consolidating of Data from Multiple Range
- Video 4. Summarizing worksheet using subtotal
- Video 5. Splitting of data into multiple column
- Video 6. Applying remove Duplicate feature of Excel to Remove duplicate transaction
- Video 7. Applying Validation for effective control
- Video 8. calculating Bonus using simple IF Function
- Video 9. Applying Nested IF when the possible outcome is More than two
- Video 10. using and or in Compound IF
- Video 11. Counting with condition using Count if
- Video 12. Applying CountIF on Multiple criteria
- Video 13. Averaging with condition using Average IF
- Video 14. Counting the number of blank cells in Range using CountIF
- Video 15. Appying large Function on Control
- Video 16. introduction to pivot table
- Video 17. Creating Pivot table
- Video 18. manipulating pivot table by changing the view one
- Video 19. manipulating Pivot table two
- Video 20. manipulating pivot table three
- Video 21. How to group data on Pivot table
- Video 22. other method of grouping on Pivot table
- Video 23. How to create Pivot chart from table
- Video 24. How to create pivot chart from source Record
- Video 25. How to move multiple chart to A single location
- Video 26. Introduction to Lookup Function
- Video 27. Using VLOOKUP on Approximate Match
- Video 28. Applying VLOOKUP on exact match
- Video 29. Nesting VLOOKUP Function
- Video 30. Applying VLOOKUP on large table
- Video 31. Introduction to match function
- Video 32. Applying choose function on spreadsheet
- Video 33. Using index on Array
- Video 34. Combining index and match function
- Video 35. Practical Application on VLOOKUP and Match to reconcile two month payroll
- Video 36. Applying HLOOKUP
- Video 37. Introduction to WHAT - IF Analysis
- Video 38. How to Apply Goal seek to maximize profit
- Video 39. Introduction to Solver & Adding solver to Quick Access Tool
- Video 40. How to Analyse WHATIF using solver
- Video 41. How to create and use scenario manager
- Video 42. How to generate scenario summary report
- Video 43. How to change a Single variable using one input table
- Video 44. How to work with two input data table
- Video 45. How to use Date Function
- Video 46. How to Apply today and now Function to generate current date and time
- Video 47. How to Group transactions to Actual Day of the Week
- Video 48. How to calculate Actual working days using NETWORKDAYS
- Video 49. How to use Workday function
- Video 50. How to calculate date difference using DATEDIF
- Video 51. How to use EDATE Function
- Video 52. How to convert date to value using DATAVALUE Function
- Video 53. How to Merize date with conditions using SUM - IF
- Video 54. How to get aggregate value on worksheet using AGGREGATE Function
- Video 55. How to use MOD Function
- Video 56. How to generate random date using Randbetween
- Video 57. How to convert measurement using convert
- Video 58. How to truncate value and generating Odd and even numbers
- Video 59. Introduction to macros
- Video 60. How to record macros for formatting sheet
- Video 61. How to Record macros for Highlighting constant value on Worksheet
- Video 62. How to apply frequency function
- Video 63. How to Transpose column to row into column using transpose
- Video 64. How to use Trend Function
- Video 65. How to Apply Array function with match function
- Video 66. How to use find to locate data on worksheet
- Video 67. How to use left and right Function to Extract value
- Video 68. How to join words using concatenate function
- Video 69. How to Apply text into proper function
- Video 70. How to use Replace and Substitute function
- Video 71. How to remove all leading space using trim function
- Video 72. How to use offset function to extract the last reporting data in Worksheet
- Video 73. How to Apply indirect function to generate report from multiple sheet
- Video 74. How to Apply Indirect Function with validation
- Video 75. How to use hyperlink on the index
- Video 76. How to link multiple sheet on a workbook
- Video 77. How to manipulate worksheet by renaming & moving sheets
- Video 78. How to Hide sheet, Formula and making cell not editable
- Video 79. How to Apply protection on Workbook
- Video 80. How to share workbook for Collaboration
- Video 81. How to import data from Microsoft Word to excel
- Video 82. How to Export Worksheet with Link to other Application
ADVANCED EXCEL TABLE OF CONTENT
Order Now & Pay into: PlatinumGold 360 Solutions GTB Account # 0263333393. Add Courier Delivery Cost Lagos N1,000. Other States N4,000.
After payment, please text your full name, The Product Category you are buying, day and month of birth (e.g June 1st) and your email address to: Vivian 08090820787, or Mercy 08082366372.
If You Miss Out of Your Next Opportunities (Because of Your Refusal To Act Today), You will Continue to Blame Yourself.
Order Now & Pay into: PlatinumGold 360 Solutions GTB Account # 0263333393. Add Courier Delivery Cost Lagos N1,000. Other States N4,000.
After payment, please text your full name, The Product Category you are buying, day and month of birth (e.g June 1st) and your email address to: Vivian 08090820787, or Mercy 08082366372.
If You Miss Out of Your Next Opportunities (Because of Your Refusal To Act Today), You will Continue to Blame Yourself.
Additionally, you will get the following:
- Software for All the Video Training to Practice with.
- Simplified Manual that guides you on how to post and deal with your day-to-day business transactions on All the Accounting Software.
After going thru some lectures in Advanced Excel Video training, I have used d knowledge to design templates for the operations of two cooperative societies in my school. And have gotten a stronger attention of my Bursar and my colleagues that they just believed I can handle any excel problem. Thanks to PlatinumGold.
Akio Princewill Bursary Dept- Federal University, Wukari, Taraba State.
After leaving my previous job in January 2016, I got 4 of your Video Training including Sage50 & QuickBooks. Currently, I set up accounting systems for small businesses. As at April 2017, I have earned over N1.2m from that initial investment.
Thank you PlatinumGold.Dotun Balogun,ACA Lead Consultant- DTB Accounting Services, Isolo Lagos.
How these videos have advanced our customers lives
After getting your QuickBooks video training last month, I have used the knowledge to set up my Employers’ Accounting system. It took me only 15 days to implement. That alone saved us over N250,000 cost of Accounting System Set Up. Aside from the knowledge gained. Thank you PlatinumGold
Joel Odeniyi Accountant -The learning Place LTD, Lekki Lagos.
Make Direct Transfer Into Our Bank Accounts
Name of Account: PlatinumGold 360 Solutions
GTB Account # 0263333393
Include DHL Courier Delivery
Lagos N1500
Other Parts of Nigeria N2800
After payment, please text your full name, what you are buying,
day and month of birth and email to 08082366372 or kindly
reply this mail with the required details so we can confirm and process
your order. Courier delivery within Lagos is 1-2 working days,
Outside Lagos is within 3-5 working days
So, Don't Delay; Act Now
Order Now & Pay into: PlatinumGold 360 Solutions GTB Account # 0263333393. Add Courier Delivery Cost Lagos N1,000. Other States N4,000.
After payment, please text your full name, The Product Category you are buying, day and month of birth (e.g June 1st) and your email address to: Vivian 08090820787, or Mercy 08082366372.
If You Miss Out of Your Next Opportunities (Because of Your Refusal To Act Today), You will Continue to Blame Yourself.