Tag: Home Tab

MS-EXCEL-86-How to Use Calculated Field in Pivot Table - Calculated Field in PivotTable with Example

Discover the power of Calculated Fields in Pivot Tables and unlock advanced data analysis capabilities. Learn step-by-step how to create and utilize Calculated Fields to perform custom calculations, derive insights, and enhance your data visualization in Pivot Tables.

Read more ›

MS-EXCEL-49-Useful Excel Shortcuts 2023 - Top most Excel Shortcut Keys in Hindi - Home tab Shortcuts

Comprehensive guide on shortcut keys for all the Home tab options

Read more ›

MS-EXCEL-48-How to Use Format Painter in Excel - Excel मे फोर्मेट कॉपी कैसे करे - Cell Formatting

The Format Painter is a powerful tool in Microsoft Excel that allows you to quickly copy the formatting of one cell or range of cells and apply it to other cells or ranges.

Read more ›

MS-EXCEL-47-Paste Special Option in Excel | Part-2 | Useful Technique for Data Entry & Data Cleaning

How to utilize various Paste Special Options such as All, Formula, Values, Formats, Comments, Data Validation, All using source theme, All except borders, Column width, Formulas and number formats, Values and number formats, Add, Subtract, Multiply, Divide, Skip blanks, Transpose, and Link.

Read more ›

MS-EXCEL-44-Use of Go To Special in Excel - Part-2 of 2 - Visible cells only - Row differences

Go To Special in Excel, Row differences, Column differences, Precedents, Dependents, Last Cell, Visible cells only, Conditional formats, Data Validation

Read more ›

MS-EXCEL-43- Use of Go To Special in Excel | Part-1 of 2 | How to Set Shortcut key for Go To Special

Learn use of Comments, Constants, Formulas, Blanks, Current Region, Current Array, and Objects in Go To Special

Read more ›

MS-EXCEL-42-How to use Wildcard Character in Excel | Find and Replace with Wildcard Character |Hindi

Learn How to use wildcard characters in Excel with the Find and Replace option. three types of wildcard characters. * , ? , ~

Read more ›