Excel for Chemists. A Comprehensive Guide

Reviews from the First Edition: «Excel® for Chemists should be part of any academic library offering courses and programs in chemistry. There is no other book on the market that deals so thoroughly with the application of Excel for analyzing chemical data. Highly recommended, for upper-division undergraduates through professionals.» -Choice «I highly recommend this book; treat yourself to it; assign it to a class; give it as a gift.» -The Nucleus Chemists across all subdisciplines use Excel to record data in tabular form, but few have learned to take full advantage of the scientific calculating power within this program. Excel is capable of helping chemists process, analyze, and present scientific data, from the relatively simple to the highly complex. Excel® for Chemists, Second Edition has been revised and updated, not only to take into account the changes that were made in Excel, but also to incorporate an abundance of new examples. Arranged in a user-friendly format, this book contains illustrations and examples of chemical applications, useful «How to» boxes outlining how to accomplish complex tasks in Excel, and step-by-step instructions for programming Excel to automate repetitive data-processing tasks. In addition, tips are provided to speed, simplify, and improve your use of Excel. Included is a CD-ROM, usable in either Macintosh or IBM/Windows environments with many helpful spreadsheet templates, macros, and other tools. Entirely new chapters contained in this Second Edition feature: Array formulas covered in depth in a separate chapter, along with a comprehensive review of using arrays in VBA How to create a worksheet with controls, such as option buttons, check boxes, or a list box An extensive list of shortcut keys-over 250 for Macintosh or PC-is provided in the appendix Whether as a text for students or as a reference for chemical professionals in industry, academia, or government, Excel® for Chemists, Second Edition provides a valuable resource for using Excel to manage various chemical calculations.

An essential guide to using Maxima, a popular open source symbolic mathematics engine to solve problems, build models, analyze data and explore fundamental concepts Symbolic Mathematics for Chemists offers students of chemistry a guide to Maxima, a popular open source symbolic mathematics engine that can be used to solve problems, build models, analyze data, and explore fundamental chemistry concepts. The author – a noted expert in the field – focuses on the analysis of experimental data obtained in a laboratory setting and the fitting of data and modeling experiments. The text contains a wide variety of illustrative examples and applications in physical chemistry, quantitative analysis and instrumental techniques. Designed as a practical resource, the book is organized around a series of worksheets that are provided in a companion website. Each worksheet has clearly defined goals and learning objectives and a detailed abstract that provides motivation and context for the material. This important resource: Offers an text that shows how to use popular symbolic mathematics engines to solve problems Includes a series of worksheet that are prepared in Maxima Contains step-by-step instructions written in clear terms and includes illustrative examples to enhance critical thinking, creative problem solving and the ability to connect concepts in chemistry Offers hints and case studies that help to master the basics while proficient users are offered more advanced avenues for exploration Written for advanced undergraduate and graduate students in chemistry and instructors looking to enhance their lecture or lab course with symbolic mathematics materials, Symbolic Mathematics for Chemists: A Guide for Maxima Users is an essential resource for solving and exploring quantitative problems in chemistry.

"The Mutual Fund Industry Handbook is a remarkably important work . . . I am profoundly impressed by the broad and comprehensive sweep of information and knowledge that this book makes available to industry participants, college and business school students, and anyone else with a serious interest in this industry." – From the Foreword by John C. Bogle President, Bogle Financial Markets Research Center Founder and former chief executive, The Vanguard Group A Foreword by John C. Bogle, founder of The Vanguard Group and one of the most respected leaders in the mutual fund industry, sets the stage for this authoritative book that explains the complexities of the phenomenal industry in simple terms. Investors like the fact that mutual funds offer professional management, easy diversification, liquidity, convenience, a wide range of investment choices, and regulatory protection. Mutual Fund Industry Handbook touches on all of those features and focuses on the diverse functions performed in the day-to-day operations of the mutual fund industry. You'll learn about: Front-office functions-analysis, buying, and selling. Back-office functions, including settlement, custody, accounting, and reporting. Commission structures-front-end loads, back-end loads, or level loads. The various fund categories used by the Investment Company Institute, Morningstar, and Lipper. The roles played by fund managers, investment advisors, custodial banks, distributors, transfer agents, and other third-party service providers. If you want a definitive reference on the mutual fund industry, this is the book for you.

