
Brilliant Excel VBA Programming
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
Develop the Excel skills that you need to produce spreadsheet solutions to your business needs - instantly!
There are an estimated 400 million Excel users, but the majority of them haven't worked out a way to effectively use Excel VBA (Visual Basic for Applications).
This book is for those that use Excel at work and who want to use the advanced features of Excel but don't have the time to have extensive training. It takes you through each task (as all Brilliant books do) and describes everything you could want to find out, for example:
- how to use the macro recorder
- how to take that recorded code and turn it into something useful that will really help you day to day
- how to automate reports and design applications
Users will then improve their Excel skills so they can in the end save a lot of time and get more done.
Brilliantguides allow you to find the info you need quickly, easily and without fuss. It guides you through all the tasks using a highly visual, step-by-step approach - providing exactly what you need to know when you need it.
All prices
More details
Other editions
Additional editions

Content
- Introduction
- 1 Recording and running macros
- 2 Starting with the Visual Basic Editor
- 3 Working with data and variables
- 4 Managing workbooks and files
- 5 Managing worksheets
- 6 Managing ranges
- 7 Managing cells
- 8 Formatting worksheets and worksheet elements
- 9 Sorting and filtering data
- 10 Managing charts
- 11 Using built-in functions and statements
- 12 Managing code ssing logical constructs
- 13 Debugging your VBA code
- 14 Using Excel events in your VBA code
- 15 Gathering data with UserForms
- Jargonbuster
- Troubleshooting guide
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.
File format: PDF
Copy protection: Watermark-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Use the free software Adobe Reader, Adobe Digital Editions, or any other PDF viewer of your choice (see eBook Help).
- Tablet/Smartphone (Android; iOS): Install the free app Adobe Digital Editions or another reading app for eBooks, e.g., PocketBook (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Watermark-DRM, a „soft” copy protection. This means that there are no technical restrictions to prevent illegal distribution. However, there is a personalised watermark embedded in the eBook that can be used to identify the purchaser of the eBook in the event of misuse and to provide evidence for legal purposes.
For more information, see our eBook Help page.