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

🎟️Cupon ACTIV 🎟️

aplică LIB20CARTICUSPF

pentru -20% REDUCERE!

Pregătește-ți lecturile tale de vară!🔆

Let's Play with Excel

Let's Play with Excel - Anurag Pandey

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/ unexpect
Citeste mai mult

-10%

PRP: 112.34 Lei

!

Acesta este Pretul Recomandat de Producator. Pretul de vanzare al produsului este afisat mai jos.

101.11Lei

101.11Lei

112.34 Lei

Primesti 101 puncte

Important icon msg

Primesti puncte de fidelitate dupa fiecare comanda! 100 puncte de fidelitate reprezinta 1 leu. Foloseste-le la viitoarele achizitii!

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
Citeste mai mult

S-ar putea sa-ti placa si

Parerea ta e inspiratie pentru comunitatea Libris!

Istoricul tau de navigare

Acum se comanda

Noi suntem despre carti, si la fel este si

Newsletter-ul nostru.

Aboneaza-te la vestile literare si primesti un cupon de -10% pentru viitoarea ta comanda!

*Reducerea aplicata prin cupon nu se cumuleaza, ci se aplica reducerea cea mai mare.

Ma abonez image one
Ma abonez image one