Let's Play with Excel
-
- Taschenbuch
- eBook ausgewählt
-
Form:Einzelkauf Download
-
Sprache:Englisch
1,99 €
3,49 €
*
*befristete Preissenkung des Verlages.
Beschreibung
Produktdetails
Format
ePUB
Kopierschutz
Ja
Family Sharing
Ja
Text-to-Speech
Ja
Erscheinungsdatum
13.05.2021
Verlag
Anurag PandeySeitenzahl
(Printausgabe)
Dateigröße
206 KB
Sprache
Englisch
EAN
9798201837082
Let's Play with Excel
What can you really make Excel do with VBA?
Excel is much more than a tool for entering data, making tables, and performing calculations. With VBA, logical thinking, and a little creativity, you can automate repetitive work, manipulate data, generate useful documents, solve programming problems, and explore possibilities that go beyond ordinary spreadsheet operations.
Let's Play with Excel contains 51 original VBA macros by Anurag Pandey, bringing together practical office automation, data manipulation, programming exercises, mathematical logic, and creative Excel experiments.
Here are just a few of the things explored in the book:
- Ready-to-Print Invoice: Automatically retrieves data and prepares an invoice ready for printing.
- Marksheet & Class Result: Processes details of an entire class and prepares individual marksheets and a result sheet.
- Invoice Data & JSON: Provides a convenient way to enter invoice data and creates a JSON file for E-Invoice-related use.
- Encode & Decode Worksheet Data: Two complementary VBA macros demonstrate how selected Excel worksheet data can be encoded and subsequently decoded.
- Compare Two Worksheets: Finds cells containing different data and displays the corresponding values, making it easier to identify unexpected or accidental changes.
- Data Manipulation: Includes programs for filtering, copying, merging, unmerging, shifting, trimming, and reorganizing Excel data.
- Programming & Logic: Explore prime numbers, palindromes, square roots, digit-reversal logic, odd/even numbers, loops, and calculations.
- Excel Experiments: Includes ten different worksheet-animation examples and other interesting ways to work with cells and worksheet data.
The book also introduces fundamental VBA concepts through examples involving If statements, Nested If, ElseIf, For...Next loops, and Nested Loops.
These macros are more than ready-made programs. Study them. Run them. Change them. Experiment with them. Each program can be an opportunity to understand VBA logic, explore Excel's capabilities, and develop your own solutions.
Whether you are a VBA learner, computer student, Excel professional, office user, or simply curious about programming, this collection offers practical programs to study and explore.
You don't need to be an Excel expert.
You need curiosity, logic, and a willingness to experiment.
Don't just use Excel. Explore it. Experiment with it. Automate it.
Let's Play with Excel.
Noch keine Bewertungen vorhanden
Verfassen Sie die erste Bewertung zu diesem Artikel
Helfen Sie anderen Kundinnen und Kunden durch Ihre Meinung.
Kurze Frage zu unserer Seite
Vielen Dank für Ihr Feedback
Wir nutzen Ihr Feedback, um unsere Produktseiten zu verbessern. Bitte haben Sie Verständnis, dass wir Ihnen keine Rückmeldung geben können. Falls Sie Kontakt mit uns aufnehmen möchten, können Sie sich aber gerne an unseren Kund*innenservice wenden.
zum Kundenservice