How to Do Everything with Excel 2007 teaches the reader how to master the latest version of Microsoft's market-dominating spreadsheet applicationExcel 2007 builds on previous versions of Excel by introducing a new interface featuring the Ribbon, a visual feature that replaces the current menus and toolbars and gives instant, context-sensitive access to whichever features the user currently needs. Excel 2007 also features an XML-based file format for greater compatibility with other applications, deeper integration with the other Office applications, and enhanced stability.FeaturesUses the proven hands-on approach of the How to Do Everything series to take the reader from being an Excel beginner to producing full-quality, professional work with ExcelCoverage includes spreadsheet layout; basic and advanced formatting; adding impact with graphics and diagrams; using functions and formulae (built-in and custom); building databases; creating PivotTables and PivotCharts; and using Solver, Goal Seek, and what-if analysis to solve complex business problemsHow To sidebars introduce practical, timesaving techniques for everyday operations-from the mundane to the sophisticated. Did You Know sidebars point up key information on why Excel works in unexpected ways and tell the reader how to get the most out of Excel

Make Excel work harder and faster for you. This unique book presents sample code for more than twenty practical, high-powered Excel VBA macro applications. You’ll get all the essentials of VBA, and then explore ways to power Excel with VBA. Automate tasks, convert numbers to labels, transpose cells, add formula details, globally changes values, and much, much more.

"By guiding teachers and their students through the workings of Excel, this book ultimately leads to high-ordered decision making about data management and interpretation?a compelling reality of the 21^st century."
Nancy Tanner Edwards, Professor of Education
Missouri Western State College
St. Joseph, MO

  Make Microsoft Excel™ work for you?in the classroom and at your desk!

Using Excel in the Classroom is the essential how-to for teachers at all grade levels, filled with specific, classroom-tested templates, and techniques that teachers need most!

Statistics for the Utterly Confused, Second Edition . .

When it comes to understanding statistics, even good students can be confused. Perfect for students in any introductory non-calculus-based statistics course, and equally useful to professionals working in the world, "Statistics for the Utterly Confused" is your ticket to success. Statistical concepts are explained step-by-step and applied to such diverse fields as business, economics, finance, and more.. .

The message of "Statistics for the Utterly Confused" is simple: you don't have to be confused anymore. Updated and expanded to give you the latest changes in the field, this up-to-the-minute edition includes many new examples of Excel output, the most widely used of all statistics programs; a new chapter on Analysis of Variance (ANOVA); and 200 additions to the 700 self-testing questions and answers. The expert author's Web site also gives you tons of fresh examples, practice problems, and strategies--so you can go from utterly confused to totally prepared in no time! . . .

Inside, you'll discover how to: . . Grasp the meaning of everyday statistical concepts . Find out what's probable and what isn't. Read, understand, and solve statistics problems. Improve your scores on exams . Use your skills in any field . .

Learn Instantly from Step-by-Step Graphics!

We know a picture is worth a thousand words--so we went heavy on pictures and light on words in this easy-to-use guide. Color screenshots and brief instructions show you how to use Excel's number-crunching features in no time. Follow along and learn to enter and format data, calculate with functions and formulas, create charts and graphs, analyze data, and more. Each chapter's "How to" list and color-coded tabs make it easy to flip straight to the tasks you need to do. Get the book that gets you started using Excel right away.

In Each Chapter: Shortcuts for accomplishing common tasks Helpful reminders or alternate ways of doing things Bonus information related to the topic being covered Errors and pitfalls to avoid Screenshots with captions show and explain exactly what you'll see on your computer screen while you're doing a task

John Cronan has more than 18 years of computing experience. He has worked on more than 20 books, including "Windows XP: A Beginner's Guide, FrontPage 2003: The Complete Reference, Excel for Windows 98 Made Easy, and "Office 2000 Answers: Certified Tech Support.

Designed for anyone who needs a comprehensive introduction to the principles of statistical methods and their applications, this text is written in a practical, non-threatening style. Step-by-step worked examples are used to illustrate the use of statistical techniques in solving practical problems while self-study exercises test students' knowledge. The use of Excel and MINITAB is fully integrated throughout the book to demonstrate the application of computer packages to solve a wide range of statistical problems. Presented alongside manual methods, these computer solutions include detailed instructions and annotated print outs where appropriate. The second edition retains the straightforward writing style and practical illustration of manual and computer methods which made the previous book successful for a wide range of courses.

