Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this pract
Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed ligh
Teach Yourself VISUALLY™
Are you a visual learner? Do you prefer instructions that show you how to do something and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 150 Excel 2010 tasks. Each task-based spread covers a single technique, sure to help you get up and running on
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. T
Teach Yourself VISUALLY™
Are you a visual learner? Do you prefer instructions that show you how to do something and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle nearly 160 Excel 2016 tasks. Each task-based spread covers a single technique, sure to help you get up and running on Exc
Chapter 1: The Excel 2010 User Experience 7
Chapter 2: Creating a Spreadsheet from Scratch 33
Chapter 3: Editing a Spreadsheet 85
Chapter 4: Formatting a Spreadsheet 115
Chapter 5: Printing a Spreadsheet 169
Chapter 6: Top Ten Features in Excel 2010 197
Index 201
Mr. Spreadsheet's formula for Excel success
It's been estimated that only 10 percent of Excel users really understand how to get the most from worksheet formulas. If you're ready to join that elite group and start using Excel to its full potential, John Walkenbach is here to show you how.
This in-depth examination of Excel formulas covers worksheet functions, named cells and ranges, and formulas for looking up values and financia
Maximize your Excel 2013 experience using VBA application development
The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application
Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel.
Jared Decker is the co-founder of StatSlice Systems and a certified BI developer with more than 14 years’ experience training and developing enterprise reporting solutions.
Bernard Wehbe a is a veteran BI consultant and co-founder of
Aus: Controller-Magazin – Alfred Biel – 03/2022
[…] Das Buch bietet einen bemerkenswerten Ansatz, quantitative Methoden des Risikomanagements vertiefend zu vermitteln. […]
Aus: rezensionen – Bernd W. Müller-Hedrich – 04.01.2022
[…] Darüber hinaus kann das Buch allen Studierenden und Praktikern, welche eine anwendungsorientierte Einführung in das quantitative Finanzrisikomanagement, etwa in den
Follow Mr. Spreadsheet's formula for Excel success
Experts estimate that barely 10 percent of Excel users understand how to make the most of worksheet formulas. If you already know your way around Excel basics, "Mr. Spreadsheet" John Walkenbach can help you master formulas to gain greater Excel functionality.
First, he shows you exactly what a formula is, how to create one, and what formulas can do. Then you'll learn about using
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. T
As the world's leading spreadsheet application, Excel has a huge user base. The release of Office 2010 brings major changes to Excel, so Excel For Dummies comes to the rescue once more!
In the friendly and non-threatening For Dummies style, this popular guide shows beginners how to get up and running with Excel and helps more experienced users get
Einleitung 17
Über dieses Buch 18
Törichte Annahmen über die Leser 18
Icons in diesem Buch 19
Die Beispieldateien zu diesem Buch 19
Wie es weitergeht 20
Teil I: Heiliges Makro, Batman! 23
Kapitel 1 Makrogrundlagen 25
Warum sollten Sie Makros verwenden? 25
Grundlagen der Makroaufzeichnung 26
Das Makro untersuchen 28
Das Makro testen 29
Das Makro bearbeiten 29
Abs
Für die Analyse größerer Datenmengen in Excel sind Pivot-Tabellen ein besonders leistungsfähiges Werkzeug. Das Buch zeigt, wie Excel-Anwender*innen mit Vorkenntnissen bei ihrer täglichen Arbeit von P
Part I: Understanding Formula Basics
Chapter 1: The Excel User Interface in a Nutshell 3
The Workings of Workbooks 3
Worksheets 4
Chart sheets 5
Macro sheets and dialog sheets 5
The Excel User Interface 5
The Ribbon 6
Backstage View 7
Shortcut menus and the mini
Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this pract
Harness the power of VBA and create custom Excel applications
Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and muc
Why do you need another book on Excel? Because this one is devoted to PivotTables and PivotCharts, Excel's powerful tools that enable you to pull meaningful information from masses of seemingly meaningless data—information you can actually use.
If you're new to PivotTables, this book is for you. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTabl
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
John Walkenbach, principal of J-Walk and Associates, Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books and 300 articles and reviews for publications including PC World, InfoWorld, and Windows.
If Excel can do it, John Walkenbach can show you how
What better way to learn Excel 2010 than from "Mr. Spreadsheet" himself? Excel guru, Microsoft MVP, and author of all
Aus: Controller-Magazin – Alfred Biel – 03/2022
[…] Das Buch bietet einen bemerkenswerten Ansatz, quantitative Methoden des Risikomanagements vertiefend zu vermitteln. […]
Aus: rezensionen – Bernd W. Müller-Hedrich – 04.01.2022
[…] Darüber hinaus kann das Buch allen Studierenden und Praktikern, welche eine anwendungsorientierte Einführung in das quantitative Finanzrisikomanagement, etwa in den
John Walkenbach, arguably the foremost authority on Excel, has written 50+ books, including the bestselling Excel Bible, Excel Formulas, and Excel Power Programming with VBA, as well as more than 300 articles for publications such as PC World, InfoWorld, and Windows. He created the award-winning Power Utility Pak, and provides Excel information and insight at www.spreadsheetpage.com.
Excel is the standard for spreadsheet applications and is used worldwide, but it's not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more.
Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet coll
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 us