Welcome Everyone In this course we are going to learn financial functions in excel and their use in day to day life. We are going to build excel model based on the financial functions, these spreadsheets are available as downloads. You can download and modify these spreadsheets according to your situation to calculate your scenario. We are going to learn following functions 1. PMT – Payment 2. IPMT – Interest Payments 3. PPMT – Principal Payments 4. CUMIPMT – Cumulative Interest Payments 5. CUMPRINC – Cumulative Principal Payments 6. IRR- Internal rate of return After learning these financial functions, we are going to use apply these functions to calculate day to day loan scenarios Examples 1. Calculate Loan EMI 2. Calculate Refinancing and cash out refinancing 3. Loan points and recovery period 4. Consolidation of loans 5. Amortization of Loan 6. Interest Rate Calculations Hope you will be able to make educated financial decisions about various loans after the course.

Need to land that office job? This course is designed to give you an easy understanding of excel formulae in a SHORT amount of time so you don't need to spend weeks wasting your money trying to learn excel formulae . This course also introduces you to the excel environment. This course covers the main office formulae like but not limited to : -Vlookup -Offset -Average-IF -Sum-IF - etc.

In this Excel Crash Course, you will learn how to use different excel functionalities to carry out financial calculations, financial analysis together with business analysis and calculations. This course will help you to be able to use excel functionalities to consolidate and calculate different Profit and Loss statements (income statements). You will learn how to use cell referencing to enhance your usage of excel for financial and business analysis. You will have an understanding of how to use excel to value a project, calculate the NPV of a project and determine if the project is viable or not. You will learn how to use excel functionalities to build dynamic models. You will learn how to carry out professional formatting. You will learn how to use important excel tools such as the WHAT IF analysis to carry out sensitivity analysis for better decision making. You will learn how to use advance excel functionalities such as the V-LOOKUP, THE CHOOSE function, DATA VALIDATION function, CONSOLIDATION function, INDEX AND MATCH function, The IF functionality, etc.

To become Master of your own personal finances, I think you need two things : 1) Fundamental understanding of how money WORKS , gets LOANED /lent, SPENT and more importantly COMPOUNDS! 2) A tool which helps you to crunch numbers effectively to put your ideas into reality . (No point in just having a theoretical knowledge) This course is for people who want to take control of their own finances in their own style! This is a truly TWO-IN-ONE course where you learn MS Excel and basic financial concepts together. The modules and the hands -on assignments are designed so that you will confidently come up with your own solutions to your personal financial scenarios. Caution : I strongly recommend you to work parallely in your MS Excel worksheet during the course. This is a practical course- you'll crunch numbers and you will make your own financial plans from the scratch. I will personally assist you to get your d What IS covered in this course? MS Excel fundamentals - Quickly learn the essential MS Excel skills like Conditional formatting, smart copy pasting, data filters Work smartly with the tips and tricks like Quick navigation, relative and absolute references, shortcuts to save time Impress your boss and colleagues with beautiful spreadsheets and follow best practices Basic financials you must know How bank loans work and how to smartly find out your repayment strategy Power of compounding - the " Mantra" to generate wealth Analyse your bank statement using data filters, get valuable insights on your spending habits Personal financial planning Link the basic ideas you have learnt to plan a grand plan suited to your personal scenario What is NOT covered in this course? 101 generic ways of money making/saving which you can anyway find it on internet easily: Let's keep it crisp, concise and clear. I feel I should not waste your time by lecturing you on 100 different money making techniques. Only a small fraction of those tips can benefit you, remaining "hacks" will most likely not be feasible for you to follow. Tax savings, Investment tips/advice on Stocks & mutual funds etc. : Without knowing your financial status, liabilities, responsibilities, risk taking limitations, it makes little sense for me to give direct advice. However, the course provides you with something more powerful - ability to gauge your financial status, ability to use a powerful tool -MS Excel to make your own calculations, ability to think in a financially smart way. Your two hours on this crash course may have a life-long impact! By the end of the course, If you are not able to you will be able to come up with your own goals, financial plans, your money will be refunded 100%. The Course includes: MS Excel tutorials, tips and techniques Carefully designed quizzes to compliment your learning Demonstration sessions on handling financial situations Practice MS Excel spreadsheets and support files Templates- xlsx financial calculators (which will be built during the course) Reference and support materials to understand basic concepts This course doesn't feed you fish; it teaches you how to fish!

