My Excel Coach

Hi All, I am Manoj Misra, my passion is to teach people related to MS Office , DOS and system related tricks, shortcuts , formulas and Macros.

Create aging / bucketing using custom aging function in excel, ready made solution available
Create aging / bucketing using custom aging function in excel, ready made solution available
How to create your own custom defined Function using VBA Editor
How to create your own custom defined Function using VBA Editor
Highlight an entire row based on a rule applied on a cell using conditional formatting
Highlight an entire row based on a rule applied on a cell using conditional formatting
How to highlight duplicate cells in a range using conditional formatting
How to highlight duplicate cells in a range using conditional formatting
Combine text and dates using Concatenate (& Operator ) and Text Function
Combine text and dates using Concatenate (& Operator ) and Text Function
Use Find & Select option to Find Comments, Data validation or Formulas using Find & select option
Use Find & Select option to Find Comments, Data validation or Formulas using Find & select option
How to use Clear Function to remove all your comments , Formats, Data or all of them at once
How to use Clear Function to remove all your comments , Formats, Data or all of them at once
Automate Excel sheet using Vlookup & IFERROR FUN,enter the key field others fields will populate
Automate Excel sheet using Vlookup & IFERROR FUN,enter the key field others fields will populate
Drop Down List in Excel / data validation and its uses, how to convert range into table in excel
Drop Down List in Excel / data validation and its uses, how to convert range into table in excel
Use of Excel Add-Ins File Format, save your own functions using Add ins to enable it for all files
Use of Excel Add-Ins File Format, save your own functions using Add ins to enable it for all files
Reduce your Excel file size by 60% using Excel Binary format / save your excel file in .xlsb format
Reduce your Excel file size by 60% using Excel Binary format / save your excel file in .xlsb format
Microsoft Excel different files formats with extension and their uses
Microsoft Excel different files formats with extension and their uses
Count with multiple condition using countifs function, how to use countifs Function
Count with multiple condition using countifs function, how to use countifs Function
Convert number into aging/bucketing by creating FUNCTION in VBA.Enable FUNCTION to work in all files
Convert number into aging/bucketing by creating FUNCTION in VBA.Enable FUNCTION to work in all files
Convert date in Financial Year using Function created in vba,Enable Function To Work in all workbook
Convert date in Financial Year using Function created in vba,Enable Function To Work in all workbook
Run Macro on any excel file by just storing your MACRO in Personal Workbook/Use of personal workbook
Run Macro on any excel file by just storing your MACRO in Personal Workbook/Use of personal workbook
Change Double touch right click setting to Single touch right click for Macbook Pro Users
Change Double touch right click setting to Single touch right click for Macbook Pro Users
Consolidate / Merge Multiple workbooks / sheets in single Workbook / sheet using Excel VBA MACRO
Consolidate / Merge Multiple workbooks / sheets in single Workbook / sheet using Excel VBA MACRO
Copy all files and folders name in text file using DIR command in command prompt /CMD
Copy all files and folders name in text file using DIR command in command prompt /CMD
Copy file names and folder names using VBA Excel MACROS / 5 line macro to copy file and folder names
Copy file names and folder names using VBA Excel MACROS / 5 line macro to copy file and folder names
Count duplicate values using IF Function when you are working on a lakhs of excel rows & columns
Count duplicate values using IF Function when you are working on a lakhs of excel rows & columns
Most Commonly/frequently used top five excel Shortcut Keys
Most Commonly/frequently used top five excel Shortcut Keys
Count duplicate values using countIF function / Use of CountIF function to check duplicate values
Count duplicate values using countIF function / Use of CountIF function to check duplicate values
How to SPLIT a big file of any format using WINZIP split Option and send it through email to user.
How to SPLIT a big file of any format using WINZIP split Option and send it through email to user.
Reduce file size by using WINZIP advance Option/ Create ZIPX file to reduce file size further by 70%
Reduce file size by using WINZIP advance Option/ Create ZIPX file to reduce file size further by 70%
VBA Macro to merge/ console multiple Sheets in a single sheet in a workbook using for each next loop
VBA Macro to merge/ console multiple Sheets in a single sheet in a workbook using for each next loop
VBA Macro to delete Sheet in a workbook by entering sheet name in box
VBA Macro to delete Sheet in a workbook by entering sheet name in box
Macro to add / create a new sheet in an excel file and rename sheet using Inputbox option in VBA.
Macro to add / create a new sheet in an excel file and rename sheet using Inputbox option in VBA.
How to create password protected excel file. How to add password in your excel file.
How to create password protected excel file. How to add password in your excel file.
My First Excel VBA Macro program. How to write your first excel macro program using excel VBA
My First Excel VBA Macro program. How to write your first excel macro program using excel VBA