Provides a step-by-step guide to using Visual Basic for Applications (VBA) and macros to import data and produce reports in Microsoft Excel 2010.

This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. You'll immediately appreciate the value and relevance of each skill as it is taught. Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way. Amongst other things you'll learn how to: ¿Use Excel 2013¿s new data model feature to create table relationships ¿Master dynamic tables and structured table references ¿Completely understand Excel 2013¿s new ability to create OLAP cubes ¿Use Excel 2013¿s new OLAP Pivot Tables to present OLAP cube data ¿Perform What-If analysis to model and compare business scenarios ¿Record macros and then execute them from button controls ¿Create intuitive user interfaces using form controls ¿Enforce complex business rules using function-driven custom validations ¿Use advanced functions to solve real-world business problems ¿Understand and use all of Excel¿s security features ¿Use Excel 2013¿s new timeline slicers to quickly filter date ranges ¿Create and use dynamic and table-based range names

This ILT Series course builds on the skills and concepts taught in Excel 2010: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics. Course manual comes with CertBlaster exam prep software (download). This course will help students prepare for the Microsoft Office Specialist exam for Excel 2010 (exam 77-882). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Excel 2010.

Loved by instructors for the visual and flexible way to build computer skills, the Illustrated Course Guides are ideal for teaching Microsoft Excel 2010 to students across experience levels. Each two-page spread focuses on a single skill, making information easy to follow and absorb. The Illustrated Course Guides split Microsoft Excel 2010 concepts and skills into three manageable levels -- Basic, Intermediate, and Advanced -- perfect for workshops or accelerated courses. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.