Countdown header img desk

MAI SUNT 00:00:00:00

MAI SUNT

X

Countdown header img  mob

MAI SUNT 00:00:00:00

MAI SUNT

X

Promotii popup img

🎁Târgul Ghetuțelor🎁

Cadouri de Moș Nicolae

-77%, -30%, -50%

Comandă aici!

Let's Play with Excel

De (autor): Anurag Pandey

Let's Play with Excel - Anurag Pandey

Let's Play with Excel

De (autor): Anurag Pandey


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/ unexpect
Citește mai mult

-20%

transport gratuit

PRP: 112.34 Lei

!

Acesta este Prețul Recomandat de Producător. Prețul de vânzare al produsului este afișat mai jos.

89.87Lei

89.87Lei

112.34 Lei

Primești 89 puncte

Important icon msg

Primești puncte de fidelitate după fiecare comandă! 100 puncte de fidelitate reprezintă 1 leu. Folosește-le la viitoarele achiziții!

Livrare in 2-4 saptamani

Descrierea produsului


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/ unexpect
Citește mai mult

S-ar putea să-ți placă și

De același autor

Părerea ta e inspirație pentru comunitatea Libris!

Istoricul tău de navigare

Noi suntem despre cărți, și la fel este și

Newsletter-ul nostru.

Abonează-te la veștile literare și primești un cupon de -10% pentru viitoarea ta comandă!

*Reducerea aplicată prin cupon nu se cumulează, ci se aplică reducerea cea mai mare.

Mă abonez image one
Mă abonez image one
Accessibility Logo