A complete appraisal of analytical tools available to managers to assess performance Required reading for anyone starting, running, or growing a business, Business Ratios and Formulas, Third Edition puts answers at the fingertips of business managers, with nearly 250 operational criteria and clear, easy-to-understand explanations that can be used right away. The Third Edition includes twenty new measurements. Approximately 20 new measurements Offers a comprehensive resource of nearly 250 operational criteria An Appendix including a dictionary of accounting and finance terms A thorough list of every ratio and formula, and how to compile and interpret that information Also by Steven M. Bragg: Fast Close: A Guide to Closing the Books Quickly, Second Edition An ideal tool for measuring corporate performance, this authoritative resource allows you to pick and choose the tools you need to best assess your organization's performance.

A comprehensive guide to building financial models Building Financial Models with Microsoft Excel + CD-ROM provides beginning or intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow readers to build their own financial models. This comprehensive resource also covers important topics such as the concept of valuation, the concept of sensitivity analysis, the concepts of contribution margin and financial ratios and the basics of building and using a Capitalization Table. K. Scott Proctor, CFA, is the Director of Investor Analytics at SNL Financial, a financial information provider.

Utilise Excel 2013 capabilities to build effective financial models Using Excel for Business Analysis, Revised Edition provides practical guidance for anyone looking to build financial models. Whether for business proposals, opportunity evaluation, financial reports, or any other business finance application, this book shows you how to design, create, and test your model, then present your results effectively using Excel 2013. The book opens with a general guide to financial modelling, with each subsequent chapter building skill upon skill until you have a real, working model of your own. Financial tools, features, and functions are covered in detail from a practical perspective, and put in context with application to real-world examples. Each chapter focuses on a different aspect of Excel modelling, including step-by-step instructions that walk you through each feature, and the companion website provides live model worksheets that give you the real hands-on practice you need to start doing your job faster, more efficiently, and with fewer errors. Financial modelling is an invaluable business tool, and Excel 2013 is capable of supporting the most common and useful models most businesses need. This book shows you how to dig deeper into Excel's functionality to craft effective financial models and provide important information that informs good decision-making. Learn financial modelling techniques and best practice Master the formulas and functions that bring your model to life Apply stress testing and sensitivity analysis with advanced conditionals Present your results effectively, whether graphically, orally, or written A deceptively powerful application, Excel supports many hundreds of tools, features, and functions; Using Excel for Business Analysis eliminates the irrelevant to focus on those that are most useful to business finance users, with detailed guidance toward utilisation and best practice.

A comprehensive and succinct guide to radiographic physics and imaging, covering all the core components of the radiographic sciences, including digital imaging production and equipment, radiation protection and safety, and the principles of Computed Tomography. Designed to support students preparing to sit certification and board examinations, including the American Registry for Radiologic Technologists (ARRT) and other global radiography certification examinations. Addresses the core radiographic science components of the ASRT curriculum, including digital imaging production and equipment, radiation protection and safety, and the principles of Computed Tomography. Useful for students and practitioners in diagnostic medical radiation technology, radiography and medical radiation sciences, as well as in biomedical engineering technology.

Well-known security experts decipher the most challenging aspect of cloud computing-security Cloud computing allows for both large and small organizations to have the opportunity to use Internet-based services so that they can reduce start-up costs, lower capital expenditures, use services on a pay-as-you-use basis, access applications only as needed, and quickly reduce or increase capacities. However, these benefits are accompanied by a myriad of security issues, and this valuable book tackles the most common security challenges that cloud computing faces. The authors offer you years of unparalleled expertise and knowledge as they discuss the extremely challenging topics of data ownership, privacy protections, data mobility, quality of service and service levels, bandwidth costs, data protection, and support. As the most current and complete guide to helping you find your way through a maze of security minefields, this book is mandatory reading if you are involved in any aspect of cloud computing. Coverage Includes: Cloud Computing Fundamentals Cloud Computing Architecture Cloud Computing Software Security Fundamentals Cloud Computing Risks Issues Cloud Computing Security Challenges Cloud Computing Security Architecture Cloud Computing Life Cycle Issues Useful Next Steps and Approaches

The ultimate guide to investor relations Your one-stop resource for everything pertaining to your company's dealings with the investment community, Running an Effective Investor Relations Department provides investor relations professionals with essential day-to-day information. From creating and properly communicating a company's investment story, to dealing with both the sell side and buy side of the investment community, to providing guidance, and the form and frequency of that guidance, this authoritative resource covers it all. Addresses every possible area of the investor relations profession Includes chapters covering disclosure, forward-looking statements, guidance, event management, and twenty other topics Other titles by Bragg: The Vest Pocket Controller, Accounting Best Practices, Sixth Edition, and Just-in-Time Accounting, Third Edition Practical and thorough, this book offers the world-class guidance you need to effectively manage your investor relations department.