Skip to main content

Posts

Showing posts with the label Excel

Educate yourself in excel

Three things you didn’t know Excel could do . Sensitivity Analysis What would be my retirement fund if I invest @ 7.5% in a recurring deposit for 10 years, Initial Investment of = Rs. 2,00,000 / 3,00,000 / 4,00,000 / 5,00,000 Monthly Investment of = Rs. 7000, / 8,000 / 9,000 / 10,000 Using Data Table. Sensitivity Analysis So if you need a retirement fund of at least Rs. 25 Lakhs, you can choose 1 of the above marked options. Automatically Lookup Values and Calculate Dates It is tedious to input data manually all the time. Automatic Lookup and Dates Calculation – Purchase to Payment tracker User has to only input in the Grey columns. All Orange columns are filled in automatically using Excel’s awesome functions. =Vlookup function used Price and Delivery No. of Days are filled up automatically from the Product Table below. Credit No. of Days is filled up automatically from the Customer Table below. Date functions used Delivery Date and Payment Date are automatically calculated Imagine ho