Все публикации

0:05:16

Create aging / bucketing using custom aging function in excel, ready made solution available

0:04:43

How to create your own custom defined Function using VBA Editor

0:02:17

Highlight an entire row based on a rule applied on a cell using conditional formatting

0:01:53

How to highlight duplicate cells in a range using conditional formatting

0:01:50

Combine text and dates using Concatenate (& Operator ) and Text Function

0:02:33

Use Find & Select option to Find Comments, Data validation or Formulas using Find & select option

0:02:18

How to use Clear Function to remove all your comments , Formats, Data or all of them at once

0:03:46

Automate Excel sheet using Vlookup & IFERROR FUN,enter the key field others fields will populate

0:04:54

Drop Down List in Excel / data validation and its uses, how to convert range into table in excel

0:05:15

Use of Excel Add-Ins File Format, save your own functions using Add ins to enable it for all files

0:02:32

Reduce your Excel file size by 60% using Excel Binary format / save your excel file in .xlsb format

0:08:44

Microsoft Excel different files formats with extension and their uses

0:01:50

Count with multiple condition using countifs function, how to use countifs Function

0:11:46

Convert number into aging/bucketing by creating FUNCTION in VBA.Enable FUNCTION to work in all files

0:08:31

Convert date in Financial Year using Function created in vba,Enable Function To Work in all workbook

0:04:05

Run Macro on any excel file by just storing your MACRO in Personal Workbook/Use of personal workbook

0:01:13

Change Double touch right click setting to Single touch right click for Macbook Pro Users

0:08:16

Consolidate / Merge Multiple workbooks / sheets in single Workbook / sheet using Excel VBA MACRO

0:02:40

Copy all files and folders name in text file using DIR command in command prompt /CMD

0:03:46

Copy file names and folder names using VBA Excel MACROS / 5 line macro to copy file and folder names

0:03:56

Count duplicate values using IF Function when you are working on a lakhs of excel rows & columns

0:03:06

Most Commonly/frequently used top five excel Shortcut Keys

0:02:45

Count duplicate values using countIF function / Use of CountIF function to check duplicate values

0:05:27

How to SPLIT a big file of any format using WINZIP split Option and send it through email to user.