Balanced Scorecards & Operational Dashboards with Microsoft Excel, 9780470386811 (0470386819), John Wiley & Sons, 2008

Balanced Scorecards & Operational Dashboards with Microsoft Excel, 9780470386811 (0470386819), John Wiley & Sons, 2008

Created in Excel, balanced scorecards enable you to monitor operations and tactics, while operational dashboards is a set of indicators regarding the state of a business metric or process—both features are in high demand for many large organizations. This book serves as the first guide to focus on combining the benefits of balanced scorecards, operational dashboards, performance managements, and data visualization and then implement them in Microsoft Excel.

Create Balanced Scorecards and operational dashboards that drive success

Balanced Scorecards help organizations clarify their strategy, translate strategy into action, and successfully execute their strategy. Operational dashboards are critical for monitoring and managing high performance.

This book is a guide for those who define and build these business performance tools: executive sponsors, operational managers, facilitators, and Excel developers. Based on years of experience, these step-by-step methods will help you develop Balanced Scorecards and operational dashboards that drive strategic execution and operational performance.

• Write a strategic Destination Statement that clarifies your vision

• Build a Strategy Map illustrating strategic objectives and the causal links that drive success

• Map operational processes to identify leverage points with the greatest impact

• Identify the "critical few" metrics that drive and measure success

• Gain buy-in with Tactical Action Plans and Implementation Plans

• Build impressive, dynamic Excel scorecards and dashboards using only spreadsheet functions

• Build powerful charts and analyses that aid business decision making

• Develop portable Balanced Scorecards that are secure and easy to maintain

Companion Web site

Download free Excel sample files at www.wiley.com/go/scorecardsanddashboardswithexcel. You can also find additional resources on Balanced Scorecards and operational dashboards at www.torconsulting.com

About the Author

