Free Trial

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

Help

Microsoft Excel


1. 

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


2. 

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

3. 

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

4. 

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

5. 

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

6. 

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

7. 

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

8. 

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

9. 

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

10. 

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

11. 

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

12. 

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

13. 

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

14. 

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

15. 

Microsoft Excel 2013: Data Analysis and Business Modeling

Microsoft Excel 2013: Data Analysis and Business Modeling

By: 

Publisher: Microsoft Press

Publication Date: 09-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....

16. 

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

17. 

MOS 2013 Study Guide for Microsoft Excel Expert

MOS 2013 Study Guide for Microsoft Excel Expert

By: 

Publisher: Microsoft Press

Publication Date: 26-SEP-2013

Insert Date: 19-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for the 2013 Excel Expert Microsoft Office Specialist (MOS) exams, this all-in-one study guide features: Full, objective-by-objective exam coverage Easy-to-follow procedures and illustrations to review essential skills Hands-on practice tasks to apply what you’ve learned; files included Online pre-test to assess your readiness Use the in-depth exam prep, practice, and review to help advance your proficiency with Microsoft Office—and earn the credential that proves it!...

18. 

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition

By: 

Publisher: Visual

Publication Date: 29-JUL-2013

Insert Date: 04-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

Professional-level coverage and techniques for Excel power users Aimed at Excel power users who appreciate logical, clean explanations of techniques, this visual guide features numerous screenshots and easy-to-follow numbered steps in order to show you how to perform professional-level modeling, charting, data sharing, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more. Demonstrates how to crunch and analyze Excel data the way...

19. 

101 Excel 2013 Tips, Tricks and Timesavers

101 Excel 2013 Tips, Tricks and Timesavers

By: 

Publisher: John Wiley & Sons

Publication Date: 01-JUL-2013

Insert Date: 04-AUG-2013

Slots: 1.0

Table of Contents • Start Reading

Get the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more, 101 Excel 2013 Tips, Tricks, & Timesavers will save you time and help you avoid...

20. 

Visual Intelligence: Microsoft Tools and Techniques for Visualizing Data

Visual Intelligence: Microsoft Tools and Techniques for Visualizing Data

By: 

Publisher: John Wiley & Sons

Publication Date: 29-APR-2013

Insert Date: 27-JUL-2013

Slots: 1.0

Table of Contents • Start Reading

Go beyond design concepts and learn to build state-of-the-art visualizations The visualization experts at Microsoft's Pragmatic Works have created a full-color, step-by-step guide to building specific types of visualizations. The book thoroughly covers the Microsoft toolset for data analysis and visualization, including Excel, and explores best practices for choosing a data visualization design, selecting tools from the Microsoft stack, and building a dynamic data visualization from start to finish. You'll examine different types of visualizations, their strengths and weaknesses, and...