ChitralTech

Use Area Chart in Excel 365 Show trends over time years, months, days, or any categories.

Effective CV Writing  A CV (Curriculum Vitae), is an overview document of a person that represents your  skills , education, and  work experience, interests, etc . The most common use of CV to send to prospective employers when looking for a new job.

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, Glorious I

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 formula like

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 contain numbers. 

Use of print option in Excel 365 The print option is a very powerful tool it proves the facility of printing a sheet in excel.  Preview the worksheet Click the worksheet or select the worksheets that you want to preview. Click  File  >  Print  >  Print Preview . Keyboard shortcut     Press Ctrl+P. Set printing options Do one or more of the following: Click the worksheet or select the worksheets that you want to preview. Click  File  >  Print . To change the printer, click the drop-down box under  Printer , and select the printer that you want. To make page setup changes, including changing page orientation, paper size, and page margins, click  Properties . Print all or part of the worksheet To print the active sheet or sheets, or the whole workbook, in the  Print  dialog box, select from  Selection ,  Active Sheet(s) ,  Entire workbook , or  Table . Click  Print .

Use of View Tab (Normal View, Page Break Preview, Page Layout, Formula Bar, Gridlines, Headings, Freeze Pans, Split, etc in Excel 365 View Tab:  View tab gives us control over showing boundaries, guides, rulers, and other layout tools. It also provides different options like Zooming, window setting, Freeze pans, etc. 

Click the download button for soft Excesise file Use of subtotal, group and ungroup tools in Excel 365 Subtotal: Quickly calculate rows of related data by inserting subtotals and totals. Group: Group rows or columns, or automatically create the outline. Ungroup: Unfroup a range of cells that were previously grouped.

Click the Download button for Soft Exercise Text to Columns: Split a single column of text into multiple columns. For example, you can separate a column of full names into separate first and last name columns. You can choose how to split it up; fixed-width or split at each comma, period, or another character. Flash Fill (Ctrl+E): Automatically fill in a value. Enter a couple of examples you want as output and keep the active cell in the column you want to be filled in. Remove Duplicates: Delete duplicate rows from a sheet. You can pick which columns should be checked for duplicate information. Data Validation: Pick from a list of rules to limit the type of data that can be entered in a cell.