Bill Jelen Bücher

Mit realen Fallbeispielen aus dem Arbeitsalltag und über 50 Übungsdateien, einschließlich Makros und Bonusbeispielen, bietet dieses praktische Handbuch eine einfache Schritt-für-Schritt-Anleitung zur Automatisierung von Excel-Routineaufgaben mit VBA und Makros. Die renommierten Excel-Experten Bill Jelen und Tracy Syrstad vermitteln nützliche Makrotechniken, um automatisierte, leistungsfähige Berichte zu erstellen und Informationen sofort zu visualisieren. Sie lernen, Daten am Desktop, Tablet oder in der Cloud zu erfassen und die neuesten Funktionen von Excel 2019 und Office 365 zu automatisieren. Das Buch umfasst praxisbezogene Erklärungen, die keine Programmierkenntnisse erfordern, sowie leicht anpassbare Lösungen. Themen sind unter anderem die Entwicklung praktischer Excel-Makros, die effiziente Arbeit mit Bereichen, Zellen und Formeln, die Anpassung automatisierter Berichte, die Automatisierung von PivotTables zur Datenanalyse und -präsentation, die Verwendung benutzerdefinierter Dialogfelder und die Verbesserung der Zuverlässigkeit Ihrer Makros. Zudem wird gezeigt, wie man Daten aus dem Internet und Access-Datenbanken integriert, automatisch Diagramme und Visualisierungen erstellt sowie leistungsstarke Lösungen mit Klassen und benutzerdefinierten Funktionen entwickelt, um komplexe Aufgaben in der Business-Analyse schneller zu lösen.

These are the 125 essential tips that all Excel users need to know. MrExcel LX provides users with a concise book that can be absorbed in under two hours. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.

Learn how to use Excel pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power--including valuable improvements in Excel and in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical recipes for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else.

Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query. Updated annually, this edition for 2021 adds information on LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.

This book shows students how to make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help students instantly visualize information, so they can act on it... capture data from anywhere, and use it anywhere... automate Excel 2019's best new features. Students will find simple, step-by-step instructions, real-world case studies, and workbooks packed with bonus examples, macros, and solutions--straight from MrExcel!

Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever. Use this guide to automate virtually any routine Excel save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Microsoft Excel. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you About This Book • For everyone who wants to get more done with Microsoft Excel in less time • For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data

Provides instructions on using Excel 2013's revamped charting and graphing tools to communicate more clearly, powerfully, and quickly.

Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables, and much more.

A practical, realistic, easy-to-understand guide to Excel's most powerful and underutilized features: PivotTables and PivotCharts. Even for students who have never created a pivot table before, this book will help them leverage all their amazing flexibility and analytical power. Drawing on more than 40 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical "recipes" for solving real business problems, help learners avoid common mistakes, and present tips and tricks found nowhere else.

Provides comprehensive coverage on the spreadsheet software, including detailed solutions to everyday problems, real-world examples, troubleshooting help, and in-depth explanations of new features.