Learn to use Excel for practical, day-to-day calculations
Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to compare the cost of buying vs. leasing a car, calculate classroom grades, or evaluate investment performance, for example. Another 85 specialized functions are also described. Detailed, step-by-step instructions help you understand how functions work within formulas and how you can use them to solve everyday problems.
Excel is a complex tool, making it a perfect subject for the straightforward, plain-English approach of this book
Formulas and functions are explained in classic For Dummies fashion, with examples of how to apply the 150 most commonly used functions in real-world situations
Discover how to use Excel to compare the cost of 15 and 30-year mortgages, decide whether to buy or lease a car, calculate the actual cost of credit card purchases, forecast college expenses, design a database for your own use, and much more
Serves as an excellent resource for all versions of Excel, including the latest version 2013
Excel Formulas and Functions For Dummies, 3rd Edition helps you put the power of Excel to work in your daily life.
Automated Trading with R: Quantitative Research and Platform Development
Learn to trade algorithmically with your existing brokerage, from data management, to strategy optimization, to order execution, using free and publicly available data. Connect to your brokerage’s API, and the source code is plug-and-play.
Automated Trading with R explains automated trading, starting with its...
Simulation and Optimization in Finance: Modeling with MATLAB, @Risk, or VBA
An introduction to the theory and practice of financial simulation and optimization
In recent years, there has been a notable increase in the use of simulation and optimization methods in the financial industry. Applications include portfolio allocation, risk management, pricing, and capital budgeting under uncertainty....
SAS Programming and Data Visualization Techniques: A Power User's Guide
SAS Programming and Data Visualization Techniques: A Power User’s Guide brings together a wealth of ideas about strategic and tactical solutions to everyday situations experienced when transferring, extracting, processing, analyzing, and reporting the valuable data you have at your fingertips. Best, you can achieve most of the...
Excel VBA 24-Hour Trainer
Increase your productivity and save time and effort with Excel VBA
This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate your routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons while the...
AI Game Engine Programming (Game Development Series)
AI Game Engine Programming provides game developers with the tools and wisdom necessary to create modern game AI engines. It takes programmers from theory to actual game development, with usable code frameworks designed to go beyond merely detailing how a technique might be used. In addition, it surveys the capabilities of the different...
Particle Physics: A Very Short Introduction
We are made of atoms. With each breath you inhale a million billion billion atoms of oxygen, which gives some idea of how small each one is. All of them, together with the carbon atoms in your skin, and indeed everything else on Earth, were cooked in a star some 5 billion years ago. So you are made of stuff that is as old as the planet,...