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® Expert

MOS 2013 Study Guide for Microsoft® Excel® Expert

By: Mark Dodge

Publisher: Microsoft Press

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

23. 

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

24. 

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

25. 

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

26. 

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

27. 

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

28. 

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

29. 

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

30. 

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

31. 

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

32. 

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

33. 

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

34. 

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

35. 

Microsoft Excel 2013 Plain & Simple

Microsoft Excel 2013 Plain & Simple

By: Curtis D. Frye

Publisher: Microsoft Press

Publication Date: 15-APR-2013

Insert Date: 13-APR-2013

Slots: 1.0

Table of Contents • Start Reading

Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before. Here’s WHAT You’ll Learn Manage your data quickly and efficiently Filter, sort, summarize, and crunch your numbers Use formulas and functions to do the heavy lifting Bring data to life with charts and graphics Share data between Microsoft Office documents Work as a...

36. 

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

37. 

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

38. 

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

39. 

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

40. 

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