Microsoft Excel programming pocket primer

✍ Scribed by Korol, Julitta

• Publisher: Mercury Learning and Information
• Year: 2015
• Tongue: English
• Leaves: 260
• Category: Library

✦ Synopsis

Getting started with Excel VBA -- Getting to know Visual Basic Editor (VBE) -- Excel VBA fundamentals -- Excel VBA functions -- Adding decisions to your Excel VBA programs -- Adding repeating actions to your VBA programs -- Keeping track of multiple values using arrays -- Keeping track of multiple values using object collections -- Getting to know built-in tools for testing and debugging.;"As part of the new Pocket Primer series, this book was designed for someone like you who needs to master Excel programming fundamentals without spending too much time. All you need is a short book to get you started. It will show you only the things you need to know to feel at home with VBA. What you learn in this book on Excel programming will also apply to, say, Access programming. The book is divided into nine chapters that progressively introduce you to programming Microsoft Excel using 2013/2010 or 365 versions. Includes a companion disc with all of the "Hands-On" files needed to complete the chapter projects and all the images from the text (including 4-color)." --Back cover.

✦ Table of Contents

Getting started with Excel VBA --
Getting to know Visual Basic Editor (VBE) --
Excel VBA fundamentals --
Excel VBA functions --
Adding decisions to your Excel VBA programs --
Adding repeating actions to your VBA programs --
Keeping track of multiple values using arrays --
Keeping track of multiple values using object collections --
Getting to know built-in tools for testing and debugging.

✦ Subjects

Electronic spreadsheets;Visual Basic for Applications (Computer program language);Microsoft Excel (Computer file)