Харкер, Ричард Вба - поворачиваясь к темной стороне Excel

VBA - Turning to the Dark Side of Excel

Opis:

Aimed at complete beginners and novices in Excel VBA programming, this book will take you from the very basics through to working with other applications in the Microsoft suite. Starting with basic navigation, you will be taken through a training program based on over ten years of running VBA training courses to people of all ages, backgrounds and industries. Each chapter will add more complexity and options to your code writing.- The Visual Basic Editor- Recording a macro- Selection methods- Dates & time- Message and input boxes- Cut, copy, paste- SpecialCells- Variables- Constants- Debugging- Calling procedures- Event procedures- Conditional statements- Replying to message boxes- R1C1 referencing & formulas- Arrays- Object variables- Working with files- Charts- Pivot tables- Application objects- Application variables- Forms- Error handling- User-defined functions Most sections have structured exercises so you can practice what you have learnt, with sample answers at the back so you can compare your answers, or simply see a way of dealing with the questions. The answers contain additional notes and comments to help you understand better why a particular method has been applied, and where applicable, explanations about where you might have been caught out. Not having a programming background, I have tried to keep explanations and terms as simple and as clear as possible so that you can understand it all without the need to decipher the text before you can even start understanding what is going on in terms of code. By the end of the book you should be in a position to automate many of your standard daily tasks involving Excel and hopefully give you the confidence and knowledge to move on to bigger projects.

Okładka: Paperback

Liczba stron:315

Autor:Harker, Richard

Język: English: Published; English: Original Language; English

Data wydania: 2020-06-01

Waga: 2 gram

Wysokość: 0.8 cm

Szerokość: 8.5 cm

Długość: 11 cm

UWAGA: Kupując produkt na tej aukcji zgadzasz się na wydłużony termin realizacji wysyłki (10-14 dni roboczych). Podany towar pochodzi z zagranicznego magazynu, stąd wydłużony czas realizacji który podany jest obok.