Your email was sent successfully. Check your inbox.

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

Proceed reservation?

Export
  • 1
    Online Resource
    Online Resource
    Excel 2016 VBA and macros (2016)
    Indianapolis, Indiana : Que
    Details
    ISBN: 9780134386027 , 0134386027
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: MrExcel library
    Keywords: Microsoft Excel (Computer file) ; Visual Basic for Applications (Computer program language) ; Macroprogramming ; Macro instructions (Electronic computers) ; Electronic books ; Electronic books ; local
    Abstract: This is the Rough Cut version of the printed book. SAVE TIME AND SUPERCHARGE EXCEL 2016 WITH VBA AND MACROS! Use Excel 2016 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 2016'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 2016 macro development Write macros that use Excel 2016 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 2016 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: Includes index. - Description based on online resource; title from title page (Safari, viewed November 23, 2015)
    URL: https://learning.oreilly.com/library/view/-/9780134386027/?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
    My Excel 2016 (2016)
    Indianapolis, Indiana : Que
    Details
    ISBN: 9780134217192 , 0134217195
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Parallel Title: Erscheint auch als
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Computer programs ; Electronic books ; Electronic books ; local
    Abstract: My Excel 2016 is your must-have companion for getting most out of Excel 2016. This friendly, quick, full-color, 100% practical tutorial walks you through every task you'll want to do with Excel 2016. Get productive fast with Excel 2016's updated interface Save time and make your data easier to work with Efficiently enter, insert, move, and manage data Use templates to reuse work and get a jumpstart on new projects Format worksheets and charts to make them clearer and more useful Use intuitive sparkline charts that fit in a single cell Build custom formulas using powerful built-in functions Sort, filter, and consolidate data and eliminate duplication Instantly group data and generate subtotals Quickly summarize huge data sets with PivotTables Find, fix, and avoid errors that break spreadsheets or cause inaccuracies Communicate more powerfully using visual tools such as SmartArt and WordArt Precisely control what you print and how it looks Securely share and distribute your workbooks Use Excel on the Web wherever you have Internet access Every task is presented step-by-step, using carefully annotated, colorful screenshots, all numbered so there's no chance of getting lost or confused. Everything's clearly organized in modular, self-contained chapters designed to help you get started quickly. Throughout, the book is packed with helpful tips, lists, and quick solutions to the problems you're most likely to encounter.
    Note: Includes index. - Description based on print version record
    URL: https://learning.oreilly.com/library/view/-/9780134217192/?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
    VBA and macros for Microsoft Office Excel 2007 (2007)
    Indianapolis, Ind. : Que | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780789736826 , 0789736829
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Microsoft Visual Basic for applications ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books ; local
    Abstract: "In this day and age of 'too much information and not enough time,' the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of." -Jerry Kohl, president of Brighton Collectibles Develop your Excel macro programming skills using VBA instantly with proven techniques Automate Reports Handle Errors Master Pivot Tables Produce Charts Build User-Defined Functions Migrate to Excel 2007 Query Web Data Build Dialog Boxes Use Data Visualizations Automate Word You are an expert in Excel, but the macro recorder doesn't work and you can't make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you. Learn VBA syntax as easy-to-understand English Automate Excel's power tools: Pivot Tables, Charts, Advanced Filters Save hours per week by automating redundant tasks Create applications built on top of Excel with custom dialog boxes Automatically produce hundreds of Excel reports in seconds Understand how changes in Excel 2007 impact your VBA macros Introduction 1 1 Unleash the Power of Excel with VBA 7 2 This Sounds Like BASIC, So Why Doesn't It Look Familiar? 29 3 Referring to Ranges 61 4 User-Defined Functions 75 5 Looping and Flow Control 101 6 R1C1-Style Formulas 121 7 What's New in Excel 2007 and What's Changed 135 8 Create and Manipulate Names in VBA 143 9 Event Programming 155 10 UserForms--An Introduction 177 11 Creating Charts 197 12 Data Mining with Advanced Filter 249 13 Using VBA to Create Pivot Tables 281 14 Excel Power 337 15 Data Visualizations and Conditional Fo...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780789736826/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 4
    Online Resource
    Online Resource
    Using Microsoft Excel 2010 (2010)
    [Erscheinungsort nicht ermittelbar] : Que
    Details
    ISBN: 9780132378093
    Language: English
    Pages: 1 streaming video file (1 hr., 52 min., 1 sec.) , digital, sd., col.
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Electronic videos ; local
    Abstract: Using Microsoft Excel 2010 brings you over 45 media elements detailing everything from getting familiar with the Excel interface and accessing the Excel Web App to using SmartArt and creating macros. Watching this media is the fastest way to get comfortable with the newest version of Microsoft Excel. Topics covered include signing up for a Windows Live ID, converting formulas to values, using Format Painter, using conditional formatting, using Goal Seek to return a value, using the AutoSum feature, using the Quick Sort buttons, using the search function to filter for specific dates, linking SmartArt to cells, recording a macro using relative referencing, and much, much more!
    Note: Title, presenters, and release information from resource description page (viewed Oct. 18, 2010)
    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 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.
  • 6
    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.
  • 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
    VBA and macros : Microsoft Excel 2010 (2010)
    [Erscheinungsort nicht ermittelbar] : Que Pub.
    Details
    ISBN: 9780789744142 , 0789744147
    Language: English
    Pages: 1 online resource , ill.
    Parallel Title: Erscheint auch als
    Keywords: Microsoft Visual Basic for applications ; Microsoft Excel (Computer file) ; Programming languages (Computers) ; Electronic books ; local
    Abstract: AUTOMATE REPORTS BUILD FUNCTIONS VISUALIZE DATA WRITE FAST, RELIABLE SCRIPTS Microsoft Excel 2010 VBA AND MACROS: SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS! Use Excel 2010 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! This book reveals scripting techniques you won't find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010's most powerful new features. Learning advanced Excel scripting 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. • Work efficiently with ranges, cells, and R1C1-style formulas • Build super-fast applications with arrays • Customize the Excel 2010 Ribbon to run your macros • Write Excel 2010 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 VBA scripts more resilient • Use Web queries to import data from virtually any online source • Master advanced techniques such as classes and collections • Use Excel VBA to control other Office programs...even control Windows itself, via the Windows API • Create add-ins to share or sell your programs 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: Description based on print version record
    URL: https://learning.oreilly.com/library/view/-/9780789744142/?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
    Using Microsoft Excel 2010 (2011)
    Indianapolis, Ind. : Que Pub.
    Details
    ISBN: 9780132182287 , 0132182289
    Language: English
    Pages: 1 online resource (xviii, 302 p.) , ill.
    Parallel Title: Erscheint auch als
    Keywords: Microsoft Excel (Computer file) ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books ; lcgft ; Electronic books ; local
    Abstract: Get comfortable with the latest versions of Microsoft Excel, Microsoft Excel Starter, and the Excel Web App. Don't just read about it: see it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the Free Web Edition that comes with every USING book. For the price of the book, you get online access anywhere with a web connection-no books to carry, updated content, and the benefit of video and audio learning. Way more than just a book, this is all the help you'll ever need...where you want, when you want! learn fast, learn easy, using web, video, and audio Show Me video walks through tasks you've just got to see-including bonus advanced techniques Tell Me More audio delivers practical insights straight from the experts UNLOCK THE FREE WEB EDITION-To register your USING book, visit quepublishing.com/using.
    Note: Includes bibliographical references and index. - Description based on print version record
    URL: https://learning.oreilly.com/library/view/-/9780132182287/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 10
    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.
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...