- Table View
- List View
Excel 2010 Just the Steps For Dummies
by Diane KoersPick your Excel task, find it fast, and get it done with Just the Steps! If you want to see how to do a particular Excel task, this is the perfect book. Each page includes step-by-step instruction in one column and illustrations and screenshots in the other column, so you have all the information you need in one place-no flipping pages! Improve your Excel skills with just the steps for entering spreadsheet data, building formulas, protecting excel data, formatting cells, designing spreadsheets with graphics, managing workbooks, changing worksheet values, sorting and filtering data, creating charts, creating PivotTables, building macros, integrating Excel into other Office programs, and-whew!-still more. Explains essentials tasks for Excel 2010, the spreadsheet application that is part of the Microsoft Office 2010 suite Shows you just the steps for numerous Excel tasks using an easy-to-follow, two-column page layout, with step-by-step instruction on one side and illustrations and screenshots on the other Covers entering spreadsheet data, building formulas, protecting excel data, formatting cells, designing spreadsheets with graphics, managing workbooks, changing worksheet values, sorting and filtering data, creating charts, creating PivotTables, and building macros Walks you step by step through collaborating in Excel and integrating or using Excel with Word, PowerPoint, and Access Make your tasks easier, improve your Excel skills, and get better results with this step-by-step guide.
Excel 2010 Power Programming with VBA
by John WalkenbachAll the methods and tools you need to successfully program with Excel John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA. Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA) Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won't find anywhere else Includes a CD with templates and worksheets from the book This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf #6)
by John WalkenbachAll the methods and tools you need to successfully program with Excel John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA. Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA) Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won’t find anywhere else This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.
Excel 2010 Workbook For Dummies
by Greg HarveyReinforce your understanding of Excel with these Workbook exercises Boost your knowledge of important Excel tasks by putting your skills to work in real-world situations. The For Dummies Workbook format provides more than 100 exercises that help you create actual results with Excel so you can gain proficiency. Perfect for students, people learning Excel on their own, and financial professionals who must plan and execute complex projects in Excel, Excel 2010 Workbook For Dummies helps you discover all the ways this program can work for you. Excel is the world's most popular number-crunching program, and For Dummies books are the most popular guides to Excel The Workbook approach offers practical application, with more than 100 exercises to work through and plenty of step-by-step guidance This guide covers the new features of Excel 2010, includes a section on creating graphic displays of information, and offers ideas for financial planners Also provides exercises on using formulas and functions, managing and securing data, and performing data analysis A companion CD-ROM includes screen shots and practice materials Excel 2010 Workbook For Dummies helps you get comfortable with Excel so you can take advantage of all it has to offer. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Excel 2010 for Biological and Life Sciences Statistics
by Thomas J Quirk Meghan Quirk Howard HortonThis is the first book to show the capabilities of Microsoft Excel to teach biological and life sciences statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems. If understanding statistics isn't your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2010 for Biological and Life Sciences Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.
Excel 2010 for Business Statistics
by Thomas J QuirkThis is the first book to show the capabilities of Microsoft Excel to teach business statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical business problems. If understanding statistics isn't your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in business courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2010 for Business Statistics: A Guide to Solving Practical Business Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.
Excel 2010 for Educational and Psychological Statistics
by Thomas J QuirkExcel has become an important and nearly ubiquitous classroom and office resource for students and practitioners who are faced with solving statistical problems on an everyday basis. Despite this, there has yet to emerge a truly practical, "how-do-I-do-it" manual that teaches the various applications and processes/formulas for Excel in educational and psychological Statistics. Quirk's Excel 2010 for Educational and Psychological Statistics will fill this void, as it is designed to be a step-by-step, exercise-driven guide for education and psychology students who need to master Excel to create formulas and solve statistical problems. Each chapter first explains briefly the formulas that are included in the chapter, and then directs the student on how to use Excel commands and formulas to solve a specific business problem. Three practice problems are provided at the end of each chapter, along with their solutions in an Appendix. At the end of the Excel Guide, an additional Practice Exam allows the reader to test his or her understanding of each chapter by attempting to solve a specific educational or psychometrical issue or problem using Excel (the solution to this problem is also given in an Appendix). From the beginning of the book, readers/students are taught how to write their own formulas and then how to utilize Excel drop-down formula menus as well for such exercises involving one-way ANOVA, simple linear regression, and multiple correlation.
Excel 2010 for Social Science Statistics
by Thomas J QuirkThis is the first book to show the capabilities of Microsoft Excel to teach social science statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical social science problems. If understanding statistics isn't your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in social science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2010 for Social Science Statistics: A Guide to Solving Practical Statistics Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand social science problems. Practice problems are provided at the end of each chapter with their solutions in an Appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand social science problems. Practice problems are provided at the end of each chapter with their solutions in an Appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned. Includes 164 Illustrations in color.
Excel 2010 für Dummies: Sonderausgabe (Für Dummies)
by Greg HarveyWer an Tabellen denkt, denkt automatisch an Excel, zumindest wenn er sie auf dem Computer erstellt. In diesem Buch stellt Greg Harvey das neue Excel vor, das 2010 auf den Markt kommt. Mit dieser gelungenen Anleitung werden die Leser auch ohne Vorkenntnisse schon bald wunderschöne Tabellen und Diagramme erstellen können.
Excel 2010: The Missing Manual (The\missing Manual Ser.)
by Matthew MacDonaldExcel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly.Navigate with ease. Master Excel's tabbed toolbar and its new backstage viewPerform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and moreOrganize your data. Search, sort, and filter huge amounts of informationIllustrate trends. Bring your data to life with charts and graphics -- including miniature charts called SparklinesExamine your data. Summarize information and find hidden patterns with pivot tables and slicersShare your spreadsheets. Use the Excel Web App to collaborate with colleagues onlineRescue lost data. Restore old versions of data and find spreadsheets you forgot to save
Excel 2013 All-in-One For Dummies
by Greg HarveyThe comprehensive reference, now completely up-to-date for Excel 2013!As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA. Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouseDetails new ways to explore your data more intuitively and then analyze and display your results with a single clickWhether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.
Excel 2013 All-in-One For Dummies
by Greg HarveyThe comprehensive reference, now completely up-to-date for Excel 2013! As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA. Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse Details new ways to explore your data more intuitively and then analyze and display your results with a single click Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.
Excel 2013 For Dummies
by Greg HarveyThe bestselling Excel book - completely updated for Excel 2013! As the world's leading spreadsheet application, Excel has an enormous user base. The release of Office 2013 brings major changes to Excel, so Excel For Dummies comes to the rescue once more! Featuring the friendly For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Walks you through the exciting new features of Excel 2013 Presents everything you need to know to perform basic Excel 2013 tasks Covers creating and editing worksheets and charts, formatting cells, entering formulas, inserting graphs, designing database forms, and adding database records Discusses printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing web page, and much more Whether you're new to Excel or are looking to get up and running with the 2013 version, Excel 2013 For Dummies has everything you need to know!
Excel 2013 eLearning Kit For Dummies
by Faithe WempenA complete package for learning Excel 2013!Excel is essential to business today, but it can be tricky to navigate. If you're eager to excel at Excel, then this dynamic multimedia learning solution is for you. This complete Excel 2013 package includes a full-color printed book and a For Dummies interactive eLearning course on CD. You'll discover the basics of the Excel interface, how to navigate it, and how to make the most of key features including charts, formulas, functions, macros, and more.Follow the material sequentially or jump in and out as you wish - it's set up so you can learn at your own pace. Throughout, you will benefit from illustrations, animations, voiceover explanations, and the option of closed captioning if you find you learn better when you can read the instructions. Helps self-motivated learners master Excel 2013, the leading spreadsheet application used todayWalks you through creating worksheets, working with formulas and functions, formatting data, using financial functions, displaying data in PivotTables, and much more Includes an easy-to-follow, full-color book and an interactive Dummies eLearning Course that corresponds with the book on CDAllows you to follow material sequentially or choose separate sections at your own time and paceExcel 2013 eLearning Kit For Dummies shows you the ins and outs of all things Excel so you can enhance your productivity and become a spreadsheet star!NOTE: CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.
Excel 2013 for Biological and Life Sciences Statistics
by Meghan Quirk Thomas J. Quirk Howard F. HortonThis is the first book to show the capabilities of Microsoft Excel to teach biological and life sciences statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems. If understanding statistics isn't your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2013 for Biological and Life Sciences Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.
Excel 2013 for Educational and Psychological Statistics
by Thomas J QuirkThis is the first book to show the capabilities of Microsoft Excel to teach educational and psychological statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical problems in education and psychology. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. <P><P> Excel, a widely available computer program for students and practitioners, is also an effective teaching and learning tool for quantitative analyses in statistics courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2013 for Educational and Psychological Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and practitioners how to apply Excel to statistical techniques necessary in their courses and work.<P> Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand problems in education and psychology. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.
Excel 2013 for Social Science Statistics
by Thomas J QuirkThis is the first book to show the capabilities of Microsoft Excel to teach social science statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical social science problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you.<P><P> Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in social science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2013 for Social Science Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work.<P> Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand social science problems. Practice problems are provided at the end of each chapter with their solutions in an Appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.
Excel 2013 für Dummies (Für Dummies)
by Greg HarveyWer an Tabellen denkt, denkt automatisch an Excel, zumindest wenn er sie auf dem Computer erstellt. In diesem Buch stellt Ihnen Greg Harvey die neue Version des Tabellenkalkulationsprogramms vor. Er führt Sie Schritt für Schritt in die Welt der Tabellen, Diagramme, Formeln und Funktionen ein und gibt Ihnen zahlreiche Tipps und Tricks an die Hand, wie Sie Ihre Arbeit mit Excel so effizient wie möglich gestalten können. Mit dieser gelungenen Anleitung kommen Excel-Neulinge und Umsteiger auf die Version 2013 schnell und sicher mit dem Programm zurecht.
Excel 2013: The Missing Manual (The\missing Manual Ser.)
by Matthew MacDonaldThe 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.
Excel 2016 Bible (Bible)
by John WalkenbachThe complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2016 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2016's new features and tools Customize downloadable templates and worksheets Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2016 Bible has you covered with complete coverage and clear expert guidance.
Excel 2016 Formulas (Mr. Spreadsheet's Bookshelf)
by Michael Alexander Richard KusleikaLeverage the full power of Excel formulas Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas. When conducting simple math or building highly complicated spreadsheets that require formulas up to the task, leveraging the right formula can heighten the accuracy and efficiency of your work, and can improve the speed with which you compile and analyze data. Understanding which formulas to use and knowing how to create a formula when you need to are essential. Access tips, tricks, and techniques that have been fully updated to reflect the latest capabilities of Microsoft Excel Create and use formulas that have the power to transform your Excel experience Leverage supplemental material online, including sample files, templates, and worksheets from the book
Excel 2016 Hands-On Lab
by Denia McGrew Handz HuizaThe new way to learn Excel 2016 immediately, and now the ebook is constantly updated with new topics. Learn at your own pace with real "step by step" exercises to guarantee your learning. Do not forget to download the practice files for free. With Excel 2016 Handson-Lab you will learn to: - Learn the basics of Microsoft Excel 2016 - Manage different types of data - Work with basic formulas and functions - Understand the use of text, logic, search and date and time functions - Use and convert ranges into tables - Insert new types of charts
Excel 2016 Passo dopo Passo
by Handz HuizaQuesto testo vi guiderà attraverso gli strumenti più usati di Excel 2016. I capitoli sono stati sviluppati in modo da essere indipendenti l’uno dall’altro, dunque non è necessario leggerli in modo sequenziale. Se già conoscete alcuni argomenti, potete scorrere direttamente fino al capitolo che vi interessa. Se invece utilizzate Excel per la prima volta, è opportuno che iniziate a leggere dal primo capitolo. Il presente testo può costituire anche materiale di consultazione, se necessario, cosi che a qualsiasi livello di preparazione, si possa trarre vantaggio dai contenuti.
Excel 2016 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
by Michael Alexander Richard KusleikaMaximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. In addition to the procedures, tips, and ideas that will expand your capabilities, this resource provides you with access to over 100 online example Excel workbooks and the Power Utility Pak, found on the Mr. Spreadsheet website. Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce—and can help you take your career to the next level. Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text Access online resources, including the Power Utility Pak, that supplement the content Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office Excel 2016 Power Programming with VBA is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.
Excel 2016 VBA and Macros
by Bill Jelen Tracy SyrstadUse this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information, so you can act on it… capture data from anywhere, and use it anywhere… automate Excel 2016’s best new features. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with bonus examples, macros, and solutions–straight from MrExcel!