Let’s Play with Excel

Excel is a very powerful application. But we only use it for simple data entry purpose. We do some plus-minus and a little multiplication etc. Let’s do little more with Excel. Let’s play with excel. It has 51 Macros written by me. They are useful programs having original VBA coding. If you are Computer Student/ VBA Learner/ Excel Professional then you would find this book really helpful. Dear Reader! I am Anurag Pandey. I am a writer, a poet and also a passionate programmer. I like writing codes. I used coding to automate required tasks in my office, which had reduced particular tasks completion time from hours and even days to just a few minutes. I remember, once an official from Income Tax Department of India had said to me that you are an Excel expert. I had replied him that I am not an Excel expert. I only use logic in anything, if I can. We know that Excel is a very powerful application. But we only use it for simple data entry purpose. We do some plus-minus and a little multiplication etc. and all that. Let’s do a little more with Excel. Let’s play with excel. 'Let’s Play with Excel' has 51 Macros written by me. They are useful programs having original VBA coding. If you are Computer Student/ VBA Learner/ Excel Professional then you would find this book really helpful. I would like to tell you about a few programs of this book here. One of its’ Macro is able to give you ready to print Invoice with auto retrieving data. Another Macro is able to take details of entire class (any number of students and subjects) and to provide ready to print Mark-sheet of each student along with Result Sheet of all students at one place. Another Macro provides you simple and easy format to enter data of one or many Invoice/s at once. Then another Macro creates JSON file from that data, which you can use for bulk upload for generating E Invoices. Other two Macros are able to Encode/Decode data of your Excel sheet. Using this you can encode your data and can send the encoded Excel file on Mails etc. At the other hand the file can be decoded only if you have provided the Macro for decoding the sheet. You can very easily make changes in those Macros and then you would have unique Macros for encoding and decoding your Excel sheets. Another Macro of this book has the ability to check two sheets and to list all those cells which have dissimilar data along with both the data. Using this you can check for changes in two sheets having similar data with some expected/ unexpected/ accidental/ unknown mismatches. Some Macros from this book would help you to learn and do manipulation of data your way, some other would help you to exercise logic and programming and some other would help you to learn a little about Excel and VBA. With great excitement and expectation, I request you to check 'Let’s Play with Excel' and provide your invaluable feedback. ANURAG PANDEYBhubaneswar, India