Author: Ellen Monk,Joseph Brady,Emillio Mendelsohn

Publisher: Cengage Learning

ISBN: 1337516988

Category: Computers

Page: 50

View: 1963

Discover how to successfully apply the advantages of the latest Access database management system and maximize tools within the most recent version of Excel spreadsheet as you analyze and solve real business problems in PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL, 15TH ANNUAL EDITION. Packed with hands-on learning, this edition highlights six individual tutorials designed to build practical knowledge as readers walk you step-by-step through the capabilities of each software application. For the best in real-world practice, this edition offers 12 all-new case studies that present scenarios and problems readers are likely to encounter on the job. In addition, a unique emphasis on skill-building integration shows how to use Access and Excel together to resolve the cases. PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL delivers today’s most up-to-date, practical guide for the popular Access and Excel programs. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Read More

Author: Ellen Monk,Joseph Brady,Emillio Mendelsohn

Publisher: Cengage Learning

ISBN: 1337101338

Category: Computers

Page: 50

View: 2424

Discover how to successfully apply the advantages of the latest Access database management system and maximize tools within the most recent version of Excel spreadsheet as you analyze and solve real business problems in PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL, 15TH ANNUAL EDITION. Packed with hands-on learning, this edition highlights six individual tutorials designed to build practical knowledge as readers walk you step-by-step through the capabilities of each software application. For the best in real-world practice, this edition offers 12 all-new case studies that present scenarios and problems readers are likely to encounter on the job. In addition, a unique emphasis on skill-building integration shows how to use Access and Excel together to resolve the cases. PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL delivers today’s most up-to-date, practical guide for the popular Access and Excel programs. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Read More

Author: Ellen Monk,Joseph Brady,Emillio Mendelsohn

Publisher: Cengage Learning

ISBN: 1305868625

Category: Computers

Page: 304

View: 8728

Packed with hands-on learning, PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL, 14TH ANNUAL EDITION clearly demonstrates how to successfully apply the advantages of the latest Access database management system and Excel spreadsheet to analyze and solve real business problems. Six individual tutorials build readers’ practical knowledge as they walk step-by-step through the capabilities of each software application. For the best in real-world practice, this edition offers 12 all-new case studies that present scenarios and problems readers will likely encounter on the job. In addition, a unique emphasis on skill-building integration shows how to use Access and Excel together on cases. Readers can count on PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL as today’s most up-to-date, practical guide for the widely used Access and Excel programs. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Read More

Author: Ellen Monk,Spring Davidson,Joseph Brady

Publisher: Cengage Learning

ISBN: 0324789106

Category: Computers

Page: 230

View: 687

Apply Access and Excel effectively and efficiently to solve real-world business problems in this seventh edition of PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL. With six individual tutorials that build a practical knowledge of Microsoft Office 2007 Access and Excel capabilities, this book sets the groundwork for applying these database and spreadsheet skills to actual scenarios. These scenarios take the form of 12 all-new case studies, which introduce problems that are likely to face today's business professionals and allow readers to apply the information gleaned from the tutorials to solve them. The seventh edition continues to offer a tutorial covering data analysis techniques and a second integration case, affording readers the most up-to-date, practical education in the most commonly used software programs. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Read More

Author: Ellen Monk,Joseph Brady,Gerard S. Cook

Publisher: Cengage Learning

ISBN: 130521594X

Category: Computers

Page: 288

View: 3118

PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL, Twelfth Annual Edition, helps you apply the Access database management system and Excel spreadsheet to effectively analyze and solve real-world business problems. Six individual tutorials build a practical knowledge of each software application's capabilities, while 12 all-new case studies present scenarios and problems common in business. Further, a skill-building integration feature requires readers to use Access and Excel together on cases, making this the most up-to-date, practical guide for these widely used software programs. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Read More

Author: Debra Gross,Frank Akaiwa,Karleen Nordquist

Publisher: Cengage Learning

ISBN: 1285963962

Category: Computers

Page: 720

View: 4119

SUCCEEDING IN BUSINESS WITH MICROSOFT OFFICE EXCEL 2013 prepares your students to solve business problems by moving beyond the basic point and click skills to think critically about realistic business situations. When students combine software analysis with their own decision making abilities, they are more likely meet any business challenge with success. The Succeeding in Business Series emphasizes problem-solving, critical thinking, and analysis - challenging students to find efficient and effective solutions. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Read More

Author: Sandra Cable

Publisher: Cengage Learning

ISBN: 1305443489

Category: Computers

Page: 608

View: 4958

SUCCEEDING IN BUSINESS WITH MICROSOFT ACCESS 2013 prepares your students to solve business problems by moving beyond the basic point and click skills to think critically about realistic business situations. When students combine software analysis with their own decision making abilities, they are more likely meet any business challenge with success. The Succeeding in Business Series emphasizes problem-solving, critical thinking, and analysis - challenging students to find efficient and effective solutions. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Read More

Author: CTI Reviews

Publisher: Cram101 Textbook Reviews

