Google Welcome to Excel Automate

Welcome to Excel Automate

Hi Webies Welcome to Excel Automate,

Myself Anoop Kumar working as Automation Tester.
In my day to day work life I have gone through lot of tedious and repetitive tasks. And I stuck with those tasks but Deepak bhai (Deepak Pagadala) gives me introduction to Macro and VBA(Visual Basic for Applications) and that was a perfect help in my career. He shown me how to automate the tedious tasks such as calculations, preparing reports, charts and some validation stuff also. Thanks to Deepak bhai, 
We all know that Microsoft Excel is very powerful tool for office use. But many of us are doing repetitive works in Excel. Excel has built-in functions for those works .In case of more complex repetitive tasks we can use Macros :)
what is Macro in Excel???????
Many tasks you perform in Excel, such as entering sales data for a particular day or adding a formula to a worksheet are done just once. Other tasks, like changing the format of a range of cells, are repeated often but can be done quickly by using tools in Excel. However, you often have one or two tasks that you perform frequently and that require a lot of steps to accomplish.
For example, you might want to highlight several important cells in a worksheet every time you present a report to your colleagues. Rather than go through a lengthy series of steps to do this manually, you can create a macro, or a series of recorded actions, to perform the steps for you. Or, if you are familiar with the Microsoft Visual Basic® for Applications (VBA) programming language, you can write a custom macro from scratch. In either case, after you create a macro, you can run it, edit it, or delete it as needed.

So folks this blog is for you to EXCEL your knowledge on Excel Automation and Tips and Tricks. You can give suggestion to improve this blog. Please share your views about this blog ..…..
Feel free to contact me….

                                                                                                        Read More.....>>>>

Need to learn Excel??????
Advanced Automation in Excel?????? Subscribe for more!!!!!!


  1. It's very informative to others. Keep going on.
    I have written a helpful code in java to trim all strings in a bean obtained from a form. Here is the link

  2. Thanks Visruth....i will add this link to my favourite list...

  3. Thanks Anoop. Great work. It has drawn my attention into some of the interesting functionalities of Excel.
    Keep posting..!!

  4. These are as useful as driving tips. Thanks Anoop...!!!

  5. Thanks Arun.. Please subscribe for more and more tips....

  6. Replies
    1. Thanks Harsh Bhai!!!!!!!!!!!!!!! Have a great Day/.......

  7. One of the best tuturial blogs i have ever seen...great please add some video tutorials also


  8. However, a good kind of systems out there within the market will create deciding the proper one for your home an amazing expertise. Most of the trendy home automation solutions feature 3 crucial components: a central hub, additionally called a primary interface; management devices, which may vary from your smartphones and tablets, to remote controllers and desktop PCs; and last the peripheral devices that receive signals from the central hub, for more information visit here Home Automation Boca Raton.

  9. Wiztech Automation Solutions is the best Training institute in Chennai, started in the year 2006 and it extended its circle through providing the best Education as per the Global Quality Standards. Hence our Training Center in Chennai was Recognized by IAO and ISO for its inspiring Education quality standards. Wiztech Automation Solution, the PLC SCADA Training Academy in Chennai offers both PLC, SCADA, DCS, VFD, Drives, Control Panels, HMI, Pneumatics, Embedded systems, VLSI, IT, Web Designing Training courses in chennai with latest various brands. Wiztech Automation Solutions offers Real Time Training Courses with 100% Placement support in chennai.


    102, W-Block, 2nd Floor, 2nd Avenue,
    (Next to Indian Bank), Anna Nagar,
    Chennai, Tamil Nadu, India
    Pincode : 600 040.
    Landmark : Anna Nagar Rountana
    Landline Number: 044-2620 9369
    Mobile : +91-99404 26826
    Website :
    E-mail :

    PLC Training in chennai | SCADA Training in chennai | Embedded Systems Training in chennai | VLSI Training in chennai | Automation Training in chennai | Industrial Automation Training in chennai | Process Automation Training in chennai | DCS Training in chennai | Inplant Training in chennai

  10. Engineering students who are interested in implant training in chennai can contact us. We provide real time implant training in chennai for aspiring students.

  11. Hello Admin, thank you for the informative post. At Fita academy, we provide the best IT trainings for various courses. You can check our Fita Chennai review page to know more about our quality and standards.

  12. Get Perfect guessing of Satta Matka, Satta Matka Result, Kalyan Matka Tips. 100% Reliable tips. Matka Chart, Matka Result

  13. PLC, SCADA,HMI, Automation ,Control Panel Design course begins at VKE from 1st March & announcing disc.more
    than 30% for first 1st batch.

  14. This comment has been removed by the author.


  16. Creogen Technologies Private Limited introduces a number of products and services for the everyday tasks of home and office. The products and services include Customized Robotics Solution, Product Prototyping and Development along with Industrial Material Handling. To know more please visit us from the given links.

  17. VK Edutech is one of leading industrial technology Knowledge Centre, providing hands on practical training in Advanced Industrial Automation(PLC,SCADA HMI,DCS)Process Control Engineering, Electro Hydraulic & Pneumatic, Industrial Electrical and Electronics, AC DC Drives, Environment, Safety & Fire Engineering. Call Us On +91 82 75067 185

  18. I really loved reading your blog. It was very well authored and easy to understand.Plc training Pune

  19. hello friends, we i know this site is the best way to get free robux for roblox and if you want to know about roblox hack then this is the way we konw. thanks.

  20. best of roblox and its free robux tips are here for you. try this method to get free tix and robux in your account as this is very amazing trick for you. have fun

  21. hello, the best way to get free coins in the game is getting this tool for free and use it as per your needs. have fun with free gaming and enjoy free sports.

  22. best way to ger free resources for your game is getting this tool of cheats and guides for the game. use it and you will have all you want instantly.

  23. This concept is a good way to enhance the knowledge.thanks for sharing. please keep it up salesforce Online Training Hyderabad

  24. I am a regular reader of your blog. This post is really nice. keep up the good stuff like this. Black Friday Hosting Deals.

  25. Very true and inspiring article. I strongly believe all your points. I also learnt a lot from your post. Cheers and thank you for the clear path.

    Digital Marketing Training in Chennai

    Digital Marketing Course in Chennai