This course expands the topic of automating monthly, quarterly, and yearly financial reporting processes to building automated AND interactive financial reports for report users. In Part I, we discovered how to set up automated financial reports in Excel based on a system report or system data, and how to transcribe them into formal financial reports. In this second course, we introduce some advanced Excel skills for building interactive dashboards with clickable buttons for detailed drill-down. In addition, we discuss 3 crucial elements in financial report modeling: Parameters, Validation, and User Guide. We culminate by introducing ways to auto-update narratives in financial reports. This course serves as a review for accounting and finance professionals who need to sharpen their Excel skills in building interactive monthly/quarterly/yearly financial reports. Although each course may be taken individually, this is part 2 of 3. 1. Automated Financial Reporting In Excel: One-Click Reports 2. Automated Financial Reporting In Excel: Self-Service Reports 3. Automated Financial Reporting In Excel: Integration If you would like Continuing Education Credit (e.g. CPE, CE, CPD, etc.) for this course, it is available if you take this course on the Illumeo dot com platform under course title: Automating Financial Reporting in EXCEL (Part II): Self-Service Reporting for Executives . Illumeo is certified to provide CPE in over two dozen different professional certifications covering finance, accounting, treasury, internal audit, HR, and more. However, in order to receive CPE credit the courses must be taken on an ‘approved-by-the-governing-body’ CPE platform, and for over two dozen corporate professional certifications, that is the Illumeo platform. Go to Illumeo dot com to learn more.

When we are learning something new, we always need to start with the basics. This course will provide you with the basic skills to calculate and interpret the financial ratios of a company using Excel . After you complete this course you will be able to : Work with multiple spreadsheets and manipulate them for your preferences Use the cells easily and understand the basic functions Know how to use the basic formulas Know how to insert and use charts and spark lines Retrieve financial statements of various companies Use the liquidity, efficiency, leverage, coverage, and profitability ratios Perform analysis of a cash flows statement Able to continue to more advanced Excel and Financial Analysis courses I encourage you to take notes , and work together with me during the course. This is very important for you to become confident with application of your knowledge. I believe that everyone should have the appropriate basic Excel skills and to perform basic financial analysis. Once you complete the course, review it so that other students can enjoy it too. Enjoy the course!

Excel Overview Excel is one of the most widely used tool in corporates across sectors and across functions It has always been user friendly and feature rich and now has been expanded to provide an even wider array of tools helping businesses right from simple work to complex problem solving and decision making Excel has become an integral part of everyday operations, making it a necessity for continuous flow of business •Excel Overview & Basic Excel tools •Basic & Advanced Excel Formulae •Nested & Dynamic Formulas •Charts – Basic, Multi Axis, Advanced & Dynamic •Pivot Table, Pivot Charts & Pivot Dashboards •Business Simulations – Sensitivity Analysis / Scenario Manager / Solver •Management Dashboards •Macro Recording, Macro Objects & VBA Coding •Shortcut techniques for easy working •Case Study based extensive hands on learning •Wide range of managerial examples

