...• Searchable PDF of the book • Understand functions, charts, worksheets, and workbooks System Requirements: See the CD Appendix in the book for details and complete system requirements. • Master “what-if” analysis, Goal Seeking, external database files, and pivot tables • Develop custom functions, program with VBA, and create UserForms • Try new slice-and-dice tools to dynamically filter your data Preview how your copied text will look www.wiley.com/compbooks Spot trends in your data with Sparklines John Walkenbach aka “Mr. Spreadsheet” is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at spreadsheetpage.com. ® • All the examples and workbook files used in the book Microsoft® Follow the examples in the book, chapter by chapter, using the bonus materials on the CD-ROM: Excel 2010 What’s on the CD-ROM? • Get up to speed on everything new in Excel 2010 • Perform magic with array formulas—and even more with Sparklines CD-ROM Included John Walkenbach If Excel can do it, John Walkenbach can show you how What better way to learn Excel 2010 than from “Mr. Spreadsheet” himself? Excel guru, Microsoft MVP, and author...
Words: 167105 - Pages: 669
...How to go to your page This eBook includes two bonus chapters, which are paginated separately from the rest of the book. The pagination of the bonus chapters consists of the identifer “BC” followed by the page number. For example, to go to page 5 of the bonus chapters, type BC5 in the “page #” box at the top of the screen and click “Go.” To go to page 15, type BC15… and so forth. Get More and Do More at Dummies.com ® Start with FREE Cheat Sheets Cheat Sheets include • Checklists • Charts • Common Instructions • And Other Good Stuff! To access the Cheat Sheet created specifically for this book, go to www.dummies.com/cheatsheet/excelvbaprogramming Get Smart at Dummies.com Dummies.com makes your life easier with 1,000s of answers on everything from removing wallpaper to using the latest version of Windows. Check out our • Videos • Illustrated Articles • Step-by-Step Instructions Plus, each month you can win valuable prizes by entering our Dummies.com sweepstakes. * Want a weekly dose of Dummies? Sign up for Newsletters on • Digital Photography • Microsoft Windows & Office • Personal Finance & Investing • Health & Wellness • Computing, iPods & Cell Phones • eBay • Internet • Food, Home & Garden Find out “HOW” at Dummies.com *Sweepstakes not currently available in all countries; visit Dummies.com for official rules. Excel VBA Programming ® FOR DUMmIES 2ND ‰ EDITION by John Walkenbach Excel® VBA Programming For Dummies®, 2nd Edition Published...
Words: 98776 - Pages: 396
...unit that can perform substantial computation, including numerous arithmetic operations or logic operations, without human intervention during a run. * It is an electronic device/machine that accepts data (raw facts & figures) as input and processes (works on it) to produce information (data converted to meaningful form) as output. The computer is made up of hardware, software and peripheral devices. Hardware- refers to the tangible, physical and mechanical components of a computer. Software- refers to the intangible computer components, which are the programs or instructions of the computer. Everything that a computer does, it acts under instructions written out as computer programs. The hardware needs these instructions to function Computer program: * A set of instructions, written in a specific programming language, which a computer follows in processing data, performing an operation, or solving a logical problem. See also software. * A computer program is a set of statements or instructions to be used directly or indirectly in a computer in order to bring about a certain result. NB: Software alone is useless, so is the hardware. The two are inseparable. Peripheral Devices- These are devices that are external (not part of the computer) but can be connected to a computer. They are not essential for the functioning of the computer but can be connected to the computer for specific reasons. Examples are scanners, modems,...
Words: 59334 - Pages: 238
...Microsoft® Office Access 2007 ™ ALL-IN-ONE DESK REFERENCE FOR DUMmIES ‰ by Alan Simpson, Margaret Levine Young, Alison Barrows, April Wells, Jim McCarter Microsoft® Office Access 2007 ™ ALL-IN-ONE DESK REFERENCE FOR DUMmIES ‰ Microsoft® Office Access 2007 ™ ALL-IN-ONE DESK REFERENCE FOR DUMmIES ‰ by Alan Simpson, Margaret Levine Young, Alison Barrows, April Wells, Jim McCarter Microsoft® Office Access™ 2007 All-in-One Desk Reference For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2007 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4355, or online at http://www...
Words: 190131 - Pages: 761
...Chapter 1 Structure and Functions of a Computer "Hardware: the parts of a computer that can be kicked." ~ Jeff Pesis After completing this chapter, you will be able to: 1. Explain the importance of computer literacy. 2. Define the term computer. 3. Identify the components of a computer. 4. Compare the uses of various types of: input devices, output devices, and storage devices. 5. Describe categories of computers and their uses. Structure and Functions of a Computer 1 1.0 Introduction A computer is an electronic machine designed for the storage and processing of data. The machinery is called hardware, and this highly sophisticated equipment needs equally sophisticated programs (called software) to become a working computer system. Modern society has come to depend very heavily on the use of computer systems. Banks, businesses, government departments, industries, shops, people at home and school all rely on computer to play a vital role in their daily activities. These activities are centered on information. In business, the computer system has been used a lot and replaced filing cabinets as means of storing information, and clerical workers as a means of processing it. By storing and processing information on a computer system, these businesses can function more quickly and efficiently, because information can be found and collated much faster. Discovery Learning: A computer was also called a data processor. Why? 1.1 Major Parts and Functions A Computer is an electronic...
Words: 47755 - Pages: 192
...Overview of Applications by Discipline ECONOMICS Estimating sensitivity of demand to price 352–356 Pricing problems 352–366, 422–427 Estimating cost of power 363–366 47–56, Assessing a utility function 554–556 Estimating demand for products 632–638, 649–650, 764–771, 965 Subway token hoarding 792 FINANCE AND ACCOUNTING Collecting on delinquent credit accounts 14–16 Cost projections 29–33 Finding a breakeven point 33–41 Calculating NPV 57–62 Calculating NPV for production capacity decision 58–62 Portfolio management 173–178, 345–346, 387–394, 442–444, 689–691 Pension fund management 178–182 Financial planning 210–214, 676–681, 734–735 Arbitrage opportunities in oil pricing 215–219 Currency trading 220 Capital budgeting 290–295 Estimating stock betas 396–401 Hedging risk with put options 407–408 Stock hedging 407–408 Asset management 409–410 New product development 503–504, 574, 673–676, 715–722 Bidding for a government contract 513–518, 523–533, 653–657 Investing with risk aversion 557–560 Land purchasing decision 575 Risk analysis 582–583 Liquidity risk management 651–653 Estimating warranty costs 657–661 Retirement planning 681–685 Modeling stock prices 685–686 Pricing options 686–689, 691–693 Investing for college 732 Bond investment 733 HUMAN RESOURCES AND HEALTH CARE Fighting HIV/AIDS 23–24 DEA in the hospital industry 184–189 Salesforce allocation problems 454–456 Assigning MBA students to teams 462 Selecting...
Words: 68271 - Pages: 274
...INFORMATION TECHNOLOGY FOUNDATION 1 Compiled By: RONKY F. DOH (aka: ronky biggy diggy daddy igp) FU DAME TALS OF COMPUTERS We are living in an information age dependent upon digital information. Digital information is electronic information, the result of computer processing. Every type of job relies upon getting information, using it, managing it, and relaying information to others. Computers enable the efficient processing and storage of information. Do not think of a computer merely as the machine with the keyboard and the mouse, although that might be true for some types of computers. Embedded computers may be inside your household appliances, the video cassette recorder, the automobile, planes, trains, power plants, water purification plants, calculators, and even inside a few toys. These embedded computers are very small. They affect our lives each day. Why, even modern traffic lights operate with computers. They are all around us. Think of additional ways in which computers affect our lives each day. Every organization somehow use(s) a computer to run the organization. Some of the places are hospitals, schools, fire department, banks, stores or supermarkets, stock exchange, police department, insurance companies, transport companies, and government agencies etc. What is a computer? A computer is many things to many people, depending on what it is being used for. At one time the computer can be a machine which processes the payroll, then it can be a machine which tabulates...
Words: 67033 - Pages: 269
...McGraw-Hill Create™ Review Copy for Instructor Espinoza. Not for distribution. Course BBE 4505 Omar Espinoza University Of Minnesota NATURAL RESOURCES McGraw-Hill Create™ Review Copy for Instructor Espinoza. Not for distribution. http://create.mcgraw-hill.com Copyright 2012 by The McGraw-Hill Companies, Inc. All rights reserved. Printed in the United States of America. Except as permitted under the United States Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without prior written permission of the publisher. This McGraw-Hill Create text may include materials submitted to McGraw-Hill for publication by the instructor of this course. The instructor is solely responsible for the editorial content of such materials. Instructors retain copyright of these additional materials. ISBN-10: 1121789048 ISBN-13: 9781121789043 McGraw-Hill Create™ Review Copy for Instructor Espinoza. Not for distribution. Contents 1. Preface 1 2. Methods, Standards, and Work Design: Introduction 7 Problem-Solving Tools 27 3. Tex 29 4. Operation Analysis 79 5. Manual Work Design 133 6. Workplace, Equipment, and Tool Design 185 7. Work Environment Design 239 8. Design of Cognitive Work 281 9. Workplace and Systems Safety 327 10. Proposed Method Implementation 379 11. Time Study 413 12. Performance Rating and Allowances 447 13. Standard Data and Formulas 485 14. Predetermined Time Systems 507...
Words: 294686 - Pages: 1179
...Operations Management for MBAs Operations Management for MBAs Fifth Edition Jack R. Meredith Scott M. Shafer Wake Forest University VICE PRESIDENT & EXECUTIVE PUBLISHER EXECUTIVE EDITOR PROJECT EDITOR ASSOCIATE DIRECTOR OF MARKETING MARKETING MANAGER MARKETING ASSISTANT PRODUCT DESIGNER MEDIA SPECIALIST SENIOR CONTENT MANAGER SENIOR PRODUCTION EDITOR PHOTO DEPARTMENT MANAGER DESIGN DIRECTOR COVER DESIGNER PRODUCTION MANAGEMENT George Hoffman Lisé Johnson Brian Baker Amy Scholz Kelly Simmons Marissa Carroll Allison Morris Ethan Bernard Lucille Buonocore Anna Melhorn Hillary Newman Harry Nolan Wendy Lai Ingrao Associates This book was set in 10/12 ITC Garamond light by MPS Limited and printed and bound by RRD/Jefferson City. The cover was printed by RRD/Jefferson City. This book is printed on acid free paper. Copyright © 2013, 2010, 2007, 2002, 1999 John Wiley & Sons, Inc. All rights reserved. No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc. 222 Rosewood Drive, Danvers, MA 01923, website www.copyright.com. Requests to the Publisher for permission should be addressed to...
Words: 67515 - Pages: 271
...CORE CONCEPTS OF Accounting Information Systems Twelfth Edition Mark G. Simkin, Ph.D. Professor Department of Accounting and Information Systems University of Nevada Jacob M. Rose, Ph.D. Professor Department of Accounting and Finance University of New Hampshire Carolyn Strand Norman, Ph.D., CPA Professor Department of Accounting Virginia Commonwealth University JOHN WILEY & SONS, INC. VICE PRESIDENT & PUBLISHER SENIOR ACQUISITIONS EDITOR PROJECT EDITOR ASSOCIATE EDITOR SENIOR EDITORIAL ASSISTANT PRODUCTION MANAGER PRODUCTION EDITOR MARKETING MANAGER CREATIVE DIRECTOR SENIOR DESIGNER PRODUCTION MANAGEMENT SERVICES SENIOR ILLUSTRATION EDITOR PHOTO EDITOR MEDIA EDITOR COVER PHOTO George Hoffman Michael McDonald Brian Kamins Sarah Vernon Jacqueline Kepping Dorothy Sinclair Erin Bascom Karolina Zarychta Harry Nolan Wendy Lai Laserwords Maine Anna Melhorn Elle Wagner Greg Chaput Maciej Frolow/Brand X/Getty Images, Inc. This book was set in 10/12pt Garamond by Laserwords Private Limited, and printed and bound by RR Donnelley/Jefferson City. The cover was printed by RR Donnelley/Jefferson City. This book is printed on acid free paper. Founded in 1807, John Wiley & Sons, Inc. has been a valued source of knowledge and understanding for more than 200 years, helping people around the world meet their needs and fulfill their aspirations. Our company is built on a foundation of principles that include responsibility to the...
Words: 241803 - Pages: 968
...regarded sources. Reprinted material is quoted with permission, and sources are indicated. A wide variety of references are listed. Reasonable efforts have been made to publish reliable data and information, but the author and the publisher cannot assume responsibility for the validity of all materials or for the consequences of their use. Neither this book nor any part may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, microfilming, and recording, or by any information storage or retrieval system, without prior permission in writing from the publisher. The consent of CRC Press LLC does not extend to copying for general distribution, for promotion, for creating new works, or for resale. Specific permission must be obtained in writing from CRC Press LLC for such copying. Direct all inquiries to CRC Press LLC, 2000 N.W. Corporate Blvd., Boca Raton, Florida 33431. Trademark Notice: Product or corporate names may be trademarks or registered trademarks, and are used only for identification and explanation, without intent to infringe. Visit the Auerbach Publications Web site at www.auerbach-publications.com Copyright © 2001 by CRC Press LLC Auerbach is an imprint of CRC Press LLC No claim to original U.S. Government works International Standard Book Number 0-8493-1076-8 Library of Congress Card Number 2001022227...
Words: 145509 - Pages: 583
...Course Technology’s Management Information Systems Instructor and Student Resources Introduction to IS/MIS Principles of Information Systems, Eighth Edition • Stair, Reynolds Fundamentals of Information Systems, Fourth Edition • Stair, Reynolds Management Information Systems, Sixth Edition • Oz Information Technology in Theory • Aksoy, DeNardis Office Applications in Business Problem-Solving Cases in Microsoft Access & Excel, Sixth Annual Edition • Brady, Monk Succeeding in Business Applications with Microsoft Office 2007 • Bast, Gross, Akaiwa, Flynn, et.al Succeeding in Business with Microsoft Office Excel 2007 • Gross, Akaiwa, Nordquist Succeeding in Business with Microsoft Office Access 2007 • Bast, Cygman, Flynn, Tidwell Databases Database Systems, Eighth Edition • Rob, Coronel Concepts of Database Management, Sixth Edition • Pratt, Adamski Data Modeling and Database Design • Umanath, Scamell A Guide to SQL, Seventh Edition • Pratt A Guide to MySQL • Pratt, Last Guide to Oracle 10g • Morrison, Morrison, Conrad Oracle 10g Titles Oracle9i Titles Enterprise Resource Planning Concepts in Enterprise Resource Planning, Third Edition • Monk, Wagner Data Communications Data Communications and Computer Networks: A Business User’s Approach, Fourth Edition • White Systems Analysis and Design Systems Analysis and Design in a Changing World, Fifth Edition • Satzinger, Jackson, Burd Object-Oriented Analysis and Design with the Unified Process • Satzinger, Jackson, Burd Systems Analysis and...
Words: 223685 - Pages: 895
...Snyder Director of Marketing: Patrice Jones Marketing Manager: Yezan Alayan Senior Marketing Coordinator: Kathryn Ferranti Director of Production: Vince O’Brien Managing Editor: Jeff Holcomb Associate Managing Editor: Robert Engelhardt Production Manager: Pat Brown Creative Director: Jayne Conte Designer: Suzanne Behnke Media Editor: Daniel Sandin Media Project Manager: John Cassar Cover Image: (c) michael Holcomb/Shutterstock.com Full-Service Project Management: Mohinder Singh/ Aptara®, Inc. Composition: Aptara®, Inc. Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on appropriate page within text. Photo Credits: Page 4: Fig. 0.1: akg-images/Paul Almasy/Newscom. Page 11: Fig. 0.4: © 2008 IEEE/Journal of Microelectromechanical Systems (2006). Page 15: Fig. 1.1: Intel Corporation Pressroom Photo Archives. Page 16: Fig. 1.2(a) ©Hugh Threlfall/Alamy; Fig. 1.2(b) Hewlett-Packard Company; Fig. 1.2(c) © D. Hurst/Alamy; Fig. 1.2(d) Handout/MCT/Newscom. Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation....
Words: 158087 - Pages: 633
...throughout the world Visit us on the World Wide Web at: www.pearsoned.co.uk First published 2004 Second edition 2007 © Pearson Education Limited 2004 © Pearson Education Limited 2007 The right of Colin Fisher to be identified as author of this work has been asserted by him in accordance with the Copyright, Designs and Patents Act 1988. All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording or otherwise, without either the prior written permission of the publisher or a licence permitting restricted copying in the United Kingdom issued by the Copyright Licensing Agency Ltd, Saffron House, 6–10 Kirby Street, London, EC1N 8TS. All trademarks used herein are the property of their respective owners. The use of any trademark in this text does not vest in the...
Words: 142971 - Pages: 572
...NOLO 10TH EDITION ® “ An essential book to help entrepreneurs.” DALLAS MORNING NEWS How to Write a O RM D S ON C Business Plan THE LEADING BUSINESS PLAN BOOK FOR • Write a winning proposal • Prepare cash flow and profit & loss forecasts • Get backers to invest 25 YEARS Mike McKeever Free Legal Updates at Nolo.com R OM - AL L L F F e Story Dear friends, Founded in 1971, and based in an old clock factory in Berkeley, California, Nolo has always strived to offer clear legal information and solutions. Today we are proud to offer a full range of plain-English law books, legal forms, software and an award-winning website. Everything we publish is relentlessly researched and tested by a dedicated group of in-house legal editors, who together have more than 150 years’ experience. And when legal changes occur after publication, we promptly post free updates at Nolo.com. Tens of millions of Americans have looked to Nolo to help solve their legal and business problems. We work every day to be worthy of this trust. Ralph Warner Nolo co-founder Emma Cofod Products Books & Software & Services Get in-depth information. Nolo publishes hundreds of great books and software programs for consumers and business owners. ey’re all available in print or as downloads at Nolo.com. Legal Encyclopedia Free at Nolo.com. Here are more than 1,400 free articles and answers to common questions about everyday legal issues including wills...
Words: 94141 - Pages: 377
