Master Personal Finance with Excel
5 Course in 1! Save, Invest & Earn FAR More! By Top Award Winning Investment Banker, Financial Planner, & Personal Coach
Office Productivity,Microsoft,Excel
Lectures -13
Resources -7
Duration -3.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Let me being by asking few simple questions...
- Have you ever received many credit card offers and was wondered which ones to go for?
- Have you ever wandered why some people are so rich?
- Have you ever felt confused when an investment product was explained to you?
- Have you ever thought how to plan my expenditure and cash flows?
- Have you ever had someone taking about retirement savings and you were stressed out?
- Have you ever been out of money?
- Have you been utterly confused with the personal finance jargon or terms?
- Have you ever dream of having financial abundance?
- Have you ever felt the urge to be your own personal financial planner?
- Have you ever wondered why my value of money is going down or things are becoming expensive?
- Have you ever though of consulting a Investment Psychologist (Personal Finance Planner) but couldn't afford their fees?
- Have you ever though to be Financially Independent?
- Have you ever though why loan / credit is so expensive / costly?
- Have you ever had difficulty in understanding math behind personal finance?
If your answer to most of the above questions is YES! Then this is the Course for you!
Why Personal Finance is so difficult?
- Schools don't Teach you to Manage your Money!
- 9 out of 10 people think that Financial Goals seems impossible to reach, Understanding Money is So HARD, Spending Today is Good (tons of Debt), Investing is TOUGH, Always out of Budget, Don't know how to get rid of financial hardship (stress), Confused with choices.
- No one us told about Power of Compounding
- No one taught us to manage our expenses
- No one taught us the math of personal finance - The RIGHT & EASY way!
- No one taught us to Do-it-Yourself of Personal Finance and Investing
What you'll learn...
Section-I
Personal Finance Concepts
- Setting GOAL & GOAL Basis the Timeline: Short Term, Mid Term, Long Term
- Illustration of SMART GOAL
- Vivid Life Cycle & Life Stages
- Understand your Net Worth – Exercise
- How Positive and Negative Impacts you
- Calculate & Plan Expenses – Exercise
- Design your own House Hold Budget
- Is the credit card interest worth paying?
- Why do I spend more than expected?
- 20% Club
- Cash Flow Planning
- Cash Flow Planning – Exercise
- Rule of 6
- Decide which Bank is the Best
- What happens, when the bank FAILS?
Section-II
Rules of Personal Finance - The non-calculator Maths at your figure tips!.
- Rule of Double
- Rule of Triple
- Rule of Quadruple
- Rule of Eight Times
- Rule of 69
- Rule of 15
Section-III
Behavioral Finance & Investing
- 2 Key Rules
- Why it is different for different people?
- What influences their behavior?
- Information Overload
- Overconfidence
- Anchoring
- Loss Aversion
- Familiarity Bias
- Herding
- 9 Ticks of Behavioral Finance & Investing
Section-IV
Risk Profiling & Asset Allocation
- Risk Profile Basis Age
- Risk Profile Basis Risk Profile
- Asset allocation
- Risk Return Trade off
- Risk Tolerance Matrix
Section-V
Foundations of Investments & Investment Products
Key Concepts of Investing:
- Investment / Saving
- Interest
- Annual Percentage Rate (APR)
- Returns
- Inflation
- Risk
- Power of Compounding - The Super Power of Multiplier
- Risk
- TEAR & PAT - The RISK
- Investment Products:
- Stock / Equity / IPO
- Mutual Funds
- Precious Metals Investing : Gold, Silver & Precious Metals
- Fixed Instruments
- Bonds
- ETF - Exchange Traded Funds
- Small Saving Schemes
- Insurance: Life and General Insurance
- Derivative
- Alternate Investments: Private Equity, Start-Ups, Cryptocurrency etc
Equity/Stocks and IPO - Initial Public Offer
- How to Identify Right Stocks?
- What do you need to Invest in Stocks?
- Why to Invest?
- How to Invest in Stocks: Price to Earning Ratio – P/E Ratio, Debt to Equity Ratio, Price to Book Value, Return on Equity – ROE, Current Ratio
Mutual Fund
- Key concepts: Units, Nav, Loads etc.
- 14 Types of Mutual Fund
- Options in Mutual Fund: SIP, SWP, STP...
- 12 Benefits of SIP Investing- Systematic Investment Plan
- 6 Things to avoid while investing in SIP
Real Estate investing
- Benefits of investing in Real Estate
- 4 cost associated with Real Estate
- 7 Variety of Real Estate
- 13 costly mistakes to avoid - investing in real estate
Gold / Silver or Precious Metal Investing
- 5 Easy ways to invest
- Risk associated with Investing in Precious Metal
Fixed Investments, Bonds & ETFs
- Certificate of Deposit / Fixed Deposits Benefits
Bond :
- Various Basket of Bond : Government Bond, Corporate Bond, Municipal Bond, Zero Coupon Bond, Junk Bond
- Key Concepts: Par Value, Face Value, Coupon etc
- 5 Risk of Investing in Bonds
- Benefits of Investing in ETFs
- Risk of Investing in ETFs
- Small Savings Schemes: PPF, National Savings Scheme, Schemes for Senior Citizen
Cryptocurrency Investing
- How to Invest?
- What are the type of Cryptocurrency Investing?
- 12 Key Points to remember while investing into Cryptocurrency
Insurance, Derivative & Private Equity
- Life Insurance
- General Insurance
- Complex Concepts Simplified - Derivative
- Types of Derivative
- Overview of Private Equity / Start-ups
- Common types of Private Equity
- How to Invest into Private Equity?
Section-VI
Financial Planner & Robo-advisory
- Do you need Financial Planner?
- A Slice of Robo-Advisory
- Top Robo-Advisory
Section-VII
- Specific Goal Planning & Time Value
- Education, Dream Car, Dream Home, Savings for Retirement etc.
- Time Value : PV, FV, Annuity, Annuity Due
- Practical Exercises
Section-VIII
Credit Facilities
- Home / Mortgage Loan
- Car Loan
- Personal Loan
- Education Loan / Study Loan
- Credit Card
- Is it worth to buy a property or rent it?
- Rule of 30%
- Rule of 2%
- 6 Credit cards – Deadly Mistakes
- 10 Ways NOT to be a Credit cards Defaulter
- Is it wise to take Personal Loan or Home Loan / Mortgage Loan?
- Is it wise to buy a Brand New Car?
Section-IX
Learn to be a Rock Star Expense Planner:
- 15 To Stop Sending On
- 122 Easy Ways to be a Rock Star Expense Planner - Exercise
Section-X
Credit Rating, Credit Score & Credit Report
- Overview
- What is Credit Score Range?
- Credit Bureau
- Importance of Credit Score
- How to get Credit Score/ Report - Legally
- 7 Ways to Repair your Credit history
- Control Credit
Section-XI
- 10 Pro Tips to Memorize
- Financial Apps (Software tools) for Android & iOS
IMPORTANT:
EXCEL Course Project:
Note: Ms-Excel (Microsoft Excel) 2007 or above recommended (Windows / Mac) for the projects.
Please use Mac Version for Mac PC/Laptop & Windows Version for Windows PC/Laptop(win7 and above recommended).
There are multiple class projects which are included in the exercise demo. Please download only one exercise at a time (this will help you to understand and practice one concept at a time).
Exercise - 1: Understand your Net Worth – Excel Exercise
Exercise - 2: Calculate & Plan Expenses – Excel Exercise
Exercise - 3: Design your own House Hold Budget – Excel Exercise
Exercise - 4: Cash Flow Planning – Excel Exercise
Exercise - 5: Learn various rules of personal finance - try it out! (No exercise file - please refer demos)
Exercise - 6: Time Value / Specific goal planning – Excel Exercise
Exercise - 7: Magical Rock Star Expense Planner (Power to you!) – Excel Exercise
Disclaimer:The information provided in this course should not be used as financial advise or recommendation, neither it should be viewed as a financial promotional or affiliation tool or advertisement nor it supports or endorse any tools or company illustrated throughout the course, should not be substituted for consulting a financial advisor, planner or allied professional in the applicable jurisdictions. This course outline the broad road map to manage your personal finance. The author or Tutorialspoint disclaim the liability or any damage, risk, loss or obligations incurred directly or indirectly. The situation is dynamic and can change anytime due to various factors. The author is directly or indirectly or otherwise is not under obligation, risk or liability due to use of information given in this course.
Goals
- Learn Complete hands-on (practical) ways to deal with money using Excel
- Manage your money EASILY.
- How to save money: Make sensible decisions on money
- Bullet-Proof Personal Finance Tips to Manage and Save More Money
- The time value of money - Why Time is MOST IMPORTANT
- How MONEY works for YOU
- Know your NET WORTH
- Will you be able to manage if you are out of job or business for 6 months?
- Do you have enough insurance cover?
- Risk-Reward Relationship
- Double, Triple, Quadruple your MONEY with the SIMPLE and EASY CALCULATION
- How to Identify & INVEST in right stocks : IMPORTANT RATIOS
- 12 Benefits of SIP (Systematic Investment Plan)
- 12 Important Points to Remember while investing into CRYPTOCURRENCY like Bitcoin
- 5 Ways to Invest in GOLD
- 10 Commandments On Investing
- 6 Credit Card Mistakes to AVOID
- DIY (Do-it-Yourself): Personal Financial Plan
- 7 Ways to repair your credit history
- How to obtain Credit Report?
- 6 Assets that make people RICH
- Power of COST-AVERAGING and COMPOUNDING: Mutual Fund (SIP)
- Psychology of Investing: BEHAVIORAL FINANCE
- Is it worth to repay the loan earlier than the loan tenure?
- Understand and Manage your Personal Cash Flow
- Understand Monthly HOUSE HOLD Budget
- Plan Specific FINANCIAL GOAL
- Risk Profile and Investment Profiles
- 100+ Easy Ways To Save LOT More on SHOPPING, PERSONAL HYGIENE, MEDICINE, GROCERY, FOOD, GIFTS, TRIPS, UTILITIES and Much More.
Prerequisites
- Note: Ms-Excel (Microsoft Excel) 2007 or above recommended (Windows / Mac) for the projects.
- Please use Mac Version for Mac PC/Laptop & Windows Version for Windows PC/Laptop(win7 and above recommended).
- Excel Exercise works both on Mac and Windows PC/Laptop/Desktop.
- There are multiple class projects which are included in the exercise demo. Please download only one exercise at a time (this will help you to understand and practice one concept at a time).
![Master Personal Finance with Excel Master Personal Finance with Excel](https://d3mxt5v3yxgcsr.cloudfront.net/courses/4475/course_4475_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Bird Eye View of the Course...
1 Lectures
-
What is in for you? 01:15 01:15
Section 1: Smart Goals, Net Worth, House Hold Budget & Cash Flow Analysis
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Section 2: Rules of Money
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Section 3: How our Emotions Shape Investment Decisions?
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Section 4: Risk Profiling & Asset Allocation
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Section 5: Foundations of Investments & Investment Products
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Section 6: Specific Goal Planning & Time Value
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Section 7: Financial Planner & Robo advisory
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Section 8: Credit Loan Facilities
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Section 9: Learn to be a Rock Star Expense Planner
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Section 10 Cash Course on Credit Rating, Credit Score & Credit Report
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Section 11: Ten Pro Tips & Apps/Tools
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Prakash Prasad](https://www.tutorialspoint.com/assets/profiles/313973/profile/200_264887-1614863834.jpg)
Prakash Prasad
"Difficult things aren't easy, but they're worth it."
I am passionate about training. My aspiration is to take away the blind of intricacy to make idea reasonable for you.
In the last 2 decades, I have trained hundreds of participants working in various sectors about Financial Markets and Products, Economics, Statistics, Design Thinking, Public Administration,Life Skills, Psychology, Banking Fundamentals, Advance Banking concepts, Foreign Exchange, International Banking, Risk Management, Compliance, Fraud Analysis, Cyber Security, Digital Forensics, FinTech, Innovative Technology(Blockchain, Cryptocurrency, AI, AR, VR, Robotics, IoT), Asset & Liability Management and Business Analytics.
My mission is to make the course accessible, affordable and easy. Most of my courses will teach you what you haven't learned in school, college or at your workplace.
I am there for you! Obviously, you are my Number 1 Priority. All of my courses are crafted to cater for a wide range of learners. If anything remains unclear or fuzzy to you, or you just need help understanding something in my course, just send me a text message or an email message and I'll be able to devote some time for you to make the topic easier that suits your style of learning.
This is to ensure you learn better and retain the knowledge. My courses will help you gain real world skills and knowledge and change your life today.
He teaches professional certification:
Certificate in Fintech Regulatory Compliance (CFRC)™
Certified Program in Anti Money laundering Professional (CPMP)™
Executive Program in Fintech Law ™
Certified Blockchain Security Analyst (CBSA)
Certified Social Media Intelligence Examiner (CSMIE)
Bitcoin and Cryptocurrency Forensic Investigation (OSINT)
Certified Patent Analyst (CPA+)
Certified Trademark Analyst (CTA)
Certified Copyright Analyst (CCA)
IS-011: Certified Private Investigator (Level 1)
IS-033: Document & Handwriting Forensics Investigation
IS-12: Certificate Course in DeFi (Decentralized Finance)
IS-044: Smart Contract Hacking & Security
Certified Blockchain Security Examiner (CBSE)
Crypto-asset Compliance Professional (CAMP)™
Thank you for your interest in my courses, and in me as an instructor. I look forward to seeing you in one of my lectures very soon.
Best Regards,
Prakash
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)