Google ExcelAutomate.com: 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!!!!!!

26 comments:

  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 http://stackoverflow.com/questions/2499530/struts2-trim-all-string-obtained-from-forms/18547657#18547657

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

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

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

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

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

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


    Sharma,
    Guragon

    ReplyDelete
  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.

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

    ReplyDelete
  10. This comment has been removed by the author.

    ReplyDelete
  11. 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.

    ReplyDelete
  12. 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

    ReplyDelete
  13. 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.

    ReplyDelete
  14. 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.

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

    ReplyDelete
  16. 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

    ReplyDelete