- Table View
- List View
Excel Tipps und Tricks für Dummies (Für Dummies)
by Rainer W. SchwabeErfahren Sie, wie Sie mit Excel noch schneller, besser und effizienter arbeiten! Zeigen Sie im Excel-Alltag richtiges Fachwissen. Verwenden Sie gelungene Mixturen aus raffinierten Formeln und Funktionen. Holen Sie zum Beispiel mehr aus WENN-Funktionen heraus, ohne dass es ein ABER gibt. Nutzen Sie im Programm Verborgenes. Dieses Buch zeigt Ihnen neben vielen Tipps, Tricks und Tastenkombinationen auch Top-Secrets für den direkten Einsatz, die nicht jeder kennt und im Geheimen schlummern.
Excel Tipps und Tricks für Dummies (Für Dummies)
by Rainer W. SchwabeSie arbeiten bereits mit Excel und interessieren sich dafür, wie Sie Ihre Arbeitsabläufe schneller und effizienter gestalten können oder welche Möglichkeiten Ihnen Excel außerdem bietet? Rainer Schwabe erklärt Ihnen, wie Sie zum Beispiel die Benutzeroberfläche nach Ihren Wünschen gestalten, wie Sie Tastenkürzel erstellen, welche Entwicklertools besonders nützlich sind und mit welchen Tricks das alles noch viel schneller funktioniert.
Excel Tipps und Tricks für Dummies (Für Dummies)
by Rainer W. SchwabeErfahren Sie, wie Sie mit Excel noch schneller, besser und effizienter arbeiten! Zeigen Sie im Excel-Alltag richtiges Fachwissen. Verwenden Sie gelungene Mixturen aus raffinierten Formeln und Funktionen. Holen Sie zum Beispiel mehr aus WENN-Funktionen heraus, ohne dass es ein ABER gibt. Nutzen Sie im Programm Verborgenes. Dieses Buch zeigt Ihnen neben vielen Tipps, Tricks und Tastenkombinationen auch Top-Secrets für den direkten Einsatz, die nicht jeder kennt und im Geheimen schlummern.
Excel Tipps und Tricks für Dummies (Für Dummies)
by Rainer W. SchwabePraktische Kniffe und Lösungen für alle Excel-Anwender in Alltag und Beruf Erfahren Sie in der 5. Auflage des Bestsellers, wie Sie mit Excel versionsübergreifend noch schneller, besser und effizienter arbeiten! Zeigen Sie Fachwissen im Excel-Alltag, indem Sie gelungene Kombinationen aus Formeln und Funktionen meistern. Holen Sie zum Beispiel mehr aus WENN-Funktionen heraus – ganz ohne ABER, dafür mit großem AHA-Effekt! Oder entdecken Sie verborgene Funktionen in Excel. Dieses Buch bietet Ihnen neben vielen Tipps, Tricks und Tastenkombinationen auch clevere und praxistaugliche Lösungen für den direkten Einsatz in Alltag und Beruf. Sie erfahren Wie Sie mit Excel rechnen, Daten erfassen und auswerten Wie Sie Funktionen und Formeln kombinieren Welche Tastenkombinationen hilfreich sind Wie Sie rechtzeitig Fehler vermeiden
Excel VBA
by Tom UrtisIncrease your productivity and save time and effort with Excel VBA This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate your routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons while the accompanying DVD provides demos to complement each lesson. Urtis takes an in-depth look at how manual tasks in Excel can be programmed with VBA for greater speed, efficiency, and accuracy. You'll learn how to use VBA to manipulate Excel in ways you may never have thought possible. Excel VBA 24-Hour Trainer: Introduces you to VBA and discusses topics including object oriented programming, variable declaration, objects and collections, and arrays Teaches you how to write your own macros for programming loops, events, charts, pivot tables and pivot charts, and user-defined functions Shows you how to customize the look and feel of Excel with User Forms, Input Boxes, Message Boxes, and embedded controls Examines advanced topics including class modules, add-ins, and retrieving external data with ADO and SQL Demonstrates how to interact with other Office Applications from Excel, including Word, Access®, PowerPoint®, and Outlook® Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved. Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox. com using a link provided in the interior of the e-book.
Excel VBA 24-Hour Trainer
by Tom UrtisMaster VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios. This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice. Program Excel's newest chart and pivot table object models Manipulate the user interface to customize the look and feel of a project Utilize message boxes, input boxes, and loops to yield customized logical results Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel If you're ready to get more out of this incredibly functional program, Excel VBA 24-Hour Trainer, 2nd Edition provides the expert instruction and fast, hands-on learning you need.
Excel VBA In Easy Steps: Covers Visual Studio Community 2017
by Mike McGrathExcel VBA in easy steps neatly demonstrates VBA (Visual Basic for Applications) Macro programming in a clear and concise manner, so you can get more from the popular Microsoft Excel spreadsheet application. <p><p> Whether you’re upgrading to Excel 2019, exploring Excel in the Office 365 suite, or new to the Macro programming concept, use this guide to learn the key features constructively and get more out of Microsoft Excel – in easy steps!
Excel VBA Programming For Dummies
by Dick KusleikaFind out what Excel is capable of with this step-by-step guide to VBA Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software. Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to: Understand the basic tools and operations of Visual Basic for Applications Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets Deal with errors and exceptions and eliminate the bugs in your code Perfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language.
Excel VBA Programming For Dummies
by John WalkenbachHaving Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50" flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more. This guide is not for rank Excel amateurs. It's for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you're an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes: An introduction to the VBA language A hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing it The essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorder The essential VBA language elements, including comments, variables and constants, and labels Working with Range objects and discovering useful Range objective properties and methods Using VBA and worksheet functions, including a list and examples Programming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loop Automatic procedures and Workbook events, including a table and event-handler procedures Error-handling and bug extermination techniques, and using the Excel debugging tools Creating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricks Customizing the Excel toolbars Using VBA code to modify the Excel menu system Creating worksheet functions and working with various types of arguments Creating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilities Author John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there's no substitute for hands-on learning. The book is complete with: A dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changes Information to help you make the most of Excel's built-in Help system so you can find out other stuff you may need to know What are you waiting for? Sure, learning to do VBA programming takes a little effort, but it's a Very Big Accomplishment.
Excel VBA Programming For Dummies
by John Walkenbach Michael AlexanderTo take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. <p><p> Inside, you’ll find an overview of the essential elements and concepts for programming with Excel. In no time, you’ll discover techniques for handling errors and exterminating bugs, working with range objects and controlling program flow, and much more. With friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, readers will be creating Excel applications custom fit to their unique needs!
Excel VBA: A Step-By-Step Comprehensive Guide on Excel VBA Programming Tips and Tricks for Effective Strategies
by Peter BradleyIf you want to take Excel to the next level, and improve your knowledge in VBA, you should learn how to implement the tools and functions that VBA offers in your work. If your aim is to improve and automate processes using Excel VBA, you have come to the right place. Over the course of the book, you will gather information on a wide array of tools and Excel options. The book will take you through some facts about Excel VBA and will also leave you with some tips that you can use to improve the processing speed of VBA. This book is packed with some friendly advice on the easiest methods that you can use to develop sub procedures, and the many ways in which you can call them. If you have some knowledge about Excel VBA, and want to improve your skills in programming with VBA then this book is for you.
Excel VBA: A Step-By-Step Guide to Learn and Master Excel VBA Programming
by Hein SmithWhether you have never created a program with Visual Basic Application or looking to learn some new tricks, then this book is for you! Containing 15 chapters full of information, definitions, and step-by-step instructions to create your own programs, this book will help you master VBA Programming. Here are just a few of the things you will find inside: Chapters on Conditional Logic, String Functions, and Recording Macros Images illustrating the different processes and programming steps Step-by-step instructions for how to program Loops and Arrays 2 chapters on creating and programming User Forms Instructions on how to write Subs and Functions Written out sample codes for many of the programs you will learn how to create How to diagnose and correct your own coding errors A step-by-step process on how to connect the Visual Basic Editor with external dataVisual Basic Application Programming in Excel is a hidden gem that will help you automate and control both basic and complex Excel functions. Following the steps in this book will help you access the inner workings of Excel spreadsheets and take your coding to the next level!
Excel Workbook For Dummies
by Greg Harvey Paul McFedriesGet practical walkthroughs for the most useful Excel features Looking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you've been waiting for. This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you'll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program. Work through the book from start to finish or, if you'd prefer, jump right to the section that's giving you trouble, whether that's data visualization, macros, analysis, or anything else. You can also: Brush up on and practice time-saving keyboard shortcuts for popular commands and actions Get a handle on multi-functional and practical pivot tables with intuitive practice exercises Learn to secure your data with spreadsheet password protections Perfect for new users of Excel, Excel Workbook For Dummies is also the ideal resource for those who know their way around a spreadsheet but need a refresher on some of the more advanced features of this powerful program.
Excel for Starters: The Missing Manual
by Matthew MacdonaldFor PC users who need a quick way to get up to speed on Microsoft Excel, our smart new Missing Manual demystifies spreadsheets and explains how to create them painlessly. The book focuses on the program's most common and useful features, guiding readers through them with clear explanations, step-by-step instructions, lots of illustrations, and friendly, time-saving advice. Like its siblings in the Missing Manual series, the book crackles with a fine sense of humour and refreshing objectivity about its subject. It's a perfect primer for readers who want to organize household and office information with Excel, and small businesses with no techie to turn to.
Excel für technische Berufe: Beispiele, Tipps und Tricks aus der Praxis
by Harald NahrstedtEs werden alle Methoden in Excel beschrieben, die keiner Programmierung bedürfen. Anhand von Praxisbeispielen aus vielen Bereichen der Technik z. B. Elektronik oder technische Chemie wird der effektive Einsatz der Methoden unter Excel beschrieben. Dieses Arbeitsbuch ist eine Ergänzung zum bestehenden Buch Excel + VBA desselben Autors.
Excel-VBA für Dummies (Für Dummies)
by Michael Alexander Dick KusleikaUm noch mehr aus Excel herauszuholen, sind Kenntnisse der VBA-Programmierung von groà em Vorteil: Dann können Sie Excel auf Ihre Bedürfnisse zuschneiden und langweilige Routinearbeiten automatisieren. Dieses Buch zeigt Ihnen zunächst den Umgang mit dem VBA-Editor und gibt einen Einblick in die wichtigsten Programmiertechniken, wie Sie Fehler beseitigen, Range-Objekte einsetzen und den Programmfluss steuern. Lernen Sie dann die vielfältigen Programmiermöglichkeiten kennen. Alle Beispielprogramme und Arbeitsblätter stehen zum Download zur Verfügung. Sie werden staunen: Mit VBA können Sie sich selbst Dialogboxen, Werkzeugleisten und Menüs schneidern. Und das schon nach kurzer Zeit!
Excel-VBA für Dummies (Für Dummies)
by John WalkenbachUm noch mehr aus Excel herauszuholen, sind Kenntnisse der VBA-Programmierung von großem Vorteil: Dann können Sie Excel auf Ihre Bedürfnisse zuschneiden und langweilige Routinearbeiten automatisieren. Dieses Buch zeigt Ihnen zunächst den Umgang mit dem VBA-Editor und gibt einen Einblick in die wichtigsten Programmiertechniken, wie Fehler beseitigen, Range-Objekte einsetzen und den Programmfluss steuern. Lernen Sie dann die vielfältigen Programmiermöglichkeiten kennen. Alle Beispielprogramme und Arbeitsblätter stehen zum Download zur Verfügung. Sie werden staunen: Mit VBA können Sie sich selbst Dialogboxen, Werkzeugleisten und Menüs schneidern. Und das schon nach kurzer Zeit!
Excel-VBA: From Solving Mathematical Puzzles to Analysing Complex Engineering Problems (Springerbriefs In Applied Sciences And Technology Ser.)
by Tariq Muneer Stoyanka IvanovaThis compact text is a powerful introduction to the Excel/VBA computing environment. The book presents some of the most useful features of Excel. First by introducing mathematical puzzles that will grab the reader’s attention with the reader invited to think hard on solving those puzzles. Then, solutions are presented in a logical manner. The book goes on to describe modern and up-to-date engineering problems and their solutions. Based on many years of the authors’ teaching, the book provides a practical, useful and enjoyable learning methods for readers to become expert in Excel and its application to engineering.
Excel: The Missing Manual
by Matthew MacdonaldWhether you are an Excel neophyte, a sophisticate who knows the program inside out, or an intermediate-level plodder, Excel: The Missing Manual will be sure to become your go-to resource for all things Excel. Covering Excel 2002 and 2003, the book is an indispensable guide to one of the most popular and complicated programs. It has all you need to help you excel at Excel.
Excellence in It: Achieving Success in an Information Technology Career
by Warren C. ZabloudilExcellence in IT reminds you that IT is an all or nothing career with too many people depending on you for the job to not be done well at all times. Everyone working in IT should rise to the occasion and seek to deliver the highest quality workmanship possible. The book covers all those things that keep IT professionals awake at night and offers advice on how to work around stress, work easier and faster, deal with problematic personalities, keep up with the never-ending chase for new knowledge, and, ultimately, how to stay competitive in your career for a long, long time. Excellence in IT provides answers to virtually everything a computer career involves and outlines how to rise to the top of your field while looking after your personal happiness too. It's not just another bone dry technical guide, but an easily readable book that explains what you're going through every day on the job and how to make your career work better for you.
Excel© 2007 VBA Programmer's Reference
by John GreenThis book is aimed squarely at Excel users who want to harness the power of the VBA language in their Excel applications. At all times, the VBA language is presented in the context of Excel, not just as a general application programming language. The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help. The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency--that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats. The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).
Excel® 2007: Top 100 Simplified® Tips & Tricks
by Denise EtheridgeYou already know Excel 2007. Now you'd like to go beyond with shortcuts, tricks, and tips that let you work smarter and faster. And because you learn more easily when someone shows you how, this is the book for you. Inside, you'll find clear, illustrated instructions for 100 tasks that reveal cool secrets, teach timesaving tricks, and explain great tips guaranteedto make you more productive with Excel 2007. * Minimal text and maximum illustrations * Task-oriented, step-by-step approach * Navigational aids connect instructions to illustrations * Self-contained, two-page lessons * Uniform layout makes it easy to read less, learn more How easy is it? Look for these symbols marking the difficulty of each task. * Demonstrates a new spin on a common task * Introduces a new skill or a new task * Combines multiple skills requiring in-depth knowledge * Requires extensive skill and may involve other technologies
Exchange Server 2010 Administration
by Joel Stidley Erik GustafsonA soup-to-nuts guide for messaging administratorsExchange Server is the world's leading e-mail server software. Windows 7 and Server 2008 R2 have made changes that messaging administrators need to know and understand in their daily work with Exchange Server. This Sybex guide focuses on the skills, concepts, technologies, and potential pitfalls that admins in the trenches need to understand. It also provides the information they need to earn MCITP certification.Updates in Exchange Server, the world's leading e-mail server software, require messaging administrators to update their knowledge in order to provide the best possible e-mail solutions Highly focused and comprehensive, this guide teaches you to design a highly available e-mail messaging server, install and configure Exchange Server 2010, work with recipients, groups and mailboxes, configure public folders, secure Exchange, and more CD includesvideo walkthroughs of more difficult tasks, practice exams, and electronic flashcards. Exchange Server 2010 Administration offers real-world knowledge that messaging admins need every day and helps prepare candidates for the MCITP certification exam.CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.
Exchange Server Cookbook
by Paul Robichaux Devin Ganger Missy KosloskyAsk network administrators what their most critical computer application is, and most will say "email" without a moment's hesitation. If you run a network powered by Windows 2000 or Windows Server 2003, Microsoft Exchange occupies much of your time. According to Microsoft, 110 million Exchange seats have been deployed, but 60% of you are still running Exchange 5.5. That's a problem, because the difference between version 5.5 and the more efficient Exchange 2000 and Exchange Server 2003 is profound. Don't fret. Exchange Server Cookbook offers you a comprehensive how-to guide to these newer versions of Exchange. You'll find quick solutions for the most common tasks you need to perform--everything from installation and maintenance to configuration and optimization, with proven recipes for the most useful tools and utilities. The book also has solutions to some uncommon tasks (that you may not know are possible) and advanced procedures that aren't part of day-to-day operations. These include tasks for critical situations, such as using a recovery storage group. Our reliable desktop reference even shows you how to write scripts for Exchange management and deployment tasks. That's right. While not every Exchange job can be scripted, many can, and we provide lots of working VBScript examples for accomplishing particular goals. Whatever your particular need, you'll find it quickly, because chapters in this Cookbook are laid out by recipe, with cross references to other pertinent solutions in the book. With this guide, you'll learn: The relationship between Exchange and Active Directory When to use the GUI, the command line, or scripting How to prepare forests, domains, and servers How to use Group Policy to control Exchange Diagnostic logging, measure performance, and administrative privileges Recipient management: user accounts, mailboxes, mail-enabled groups Mailbox and public folder database management Message routing and transport functions Security, backup, restore, and recovery operations For every question you have about Exchange 2000 or Exchange Server 2003, our Cookbook has the answer--one that you can find and implement without a moment's hesitation.
Exchange Server Cookbook
by Paul Robichaux Missy Koslosky Devin L. GangerAsk network administrators what their most critical computer application is, and most will say "email" without a moment's hesitation. If you run a network powered by Windows 2000 or Windows Server 2003, Microsoft Exchange occupies much of your time. According to Microsoft, 110 million Exchange seats have been deployed, but 60% of you are still running Exchange 5.5. That's a problem, because the difference between version 5.5 and the more efficient Exchange 2000 and Exchange Server 2003 is profound. Don't fret. Exchange Server Cookbook offers you a comprehensive how-to guide to these newer versions of Exchange. You'll find quick solutions for the most common tasks you need to perform--everything from installation and maintenance to configuration and optimization, with proven recipes for the most useful tools and utilities. The book also has solutions to some uncommon tasks (that you may not know are possible) and advanced procedures that aren't part of day-to-day operations. These include tasks for critical situations, such as using a recovery storage group. Our reliable desktop reference even shows you how to write scripts for Exchange management and deployment tasks. That's right. While not every Exchange job can be scripted, many can, and we provide lots of working VBScript examples for accomplishing particular goals. Whatever your particular need, you'll find it quickly, because chapters in this Cookbook are laid out by recipe, with cross references to other pertinent solutions in the book. With this guide, you'll learn: The relationship between Exchange and Active Directory When to use the GUI, the command line, or scripting How to prepare forests, domains, and servers How to use Group Policy to control Exchange Diagnostic logging, measure performance, and administrative privileges Recipient management: user accounts, mailboxes, mail-enabled groups Mailbox and public folder database management Message routing and transport functions Security, backup, restore, and recovery operations For every question you have about Exchange 2000 or Exchange Server 2003, our Cookbook has the answer--one that you can find and implement without a moment's hesitation.