Brilliant Excel VBA Programming, 1st edition

Published by Pearson (March 7, 2013) © 2013

  • Curtis Frye
£14.99
Instant access
Products list
£14.99
Instant access

Title overview

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.

Table of contents

  • 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

Need help?Get in touch