Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
Filter
Datasource
Material
Language
Years
Author, Corporation
Publisher
Keywords
  • 1
    Online Resource
    Online Resource
    Microsoft Excel 2019 pivot table data crunching (2019)
    [Place of publication not identified] : Published with the authorization of Microsoft Corporation by Pearson Education
    Details
    ISBN: 9781509308200 , 1509308202
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Microsoft Excel (Computer file) ; Business ; Computer programs ; Table manipulation (Computer science) ; Electronic books ; Electronic books ; local
    Abstract: Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 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 2019 and Excel 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. By reading this book, you will: • Master easy, powerful ways to create, customize, change, and control pivot tables • Control all future pivot tables using new pivot table defaults • Transform huge data sets into clear summary reports • Instantly highlight your most profitable customers, products, or regions • Use Power Query to quickly import, clean, shape, and analyze disparate data sources • Build geographical pivot tables with 3D Map • Construct and share state-of-the-art dynamic dashboards • Revamp analyses on the fly by dragging and dropping fields • Build dynamic self-service reporting systems • Share your pivot tables with colleagues • Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 • Automate pivot tables with macros and VBA • Save time by adapting reports with GetPivotData • Discover today's most useful pivot table tips and shortcuts
    Note: Description based on online resource; title from title page (Safari, viewed February 20, 2019)
    URL: https://learning.oreilly.com/library/view/-/9781509308200/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 2
    Online Resource
    Online Resource
    Microsoft Excel 2019 VBA and macros (2019)
    [Place of publication not identified] : Published with the authorization of Microsoft Corporation by Pearson Education
    Details
    ISBN: 9781509307203 , 1509307206
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Microsoft Excel (Computer file) ; Visual Basic for Applications (Computer program language) ; Macroprogramming ; Macro instructions (Electronic computers) ; Electronic books ; Electronic books ; local
    Abstract: Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets. Use this guide to automate virtually any routine Excel task: 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 Excel 2019 and Excel in Office 365. 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 will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate pivot tables to summarize, analyze, explore, and present data Use custom dialog boxes to collect data from others using Excel Improve the reliability and resiliency of your macros Integrate data from the internet, Access databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Create powerful solutions with classes, collections, and custom functions Solve sophisticated business analysis problems more rapidly 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
    Note: Includes index. - Description based on online resource; title from title page (Safari, viewed February 13, 2019)
    URL: https://learning.oreilly.com/library/view/-/9781509307203/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 3
    Online Resource
    Online Resource
    Microsoft Excel VBA and macros : (Office 2021 and Microsoft 365) (2022)
    [Place of publication not identified] : Pearson Education, Inc.
    Details
    Language: English
    Pages: 1 online resource (640 pages)
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Microsoft Visual Basic for applications ; Business Computer programs ; Electronic spreadsheets ; Microsoft Excel (Computer file) ; Microsoft Visual Basic for applications ; Tableurs ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books
    Abstract: 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 task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you wont 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. Youll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions.
    Note: Includes index
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 4
    Online Resource
    Online Resource
    Charts and graphs for Microsoft Office Excel 2007 (2007)
    Indianapolis, Ind. : Que
    Details
    ISBN: 0789736101 , 9780789736109
    Language: English
    Pages: 1 online resource
    Series Statement: Business solutions
    Parallel Title: Erscheint auch als
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Electronic spreadsheets ; Charts, diagrams, etc Computer programs ; Microsoft Excel (Computer file) ; Microsoft Excel (Computer file) ; Business ; Computer programs ; Electronic spreadsheets ; Charts, diagrams, etc ; Computer programs ; Business ; Computer programs ; Charts, diagrams, etc ; Computer programs ; Electronic spreadsheets ; Electronic books
    Note: Includes bibliographical references and index. - Print version record
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 5
    Online Resource
    Online Resource
    Microsoft Excel 2019 VBA und Makros (2019)
    [Erscheinungsort nicht ermittelbar] : dpunkt | Boston, MA : Safari
    Details
    Language: English , German
    Pages: 1 online resource (706 pages)
    Edition: 1st edition
    Keywords: Electronic books ; local
    Abstract: In diesem praktischen Leitfaden erfahren Sie, wie Sie mithilfe von VBA und Makros nahezu jede Excel-Routineaufgabe automatisieren und zuverlässigere und effizientere Excel-Arbeitsblätter erstellen, um in kürzerer Zeit mehr Aufgaben zu erledigen. Die renommierten Excel-Experten Bill Jelen (MrExcel) und Tracy Syrstad zeigen Ihnen nützliche Makrotechniken und helfen Ihnen dabei, automatisierte, leistungsfähige Berichte zu erstellen und Informationen sofort zu visualisieren, um schnell damit weiterarbeiten zu können. Erfassen und verwenden Sie Daten überall, egal ob am Desktop-Computer, am Tablet oder in der Cloud, und automatisieren Sie die besten neuen Features von Excel 2019 und Excel für Office 365.
    Note: Online resource; Title from title page (viewed July 8, 2019)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 6
    Online Resource
    Online Resource
    Microsoft Excel 2019 inside out (2018)
    [Place of publication not identified] : Pearson Education
    Details
    ISBN: 9781509306015 , 1509306013
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Computer programs ; Electronic books ; Electronic books ; local
    Abstract: Conquer Microsoft Excel 2019-from the inside out! Dive into Microsoft Excel 2019-and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds-all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today's key tasks-and challenge yourself to new levels of mastery. Enter formulas more efficiently, and fully control operators and dates Master the most widely-used functions in Excel Integrate external data from the web and other sources Easily transform complex datasets with Power Query Quickly summarize millions of records with Pivot Tables Perform ad hoc analyses with slicers and other filters Create advanced data mashups with Power Pivot Solve complex problems with What-If, Scenario Manager, Goal Seek, and Solver Automate repetitive tasks by editing recorded VBA code Demystify data with conditional formatting and other visualization techniques Use the newest maps, charts, and data types in Excel Show geographical changes over time with animated 3D maps Use dynamic array functions: SORT, FILTER, UNIQUE, SORTBY and SEQUENCE Find insights using Excel's new artificial intelligence Collaborate via Excel 2019's breakthrough CoAuthoring tools Publish Power BI Desktop dashboards based on Excel data
    Note: Includes index. - Description based on online resource; title from title page (viewed November 12, 2018)
    URL: https://learning.oreilly.com/library/view/-/9781509306015/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 7
    Online Resource
    Online Resource
    Excel® 2013 VBA and Macros (2013)
    [Erscheinungsort nicht ermittelbar] : Que | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (648 pages)
    Edition: 1st edition
    Keywords: Electronic books ; local
    Abstract: SAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS! Use Excel® 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! You’ll discover macro techniques you won’t find anywhere else and learn how to create automated reports that are amazingly powerful and useful. Bill Jelen and Tracy Syrstad show how to instantly visualize information, so you and your colleagues can understand and act on it…how to capture data from anywhere, and use it anywhere…how to automate Excel 2013’s most valuable new features. Mastering advanced Excel macros has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions–straight from MrExcel. • Get started fast with Excel 2013 macro development • Write macros that use Excel 2013 enhancements, including Timelines and the latest pivot table models • Work efficiently with ranges, cells, and R1C1-style formulas • Build super-fast applications with arrays • Write Excel 2013 VBA code that works on older versions of Excel • Create custom dialog boxes to collect information from your users • Use error handling to make your macros more resilient • Use web queries and new web service functions to integrate data from anywhere • Master advanced techniques such as classes, collections, and custom functions • Build sophisticated data mining and business analysis applications • Read and write to both Access and SQL Server databases • Control other Office programs–and even control Windows itself • Start writing Excel Apps similar to those in the Excel App Store About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will • Dramatically increase your productivity–saving you 50 hours a year or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make
    Note: Online resource; Title from title page (viewed February 4, 2013)
    URL: https://learning.oreilly.com/library/view/-/9780133259469/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 8
    Online Resource
    Online Resource
    Excel® 2013 In Depth (2013)
    [Erscheinungsort nicht ermittelbar] : Que | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1152 pages)
    Edition: 1st edition
    Keywords: Electronic books ; local
    Abstract: Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen (“Mr Excel”) brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won’t find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013’s full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration. Start by taking a quick “tour” of Excel 2013’s most valuable new features. Then, learn how to Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets Get more productive with Excel 2013’s new Start Screen and Timelines Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens Quickly apply attractive, consistent formats Master every function you’ll ever need,- including powerful new web services functions Solve real-world business intelligence analysis problems Create amazing PowerPivot data mashups that integrate information from anywhere Use Power View to generate stunningly intuitive maps, dashboards, and data visualizations Share workbooks on the Web and social networks Leverage the improved Excel Web App to create highly interactive web pages and online surveys Automate repetitive functions using Excel macros Supercharge your workbooks with new apps from the Excel App Store Like all In Depth books, Excel 2013 In Depth delivers complete coverage with detailed solutions, and troubleshooting help for tough problems you can’t fix on your own. Whatever you intend to do with Excel 2013, this is the only book you’ll need!
    Note: Online resource; Title from title page (viewed January 25, 2013)
    URL: https://learning.oreilly.com/library/view/-/9780133259322/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 9
    Online Resource
    Online Resource
    Safari Books Online webcast: Microsoft Excel 2010 in depth (2012)
    [Erscheinungsort nicht ermittelbar] : Safari Books Online
    Details
    Language: English
    Pages: 1 streaming video file (57 min., 34 sec.) , digital, sd., col.
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Electronic videos ; local
    Abstract: "Legendary Excel expert Bill Jelen provides solutions to the problems Excel users run into every day -- problems that are often ignored or oversimplified. Learn how to streamline your work with Excel 2010 and get more done in less time. Did you know that multiple users can actually edit a spreadsheet simultaneously using Excel Web App? Learn breakthrough techniques and exclusive shortcuts from the mastermind behind the leading Excel solutions website MrExcel.com. This 60-minute webcast is for everyone who wants to get the most out of Excel 2010, from casual users to corporate professionals. Jelen will cover many facets of working with Excel 2010 such as Slicer, which offers dynamic filtering of PivotTables; Sparklines, which adds data visualization to any cell; Calculation engine which improves the speed and accuracy of math, financial, and statistical functions; and the new version of Solver. Other topics include: - Updated Ribbon interface - Breakthrough collaboration - Improved business intelligence Take advantage of this opportunity to improve your Excel skills with Bill Jelen, aka Mr. Excel, an Excel MVP and the principal behind the leading Excel website, MrExcel.com."--Resource description page.
    Note: Title from resource description page (viewed Feb. 12, 2013). - Description based on print version record
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 10
    Online Resource
    Online Resource
    Pivot table data crunching : Microsoft Excel 2010 (2011)
    [Erscheinungsort nicht ermittelbar] : Que
    Details
    ISBN: 9780789746719 , 0789746719
    Language: English
    Pages: 1 online resource (viii, 496 p.) , ill.
    Series Statement: MyExcel library
    Keywords: Microsoft Excel (Computer file) ; Business ; Computer programs ; Electronic books ; local
    Abstract: PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels Includes proven PivotTable recipes for instant on-the-job results Helps Excel users avoid common pitfalls and mistakes Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen
    Note: Description based on resource description page
    URL: https://learning.oreilly.com/library/view/-/9780789746719/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...