Formula for Automation

Hello Friends. Here i would like to explain my 11 year excel experience. I would like you to explain why we need to logic and formula for automation. Automation is only one way to reduce our manual effort. If we will use this logic, then smartly we can automate our activities and smartly we can handle the work pressure. automation is only one way to produce maximum output from minimum time. automation is the only one way to convert all the hard work to smart work. automation is the only one way to produce correct information

below you can see some example how we can automate some critical report and critical analysis.

List of Name for Automation report List of Name for Automation report
1 How to Fill Blank Cell in Excel 16 How to Split Left Name from a cell using a special character
2 How to create Week and month Wise summary IF only date is there 17 How to Split Right Name Name from a cell using a special character
3 How to calculate position Of Letter from A to Z 18 How to Pull Salary using Multiple Vlookup from Different Source
4 How to convert Numeric number to Word 19 How to Pull some information using Multiple Hlookup from different Source
5 How to Reverse the number 20 How to Place your Name under respective column
6 How to Relevant information by Drop down Menu 21 How to Add Country code before the mobile number
7 How to Create Week, Month, and Day Master through Drop down menu 22 How to replace Error
8 How to Calculate age of a Person from the DOB 23 How to Do a 100% Quality Check within a Sec
9 How to find a happy birth day of a person 24 How to Create Cost Sheet
10 How to create a summary from a Raw data 25 How to Create Proforma Invoice
11 How to calculate a week from a manual number 26 How to Create Balance sheet
12 How to Find a Position of Letter from A to Z 27 How to Create a Score card
13 How to validate the number from Multiple Line Item  
14 How to Calculate some additional calculation Through Pivot Table  
15 How to Split Middle Name from a cell using a special character  

 

 

 

hakdhakdkad aksdjalkd