Free Trial

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

Help

Microsoft Excel


21. 

MOS 2013 Study Guide for Microsoft Excel

MOS 2013 Study Guide for Microsoft Excel

By: 

Publisher: Microsoft Press

Publication Date: 03-SEP-2013

Insert Date: 27-JUL-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 Microsoft Office Specialist (MOS) exam, 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 Use the in-depth exam prep, practice, and review to help advance your proficiency with Microsoft Office—and earn the credential that proves it!...

22. 

Excel 2013 Formulas

Excel 2013 Formulas

By: 

Publisher: John Wiley & Sons

Publication Date: 01-APR-2013

Insert Date: 19-JUL-2013

Slots: 1.0

Table of Contents • Start Reading

Maximize the power of Excel 2013 formulas with this must-have Excel reference John Walkenbach, known as "Mr. Spreadsheet," is a master at deciphering complex technical topics and Excel formulas are no exception. This fully updated book delivers more than 800 pages of Excel 2013 tips, tricks, and techniques for creating formulas that calculate, developing custom worksheet functions with VBA, debugging formulas, and much more. Demonstrates how to use all the latest features in Excel 2013 Shows how to create financial formulas and tap into the power of array formulas Serves as a...

23. 

Statistical Analysis with Excel For Dummies, 3rd Edition

Statistical Analysis with Excel For Dummies, 3rd Edition

By: 

Publisher: For Dummies

Publication Date: 01-APR-2013

Insert Date: 16-JUL-2013

Slots: 1.0

Table of Contents • Start Reading

Take the mystery out of statistical terms and put Excel to work! If you need to create and interpret statistics in business or classroom settings, this easy-to-use guide is just what you need. It shows you how to use Excel's powerful tools for statistical analysis, even if you've never taken a course in statistics. Learn the meaning of terms like mean and median, margin of error, standard deviation, and permutations, and discover how to interpret the statistics of everyday life. You'll learn to use Excel formulas, charts, PivotTables, and other tools to make sense of everything from...

24. 

Balanced Scorecards and Operational Dashboards with Microsoft Excel, 2nd Edition

Balanced Scorecards and Operational Dashboards with Microsoft Excel, 2nd Edition

By: 

Publisher: John Wiley & Sons

Publication Date: 14-JAN-2013

Insert Date: 09-JUL-2013

Slots: 1.0

Table of Contents • Start Reading

Learn to maintain and update scorecards and dashboards with Excel Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time-proven step-by-step processes on how to guide executive teams and managers in creating scorecards and dashboards. It then shows Excel developers how to create those scorecards and dashboards. This is the only book that converts theory into practice. The author addresses the people and processes you need to identify strategy and...

25. 

Excel Dashboards and Reports, 2nd Edition

Excel Dashboards and Reports, 2nd Edition

By: 

Publisher: John Wiley & Sons

Publication Date: 20-MAY-2013

Insert Date: 20-JUN-2013

Slots: 1.0

Table of Contents • Start Reading

Learn to use Excel dashboards and reports to better conceptualize data Updated for all the latest features and capabilities of Excel 2013, this go-to resource provides you with in-depth coverage of the individual functions and tools that can be used to create compelling Excel reports. Veteran author Michael Alexander walks you through the most effective ways to present and report data. Featuring a comprehensive review of a wide array of technical and analytical concepts, this essential guide helps you go from reporting data with simple tables full of dull numbers to presenting key...

26. 

Excel et VBA: Développez des macros compatibles avec toutes les versions d'Excel (97 à 2010)

Excel et VBA: Développez des macros compatibles avec toutes les versions d'Excel (97 à 2010)

By: Mikaël Bidault

Publisher: Pearson France

Publication Date: 18-MAR-2013

Insert Date: 12-JUN-2013

Slots: 1.0

Table of Contents • Start Reading

Vous souhaitez automatiser vos manipulations sous Excel pour éviter d'avoir à refaire toujours les mêmes tâches ? De la simple macro enregistrée à la conception de programmes plus élaborés, cet ouvrage vous explique comment améliorer votre productivité ! Prenant en compte l'évolution d’Office, il vous aidera à développer des macros compatibles avec toutes les versions d’Excel. Vous découvrirez en détail les multiples outils de Visual Basic Editor et apprendrez à déboguer vos programmes et à gérer les erreurs. Vous saurez personnaliser l’environnement d’Excel à l’aide de programmes...

