Excel VBA 24-Hour Trainer 2e

The book is a series of lessons teaching the reader how to get more out of Microsoft Excel by using Visual Basic for Applications. The content is applicable to Excel versions 2007 to 2010 and in between. More than 20% of the content is updated. The content itself is text explanations, illustrations, and code blocks that are not too lengthy and downloadable examples to demonstrate to the reader how and why the programming code works. Most importantly, the aim of the book will be to lead the reader into understanding how to apply these VBA programming techniques to their everyday Excel tasks. A video will complement each lesson in the printed book. Important topics covered in the book: New features including chart and pivot table updatesIntroduction to VBA, macros, and the programming environment, to orient readers to what VBA is and how it can help them.Manipulating the Excel user interface by customizing the look and feel of Excel applications for a user-friendly experience.Events programming and class modules to demonstrate how a user's interactions within the workbook can be controlled or allowed.Decision-making techniques with user forms, message boxes, input boxes, and range selections to yield customized logical results.Programming tasks from Excel that involve other Office programs, such as manipulating Word, Access, PowerPoint, or Outlook.Most importantly 15 new advanced video lessons for the reader who has gone beyond the basics have been added resulting in 11 hours of video training and 41 total lessons to take the reader from the basics and beyond.