Discover an accessible introduction to business statistics as ESSENTIALS OF MODERN BUSINESS STATISTICS, 7E balances a conceptual understanding of statistics with real-world applications of statistical methodology. The book integrates Microsoft Excel (R) 2016, providing step-by-step instructions and screen captures to help you master the latest Excel tools. Extremely reader-friendly, this edition includes numerous tools to maximize your course success, including Self-Test Exercises, margin annotations, insightful Notes and Comments, and real-world Methods and Applications exercises. Eleven new Case Problems, as well as new Statistics in Practice applications and real data examples and exercises, give you opportunities to put what you learn into practice. Additional learning resources, including MindTap and CengageNOW for online homework assistance and a complete support website, provide everything to acquire Excel (R) 2016 skills and an understanding of business statistics.

Build valuable skills that are in high demand in today's businesses with BUSINESS ANALYTICS, 3E. You master the full range of analytics as you strengthen your descriptive, predictive and prescriptive analytic skills. Real-world examples and visuals help illustrate data and results for each topic. Clear, step-by-step instructions for various software programs, including Microsoft Excel, Analytic Solver, and JMP Pro, teach you how to perform the analyses discussed. Practical, relevant problems at all levels of difficulty further help you apply what you've learned to succeed in your course.

Introduce your students to the latest advancements that Microsoft (R) Office and Excel 2016 have to offer with MICROSOFT (R) OFFICE 365 & EXCEL 2016: COMPREHENSIVE -- the new edition in the acclaimed Shelly Cashman Series (R). For more than three decades, the Shelly Cashman Series (R) has effectively introduced computer skills to millions. MICROSOFT (R) OFFICE 365 & EXCEL 2016: COMPREHENSIVE continues the Series' strong history of innovation with a hallmark learning approach now enhanced to address the varied learning styles of today's students. A trademark, step-by-step, screen-by-screen approach provides a thorough understanding of Microsoft (R) Excel 2016 through experimentation, critical thought, and personalization. This new edition and accompanying resources deliver effective educational materials specifically designed to engage readers, improve retention, and prepare students for future success in working with all aspects of Excel 2016.

Develop the Microsoft (R) Excel 2013 skills you need for success in college and beyond with this latest edition from the popular New Perspectives Series. Updated with all-new case-based tutorials, NEW PERSPECTIVES MICROSOFT (R) EXCEL 2013, COMPREHENSIVE ENHANCED EDITION continues to apply MS Excel 2013 skills to real situations that fully demonstrate the relevance of concepts. A proven learning approach emphasizes critical thinking, problem-solving, and in-depth coverage. A new Troubleshoot case problem enhances analytical skills, while a new tutorial on Managing Your Files helps you navigate Windows 8. A wealth of resources, including MindTap and SAM, provides opportunities to practice skills. Discover success with MS Excel 2013 as NEW PERSPECTIVES MICROSOFT (R) EXCEL 2013 helps you fully understand the value and application of what you're learning.

Develop the Microsoft (R) Excel (R) 2016 skills you need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT (R) OFFICE 365 & EXCEL (R) 2016: INTERMEDIATE. Updated with all-new case scenarios, this edition clearly applies the skills you are learning to real-world situations, making concepts even more relevant. New Productivity Apps provide a visual introduction to Microsoft (R) OneNote, Sway, Office Mix and Edge with fun, hands-on activities for active learning. Companion Sways highlight videos and step-by-step instructions to help you learn how to use each app. NEW PERSPECTIVES MICROSOFT (R) OFFICE 365 & EXCEL (R) 2016: INTERMEDIATE demonstrates the importance of what you're learning while strengthening your outcomes and helping you transfer your skills to other applications and disciplines for further success.

Whether you are a computer rookie or hot shot, you can master basic and more advanced Microsoft (R) Office and Excel 2016 skills quickly and efficiently with ILLUSTRATED MICROSOFT (R) OFFICE 365 & EXCEL 2016: INTERMEDIATE. Using a concise, focused approach and user-friendly format, the Illustrated Series incorporates a hallmark two-page layout that allows you to see an entire task in one view. Each presentation is easy to follow with Learning Outcomes that outline the skills covered in each lesson and larger full-color screens that reflect exactly what you should see on your own computer. Each module begins with a brief overview of the lesson's principles and introduces a case study for further application. In addition, new Productivity Apps visually introduce Microsoft (R) OneNote, Sway, Office Mix and Edge using hands-on activities.