ISBN: 1497041201

Category: Education

Page: 35

View: 7571

Facts101 is your complete guide to Problem Solving Cases in Microsoft Access and Excel. In this book, you will learn topics such as as those in your book plus much more. With key features such as key terms, people and places, Facts101 gives you all the information you need to prepare for your next exam. Our practice tests are specific to the textbook and we have designed tools to make the most of your limited study time.
Read More

Solving Small Business Scenarios Using Application Software

Author: Cynthia Gardner,Eugene Rathswohl

Publisher: Wiley

ISBN: 9781118291610

Category: Computers

Page: 168

View: 9691

The 2nd edition of Gardner's MIS Cases: Solving Small Business Scenarios Using Application Software is a problem solving book that contains practical assignments with business solving scenarios to grasp the skills for Microsoft Excel, Access, and simple web design. Each chapter offers a teaching case and two follow-up working cases as well as limited screen shots, only including a description of the case to solve, followed by questions to further reconfirm the skill set; existing only as figures of completed tasks.
Read More

Getting Started with Advanced Problem Solving Cases

Author: Amy S. Kinser,Eric Kinser,Jennifer Paige Nightingale

Publisher: Pearson

ISBN: 0134488148

Category: Business & Economics

Page: 100

View: 1217

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. This book is the perfect complement to the Excel or Access Comprehensive texts, particularly for instructors looking for more complex, real world cases for students to work through. Included are 15 total cases (6 Excel, 6 Access, and 3 integrated). Real world problem solving for business and beyond The Your Office series prepares students to use both technical and soft skills in the real world. Hands-on technical content is woven into realistic business scenarios and focuses on using Microsoft Office® as a decision-making tool. The series features a unique running business scenario that connects all of the cases together and exposes students to using Office to solve problems relating to business areas like finance and accounting, production and operations, sales and marketing. Each chapter introduces a realistic business case for students to complete via hands-on steps that are easily identified in blue shaded boxes. Each blue box teaches a skill and comes complete with video and interactive support. Chapters are grouped into Business Units, which collectively illustrate a specific set of business concepts to achieve AACSB-related outcomes. Each Business Unit ends with a Capstone section, testing students' ability to apply concepts and skills beyond a single chapter. Note: You are purchasing a standalone product; MyITLab does not come packaged with this content. Students, if interested in purchasing this title with MyITLab, ask your instructor for the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.
Read More

An Opinionated Guide to Problem Solving and Data Analysis Using Microsoft Excel (or Your Favorite Alternative)

Author: Joel Grus

Publisher: N.A

ISBN: 9780982481813

Category: Electronic spreadsheets

Page: 417

View: 3530

Whether you're a complete beginner or a grizzled veteran, Thinking Spreadsheet will make you an Excel expert. Its clear instruction and carefully-chosen examples will help you * Understand how spreadsheets work, what they do well, and what they don't do well. * Use the spreadsheet's structure to intelligently organize your data. * Solve problems using techniques that take advantage of the spreadsheet's strengths. * Build spreadsheets that are easy to understand and difficult to break. Along the way you'll learn core spreadsheet principles, basic tools like SUM() and IF(), advanced functions like MATCH() and VLOOKUP(), and power-user features like array formulas and pivot tables. You'll also learn a little bit of mathematics, a little bit of probability, a little bit of statistics, and a whole lot about how to intelligently solve problems. You might even laugh a few times!
Read More

Tips & Tools for Streamlining Your Spreadsheets

Author: David Hawley,Raina Hawley

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596555283

Category: Computers

Page: 412

View: 7150

Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks -- clever tools, tips and techniques -- that will leapfrog your work beyond the ordinary. Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to: Reduce workbook and worksheet frustration -- manage how users interact with worksheets, find and highlight information, and deal with debris and corruption. Analyze and manage data -- extend and automate these features, moving beyond the limited tasks they were designed to perform. Hack names -- learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet. Get the most out of PivotTables -- avoid the problems that make them frustrating and learn how to extend them. Create customized charts -- tweak and combine Excel's built-in charting capabilities. Hack formulas and functions -- subjects range from moving formulas around to dealing with datatype issues to improving recalculation time. Make the most of macros -- including ways to manage them and use them to extend other features. Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook. You can either browse through the book or read it from cover to cover, studying the procedures and scripts to learn more about Excel. However you use it, Excel Hacks will help you increase productivity and give you hours of "hacking" enjoyment along the way.
Read More

Forecasting, Statistics, and Data Management

Author: Gerald Knight

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596553463

Category: Computers

Page: 266

View: 5839