27. 

My Excel® 2013

My Excel® 2013

By: Michael Alexander

Publisher: Que

Publication Date: 09-MAY-2013

Insert Date: 03-MAY-2013

Slots: 1.0

Table of Contents • Start Reading

Full-color, step-by-step tasks walk you through everything you want to do with Excel 2013. Step-by-step instructions with callouts to Excel 2013 screenshots that show you exactly what to do. Help when you run into Excel 2013 problems or limitations. Tips and Notes to help you get the most from Excel 2013. • Quickly find and use the Excel 2013 features you’re looking for • Create, save, and organize your spreadsheets • Build custom formulas using Excel’s powerful built-in functions • Master time-saving techniques to find, replace, move, filter, and sort data • Find, fix, and...

28. 

Instant Creating Data Models with PowerPivot How-to

Instant Creating Data Models with PowerPivot How-to

By: Leo Taehyung Lee;

Publisher: Packt Publishing

Publication Date: 25-APR-2013

Insert Date: 30-APR-2013

Slots: 1.0

Table of Contents • Start Reading

Build better business intelligence with this practical guide to creating Excel data models with PowerPivot Learn something new in an Instant! A short, fast, focused guide delivering immediate results Detailed, step-by-step interactive tutorial guide to learning PowerPivot Carefully organized topics for users of all levels Learn how to make your data accessible and attractive In Detail Microsoft PowerPivot is a free software designed to enhance Microsoft Excel. It allows the user to make extensive use of his/her computer’s powers to draw data from various sources, do...

29. 

Dieses Maxibuch bietet Ihnen alle Excel-Funktionen von Version 2007 bis 2013 mit einer ausführlichen Beschreibung und praktischen Beispielen....

30. 

Excel 2013: The Missing Manual

Excel 2013: The Missing Manual

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 25-APR-2013

Insert Date: 19-APR-2013

Slots: 1.0

Table of Contents • Start Reading

The world’s most popular spreadsheet program is now more powerful than ever, but it’s also more complex. That’s where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data....

31. 

Microsoft® Excel® 2013 Plain & Simple

Microsoft® Excel® 2013 Plain & Simple

By: 

Publisher: Microsoft Press

Publication Date: 23-APR-2013

Insert Date: 13-APR-2013

Slots: 1.0

Table of Contents • Start Reading

With this full color, no-nonsense guide, you'll learn the quickest ways to solve a problem or learn a skill with Microsoft Excel. Easy-to-follow steps and concise, straightforward language make learning plain and simple!...

32. 

La gestion sous Excel et VBA

La gestion sous Excel et VBA

By: Chelali Herbadji

Publisher: Eyrolles

Publication Date: 15-MAY-2012

Insert Date: 10-APR-2013

Slots: 1.0

Table of Contents • Start Reading

PrésentationLes clés pour gérer une entreprise avec Excel et VBACet ouvrage propose une approche pratique des techniques quantitatives de gestion sous Excel et avec le langage de programmation Visual Basic pour Applications (ou VBA), qui permet de créer des macros dans Excel.Il met à la disposition du lecteur :des outils pour gérer l'entreprise : facturation, amortissements, impôts sur les sociétés, affectation du résultat, valorisation des stocks, gestion des coûts, bilan, rentabilité des investissements, etc. ;de nombreux exemples et exercices d'application ;un CD-rom d'accompagnement :...

33. 

Excel® 2013 On Demand

Excel® 2013 On Demand

By: Steve Johnson, Perspection Inc.

Publisher: Que

Publication Date: 22-FEB-2013

Insert Date: 09-APR-2013

Slots: 1.0

Table of Contents • Start Reading

Excel 2013 On Demand is built from the ground up for today's beginning-to-intermediate-level Exceluser. Like every book in the On Demand Series, it teaches visually, using an easy, friendly, full-color format designed to "show you how," instead of "telling you how." But that's not all. This book: * Combines step-by-step training with quick-reference material users can rely on long after they've mastered the core skills they need * Provides easy-to-follow task-based coverage of the techniques you'll use most often, presenting most tasks in just one or two pages * Offers in-depth...

34. 

Excel® 2013 Absolute Beginner’s Guide

Excel® 2013 Absolute Beginner’s Guide

By: Tracy Syrstad

Publisher: Que

Publication Date: 21-MAR-2013

Insert Date: 15-MAR-2013

