Let's Play with Excel

Anurag Pandey

$31.95 $28.97

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Anurag Pandey
28 February 2023

Educational equipment & technology, computer-aided learning (CAL); Algorithms & data structures; Programming & scripting languages: general

Summary
Details

"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 PANDEY

Bhubaneswar, India"

By: Anurag Pandey
Imprint: Anurag Pandey
Dimensions: Height: 279mm, Width: 216mm, Spine: 10mm
Weight: 449g
ISBN: 9798215326336
Pages: 188
Publication Date: 28 February 2023
Audience: General/trade , ELT Advanced
Format: Paperback
Publisher's Status: Active

PERHAPS A GIFT VOUCHER FOR MUM?: MOTHER'S DAY

Let's Play with Excel

Anurag Pandey

$31.95 $28.97

Paperback

See Also

Contact Abbeys

Contact Galaxy

Contact Language

Contact Us

About ABBEY'S