As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don't know the full extent of what Excel can do, mostly because of its recent growth in power, versatility, and complexity. The truth is that there are many ways Excel can help make your job easier-beyond calculating sums and averages in a standard spreadsheet. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the max. Rather than focusing on individual Excel functions and features, the book keys directly on the needs of business users. Most of the chapters start with a business problem or question, and then show you how to create pointed spreadsheets that address common data analysis issues. Aimed primarily at experienced Excel users, the book doesn't spend much time on the basics. After introducing some necessary general tools, it quickly moves into more specific problem areas, such as the following: Statistics Pivot tables Workload forecasting Modeling Measuring quality Monitoring complex systems Queuing Optimizing Importing data If you feel as though you're getting shortchanged by your overall application of Excel, Analyzing Business Data with Excel is just the antidote. It addresses the growing Excel data analysis market head on. Accountants, managers, analysts, engineers, and supervisors-one and all-will learn how to turn Excel functionality into actual solutions for the business problems that confront them.
Read More

Author: Matthew MacDonald

Publisher: "O'Reilly Media, Inc."

ISBN: 1449359515

Category: Computers

Page: 1020

View: 6834

The world’s most popular spreadsheet program is now more powerful than ever, but it’s also more complex. That’s where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. You’ll be using new features like PowerPivot and Flash Fill in no time. The important stuff you need to know: Go from novice to ace. Learn how to analyze your data, from writing your first formula to charting your results. Illustrate trends. Discover the clearest way to present your data using Excel’s new Quick Analysis feature. Broaden your analysis. Use pivot tables, slicers, and timelines to examine your data from different perspectives. Import data. Pull data from a variety of sources, including website data feeds and corporate databases. Work from the Web. Launch and manage your workbooks on the road, using the new Excel Web App. Share your worksheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn. Master the new data model. Use PowerPivot to work with millions of rows of data. Make calculations. Review financial data, use math and scientific formulas, and perform statistical analyses.
Read More

Decision Making with Application Software

Author: M. Lisa Miller

Publisher: Prentice Hall

ISBN: 9780138146801

Category: Application software

Page: 462

View: 8969

For introductory management information systems courses. MIS Cases gives students practice solving business problems using application software.
Read More

Author: John W. Satzinger,Robert B. Jackson,Stephen D. Burd

Publisher: Cengage Learning

ISBN: 1305465261

Category: Computers

Page: 512

View: 4909

Refined and streamlined, SYSTEMS ANALYSIS AND DESIGN IN A CHANGING WORLD, 7E helps students develop the conceptual, technical, and managerial foundations for systems analysis design and implementation as well as project management principles for systems development. Using case driven techniques, the succinct 14-chapter text focuses on content that is key for success in today's market. The authors' highly effective presentation teaches both traditional (structured) and object-oriented (OO) approaches to systems analysis and design. The book highlights use cases, use diagrams, and use case descriptions required for a modeling approach, while demonstrating their application to traditional, web development, object-oriented, and service-oriented architecture approaches. The Seventh Edition's refined sequence of topics makes it easier to read and understand than ever. Regrouped analysis and design chapters provide more flexibility in course organization. Additionally, the text's running cases have been completely updated and now include a stronger focus on connectivity in applications. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Read More

Author: Michael Alexander

Publisher: John Wiley & Sons

ISBN: 1119369274

Category: Computers

Page: 312

View: 1600

Save time and be way more productive with Microsoft Excel macros Looking for ready-made Excel macros that will streamline your workflow? Look no further! Excel Macros For Dummies, 2nd Edition helps you save time, automate, and be more productive–even with no programming experience at all. Each chapter offers macros you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work. You'll find over 70 of the most effective Excel macros for solving common problems and explanations of why and where to use each one–plus invaluable guidance and step-by-step instruction for applying them effectively. Microsoft Excel is the world's leading spreadsheet application, and it supports VBA macros that allow you to customize the program and automate many common tasks. In no time, you'll learn how to customize your applications to look and work exactly the way you want them to, with simple, friendly walk-throughs that directly apply to real-world tasks. Follow it through from start to finish, or quickly look up problems as they occur. It's the perfect desk reference for all of your Microsoft Excel macros needs! Immediately implement the given Excel macros Work with workbooks, worksheets, and ranges Clean data, automate reporting, and send email from Excel Streamline your workflow If you have an Excel problem, there's a macro to solve it–and now, you don't need to be a programmer to customize it for your own use!.
Read More

Author: Gordon S. Linoff

Publisher: John Wiley & Sons

ISBN: 1119021456

Category: Computers

Page: 792

View: 5571

A practical guide to data mining using SQL and Excel Data Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis—SQL and Excel—to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the "where" and "why" of each analysis, and then learn how to design and perform these analyses using SQL and Excel. Examples include SQL and Excel code, and the appendix shows how non-standard constructs are implemented in other major databases, including Oracle and IBM DB2/UDB. The companion website includes datasets and Excel spreadsheets, and the book provides hints, warnings, and technical asides to help you every step of the way. Data Analysis Using SQL and Excel, 2nd Edition shows you how to perform a wide range of sophisticated analyses using these simple tools, sparing you the significant expense of proprietary data mining tools like SAS. Understand core analytic techniques that work with SQL and Excel Ensure your analytic approach gets you the results you need Design and perform your analysis using SQL and Excel Data Analysis Using SQL and Excel, 2nd Edition shows you how to best use the tools you already know to achieve expert results.
Read More