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!!!!!!

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

    WIZTECH AUTOMATION SOLUTIONS PVT LTD

    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 : www.automationtraining.info
    E-mail : info@automtiontraining.info

    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

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

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

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

    ReplyDelete
  13. PLC, SCADA,HMI, Automation ,Control Panel Design course begins at VKE from 1st March & announcing disc.more
    than 30% for first 1st batch.
    Cont:02026632710,8237070153.
    www.vkedutech.com

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

    ReplyDelete
  15. http://www.aigproexcellence.com/

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

    ReplyDelete
  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

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

    ReplyDelete