Search This Blog

ChitralTech

Chitral Tech 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.

Custom Formatting of Cell No and CNIC No in Excel 365

Get link
Facebook
X
Pinterest
Email
Other Apps

April 27, 2020

Exercise File Click Download

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

How to use subtotal, group and ungroup tools in Excel 365

May 01, 2020

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.

How to use Absolute, Mixed and Relative cell references in Excel 365

May 04, 2020

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

How to use COUNT, COUNTA, COUNTIF, COUNTSIFS in Excel 365

May 11, 2020