Скачать или смотреть Most Commonly/frequently used top five excel Shortcut Keys

Most Commonly/frequently used top five excel Shortcut Keys



Link of My Videos

Count duplicate value using countIF Function
   • Count duplicate values using countIF funct...  

How to split one single big file into multiple small files in size so to enable to send it through email
   • How to SPLIT a big file  of any format usi...  

How to reduce file size even better than zip filing using zipx option of WINZIP
   • Reduce file size by using WINZIP advance O...  

How to merge multiple sheets into one excel sheet
   • VBA Macro to merge/ console multiple Sheet...  

How to delete a sheet using MACRO
   • VBA Macro to delete    Sheet in a workbook...  

How to create a Macro to add a new sheet automatically
   • Macro to add / create a new sheet in an ex...  


How to create a password protected excel file
   • How to create password protected excel fil...  

Create your first Macro in Excel VBA
   • My First Excel VBA Macro program. How to w...  

How to use IFERROR Function with Vlookup Function
   • IFERROR with Vlookup function is used to r...  

Use of Hlookup Function
   • Use of HLOOKUP FUNCTION - HLOOKUP FUNCTION...  

Use of Vlookup Function
   • VLOOKUP FUNCTION - Use VLOOKUP when you ne...  

Use of Lookup Function
   • LOOKUP FUNCTION -A value that LOOKUP searc...  


Create multiple files from a single file based on a criteria using macros in excel VBA
   • Use of Macro to Un-merge / Split data from...  

MID Function - Extract number / words from a dynamic position / position not fixed
   • MID Function - Extract number / words from...  

Change date format using Text Function
   • Change date format using Text Function  

How to protect rows or columns - Allow edit range allows you to edit only selected ranges in Excel
   • How to protect rows or  columns - Allow ed...  

Concatenate function used with text function, joins two or more text / numbers into one
   • Concatenate function used with text functi...  

Text Function - change the way a number /text / date appears
   • Text Function - change the way a number /t...  

How to use Subtotal function to count visible cells only in a given range
   • How to use Subtotal function to count visi...  

Use of Subtotal function to sum / total of all visible cell in a given range
   • Use of Subtotal function to sum / total of...  

Use of Dollar Sign/ How to use $ Sign, Freeze rows or column and both
   • Use of Dollar Sign/ How to use $ Sign, Fre...  

How to console / Merge multiple text files into one text file using command prompt / DOS / CMD
   • How to console / Merge multiple text files...  

How to use SUMIFS function, sums a selected range with multiple criteria's / conditions
   • How to use SUMIFS function, sums a selecte...  

How to create aging / Bucketing using IF Function in excel
   • How to create aging / Bucketing using IF F...  

SUMIF Function - Sumif function, sums up a range with a single condition / Criteria
   • How to use SUMIFS function, sums a selecte...  

How to create aging / Bucketing using IF Function in excel
   • How to create aging / Bucketing using IF F...  

SUMIF Function - Sumif function, sums up a range with a single condition / Criteria
   • SUMIF Function - Sumif function, sums up a...  

Use of Countif Function - How to count cells in a range with a condition / Criteria
   • Use of Countif Function  - How to count ce...  

Use of CountBlank Function - Count empty cells in a given range in Excel
   • Use of CountBlank Function - Count empty c...  

Use of CountA Function- CountA function use and comparison/Difference of CountA with Count function
   • Use of CountA Function- CountA function us...  

Count Function - How to count numeric value in MS Excel using Count Function
   • Count Function - How to count numeric valu...