Slots: 1.0

Table of Contents • Start Reading

Make the most of Excel 2013–without becoming a technical expert! This book is the fastest way to master Excel…use it to build powerful, trustworthy, easy-to-understand workbooks…discover hidden patterns and make better decisions…visualize data so everyone understands it…share and present workbooks on the web, tablets, anywhere! Even if you’ve never used Excel before, you’ll learn how to do what you want, one incredibly clear and easy step at a time. Excel has never, ever been this simple! Who knew how simple Excel 2013 could be? This is the easiest, most practical beginner’s guide to...

35. 

Microsoft Excel 2013 auf einen Blick

Microsoft Excel 2013 auf einen Blick

By: Michael Kolberg

Publisher: Microsoft Press Deutschland

Publication Date: 05-MAR-2013

Insert Date: 06-MAR-2013

Slots: 1.0

Table of Contents • Start Reading

Bild für Bild erklärt Ihnen dieses vollständig farbige Buch, wie Sie typische Aufgaben mit Excel 2013 erledigen. Dabei wird jede Aufgabe - wie die Beherrschung der neuen touch-optimierten Oberfläche, die Eingabe von Daten, die Verwendung von Formeln oder die neuen FlashFill-Funktionen - auf maximal einer Doppelseite dargestellt. Mit nummerierten Schritten und in verständlicher Sprache. So macht Lernen Spaß!...

36. 

Excel® 2013 Formulas and Functions

Excel® 2013 Formulas and Functions

By: Paul McFedries

Publisher: Que

Publication Date: 14-FEB-2013

Insert Date: 24-FEB-2013

Slots: 1.0

Table of Contents • Start Reading

Master core Excel 2013 tools for building powerful, reliable spreadsheets! Excel expert Paul McFedries shows how to use Excel 2013’s core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from FlashFill to Excel’s newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation. Becoming an Excel expert has never been easier! You’ll find crystal-clear...

37. 

Excel® 2013 Charts and Graphs

Excel® 2013 Charts and Graphs

By: Bill Jelen

Publisher: Que

Publication Date: 14-FEB-2013

Insert Date: 24-FEB-2013

Slots: 1.0

Table of Contents • Start Reading

Use Excel 2013’s radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly… so you drive your message home, and get the decisions and actions you’re looking for! This book reveals data visualization techniques you won’t find anywhere else and shows you how to use Excel 2013 to create designer-quality charts and graphs that stand out from the crowd. It will help you make the most of new features ranging from Power View to Recommended Charts, and instantly share your insights with anyone, anywhere–even on the Web and social networks. Learning...

38. 

Microsoft® Excel® 2013 Inside Out

Microsoft® Excel® 2013 Inside Out

By: ;

Publisher: Microsoft Press

Publication Date: 26-APR-2013

Insert Date: 15-FEB-2013

Slots: 1.0

Table of Contents • Start Reading

This supremely organized reference packs the in-depth insights needed to advance your Excel expertise—including hundreds of timesaving solutions, troubleshooting tips, and workarounds....

39. 

Microsoft Excel 2013: Building Data Models with PowerPivot

Microsoft Excel 2013: Building Data Models with PowerPivot

By: ;

Publisher: Microsoft Press

Publication Date: 26-MAR-2013

Insert Date: 08-FEB-2013

Slots: 1.0

Table of Contents • Start Reading

Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling....

40. 

Excel et VBA: Développez des macros compatibles avec toutes les versions d'Excel (97 à 2010)

Excel et VBA: Développez des macros compatibles avec toutes les versions d'Excel (97 à 2010)

By: Mikaël Bidault

Publisher: Pearson France

Publication Date: 08-JUN-2012

Insert Date: 02-FEB-2013

Slots: 1.0

Table of Contents • Start Reading

Vous souhaitez automatiser vos manipulations sous Excel pour éviter d'avoir à refaire toujours les mêmes tâches ? De la simple macro enregistrée à la conception de programmes plus élaborés, cet ouvrage vous explique comment améliorer votre productivité ! Prenant en compte l'évolution d’Office, il vous aidera à développer des macros compatibles avec toutes les versions d’Excel. Vous découvrirez en détail les multiples outils de Visual Basic Editor et apprendrez à déboguer vos programmes et à gérer les erreurs. Vous saurez personnaliser l’environnement d’Excel à l’aide de programmes...