Brilliant Excel VBA Programming

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.

Brilliant guides 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.

Everything you need to know to use VBA Programming to get the most out of Excel.

 

Brilliant Excel VBA Programming guides you through the essential tasks step-by-step, showing you how to:

 

·   Record and run macros

·   Get started with Visual Basic Editor

·   Start working with data and variables

·   Manage workbooks, files and worksheets

·   Format worksheets and worksheet elements

·   Sort and filter data effectively

·   Create, format and manage charts

·   Use built-in functions and statements

·   Debug your VBA code

·   Use Excel events in your VBA code

·   Gather data with UserForms

 

Brilliant books provide quick and easy-to-access information. Features include:

• Numbered step-by-step tasks
• Visual full colour screenshots
• Expert tips, tricks & advice

Practical troubleshooting guide