Introduction To Manipulating Data Programmatically In Microsoft Excel With VBA

Contenuto dell'eBook:

Do you seek a fast but solid introduction to programming in Excel? Inside you will find everything you need to start manipulating spreadsheet data using the VBA programming environment within Microsoft Excel 2013. Upon finishing the book, you will have created a complete, working project from start to finish.

Chapter 1, Importing Data, starts by discussing a number of different ways to bring external data into Excel and has you work through several examples. You will also be importing the film list data that will be used throughout the project, the source file for which can be downloaded from the book's Resources section.

Chapter 2, Add-Ins and Macros, introduces both of these and guides you through the creation of each.


Chapter 3, Preparing for Development, shows you how to access the Developer tab in Excel.

Chapter 4, Setting Up the Projects, teaches you how to set up your projects within Excel before starting to write code.

Chapter 5, Creating a List of Genres Programmatically, walks you through writing the code to locate the different genres found within the film list data and to save them to a collection.

Chapter 6, Creating and Populating Worksheets Programmatically, uses code to copy the films of each particular genre out of the original film list and place them within a new worksheet for that genre.

Chapter 7, Summarizing Data Programmatically, looks at presenting totals and percentages in a separate worksheet.

Chapter 8, Creating Charts Programmatically, uses the summary data gathered in the previous chapter to create a chart in the Summary worksheet.

Chapter 9, Formatting Programmatically, focuses on the presentation of the data, increasing readability for the end user.

Chapter 10, Distributing the Add-In, wraps up development by talking about distributing your Add-In and enabling its functionality.

The next two sections contain full code listings for the two project files created in the book.

At the end of the book you will find the Resources section which acts as a central repository for all of the files/resources that you will need as you work through the book's projects.

Per maggiori informazioni: l'eBook "Introduction To Manipulating Data Programmatically In Microsoft Excel With VBA" di Darren Cook, edito da Abstractive Media, è in vendita in formato Kindle su Amazon.it al prezzo di Euro 2,99.