Ron Person is Managing Director of Tor Consulting, Inc., a firm passionately dedicated to helping organizations execute their strategy and build measurable high performance. He is certified as a Balanced Scorecard consultant through the Balanced Scorecard Collaborative founded by Drs. Kaplan and Norton, founders of the Balanced Scorecard, and he is a member of the California Awards for Performance Excellence Board of Examiners, 2008 (California's Malcolm Baldridge Award). Ron's clients span a wide range of industries in the U.S. and internationally.

The Language of SQL: How to Access Data in Relational Databases, 9781435457515 (143545751X), Course Technology PTR, 2010

The Language of SQL: How to Access Data in Relational Databases, 9781435457515 (143545751X), Course Technology PTR,2010

Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is counterproductive, since this information is readily available in online references published by the major database vendors. For SQL beginners, it's more important for a book to focus on general concepts and offer clear explanations and examples of what the various statements can accomplish. This is that beginner book. A number of features make The LANGUAGE OF SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading them. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to build on your prior understanding as you encounter new words and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle, with special "Database Differences" boxes that will show you any differences in the syntax among those three databases, as well as instructions on how to obtain and install free versions of the databases. This is the only book you'll need to gain a working knowledge of SQL and relational databases.

VBA and Macros: Microsoft Excel 2010 (MrExcel Library), 9780789743145 (0789743140), Que, 2010

VBA and Macros: Microsoft Excel 2010 (MrExcel Library), 9780789743145 (0789743140), Que, 2010

Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won’t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010’s most powerful new features. Learning advanced Excel scripting has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel.

• Work efficiently with ranges, cells, and R1C1-style formulas

• Build super-fast applications with arrays

• Customize the Excel 2010 Ribbon to run your macros

• Write Excel 2010 VBA code that works on older versions of Excel

• Create custom dialog boxes to collect information from your users

• Use error handling to make your VBA scripts more resilient

• Use Web queries to import data from virtually any online source

• Master advanced techniques such as classes and collections

• Use Excel VBA to control other Office programs…even control Windows itself,

via the Windows API

• Create add-ins to share or sell your programs

About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

• Dramatically increase your productivity—saving you 50 hours a year or more

• Present proven, creative strategies for solving real-world problems

• Show you how to get great results, no matter how much data you have

• Help you avoid critical mistakes that even experienced users make

XSLT 2.0 and XPath 2.0 Programmer's Reference (Programmer to Programmer), 9780470192740 (0470192747), Wrox Press, 2008

XSLT 2.0 and XPath 2.0 Programmer's Reference (Programmer to Programmer), 9780470192740 (0470192747), Wrox Press,2008

Balanced Scorecards & Operational Dashboards with Microsoft Excel, 9780470386811 (0470386819), John Wiley & Sons, 2008

Created in Excel, balanced scorecards enable you to monitor operations and tactics, while operational dashboards is a set of indicators regarding the state of a business metric or process—both features are in high demand for many large organizations. This book serves as the first guide to focus on combining the benefits of balanced scorecards, operational dashboards, performance managements, and data visualization and then implement them in Microsoft Excel.

Create Balanced Scorecards and operational dashboards that drive success

Balanced Scorecards help organizations clarify their strategy, translate strategy into action, and successfully execute their strategy. Operational dashboards are critical for monitoring and managing high performance.

This book is a guide for those who define and build these business performance tools: executive sponsors, operational managers, facilitators, and Excel developers. Based on years of experience, these step-by-step methods will help you develop Balanced Scorecards and operational dashboards that drive strategic execution and operational performance.

• Write a strategic Destination Statement that clarifies your vision

• Build a Strategy Map illustrating strategic objectives and the causal links that drive success

• Map operational processes to identify leverage points with the greatest impact

• Identify the "critical few" metrics that drive and measure success

• Gain buy-in with Tactical Action Plans and Implementation Plans

• Build impressive, dynamic Excel scorecards and dashboards using only spreadsheet functions

• Build powerful charts and analyses that aid business decision making

• Develop portable Balanced Scorecards that are secure and easy to maintain

Companion Web site

Download free Excel sample files at www.wiley.com/go/scorecardsanddashboardswithexcel. You can also find additional resources on Balanced Scorecards and operational dashboards at www.torconsulting.com

About the Author

Ron Person is Managing Director of Tor Consulting, Inc., a firm passionately dedicated to helping organizations execute their strategy and build measurable high performance. He is certified as a Balanced Scorecard consultant through the Balanced Scorecard Collaborative founded by Drs. Kaplan and Norton, founders of the Balanced Scorecard, and he is a member of the California Awards for Performance Excellence Board of Examiners, 2008 (California's Malcolm Baldridge Award). Ron's clients span a wide range of industries in the U.S. and internationally.

The Language of SQL: How to Access Data in Relational Databases, 9781435457515 (143545751X), Course Technology PTR, 2010

The Language of SQL: How to Access Data in Relational Databases, 9781435457515 (143545751X), Course Technology PTR,2010

Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is counterproductive, since this information is readily available in online references published by the major database vendors. For SQL beginners, it's more important for a book to focus on general concepts and offer clear explanations and examples of what the various statements can accomplish. This is that beginner book. A number of features make The LANGUAGE OF SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading them. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to build on your prior understanding as you encounter new words and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle, with special "Database Differences" boxes that will show you any differences in the syntax among those three databases, as well as instructions on how to obtain and install free versions of the databases. This is the only book you'll need to gain a working knowledge of SQL and relational databases.

Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets, 9780470591611 (0470591617), Visual, 2010

Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets, 9780470591611 (0470591617),Visual, 2010

Master two of the most powerful features of Excel

Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide.

Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work.

• Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheets
• Covers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and more
• Uses step-by-step tutorials and easy-to-follow screenshots, a "learn by seeing" approach for visual learners

Practical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.

Stock Investing For Dummies (Business & Personal Finance), 9780764599033 (0764599038), For Dummies, 2006

Stock Investing For Dummies (Business & Personal Finance), 9780764599033 (0764599038), For Dummies, 2006

Fully covers today's economic realities — and new opportunities

Build your wealth with smart investing — even in a bear market!

With so many choices, investing can be tricky. Stock Investing For Dummies, 2nd Edition, makes it simple with proven tactics and time-tested strategies for picking winners. This updated edition gives you new case studies, resources, and insight on government policy — and will have you investing with confidence in no time!

Discover how to

• Find a great broker
• Decode company documents
• Choose the right investment strategy
• Handle your taxes
• Weigh risk versus reward
• Discover new investing opportunities

About the Author

Paul Mladjenovic is a certified financial planner practitioner, writer, and public speaker who has a Web site at www.mladjenovic.com. His business, PM Financial Services, has helped people with financial and business concerns since 1981. In 1985 he achieved his CFP designation. Since 1983, Paul has taught thousands of budding investors through popular national seminars such as “The $50 Wealthbuilder” and “Stock Investing Like a Pro.” Paul has been quoted or referenced by many media outlets such as Bloomberg, MarketWatch, CNBC, and many financial and business publications and Web sites. As an author, he has written the books The Unofficial Guide to Picking Stocks (Wiley, 2000) and Zero-Cost Marketing (Todd Publications, 1995). In 2002, the first edition of Stock Investing For Dummies was ranked in the top 10 out of 300 books reviewed by Barron’s. In recent years, Paul accurately forecasted many economic events, such as the rise of gold and the decline of the U.S. dollar. At press time he has been warning his students and clients about the coming decline in housing. He maintains a financial database for his readers and students at www.supermoneylinks.com

VBA and Macros: Microsoft Excel 2010 (MrExcel Library), 9780789743145 (0789743140), Que, 2010

Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won’t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010’s most powerful new features. Learning advanced Excel scripting has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel.

• Work efficiently with ranges, cells, and R1C1-style formulas

• Build super-fast applications with arrays

• Customize the Excel 2010 Ribbon to run your macros

• Write Excel 2010 VBA code that works on older versions of Excel

• Create custom dialog boxes to collect information from your users

• Use error handling to make your VBA scripts more resilient

• Use Web queries to import data from virtually any online source

• Master advanced techniques such as classes and collections

• Use Excel VBA to control other Office programs…even control Windows itself,

via the Windows API

• Create add-ins to share or sell your programs

About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

• Dramatically increase your productivity—saving you 50 hours a year or more

• Present proven, creative strategies for solving real-world problems

• Show you how to get great results, no matter how much data you have

• Help you avoid critical mistakes that even experienced users make