- Table View
- List View
Advanced Excel Essentials
by Jordan GoldmeierAdvanced Excel Essentials is the only book for experienced Excel developers who want to channel their skills into building spreadsheet applications and dashboards. This book starts from the assumption that you are well-versed in Excel and builds on your skills to take them to an advanced level. It provides the building blocks of advanced development and then takes you through the development of your own advanced spreadsheet application. For the seasoned analyst, accountant, financial professional, management consultant, or engineer--this is the book you've been waiting for! Author Jordan Goldmeier builds on a foundation of industry best practices, bringing his own forward-thinking approach to Excel and rich real-world experience, to distill a unique blend of advanced essentials. Among other topics, he covers advanced formula concepts like array formulas and Boolean logic and provides insight into better code and formulas development. He supports that insight by showing you how to build correctly with hands-on examples. What you'll learn How to build better, faster, and leaner spreadsheets that will make you a force to be reckoned with in your organization How to write optimized code and formulas that are easily understood even by less experienced users How to turn a spreadsheet into a powerhouse application that rivals commercial software About the tools and techniques for optimal layout, data storage, and advanced analytics Who this book is for Intermediate or advanced excel users who wish to learn how to be more productive and develop more powerful applications Table of Contents 1. Introduction 2. Visual Basic for Applications for Excel, a Refresher 3. Introducing Formula Concepts 4. Advanced Formula Concepts 5. Introduction to Controls 6. Getting Input from Users 7. Storage Patterns for User Input 8. Building for Sensitivity Analysis 9. Perfecting the Presentation
Advanced Excel for Surveyors
by Philip Bowcock Natalie BayfieldAdvanced Excel for Surveyors is the companion to the highly successful Excel for Surveyors. This volume is intended to help both students and practitioners use Mircosoft Excel™ to solve some of the more complex problems that the surveyor may come across.It explores how Visual Basic and macros can simplify and speed up repetitive tasks, fulfilling one of the basic aims of computing: “If it is repetitive teach the machine to do this for you”. The methodology of portfolio analysis is a relatively new discipline, which may be unfamiliar to many readers. The book provides an introduction to the principles and shows how Excel can help, readers may even find this of help when assessing their own personal investment portfolios. Further ideas for setting up databases; how to arrange for several surveyors to work on a single project; data analysis; and the use of charts in Reports are discussed together with further advice on security and protection.
Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas
by Alan MurrayEnhance and upgrade your Excel knowledge with this comprehensive guide to formulas in Excel. Over 150 of the most useful Excel functions are covered with numerous practical examples of their use. This book is fully updated and includes examples of the most recently released functions in 2022. It is written in a manner that you can read it cover-to-cover or pick it up and learn something new in just 5 minutes.The book begins with a primer on Excel formulas and functions. Starting from a basic level, but diving into intricate detail and building a solid understanding of the fundamentals. It may not always be sexy, but learning why, in addition to how, is important to truly understanding Excel formulas. Having strong fundamentals is the most advanced skill.The book covers all the most popular functions in Excel including VLOOKUP, SUMPRODUCT, COUNTIFS, MATCH, SORT and so much more. You will learn how to return multiple results with a single formula. Harness the power of the dynamic array engine and functions such as SEQUENCE, SORTBY, UNIQUE, XLOOKUP and FILTER to create top N Lists, models and reports that would seem impossible without array formulas. In the final chapter, we discover the amazing LAMBDA function in Excel. Create your own Excel functions to simplify future Excel formulas and share them with others. In this book, the formulas are not only written to return values to the grid, but also for use with other Excel features such as charts and Conditional Formatting, to take them to another level. Practice files are provided to follow all examples shown in the book.What Will You Learn Gain intimate knowledge of Excel formulas Understand efficient and practical use of Defined Names and TablesMaster the most popular functions of Excel – VLOOKUP, COUNTIFS, MATCH, SUMPRODUCT, and so much moreLearn to return multiple results from a single formula with the magical array formulas. Know the best lookup functions for dynamic spreadsheetsKnow true power of classic Excel functions such as IF, SUM, and INDEXUse new Excel functions including XLOOKUP, VSTACK, LET, and LAMBDA Who Is This Book ForExcel users who are familiar with formulas but want to improve their current skill level
Advanced Excel Reporting for Management Accountants
by Neale BlackwoodThe advanced tools accountants need to build automated, reliable, and scalable reports using ExcelLearn about the functions that work together to automate many of the processes involved in Management Reporting. See how to take advantage of the many new features of Excel 2007 and 2010. Find out how to build validation structures into your spreadsheet reports. Discover how to identify missing or new codes, either in the creation process or in the day-to-day running of the reports. Do it all with Advanced Excel Reporting for Management Accountants.Explore the structures that simplify the report creation process and make the reports more maintainableLearn techniques to "cleanse" data so that it is ready for use in Pivot Tables and formula-based reportsFind out the tips and tricks that can make the creation process quicker and easierDiscover all you need to know about Excel's summing functions and how versatile they can beWritten in a hands-on style that works towards the completion of two reporting case studies, Advanced Excel Reporting for Management Accountants explains and demonstrates techniques so that Management Accountants can learn how to automate many aspects of the reporting process.
Advanced Excel Success: A Practical Guide to Mastering Excel
by Alan MurrayExplore advanced skills in Excel and gain an amazing array of tricks and tools to increase your productivity. This book discusses new techniques such as power functions, chart tricks, and many more to master Excel. Advanced Excel Success starts with a few useful data tools in Excel followed by advanced formulas that will help you increase productivity. Here, you will learn power functions that aggregate, return ranges, and much more. Further, you will look at custom formatting tricks along with advanced charting tricks. These include automatically changing the color of key metrics, dynamically sorting chart data, and building creative labels. Next, you will understand the role of Power Query which is one of the most important upgrades in Excel. Power Query is the Microsoft Data Connectivity and Data Preparation technology that enables business users to seamlessly access data stored in hundreds of data sources and reshape it to fit their needs, with an easy–to-use, engaging, and no-code user experience. Finally, you will learn Power Pivot which is a distinct feature in Excel that goes beyond spreadsheets. After reading this book, you will be well equipped to work on Excel with its advanced features. What You Will Learn Work with the most useful data tools Understand formulas and the ten power functionsUse advanced chart and formatting tricks and techniques for dynamic and effective visualsWork with power tools Who This Book Is For Excel users looking to take the next step to expert level.
Advanced Experimental and Numerical Techniques for Cavitation Erosion Prediction (Fluid Mechanics and Its Applications #106)
by Ki-Han Kim Georges Chahine Jean-Pierre Franc Ayat KarimiThis book provides a comprehensive treatment of the cavitation erosion phenomenon and state-of-the-art research in the field. It is divided into two parts. Part 1 consists of seven chapters, offering a wide range of computational and experimental approaches to cavitation erosion. It includes a general introduction to cavitation and cavitation erosion a detailed description of facilities and measurement techniques commonly used in cavitation erosion studies, an extensive presentation of various stages of cavitation damage (including incubation and mass loss) and insights into the contribution of computational methods to the analysis of both fluid and material behavior. The proposed approach is based on a detailed description of impact loads generated by collapsing cavitation bubbles and a physical analysis of the material response to these loads. Part 2 is devoted to a selection of nine papers presented at the International Workshop on Advanced Experimental and Numerical Techniques for Cavitation Erosion Prediction (Grenoble, France, 1-2 March 2011) representing the forefront of research on cavitation erosion. Innovative numerical and experimental investigations illustrate the most advanced breakthroughs in cavitation erosion research.
Advanced Experimental Inorganic Chemistry
by V.K. Ahluwalia Sunita DhingraThis book is divided into four parts:- Part I deals with Qualitative Inorganic Analysis. Systematic procedures of anion and cation analysis alongwith their confirmatory tests and spot tests are given. Detection of cations by flame photometry and atomic absorption spectroscopy are also incorporated. Besides chromatographic separation and identification of cations are also discussed. - Part II deals with volumetric analysis. The instrumental methods of volumetric analysis have also been incorporated.- Part III deals with gravimetric analysis. Estimation of one or more than one constituent in a solution and instrumental methods of quantitative analysis are also incorporated.- Part IV describes many inorganic preparations. These include simple salts, double salts, complex salts, amalgams, activated metals, organometallics and some other miscellaneous inorganic preparations. The uses of various compounds have also been mentioned.Print edition not for sale in South Asia (India, Sri Lanka, Nepal, Bangladesh, Pakistan or Bhutan)
Advanced Experimental Organic Chemistry
by V.K. Ahluwalia Sunita DhingraAimed at undergraduate and post-graduate students and aligned with the curricula across universities, this book details the fundamental concepts in Organic Chemistry, including – Qualitative analysis of organic compounds: Methods for identifying single compounds and mixtures, with detailed explanations of tests, derivative preparations, and spot tests for functional groups and elements are discussed. Microwave-assisted synthesis is also included. Spectrometric methods: Techniques like IR, UV, NMR, and Mass Spectrometry are explained with practical examples for the analysis of compound structures and applications of these techniques. Practical applications: Chapters on organic compound preparation, natural product isolation, quantitative estimations, and chromatographic techniques for purification are included. The subject matter of this book also includes self-assessment questions for enhanced understanding and practice.Print edition not for sale in South Asia (India, Sri Lanka, Nepal, Bangladesh, Pakistan or Bhutan)
Advanced Express Web Application Development
by Andrew KeigA practical book, guiding the reader through the development of a single page application using a feature-driven approach.If you are an experienced JavaScript developer who wants to build highly scalable, real-world applications using Express, this book is ideal for you. This book is an advanced title and assumes that the reader has some experience with node, Javascript MVC web development frameworks, and has heard of Express before, or is familiar with it. You should also have a basic understanding of Redis and MongoDB. This book is not a tutorial on Node, but aims to explore some of the more advanced topics you will encounter when developing, deploying, and maintaining an Express web application.
Advanced Facilitation Strategies: Tools & Techniques to Master Difficult Situations
by Ingrid BensFrom Ingrid Bens, the author of the best-selling book Facilitating with Ease!, comes the next-step resource for project leaders, managers, community leaders, teachers, and other facilitators who want to hone their skills in order to deal with complex situations. Advanced Facilitation Strategies is a field guide that offers practical strategies and techniques for working with challenging everyday situations. These proven strategies and techniques are based on experience gleaned from hundreds of facilitated activities in organizations of all sizes and in all sectors. Both novice and seasoned facilitators who have had firsthand experience designing and leading meetings will benefit from this reality-based playbook. Advanced Facilitation Strategies is filled with the information facilitators need to Become better at diagnosing facilitation assignments and creating effective process designs Broaden their repertoire of tools to make impromptu design changes whenever they are needed Learn to be more resilient and confident when dealing with dysfunctional situations and difficult people.
Advanced Fashion Drawing: Lifestyle Illustration
by William Bil DonovanAdvanced Fashion Drawing is a practical book showing not only how to draw the figure but also how to illustrate it in today’s fashion and lifestyle market. Designed specifically for those interested in illustrating fashion and lifestyle commercially, Bil Donovan demonstrates how to create an illustration with a sense of fashion, rather than one that concentrates solely on the fashion figure.A series of demonstrations and exercises help the advanced illustration student hone their skills and increase their level of draughtsmanship, while establishing their own personal style.
Advanced Fashion Drawing: Lifestyle Illustration
by Bil Donovan William Bil DonovanAdvanced Fashion Drawing is a practical book showing not only how to draw the figure but also how to illustrate it in today’s fashion and lifestyle market. Designed specifically for those interested in illustrating fashion and lifestyle commercially, Bil Donovan demonstrates how to create an illustration with a sense of fashion, rather than one that concentrates solely on the fashion figure.A series of demonstrations and exercises help the advanced illustration student hone their skills and increase their level of draughtsmanship, while establishing their own personal style.
Advanced Fermentation and Cell Technology
by Byong H. LeeADVANCED FERMENTATION AND CELL TECHNOLOGY A comprehensive and up-to-date reference covering both conventional and novel industrial fermentation technologies and their applications Fermentation and cell culture technologies encompass more than the conventional microbial and enzyme systems used in the agri-food, biochemical, bioenergy and pharmaceutical industries. New technologies such as genetic engineering, systems biology, protein engineering, and mammalian cell and plant cell systems are expanding rapidly, as is the demand for sustainable production of bioingredients, drugs, bioenergy and biomaterials. As the growing biobased economy drives innovation, industrial practitioners, instructors, researchers, and students must keep pace with the development and application of novel fermentation processes and a variety of cell technologies. Advanced Fermentation and Cell Technology provides a balanced and comprehensive overview of the microbial, mammalian, and plant cell technologies used by the modern biochemical process industry to develop new and improved processes and products. This authoritative volume covers the essential features of advanced fermentation and cell technology, and highlights the interaction of food fermentation and cell culture biopharmaceutical actives. Detailed chapters, organized into five sections, cover microbial cell technology, animal and plant cell technology, safety issues of new biotechnologies, and applications of microbial fermentation to food products, chemicals, and pharmaceuticals. Written by an internationally-recognized expert in food biotechnology, this comprehensive volume: Covers both conventional and novel industrial fermentation technologies and their applications in a range of industries Discusses current progress in novel fermentation, cell culture, commercial recombinant bioproducts technologies Includes overviews of the global market size of bioproducts and the fundamentals of cell technology Highlights the importance of sustainability, Good Manufacturing Practices (GMP), quality assurance, and regulatory practices Explores microbial cell technology and culture tools and techniques such as genome shuffling and recombinant DNA technology, RNA interference and CRISPR technology, molecular thermodynamics, protein engineering, proteomics and bioinformatics, and synthetic biology Advanced Fermentation and Cell Technology is an ideal resource for students of food science, biotechnology, microbiology, agricultural sciences, biochemical engineering, and biochemistry, and is a valuable reference for food scientists, researchers, and technologists throughout the food industry, particularly the dairy, bakery, and fermented beverage sectors.
Advanced Fiber Sensing Technologies (Progress in Optical Science and Photonics #9)
by Lei WeiFiber sensing technologies have enabled both fundamental studies and a wide spectrum of applications in every aspect of life. This book highlights the recent advancement in fiber sensing technologies based on newly developed sensing mechanisms, advanced fiber structures, and functional materials. In particular, the integration of functional materials with different electrical, optical, thermal, or mechanical properties into a single fiber offers a wealth of new opportunities in sensing. The book covers the major developments in novel fiber materials, such as semiconductors, metals, polymers, soft glasses, and carbon materials, as well as the sensing applications based on both single fiber and multi-dimensional fiber arrays for temperature, light, strain, vibration, electric and magnetic fields, hazardous chemicals, gases, and physiological signals.
Advanced Field-Effect Transistors: Theory and Applications
by Dharmendra Singh Yadav Shiromani Balmukund Rahi Sukeshni TirkeyAdvanced Field-Effect Transistors: Theory and Applications offers a fresh perspective on the design and analysis of advanced field-effect transistor (FET) devices and their applications. The text emphasizes both fundamental and new paradigms that are essential for upcoming advancement in the field of transistors beyond complementary metal–oxide–semiconductors (CMOS). This book uses lucid, intuitive language to gradually increase the comprehension of readers about the key concepts of FETs, including their theory and applications. In order to improve readers’ learning opportunities, Advanced Field-Effect Transistors: Theory and Applications presents a wide range of crucial topics: • Design and challenges in tunneling FETs • Various modeling approaches for FETs • Study of organic thin-film transistors • Biosensing applications of FETs • Implementation of memory and logic gates with FETs The advent of low-power semiconductor devices and related implications for upcoming technology nodes provide valuable insight into low-power devices and their applicability in wireless, biosensing, and circuit aspects. As a result, researchers are constantly looking for new semiconductor devices to meet consumer demand. This book gives more details about all aspects of the low-power technology, including ongoing and prospective circumstances with fundamentals of FET devices as well as sophisticated low-power applications.
Advanced Field-Solver Techniques for RC Extraction of Integrated Circuits
by Wenjian Yu Xiren WangResistance and capacitance (RC) extraction is an essential step in modeling the interconnection wires and substrate coupling effect in nanometer-technology integrated circuits (IC). The field-solver techniques for RC extraction guarantee the accuracy of modeling, and are becoming increasingly important in meeting the demand for accurate modeling and simulation of VLSI designs. Advanced Field-Solver Techniques for RC Extraction of Integrated Circuits presents a systematic introduction to, and treatment of, the key field-solver methods for RC extraction of VLSI interconnects and substrate coupling in mixed-signal ICs. Various field-solver techniques are explained in detail, with real-world examples to illustrate the advantages and disadvantages of each algorithm. This book will benefit graduate students and researchers in the field of electrical and computer engineering as well as engineers working in the IC design and design automation industries. Dr. Wenjian Yu is an Associate Professor at the Department of Computer Science and Technology at Tsinghua University in China; Dr. Xiren Wang is a R&D Engineer at Cadence Design Systems in the USA.
Advanced Financial Accounting
by Theodore E. Christensen David M. Cottrell Cassy BuddThe Thirteenth Edition of Advanced Financial Accounting is an up-to-date, comprehensive, and highly illustrated presentation of the accounting and reporting principles and procedures used in a variety of business entities. Every day, the business press carries stories about merger and acquisition mania, the complexities of modern business entities, new organizational structures for conducting business, accounting scandals related to complex business transactions, the foreign activities of multinational firms, the operations of governmental and not-for-profit entities, and bankruptcies of major firms. Accountants must understand and know how to deal with the accounting and reporting ramifications of these issues.
Advanced Financial Risk Management
by Mark Mesler Donald R. Van Deventer Kenji ImaiPractical tools and advice for managing financial risk, updated for a post-crisis worldAdvanced Financial Risk Management bridges the gap between the idealized assumptions used for risk valuation and the realities that must be reflected in management actions. It explains, in detailed yet easy-to-understand terms, the analytics of these issues from A to Z, and lays out a comprehensive strategy for risk management measurement, objectives, and hedging techniques that apply to all types of institutions. Written by experienced risk managers, the book covers everything from the basics of present value, forward rates, and interest rate compounding to the wide variety of alternative term structure models.Revised and updated with lessons from the 2007-2010 financial crisis, Advanced Financial Risk Management outlines a framework for fully integrated risk management. Credit risk, market risk, asset and liability management, and performance measurement have historically been thought of as separate disciplines, but recent developments in financial theory and computer science now allow these views of risk to be analyzed on a more integrated basis. The book presents a performance measurement approach that goes far beyond traditional capital allocation techniques to measure risk-adjusted shareholder value creation, and supplements this strategic view of integrated risk with step-by-step tools and techniques for constructing a risk management system that achieves these objectives.Practical tools for managing risk in the financial worldUpdated to include the most recent events that have influenced risk managementTopics covered include the basics of present value, forward rates, and interest rate compounding; American vs. European fixed income options; default probability models; prepayment models; mortality models; and alternatives to the Vasicek model Comprehensive and in-depth, Advanced Financial Risk Management is an essential resource for anyone working in the financial field.
Advanced Fingerprint Recognition: From 3D Shape to Ridge Detail
by Feng Liu Qijun Zhao David ZhangFingerprints are among the most widely used biometric modalities and have been successfully applied in various scenarios. For example, in forensics, fingerprints serve as important legal evidence; and in civilian applications, fingerprints are used for access and attendance control as well as other identity services. Thanks to advances in three-dimensional (3D) and high-resolution imaging technology, it is now feasible to capture 3D or high-resolution fingerprints to provide extra information and go beyond the traditional features such as global ridge patterns and local ridge singularities used in conventional fingerprint recognition tasks. This book presents the state of the art in the acquisition and analysis of 3D and high-resolution fingerprints. Based on the authors’ research, this book focuses on advanced fingerprint recognition using 3D fingerprint features (i.e., finger shape, level 0 features) or high-resolution fingerprint features (i.e., ridge detail, level 3 features). It is a valuable resource for researchers, professionals and graduate students working in the field of computer vision, pattern recognition, security/biometrics practice, as well as interdisciplinary researchers.
Advanced Finite Element Methods with Applications: Selected Papers from the 30th Chemnitz Finite Element Symposium 2017 (Lecture Notes in Computational Science and Engineering #128)
by Ulrich Langer Thomas Apel Arnd Meyer Olaf SteinbachFinite element methods are the most popular methods for solving partial differential equations numerically, and despite having a history of more than 50 years, there is still active research on their analysis, application and extension. This book features overview papers and original research articles from participants of the 30th Chemnitz Finite Element Symposium, which itself has a 40-year history. Covering topics including numerical methods for equations with fractional partial derivatives; isogeometric analysis and other novel discretization methods, like space-time finite elements and boundary elements; analysis of a posteriori error estimates and adaptive methods; enhancement of efficient solvers of the resulting systems of equations, discretization methods for partial differential equations on surfaces; and methods adapted to applications in solid and fluid mechanics, it offers readers insights into the latest results.
Advanced Finite Element Simulation with MSC Marc: Application of User Subroutines
by Andreas Öchsner Zia JavanbakhtThis book offers an in-depth insight into the general-purpose finite element program MSC Marc, which is distributed by MSC Software Corporation. It is a specialized program for nonlinear problems (implicit solver) which is common in academia and industry. The primary goal of this book is to provide a comprehensive introduction to a special feature of this software: the user can write user-subroutines in the programming language Fortran, which is the language of all classical finite element packages. This subroutine feature allows the user to replace certain modules of the core code and to implement new features such as constitutive laws or new elements. Thus, the functionality of commercial codes ('black box') can easily be extended by linking user written code to the main core of the program. This feature allows to take advantage of a commercial software package with the flexibility of a 'semi-open' code.
Advanced Finite Element Technologies (CISM International Centre for Mechanical Sciences #566)
by Peter Wriggers Jörg SchröderThe book presents an overview of the state of research of advanced finite element technologies. Besides the mathematical analysis, the finite element development and their engineering applications are shown to the reader. The authors give a survey of the methods and technologies concerning efficiency, robustness and performance aspects. The book covers the topics of mathematical foundations for variational approaches and the mathematical understanding of the analytical requirements of modern finite element methods. Special attention is paid to finite deformations, adaptive strategies, incompressible, isotropic or anisotropic material behavior and the mathematical and numerical treatment of the well-known locking phenomenon. Beyond that new results for the introduced approaches are presented especially for challenging nonlinear problems.
Advanced Fire & Emergency Services Administration with Navigate Advantage Access
by Randy R BruegmanAdvanced Fire and Emergency Services Administration, Second Edition includes all of the information necessary to provide the current or future chief officer with the knowledge to lead and prepare their organization while making the necessary shifts to be relevant and sustainable in the future. The text is designed to be a progressive primer for students who are seeking more knowledge about fire and emergency service administration. It demonstrates the importance of the following skills necessary to manage and lead a fire and emergency services department through the challenges and changes of the 21st century: Persuasion and influence Accountable budgeting Anticipation of challenges and the need for change Using specific management tools for analyzing and solving problems With Advanced Fire and Emergency Services Administration, Second Edition, learners will see first hand how the leader of a fire and emergency services department develop internal and external cooperative skills to cr
Advanced First Aid CPR + AED
by National Safety Council National Safety Council NscPart of a series of titles authored by the National Safety Council, First Aid: Taking Action covers the material required for a semester long Advanced First Aid course . The focus is teaching how to recognize and act in any emergency and to sustain life until professional help can arrive. Other information includes bleeding control, and first aid for sudden illnesses and injuries. Information is presented in a concise easy-to-read manner that works as a handy reference after the course. National Safety Council programs and products are designed to benefit all types of learning styles by combining lectures, video presentations, group discussions, and hands-on training.
Advanced First Aid, CPR, and AED eBook
by AAOSAdvanced First Aid, CPR, and AED, Eighth Edition is ideal for use within college-level courses designed to train individuals in first aid, CPR, and AED. More than a stand-alone text, this student manual is the center of an integrated teaching and learning system that offers many resources to better