ChitralTech

For soft Exercise File Click Download Button Use  of PMT, PPMT, IPMT, FV, PV function in Excel 365 PMT : Calculates the payment for a loan based on constant payments and a constant interest rates. PPMT : Returns the payments on the principal for a given investment based on periodic, constant payments and a constant interest rate. IPMT: Returns the interest payment for a given period for a investment based on periodic, constant payments and a constant interest rate. NPER: Returns the number of periods for an investment based on periodic, constant payments and constant interests’ rate PV: Returns the present value of an investment. The total amount that a series of future payments is worth now. FV: Returns the future value of an investment based on periodic, constant payments and a constant interest rate. 

Use of Comment and Notes tool in Excel 365 Review Tab: Comment: Add a comment about this part of the document. Notes: Add a Notes about this part of the document

About ChitralTech  ChitralTech is providing state of the art training and consultancy services on Microsoft Office products i-e Excel Basic and excel advance feature, Microsoft Word PowerPoint, Outlook, and access. Quality training on your doorstep with certified trainers. Continuing education will always be essential to keep you up to date or to learn new skills that will help you advance your career. This opportunity is to continue your education learning from the comfort of your home. We have put together our tips and tricks on how to learn successfully. About the Author  9 years’ experience as an IT and Life Skills . I have delivered various in -house, public level and online (Skype and Team viewer) training of Microsoft Excel Advanced (Financial Module), Microsoft Word Advance (Reporting Module), Microsoft PowerPoint, Microsoft Outlook, and Life Skills for the Aga Khan Economic Planning Board, Aga Khan Education Board, Aga Khan Health Services, G...

Using $ sing - absolute cell reference in Excel The dollar sign fixes the reference to a given cell no so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references permission you to copy the formula in Excel without changing cell references.   Mixed Cell Reference in Excel Absolute column and relative row, like $B2. When a formula with this reference type is copied to other cells, the $ sign in front of the column letter locks the reference to the specific column so that it never modified. The relative row reference, without the dollar sign, varies depending on the row to which the formula is copied. Relative column and absolute row, like B$2. In this reference type, it's the row's reference that won't change, and the column's reference will. Using F4 key to switch between the absolute, relative, and mixed references   Through the F4 key to you must be able to modify   your form...

For Soft Exercise File Click Download Button Use of Sumif and Sumifs function in Excel 365 Sumif Function: You use the SUMIF function to sum the values in a range that meets the criteria that you specify the cell range. Sumifs Function:  The Sumifs function, one of the math and trig functions, adds all of its arguments that meet multiple criteria.

For Soft Exercise File Click Download Button  How to use the Formulas of Sum, Max, Min, Average, and Count SUM: The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(B2:B6) Adds the values in cells B2:B6 =SUM(D2:D6,F2:F6)  Adds the values in cells  D2:D6 , as well as cells  F2:F6 Max: Returns the smallest number is a set of values, ignores logical values and text. =Max(B2:B6)  Largest value in the cell range B2:B6 is 67 Min: Returns the smallest number is a set of values, ignores logical values and text. =Max(B12:A16)  The largest value in the cell range B12:B16 is 33 Count:   Count the number of cells in a range that contains numbers. =Count(B2:B6)  The function return in B6:B6 is 5 Average: Returns the average arithmetic mean of its arguments, which can be numbers or names, arrays, or references that contai...