Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help

Microsoft Excel


1. 

Finanzmathematik mit Excel kurz & gut

Finanzmathematik mit Excel kurz & gut

By: Michael Kolberg

Publisher: O'Reilly Verlag

Publication Date: 18-JUL-2014

Insert Date: 22-JUL-2014

Slots: 1.0

Table of Contents • Start Reading

Die Wirtschaftlichkeit von Investitionen wird mithilfe von Rechenoperationen und speziellen Formeln ermittelt. Für diese Berechnungen stellt Microsoft Excel unter dem Namen Finanzmathematik einen großen Vorrat an Formeln bereit. Damit können sowohl einfache Fälle als auch komplizierte Probleme berechnet werden. Die Vielfalt der Möglichkeiten und Formeln, die Excel zur Verfügung stellt, werden in diesem Buch nach Anwendungsbereichen strukturiert zusammengefasst und erläutert - für Excel 2003, 2007, 2010 und 2013. So können sie je nach Bedarf gezielt nachgeschlagen und angewendet werden....

2. 

Power Query for Power BI and Excel

Power Query for Power BI and Excel

By: Chris Webb

Publisher: Apress

Publication Date: 24-JUN-2014

Insert Date: 15-JUL-2014

Slots: 1.0

Table of Contents • Start Reading

"Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise, practical...

3. 

Microsoft Business Intelligence Tools for Excel Analysts

Microsoft Business Intelligence Tools for Excel Analysts

By: 

Publisher: For Dummies

Publication Date: 05-MAY-2014

Insert Date: 16-MAY-2014

Slots: 1.0

Table of Contents • Start Reading

Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, Microsoft Business Intelligence...

4. 

Excel Dashboards and Reports For Dummies, 2nd Edition

Excel Dashboards and Reports For Dummies, 2nd Edition

By: 

Publisher: For Dummies

Publication Date: 31-MAR-2014

Insert Date: 09-MAY-2014

Slots: 1.0

Table of Contents • Start Reading

Create dynamic dashboards and put your data on display with For Dummies No matter what business you're in, reports have become a staple of the workplace, but what good is a report if no reads it, or even worse, understands it? This all new edition of Excel Dashboards & Reports For Dummies is here to help you make meaning of all your data and turn it into clear and actionable visualizations. Fully updated for the latest business intelligence and spreadsheet tools in Excel 2013, this book shows you how to analyze large amounts of data, quickly slice data into various views on the fly,...

5. 

Microsoft Excel Programmierung - Das Handbuch (Buch + E-Book). Automatisierung mit VBA - Für Excel 2007 - 2013. Vollständig überarbeitet

Microsoft Excel Programmierung - Das Handbuch (Buch + E-Book). Automatisierung mit VBA - Für Excel 2007 - 2013. Vollständig überarbeitet

By: Mourad Louha; Monika Weber

Publisher: Microsoft Press Deutschland

Publication Date: 20-FEB-2014

Insert Date: 27-FEB-2014

Slots: 1.0

Table of Contents • Start Reading


6. 

Microsoft Excel VBA - Das Praxisbuch. Für Microsoft Excel 2007-2013.

Microsoft Excel VBA - Das Praxisbuch. Für Microsoft Excel 2007-2013.

By: Bernd Held; Sandra Seifert

Publisher: Microsoft Press Deutschland

Publication Date: 20-FEB-2014

Insert Date: 25-FEB-2014

Slots: 1.0

Table of Contents • Start Reading

Tipps und Tools für die VBA-Praxis. Für Programmierer mit Grundkenntnissen....

7. 

Microsoft Excel 2013 - Das Handbuch

Microsoft Excel 2013 - Das Handbuch

By: Frank Arendt-Theilen; Dietmar Gieringer; Hildegard Hügemann; ; Dieter Schiecke; Helmut Schuster

Publisher: Microsoft Press Deutschland

Publication Date: 11-DEC-2013

Insert Date: 13-DEC-2013

Slots: 1.0

Table of Contents • Start Reading

Sie möchten Ihre Aufgaben mit Excel in der Version 2013 schneller und besser erledigen? Beispielsweise mit den Erleichterungen bei der Datenvisualisierung, beim Berechnen ohne Formel oder bei PivotTables? In diesem Handbuch erfahren Sie umfassend und leicht verständlich, wie das geht. Anhand von Beispieldateien können Sie Schritt für Schritt alle wichtigen Arbeitstechniken sofort nachvollziehen. Hilfreiche Übersichten erleichtern Ihnen das Verständnis. Profitipps helfen Ihnen, Zeit zu sparen. Außerdem finden Sie alles, was Sie wissen wollen, schnell und gezielt über die vielfältigen...

8. 

PowerPivot for Advanced Reporting and Dashboards

PowerPivot for Advanced Reporting and Dashboards

By: Robert Bosco J

Publisher: Packt Publishing

Publication Date: 25-NOV-2013

Insert Date: 28-NOV-2013

Slots: 1.0

Table of Contents • Start Reading

Leverage the capabilities of the Microsoft Excel PowerPivot add-on to create advanced BI solutions Learn how to create advanced BI solutions quickly and efficiently using easy-to-follow, step-by-step examples Understand the key principles of PowerPivot with the help of real-time examples Discover more about some interesting DAX functions with examples of how they work In Detail Business intelligence technology gives an organization the power to make decisions using large volumes of data. By obtaining an adequate amount of data and integrating data from a variety of...

9. 

Decision Analytics: Microsoft® Excel®

Decision Analytics: Microsoft® Excel®

By: Conrad Carlberg

Publisher: Que

