Excel Basics to Blackbelt

This third edition capitalizes on the success of the previous editions and leverages the important advancements in visualization, data analysis, and sharing capabilities that have emerged in recent years. It serves as an accelerated guide to decision support designs for consultants, service professionals and students. This 'fast track' enables a ramping up of skills in Excel for those who may have never used it to reach a level of mastery that will allow them to integrate Excel with widely available associated applications, make use of intelligent data visualization and analysis techniques, automate activity through basic VBA designs, and develop easy-to-use interfaces for customizing use. The content of this edition has been completely restructured and revised, with updates that correspond with the latest versions of software and references to contemporary add-in development across platforms. It also features best practices in design and analytical consideration, including methodical discussions of problem structuring and evaluation, as well as numerous case examples from practice.

• Updated reference to MS products, including new features embedded in Excel, but also references to Power BI resources such as Power BI Desktop, Power Query, Power Pivot and Power Map
• Complete discussions of the use of the updated Blackbelt Ribbon add-in, including a host of updated visual and analytical tools
• Formal discussion of systematic approaches to problem structuring, use of the OUtCoMES Cycle, new visualization tools and the associated A3 framework