Канал: Excel Shortcut Fundas

Shortcut Key to apply SUM formula in Excel

Shortcut Key to apply SUM formula in Excel

How to apply VLOOKUP - Part 2

How to apply VLOOKUP - Part 2

How to apply VLOOKUP - Part 1

How to apply VLOOKUP - Part 1

How to Change the number format from Billions to Lakh and Lakh to Billions

How to Change the number format from Billions to Lakh and Lakh to Billions

How to add Calendar / Date Picker in Excel (Part 1)

How to add Calendar / Date Picker in Excel (Part 1)

How to convert European Format Number to the US Format Number

How to convert European Format Number to the US Format Number

Share the Excel file and Track the changes

Share the Excel file and Track the changes

What is Text to column and How to use Text to column function

What is Text to column and How to use Text to column function

Change the Date Format from DD.MM.YYYY to DD-MM-YYYY

Change the Date Format from DD.MM.YYYY to DD-MM-YYYY

How to Highlight & Remove duplicate entries in Excel?

How to Highlight & Remove duplicate entries in Excel?

How to use Wrap Text, Shrink to fit & Merge cells functions?

How to use Wrap Text, Shrink to fit & Merge cells functions?

How to use Hyperlink ???

How to use Hyperlink ???

How to hide the Formula in Excel

How to hide the Formula in Excel

How to protect particular cell in Excel ???

How to protect particular cell in Excel ???

Usage of Protect Sheet & Protect Workbook functions in Excel

Usage of Protect Sheet & Protect Workbook functions in Excel

How to insert an Object file in MS Excel?

How to insert an Object file in MS Excel?

How to create Password Protected Excel?

How to create Password Protected Excel?

How to create Read-Only Excel file?

How to create Read-Only Excel file?

Pivot Table (Part - 3)

Pivot Table (Part - 3)

Pivot Table (Part-2)

Pivot Table (Part-2)

Pivot Table (Part - 1)

Pivot Table (Part - 1)

Keyboard shortcuts - Part 9 (Sheet Management)

Keyboard shortcuts - Part 9 (Sheet Management)

Use of formulas - LEN, RIGHT, LEFT, MID

Use of formulas - LEN, RIGHT, LEFT, MID

Shortcut & Concept - Filter and Sort

Shortcut & Concept - Filter and Sort

Keyboard shortcuts - Part 8

Keyboard shortcuts - Part 8

ROUND v/s ROUNDUP v/s ROUNDDOWN

ROUND v/s ROUNDUP v/s ROUNDDOWN

Minimum & Maximum

Minimum & Maximum

How to apply Data validation in Excel?

How to apply Data validation in Excel?

Keyboard shortcuts - Part 7

Keyboard shortcuts - Part 7

Keyboard shortcuts - Part 6

Keyboard shortcuts - Part 6

Keyboard shortcuts - Part 5

Keyboard shortcuts - Part 5

Use of Trim & Substitute Function/Formula in Excel

Use of Trim & Substitute Function/Formula in Excel

Keyboard shortcuts - Part 4

Keyboard shortcuts - Part 4

Keyboard Shortcuts - Font style, Font Size, Font Alignment, Font color

Keyboard Shortcuts - Font style, Font Size, Font Alignment, Font color

Shortcuts to adjust Row Height & Column width

Shortcuts to adjust Row Height & Column width

Keyboard shortcuts - Part 3

Keyboard shortcuts - Part 3

IF,ANDIF,ORIF

IF,ANDIF,ORIF

Keyboard shortcuts-Part 2

Keyboard shortcuts-Part 2

COUNT,COUNTA,COUNTIF,COUNTIFS

COUNT,COUNTA,COUNTIF,COUNTIFS

SUM,SUMIF,SUMIFS

SUM,SUMIF,SUMIFS

Concatenate long range data very easily with the help of Transpose

Concatenate long range data very easily with the help of Transpose

Pareto Analysis

Pareto Analysis

Keyboard Short-cuts of Excel-Part 1

Keyboard Short-cuts of Excel-Part 1

Excel magical vlookup

Excel magical vlookup

Concatenate date and text with date format

Concatenate date and text with date format