Publication Date: 05-NOV-2013

Insert Date: 02-NOV-2013

Slots: 1.0

Table of Contents • Start Reading

Crunch Big Data to optimize marketing and more!   Overwhelmed by all the Big Data now available to you? Not sure what questions to ask or how to ask them? Using Microsoft Excel and proven decision analytics techniques, you can distill all that data into manageable sets—and use them to optimize a wide variety of business and investment decisions. In Decision Analytics: Microsoft Excel, best selling statistics expert and consultant Conrad Carlberg will show you how—hands-on and step-by-step. Carlberg guides you through using decision analytics to segment customers (or anything else)...

10. 

Microsoft® Excel® 2013 for the Business Analyst

Microsoft® Excel® 2013 for the Business Analyst

By: Larry Rockoff

Publisher: Course Technology PTR

Publication Date: 17-OCT-2013

Insert Date: 30-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

As one of the most popular software tools in the world, Microsoft Excel is used by business analysts across the globe to keep track of details, look deeply into the data that drives business, and provide managers with the information and insights they need to keep their companies moving forward. MICROSOFT EXCEL 2013 FOR THE BUSINESS ANALYST is an introduction to Excel, written by a business analyst for business analysts. While providing a general overview of the features and functions of Excel, the book places special emphasis on helping users in the task of data analysis. The book...

11. 

Microsoft Excel Pivot-Tabellen - Das Praxisbuch. Für Version 2010 und 2013

Microsoft Excel Pivot-Tabellen - Das Praxisbuch. Für Version 2010 und 2013

By: Helmut Schuster

Publisher: Microsoft Press Deutschland

Publication Date: 17-OCT-2013

Insert Date: 18-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

Das Buch zeigt, wie Excel-Anwender mit Vorkenntnissen bei ihrer täglichen Arbeit von der Datenanalyse mit PivotTables profitieren können....

12. 

Excel 2013 All-in-One For Dummies

Excel 2013 All-in-One For Dummies

By: 

Publisher: For Dummies

Publication Date: 04-MAR-2013

Insert Date: 09-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

The comprehensive reference, now completely up-to-date for Excel 2013! As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel...

13. 

Excel VBA Programming For Dummies, 3rd Edition

Excel VBA Programming For Dummies, 3rd Edition

By: 

Publisher: For Dummies

Publication Date: 25-FEB-2013

Insert Date: 09-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

Take control of your spreadsheets and use VBA to create your own custom Excel applications Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more. Introduces you to a wide array of new Excel 2013 options, beginning with the...

14. 

Excel 2013 Bible

Excel 2013 Bible

By: 

Publisher: John Wiley & Sons

Publication Date: 04-MAR-2013

Insert Date: 09-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more. Whether you're an Excel...

15. 

Excel Formulas and Functions For Dummies, 3rd Edition

Excel Formulas and Functions For Dummies, 3rd Edition

By: 

Publisher: For Dummies

Publication Date: 25-FEB-2013

Insert Date: 09-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

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...

16. 

Excel 2013 For Dummies

Excel 2013 For Dummies

By: 

Publisher: For Dummies

Publication Date: 29-JAN-2013

Insert Date: 08-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

The bestselling Excel book - completely updated for Excel 2013! As the world's leading spreadsheet application, Excel has an enormous user base. The release of Office 2013 brings major changes to Excel, so Excel For Dummies comes to the rescue once more! Featuring the friendly For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Walks you through the exciting new features of Excel 2013 Presents everything you need to know to perform basic Excel 2013...

17. 

Excel 2013 Simplified

Excel 2013 Simplified

By: Paul McFedries

Publisher: Visual

Publication Date: 25-MAR-2013

Insert Date: 08-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

A friendly, visual approach to learning the basics of Excel 2013 As the world's leading spreadsheet program, Excel is a spreadsheet and data analysis tool that is part of the Microsoft Office suite. The new Excel 2013 includes new features and functionalities that require users of older versions to re-learn the application. However, whether you're switching from an earlier version or learning Excel for the first time, this easy-to-follow visual guide gets you going with Excel 2013 quickly and easily. Numbered steps as well as full-color screen shots, concise information, and helpful...

18. 

Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition

Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition

By: 

Publisher: John Wiley & Sons

Publication Date: 04-MAR-2013

Insert Date: 05-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

Take Excel to the next level in accounting and financial modeling In this new Second Edition of Next Generation Excel, Isaac Gottlieb shows financial analysts how to harness the full power of Excel to move forward into the new world of accounting and finance. Companies of all sizes use financial models to analyze their finances and plan business operations, as well as to create financial accounting reports like balance sheets, income statements, and statements of cash flows. While many businesspeople are quite familiar with the reports created with financial models, most are not as...

19. 

Microsoft Excel 2013: Data Analysis and Business Modeling

Microsoft Excel 2013: Data Analysis and Business Modeling

By: Wayne L. Winston

Publisher: Microsoft Press

Publication Date: 15-JAN-2014

Insert Date: 04-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook. Solve real business problems with Excel—and sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple...

20. 

Mastering Financial Modeling: A Professional’s Guide to Building Financial Models in Excel

Mastering Financial Modeling: A Professional’s Guide to Building Financial Models in Excel

By: Eric Soubeiga

Publisher: McGraw-Hill

Publication Date: 25-JUN-2013

Insert Date: 04-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

All the precision of financial modeling-and none of the complexityEvidence-based decision making is only as good as the external evidence on which it is based. Financial models uncover potential risks on a company’s balance sheet, but the complexity of these instruments has limited their effectiveness. ...