Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Excel Basics to Blackbelt is intended to serve as an accelerated guide to decision support designs. Its structure is designed to enhance the skills in Excel of those who have never used it for anything but possibly storing phone numbers, enabling them to reach a level of mastery that will allow them to develop user interfaces and automated applications. To accomplish this, the major theme of the text is 'the integration of the basic'; as a result readers will be able to develop decision support tools that are at once highly intuitive from a working-components perspective but also highly significant from the perspective of practical use and distribution. Applications integration discussed includes the use of MS MapPoint, XLStat and RISKOptimizer, as well as how to leverage Excel's iteration mode, web queries, visual basic code, and interface development. There are ample examples throughout the text.

Decision support systems. --- Microsoft Excel (Computer file). --- Management information systems --- Telematics --- Microsoft Excel (Computer file) --- Microsoft Excel for the Macintosh --- Microsoft Excel for Windows --- Excel (Computer file) --- Excel for Windows --- Microsoft Excel for Windows 95 --- Excel 97 --- Microsoft Excel 97 for Windows --- Excel 2000 --- Excel 2000 for Windows 95 --- Microsoft Excel 2002 --- Microsoft Office Excel 2003 --- Excel 2003 --- Microsoft Excel 2007 --- Excel 2007 --- Excel 2010 --- Microsoft Excel 2013 --- Excel 2013 --- Microsoft Excel 2016 --- Excel 2016 --- Business, Economy and Management --- Business Management --- Decision support systems

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like.

SQL (Computer program language) --- Querying (Computer science) --- Data mining --- Microsoft Excel (Computer file) --- -Querying (Computer science) --- -Data mining --- -005.7585 --- Algorithmic knowledge discovery --- Factual data analysis --- KDD (Information retrieval) --- Knowledge discovery in data --- Knowledge discovery in databases --- Mining, Data --- Database searching --- Structured Query Language (Computer program language) --- Declarative programming languages --- Query languages (Computer science) --- Electronic information resources --- Microsoft Excel for the Macintosh --- Microsoft Excel for Windows --- Excel (Computer file) --- Excel for Windows --- Microsoft Excel for Windows 95 --- Excel 97 --- Microsoft Excel 97 for Windows --- Excel 2000 --- Excel 2000 for Windows 95 --- Microsoft Excel 2002 --- Microsoft Office Excel 2003 --- Excel 2003 --- Microsoft Excel 2007 --- Excel 2007 --- Excel 2010 --- Microsoft Excel 2013 --- Excel 2013 --- Electronic information resources. --- E-books --- Data mining. --- Database interrogation --- Interrogation of databases --- Reporting (Computer science) --- WHOIS (Computer network protocol) --- Microsoft Excel 2016 --- Excel 2016

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Financial Products provides a step-by-step guide to some of the most important ideas in financial mathematics. It describes and explains interest rates, discounting, arbitrage, risk neutral probabilities, forward contracts, futures, bonds, FRA and swaps. It shows how to construct both elementary and complex (Libor) zero curves. Options are described, illustrated and then priced using the Black Scholes formula and binomial trees. Finally, there is a chapter describing default probabilities, credit ratings and credit derivatives (CDS, TRS, CSO and CDO). An important feature of the book is that it explains this range of concepts and techniques in a way that can be understood by those with only a basic understanding of algebra. Many of the calculations are illustrated using Excel spreadsheets, as are some of the more complex algebraic processes. This accessible approach makes it an ideal introduction to financial products for undergraduates and those studying for professional financial qualifications.

Programming --- Capital structure --- 51-7 --- aandelen --- aandelenhandel --- dataverwerking --- futures --- mathematische modellen, toegepast op bedrijfsleven --- opties --- softwarepakketten --- swaps --- wiskundige statistiek --- 332.632 --- Finance --- -Funding --- Funds --- Economics --- Currency question --- Mathematical studies and methods in other sciences. Scientific mathematics. Actuarial mathematics. Biometrics. Econometrics etc. --- Mathematical models --- Microsoft Excel (Computer file) --- Microsoft Excel for the Macintosh --- Microsoft Excel for Windows --- Excel (Computer file) --- Excel for Windows --- Microsoft Excel for Windows 95 --- Excel 97 --- Microsoft Excel 97 for Windows --- Excel 2000 --- Excel 2000 for Windows 95 --- Microsoft Excel 2002 --- Microsoft Office Excel 2003 --- Excel 2003 --- Microsoft Excel 2007 --- Excel 2007 --- Excel 2010 --- Microsoft Excel 2013 --- Excel 2013 --- Mathematical models. --- Microsoft Excel (Computer file). --- -Mathematical studies and methods in other sciences. Scientific mathematics. Actuarial mathematics. Biometrics. Econometrics etc. --- 51-7 Mathematical studies and methods in other sciences. Scientific mathematics. Actuarial mathematics. Biometrics. Econometrics etc. --- -51-7 Mathematical studies and methods in other sciences. Scientific mathematics. Actuarial mathematics. Biometrics. Econometrics etc. --- Funding --- Mathematical studies and methods in other sciences. Scientific mathematics. Actuarial mathematics. Biometrics. Econometrics etc --- Microsoft Excel 2016 --- Excel 2016 --- Business, Economy and Management