Teach Excel to Do Your Work FOR YOU. . . Microsoft Office is everywhere, installed on over 750 million computers, but most users only know how to set up a basic table or maybe even do a few formulas here and there. In my course, I teach you how to take Excel by the horns and make it do whatever you want, whenever you want. It can go through loads of information and create a printable report for you. You can make custom forms so that you can access, analyze, edit, or add new information quickly to your data tables/ worksheets. Excel programming utilizes a simple but effective tool called "VBA" - the hidden programming language that runs quietly in the background while you work. It’s very easy and straight-forward to use. I'll show you the easiest tricks to learn this basic language in a fun, progressive method. Learn at your own pace. With each of my short, info-packed lectures, you'll learn another essential skill that you can immediately use. You'll find yourself handling these Automation tools instantly and in any spreadsheet you already use every day. If there's one thing I'm good at - and my students are good at - it's AUTOMATION. My motto is, "If I'm not making everybody's job easier, quicker and more enjoyable, I don't deserve to have this job" - and that's what I live by. Take this course and access your true potential. Oh, and I want to be the first to hear about your New Raise you get once you're making Excel Programs and running everything on autopilot for your co-workers! -Dan Here's what some of the students are saying: “I love this course. Extremely easy to follow along. If you are looking to learn more about Excel this is it!” - Jim C. “Loving this course! The information is presented quite clear and concise, and it is a really great way of learning VB really fast, yesterday I was a total ignorant of the subject. Today I programmed my first macro and cannot wait to learn more.” - Marcela T. “I had experimented with VBA previously, but I really feel like this course is exactly what I needed to take my Excel knowledge to the next level. In only 2 weeks I've improved my reporting exponentially and it's all thanks to this course!" - Ryan S. “You can't go wrong with Daniel Strong!” - Steven S. “The presenter explains in detail and demonstrates what he's covering, easy to follow along and learn!” - David B. “Teaches you the fundamental of VBA programming without any prior experience. Shows with easy to follow Example!. thanks for the video!” - Sean C. "I've taken several different VBA courses here on Udemy and this one from Daniel is by far the most interesting and easy to understand. I've done exactly 107 lectures so far and already was able to automate 80% of my tasks at work that I've been doing manually for years... I'm angry with myself because of the time I wasted by not buying this course earlier . I can't even imagine what I will be able to do after finishing the entire course :)" - Robert “Well explained, easy to understand lectures. Enjoyable and informative videos.” - Marlena “Very clear explanations broken down in short videos. Daniel goes at a slow pace that is easy to follow and understand, even for people with no programming experience.” - Gustavo P. “ Best course on VBA ever taken . Thanks a lot!” - Nikita L. “This is an excellent course!!!  There's a lot of good, useful "stuff" here.  The examples are practical and real-world!” - Todd W. “Wow, I thought I knew a little bit about Excel but clearly I had only seen the tip of the iceberg. This course has opened my eyes to the true power of VBA within excel. Great course, fantastic instructor .” - Scott K. “By large and far, one of the best step by step guide to VBA programming I have ever seen. I have been playing around with VBA for over a year now, have watched countless videos and have read numerous articles and "How-to" guides, but I have never seen something this complete , this throughout. I am amazed at how little I actually new about the VBA world. Thanks a million!” - Alex B. “Everything I have been looking for, you would have to buy multiple books for this level of instruction!” - Luke S. "Excellent VBA basic to advance tutorial." – Sandeep G. “This course is good for beginners and for experienced programmers .  Experienced programmers may want to skip through some sections on basics, but it is good to see how the basics work in the context of and excell worksheet.  He goes over different events and triggers (like buttons) to execute code.  This is a really good course if you plan to do some pretty complex vba code with forms and reports.” - Christian H. “Very helpful if you do any type of data analysis.” – Jonathan D. “I think this is an excellent gateway to the tools we need to use going forward. I like the hands on nature.” – Andre C. “Much better than other classes and seminars. Great course.” – Mark S. “The instructor made VBA easy and straight forward to use.” – Min Z. “Very thorough and practical.” – Juan S. ***Now Available for Offline Viewing!***

Statistical Analysis and Research using Excel is a blended learning program of theoretical knowledge with its application in Microsoft Excel software. This course is a base to all the analytical studies and research studies. It is focused on more industry relevant examples and situations, where in you learn how you actually need to apply your research and analytical skills at workplace. This can also be considered as a foundation course if you are looking out for higher education in research and analytics. From the work perspective, this course is more suitable to jobs for data engineering, data analyst and marketing research jobs.

The course is presented in three parts. First, the course reveals the 3 environments forecasts and budgets are made and compare each one of them. Next, the course presents 6 challenges in budget modeling and reporting. They include: o How to accommodate Operation Team’s need to work from Excel while all budgets are in the Planning system? o How to build an interactive budgeting model in Excel? o How to write into a PivotTable? Last, we provide 6 solutions to the above 6 challenges in budget modeling and reporting. They include: o Building an interactive budgeting model that allows the Operation Team to make changes to forecasts and budgets and see the results instantaneously o Building an “editable” PivotTable that allows Operation Team to put forecasts and budgets directly in the PivotTable report. o Consolidating Actuals, Forecasts and Budgets from different data sources by using Power Query o Building integrated Slides from Excel Reports: