- Table View
- List View
Excel Programming with VBA Starter
by Robert MartinThis is a starter guide, covering the basics you need to get up and running as quickly as possible. This book is written for users of Excel who want to speed up and streamline normally arduous tasks for maximum productivity.
Excel Sales Forecasting For Dummies
by Conrad CarlbergWhen they first told you that forecasting sales would be part of your job, did you feel just the tiniest bit of panic? Did you momentarily consider consulting the Yellow Pages for listings of "Psychics" or "Tea Leaf Readers"? Well, fear not. Excel Sales Forecasting For Dummies can help you predict the future without incense or a crystal ball. Excel Sales Forecasting For Dummies shows you how to use the number one workbook program, Microsoft Excel, to predict trends and future sales based on something not quite so ethereal-numbers. You use data about the past to forecast the future. Excel provides all sorts of tools to help you do that, and this book shows you how to use them. From recognizing why forecasting is a good idea to making sense of exponential smoothing, Excel Sales Forecasting For Dummies has you covered. If you have a basic grasp of how to use Excel, you'll be ready to discover how to Select and use the right forecasting method for your business Choose and arrange data in lists, then manage that data with pivot tables Filter lists and turn them into charts that illustrate what's going on Find relationships in your data Use Excel's Analysis Toolpak feature to create forecasts automatically, or venture into advanced forecasts using worksheet functions Gain more control over your forecasting and target specific types of predictions Use moving averages and predict seasonal sales Written by Conrad Carlberg, a nationally recognized expert on Excel who also has experience in sales and marketing, this friendly guide gets you up and running quickly and easily. You'll soon be setting up a baseline you can chart and label, summarizing data with pivot tables, making forecasts based on regression, understanding correlation, and discovering how smoothing lets us profit from our mistakes. You'll find your confidence in your ability to make sales predictions has soared right off the chart.
Excel Scientific and Engineering Cookbook
by David M BourgGiven the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: Use Excel and VBA in general Import data from a variety of sources Analyze data Perform calculations Visualize the results for interpretation and presentation Use Excel to solve specific science and engineering problems Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.
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 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: 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: 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 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 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 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 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 Michael Alexander John WalkenbachTo 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 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 Workbook For Dummies
by Paul McFedries Greg HarveyGet 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.
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.
The Excellent Online Instructor
by Keith Pratt Rena M. PalloffThe hiring, training, and evaluation of good online instructors are high priorities for online institutions, and increasingly, all colleges and universities. This book shows what it takes to develop a new instructor in order to promote excellent online teaching, describes the qualities of a good online instructor, and reveals how to evaluate online teaching. In addition, it includes illustrative models of faculty training for online teaching based on adult learning principles and best practices in faculty training and identifies how technology can be used to facilitate and enhance the training process. The Excellent Online Instructor is perfect for faculty developers, instructional designers, program directors, and other administrators tasked with developing new instructors or training experienced faculty for the online environment.
The Exception to the Rulers: Exposing Oily Politicians, War Profiteers, and the Media that Love Them
by Amy Goodman David GoodmanHost of Pacifica Radio's Democracy Now! Analyzes world events.
Exchange Server 2010 Administration
by Erik Gustafson Joel StidleyA 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 Devin Ganger Missy Koslosky Paul RobichauxAsk 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 Devin L. 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.
The Executive Guide to Artificial Intelligence
by Andrew BurgessThis book takes a pragmatic and hype-free approach to explaining artificial intelligence and how it can be utilised by businesses today. At the core of the book is a framework, developed by the author, which describes in non-technical language the eight core capabilities of Artificial Intelligence (AI). Each of these capabilities, ranging from image recognition, through natural language processing, to prediction, is explained using real-life examples and how they can be applied in a business environment. It will include interviews with executives who have successfully implemented AI as well as CEOs from AI vendors and consultancies. AI is one of the most talked about technologies in business today. It has the ability to deliver step-change benefits to organisations and enables forward-thinking CEOs to rethink their business models or create completely new businesses. But most of the real value of AI is hidden behind marketing hyperbole, confusing terminology, inflated expectations and dire warnings of 'robot overlords'. Any business executive that wants to know how to exploit AI in their business today is left confused and frustrated. As an advisor in Artificial Intelligence, Andrew Burgess regularly comes face-to-face with business executives who are struggling to cut through the hype that surrounds AI. The knowledge and experience he has gained in advising them, as well as working as a strategic advisor to AI vendors and consultancies, has provided him with the skills to help business executives understand what AI is and how they can exploit its many benefits. Through the distilled knowledge included in this book business leaders will be able to take full advantage of this most disruptive of technologies and create substantial competitive advantage for their companies.