- Table View
- List View
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 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 Thomas J. Quirk Meghan 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 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 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 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 for Biological and Life Sciences Statistics
by Thomas J. Quirk Meghan H. Quirk Howard F. HortonThis book is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical biological and life 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 is an effective learning tool for quantitative analyses in biological and life sciences courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2016 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 2016 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 biological and life 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 2016 for Business Statistics
by Thomas J. QuirkThis book shows the capabilities of Microsoft Excel in teaching business statistics effectively. Similar to the previously published Excel 2010 for Business Statistics, this book 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 2016 for Business 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 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 2016 for Educational and Psychological Statistics: A Guide to Solving Practical Problems (Excel for Statistics)
by Thomas J QuirkThis book shows the capabilities of Microsoft Excel in teaching educational and psychological statistics effectively. Similar to the previously published Excel 2013 for Educational and Psychological Statistics, this book is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical education and psychology 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 education and psychology courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2016 for Educational and Psychological 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 educational and psychological 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 2016 for Health Services Management Statistics
by Thomas J. Quirk Simone M. CummingsThis book shows the capabilities of Microsoft Excel in teaching health services management statistics effectively. Similar to the previously published Excel 2013 for Health Services Management Statistics, this book is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical health service management 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 health service courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2016 for Health Services Management 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 health service management 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 2016 for Marketing Statistics
by Thomas J. Quirk Eric RhineyThis is the first book to show the capabilities of Microsoft Excel in teaching marketing statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical marketing 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 marketing courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2016 for Marketing 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 marketing 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 2016 for Social Science Statistics
by Thomas J QuirkThis book shows the capabilities of Microsoft Excel in teaching social science statistics effectively. Similar to the previously published Excel 2013 for Social Sciences Statistics, this book 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 2016 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 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 für Dummies (Für Dummies)
by Greg HarveyExcel-Tabellen leicht gemacht Man denkt zuerst an Excel, wenn man an Tabellenkalkulation denkt. Greg Harvey stellt Ihnen in diesem Buch die neue Version von Excel 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. Dank dieser gelungenen Anleitung kommen Excel-Neulinge und -Umsteiger auf die Version 2016 schnell und sicher mit dem Programm zurecht.
Excel 2016 für Dummies kompakt (Für Dummies)
by Greg HarveyBearbeiten und verwalten Sie umfangreiche Tabellen am Computer? Dann kommen Sie um Excel nicht herum. In diesem kompakten Buch lernen Excel-Neulinge und -Umsteiger die aktuellste Version von Excel und die wesentlichen Funktionen in aller Kürze kennen. Fangen Sie ganz einfach an und arbeiten Sie sich zu Diagrammen, Tabellen, Funktionen und Formeln vor. Sie finden in diesem Buch die besten Tipps und Tricks zu Excel, die Ihnen das Arbeiten sehr erleichtern werden.
Excel 2016 Hands-On Lab
by Handz Huiza Denia McGrewThe 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!
Excel 2019 All-in-One For Dummies
by Greg HarveyExcel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions—including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. <p><p> The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources.
Excel 2019 All-in-One For Dummies
by Greg HarveyMake Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions—including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources. Get familiar with Worksheet design Find out how to work with charts and graphics Use Excel for data management, analysis, modeling, and visualization Make sense of macros and VBA If you’re a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you, this all-encompassing book makes it easy!
Excel 2019 Alles-in-einem-Band für Dummies (Für Dummies)
by Greg HarveyDieses Buch lässt keine Excel-Wünsche offen: Es beschreibt grundlegende Excel-Funktionen, wie das Erstellen und Bearbeiten von Arbeitsblättern, aber auch das Teilen und Überarbeiten von Dokumenten oder das Bearbeiten von Makros mit Visual Basic. Darüber hinaus: Arbeitsblätter formatieren und schützen, Formeln erstellen, Daten importieren, in Diagrammen darstellen und mit Statistikfunktionen auswerten, Pivot-Tabellen erzeugen, Was-wäre-wenn-Szenarien und Webabfragen durchführen, Datenbankfunktionen nutzen, Makros erstellen und ausführen, Excel in Verbindung mit Power BI nutzen und noch vieles mehr. Mit diesem Buch suchen Sie nicht mehr endlos nach Excel-Funktionen, sondern haben mehr Zeit für Ihre Projekte!