Holy Macro! Books, 2020. - 278p. - ISBN: 9781615470679 Learn favorite techniques from this group of twenty-two Excel MVPs. The Excel MVPs are friends and competitors who each pulled out their favorite tricks to impress you and their fellow MVPs.
Holy Macro! Books, 2020. - 278p. - ISBN: 9781615470679 Learn favorite techniques from this group of twenty-two Excel MVPs. The Excel MVPs are friends and competitors who each pulled out their favorite tricks to impress you and their fellow MVPs.
Без выходных данных, 2017. — 45 с. Данный сборник состоит из 201 трюка, каждый из которых это настоящее открытие для пользователей Excel. Это лаконичные по содержанию, но емкие по смыслу приемы, которые способны облегчить любую Вашу задачу в Excel. Трюк представляет из себя небольшой текст написанный живым языком с элементами юмора, размером всего 1-2 абзаца. Каждый трюк...
Без выходных данных, 2017. — 45 с. Данный сборник состоит из 201 трюка, каждый из которых это настоящее открытие для пользователей Excel. Это лаконичные по содержанию, но емкие по смыслу приемы, которые способны облегчить любую Вашу задачу в Excel. Трюк представляет из себя небольшой текст написанный живым языком с элементами юмора, размером всего 1-2 абзаца. Каждый трюк...
Wiley, 2006. — 408 p. — ISBN: 978-0-470-04311-0. Written especially for advanced beginners and intermediate users, this book offers quick fixes for anyone bedeviled by faulty formulas, failed formatting, printer purgatory, and other perplexing Excel problems. Offers three types of fixes: Escape in Under 30 Seconds, Escape in Under Two Minutes, and More Elaborate Escapes-over...
Independently published, 2023-10-28. — 115 p. — ASIN: B0CM1XBVQV. Whether you’re a beginner taking your first steps into spreadsheets or an experienced user seeking to enhance your skills, this book provides a meticulously researched and expertly curated journey through Excel’s powerful features and functionalities. Table of Contents Highlights: Getting Started With Microsoft...
Independently published, 2023-10-28. — 115 p. — ASIN: B0CM1XBVQV. Whether you’re a beginner taking your first steps into spreadsheets or an experienced user seeking to enhance your skills, this book provides a meticulously researched and expertly curated journey through Excel’s powerful features and functionalities. Table of Contents Highlights: Getting Started With Microsoft...
Independently published, 2023-10-28. — 115 p. — ASIN: B0CM1XBVQV. Whether you’re a beginner taking your first steps into spreadsheets or an experienced user seeking to enhance your skills, this book provides a meticulously researched and expertly curated journey through Excel’s powerful features and functionalities. Table of Contents Highlights: Getting Started With Microsoft...
Independently published, 2020. — 567 p. — ASIN B09DQY242V. Microsoft Excel is one of the most used software applications of all time. Hundreds of millions of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations. This book Easy Excel, Master Excel is very much user friendly....
Independently published, 2020. — 567 p. — ASIN B09DQY242V. Microsoft Excel is one of the most used software applications of all time. Hundreds of millions of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations. This book Easy Excel, Master Excel is very much user friendly....
Independently published, 2020. — 567 p. — ASIN B09DQY242V. Microsoft Excel is one of the most used software applications of all time. Hundreds of millions of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations. This book Easy Excel, Master Excel is very much user friendly....
Wiley, 2006. — 288 p. — ISBN: 978-0-471-77240-8. These are powerful, flexible, and complex tools, and most Excel users never tap their full potential. But you can, with Peter Aitken's step-by-step tutorials, understandable instructions, and detailed explanations. You'll learn to create and use PivotTables and charts from the simplest to the most complex. This book will help you...
Wiley, 2003. — 456 p. Thirty clearly defined lessons take the reader from understanding the parts of an Excel application into building applications to work with data, formulas, charts, and the enhanced XML capabilities of the new Excel "X" Book is designed to teach the core concepts of Excel over a weekend or in just fifteen hours, with each session being thirty minutes...
Wiley, 2012. — 336 p. — ISBN: 1118281217, 9781118281215 Save time and be more productive with this helpful guide to Excel macros! While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step...
2nd.edition. — Wiley, 2017. — 312p. — ISBN: 111936924X (+Sample Files) 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...
Wiley, 2015. — 290 p. — (For Dummies). — ISBN: 1119089344, 9781119089346 Learn to: Save time, automate, and be more productive with Excel macros. Immediately implement and use over 70 Excel macros. Understand how each macro works and how to customize it. Reuse the macros in other workbooks or with other macros. Maximize these ready-made Excel macros to make your workflow...
2nd ed. — Wiley, 2022. — 272 p. — ISBN 1119844487. Learn to crunch huge amounts of data with PowerPivot and Power Query. Do you have a ton of data you need to make sense of? Microsoft's Excel program can handle amazingly large data sets, but you'll need to get familiar with PowerPivot and Power Query to get started. And that's where Dummies comes in. With step-by-step...
Wiley, 2016. — 325 p. — (For Dummies). — ISBN 978-1119210641. A guide to PowerPivot and Power Query no data cruncher should be without! Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! “Excel PowerPivot & Power Query For Dummies” shows you how this powerful new set of...
Wiley, 2016. — 288 p. — (For Dummies). — ISBN: 978-1119210641. A guide to PowerPivot and Power Query no data cruncher should be without! Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of...
Wiley, 2016. — 288 p. — (For Dummies). — ISBN: 978-1119210641. A guide to PowerPivot and Power Query no data cruncher should be without! Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of...
Wiley, 2014. — 384 p. in color. — Kindle Edition — ASIN: B00JSPNXNE — ISBN: 1118821521, 9781118821527
Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now...
Wiley, 2014. — 386 p. — ISBN 1118821521, 9781118821527 Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of...
Wiley, 2014. — 285 p. — ISBN: 1118902688, 9781118902684
Excel formulas can make your work easier and more productive, but it takes time to grasp the ins and outs of formulas. Do you need immediate help and don’t have time to research the right formula for the job at hand? 101 Ready-to-Use Excel Formulas arms you with the 101 most commonly used Excel formulas that will solve...
Wiley, 2014. — 285 p. — ISBN: 1118902688, 9781118902684 101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines a common business or analysis problem that needs to be solved and provides the actual Excel formulas...
Wiley, 2014. — 285 p. — ISBN: 1118902688, 9781118902684 101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines a common business or analysis problem that needs to be solved and provides the actual Excel formulas...
Wiley, 2013. — 432 p. — 2nd ed. — ISBN: 1118490428, 9781118490426
Learn to use Excel dashboards and reports to better conceptualize data
Updated for all the?latest features and capabilities of Excel 2013, this go-to resource provides you with in-depth coverage of the individual functions and tools that can be used to create?compelling Excel reports. Veteran author Michael...
Wiley, 2013. – 432 p. – 2nd ed. – ISBN: 1118490428, 9781118490426 Learn to use Excel dashboards and reports to better conceptualize data Updated for all the?latest features and capabilities of Excel 2013, this go-to resource provides you with in-depth coverage of the individual functions and tools that can be used to create?compelling Excel reports. Veteran author Michael...
Wiley Publishing, Inc., 2010. - 456 p. Рассматривается версии MS Excel 2007 и Excel 2010. The go to resource for how to use Excel dashboards and reports to better conceptualize data Many Excel books do an adequate job of discussing the individual functions and tools that can be used to create an Excel Report. What they don’t offer is the most effective ways to present and...
Wiley, 2006. — 294 p. — (For Dummies). — ISBN: 978-0-471-77910-0. As the fastest growing dashboarding solution on the market, Xcelsius is an intuitive stand-alone Windows application that enables Excel users to transform the contents of an ordinary Excel spreadsheet into an engaging, interactive Flash-based dashboard. Offers step-by-step instruction on the wide array of...
4th Edition. – John Wiley & Sons, Inc., For Dummies, 2022. – 387 p. – ISBN 978-1-119-84439-6. It's time for some truly "Excel-lent" spreadsheet reporting Beneath the seemingly endless rows and columns of cells, the latest version of Microsoft Excel boasts an astonishing variety of features and capabilities. But how do you go about tapping into some of that power without...
Alexander Michael. Excel Dashboards and Reports for Dummies, 3rd Edition. — For Dummies, 2016. - 384p. ISBN10: 1119076765 ISBN13: 978-1119076766 Файл PDF в архиве ZIP. Part I Getting Started with Excel Dashboards & Reports Getting In the Dashboard State of Mind Building a Super Model Part II Building Basic Dashboard Components Dressing Up Your Data Tables Sparking Inspiration...
Alexander Michael. Excel Dashboards and Reports for Dummies, 3rd Edition. — For Dummies, 2016. - 384p. ISBN10: 1119076765 ISBN13: 978-1119076766 Файл MOBI в архиве ZIP. Part I Getting Started with Excel Dashboards & Reports Getting In the Dashboard State of Mind Building a Super Model Part II Building Basic Dashboard Components Dressing Up Your Data Tables Sparking Inspiration...
Alexander Michael. Excel Dashboards and Reports for Dummies, 3rd Edition. — For Dummies, 2016. - 384p. ISBN10: 1119076765 ISBN13: 978-1119076766 Файл EPUB в архиве ZIP. Part I Getting Started with Excel Dashboards & Reports Getting In the Dashboard State of Mind Building a Super Model Part II Building Basic Dashboard Components Dressing Up Your Data Tables Sparking Inspiration...
Wiley, 2014. — 336 p. — 2nd ed. — ISBN: 1118842243
Create dynamic dashboards and put your data on display with For Dummies No matter what business you’re in, reports have become a staple of the workplace, but what good is a report if no reads it, or even worse, understands it? This all new edition of Excel Dashboards & Reports For Dummies is here to help you make meaning of all...
Содержит только ZIP-архив файлов к книге : Alexander Michael. Excel Dashboards and Reports for Dummies, 3rd Edition. — For Dummies, 2016. - 384p.ISBN10: 1119076765 ISBN13: 978-1119076766.
Allington Matt. Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI. – Holy Macro! Books, 2015. – 180p. ISBN10: 1615470417. ISBN13: 978-1615470419 Архив ZIP включает книгу в формате PDF на английском языке и бд, которая используется в книге для примеров. Data analysis expressions (DAX) is the formula language of PowerPivot and this book is...
2nd ed. — Holy Macro! Books, 2018. — 186 p. — ISBN: 978-1615470532. An active reading experience to learn DAX Power Pivot is an embedded database that significantly improves the business intelligence (BI) reporting an analytics capabilities of Microsoft Excel (versions 2010 and above). Data analysis expressions (DAX) is the formula language of Power Pivot. Learning the DAX...
2nd ed. — Holy Macro! Books, 2018. — 186 p. — ISBN: 978-1615470532. An active reading experience to learn DAX Power Pivot is an embedded database that significantly improves the business intelligence (BI) reporting an analytics capabilities of Microsoft Excel (versions 2010 and above). Data analysis expressions (DAX) is the formula language of Power Pivot. Learning the DAX...
CreateSpace Independent Publishing Platform, 2016. — 59 p. — ISBN10: 1533420092, ISBN13: 978-1533420091. Preview ebook Collection of simple and easy to implement tips and trick that make your Excel experience more convenient and enjoyable.
Independently published, 2020. - 103 p. Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. There may be times when we would like to go beyond the basic charts that excel creates for us. This book will focus on that complexity. An advanced chart is a chart that goes...
Independently published, 2020. - 103 p. Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. There may be times when we would like to go beyond the basic charts that excel creates for us. This book will focus on that complexity. An advanced chart is a chart that goes...
Independently published, 2020. - 103 p. Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. There may be times when we would like to go beyond the basic charts that excel creates for us. This book will focus on that complexity. An advanced chart is a chart that goes...
Independently published, 2020. - 103 p. Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. There may be times when we would like to go beyond the basic charts that excel creates for us. This book will focus on that complexity. An advanced chart is a chart that goes...
BPB Publications, 2023. — 333 р. — ASIN: B0CCL7KSR4. Unleash the power of Excel for advanced data analysis, automation, and productivity. Key Features: - Build a solid foundation in Excel by learning the basics, including the creation and formatting cells, sheets, and workbooks. - Explore advanced Excel techniques, including formulas, data analysis, and VBA macros. - Discover...
BPB Publications, 2023. — 333 р. — ASIN: B0CCL7KSR4. Unleash the power of Excel for advanced data analysis, automation, and productivity. Key Features: - Build a solid foundation in Excel by learning the basics, including the creation and formatting cells, sheets, and workbooks. - Explore advanced Excel techniques, including formulas, data analysis, and VBA macros. - Discover...
BPB Publications, 2023. — 333 р. — ASIN: B0CCL7KSR4. Unleash the power of Excel for advanced data analysis, automation, and productivity. Key Features: - Build a solid foundation in Excel by learning the basics, including the creation and formatting cells, sheets, and workbooks. - Explore advanced Excel techniques, including formulas, data analysis, and VBA macros. - Discover...
McGraw-Hill Education, 2014. - 208p. - ISBN: Maximize speed, quality, productivity, and profits with QI Macros for Excel Breakthrough Improvement with QI Macros and Excel: Finding the Invisible Low-Hanging Fruit reveals proven techniques for identifying and analyzing data that will lead to immediate results. This practical guide focuses on using Excel, one of the most widely used...
2nd Edition. — Apress, 2016 — 618 p. — ISBN: 978-1-4842-2399-4. Take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision making. Do this through the power of visualization using this updated edition covering new features and added support for visualization in Excel 2016, and...
Apress Media LLC., 2020. — 404 p. — ISBN13: 978-1-4842-6017-3. Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel’s Get and Transform feature set, showing you how to connect to a range of external databases and other data sources to...
Apress Media LLC., 2020. — 404 p. — ISBN13: (electronic): 978-1-4842-6018-0. Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel’s Get and Transform feature set, showing you how to connect to a range of external databases and other...
Apress Media LLC., 2020. — 404 p. — ISBN13: (electronic): 978-1-4842-6018-0. Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel’s Get and Transform feature set, showing you how to connect to a range of external databases and other...
Apress Media LLC., 2020. — 404 p. — ISBN13: (electronic): 978-1-4842-6018-0. Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel’s Get and Transform feature set, showing you how to connect to a range of external databases and other...
2nd Edition. — Apress, 2016. — 618 p. — ISBN: 978-1-4842-2399-4. Code files only! Take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision making. Do this through the power of visualization using this updated edition covering new features and added support for visualization in Excel...
2nd Edition. — Apress, 2016. — 618 p. — ISBN: 978-1-4842-2399-4. Take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision making. Do this through the power of visualization using this updated edition covering new features and added support for visualization in Excel 2016, and...
Amazon.com Services LLC, 2019. — 146 p. — ISBN: 978-1675864166. Master Excel formulas, functions, pivot charts & Excel shortcuts. A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don’t. Are you ready to land your next job and increase...
Amazon.com Services LLC, 2019. — 146 p. — ISBN: 978-1675864166. Master Excel formulas, functions, pivot charts & Excel shortcuts. A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don’t. Are you ready to land your next job and increase...
Amazon.com Services LLC, 2019. — 146 p. — ISBN: 978-1675864166. Master Excel formulas, functions, pivot charts & Excel shortcuts. A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don’t. Are you ready to land your next job and increase...
Independently published, 2021. — 363 p. — ISBN 9798719914886. We all deal with numbers in a way or the other. We all have expenditures ranging from the monthly income that we earn to our day-to-day expenses. For one to spend wisely, one will need to know their income with respect to their expenditure. Microsoft Excel comes in handy when we want to analyze, record and store such...
Independently published, 2021. — 363 p. — ISBN 9798719914886. We all deal with numbers in a way or the other. We all have expenditures ranging from the monthly income that we earn to our day-to-day expenses. For one to spend wisely, one will need to know their income with respect to their expenditure. Microsoft Excel comes in handy when we want to analyze, record and store such...
Independently published, 2021. — 363 p. — ISBN 9798719914886. We all deal with numbers in a way or the other. We all have expenditures ranging from the monthly income that we earn to our day-to-day expenses. For one to spend wisely, one will need to know their income with respect to their expenditure. Microsoft Excel comes in handy when we want to analyze, record and store such...
Independently published, 2017. - 52p. - ISBN: 978-1521066300 This book is specially arranged for people who wants to learn VBA on their own. The author has been teaching VBA for five years and had designed this book the way VBA can be easily learned. Similar to other books of the author, concepts are explained in layman's term to make learning easy. This contains the basics up to...
Independently published, 2017. - 52p. - ISBN: 978-1521066300 This book is specially arranged for people who wants to learn VBA on their own. The author has been teaching VBA for five years and had designed this book the way VBA can be easily learned. Similar to other books of the author, concepts are explained in layman's term to make learning easy. This contains the basics up to...
Ballerini M., Clerici A., Debernardi M., Corno D., De Pra M. - 3rd edition. - EGEA Spa — Bocconi University Press, 2021. — 431 p. — ISBN 978-8831322089. Excel is the most popular and widely used productivity software in all business environments, and it is an irreplaceable companion in ordinary work as in the analysis of large amounts of complex data. Nevertheless, the majority...
3rd edition. — Bocconi University Press, 2021. — 431 p. — ISBN 978-8831322089. Excel is the most popular and widely used productivity software in all business environments, and it is an irreplaceable companion in ordinary work as in the analysis of large amounts of complex data. Nevertheless, the majority of users knows and uses only a very limited number of features, often in...
Trump Excel, 2013. — 57 p.
This e-guide is an effort to share useful tips on Excel. These are quick one-page tips that would help you in your day-to-day work.
John Wiley & Sons Ltd, 2005. - 432 p.
Рассматривается версия MS Excel 2003.
Excel Models for Business and Operations Management, Second Edition, adopts a structured approach to management decision-making by integrating the activities of a manufacturing organization. The text is entirely assignment-based and uses Microsoft’s Excel software to develop over eighty models....
Holy Macro! Books, 2014. — 195 p. — ISBN10: 161547028X, 13 978-1615470280. Creating tables in Excel allows for easier formatting and reporting, but the new syntax that it implies can be intimidating to the uninitiated. In this guide, one of the developers of the official Microsoft Excel 2013 templates—all of which employ tables—helps introduce readers to the multiple benefits...
Golden AT, 2021. — 99 p. — (Pega How-to Guide). — ISBN 9789811703126. In Pega, we are often required to provide some search functionalities for users, such as listing records matching some given search criteria. This is simple and OOTB. However, sometimes, the users might require us to provide a functionality to export the search results into Excel. The purpose of this...
Golden AT, 2021. — 99 p. — (Pega How-to Guide). — ISBN 9789811703126. In Pega, we are often required to provide some search functionalities for users, such as listing records matching some given search criteria. This is simple and OOTB. However, sometimes, the users might require us to provide a functionality to export the search results into Excel. The purpose of this...
Golden AT, 2021. — 99 p. — (Pega How-to Guide). — ISBN 9789811703126. In Pega, we are often required to provide some search functionalities for users, such as listing records matching some given search criteria. This is simple and OOTB. However, sometimes, the users might require us to provide a functionality to export the search results into Excel. The purpose of this...
3rd Edition. — Cambridge University Press, 2020. — 446 p. — ISBN: 978-1-108-73836-1. This third edition capitalizes on the success of the previous editions and leverages the important advancements in visualization, data analysis, and sharing capabilities that have emerged in recent years. It serves as an accelerated guide to decision support designs for consultants, service...
2nd edition. — Amazon Digital Services, 2017. — 195 p. — ASIN: B01N1YLOQ5. Learn how to create Pivot Tables quickly and easily with this step-by-step guide! Updated for Microsoft Excel 2016! This book contains easy to follow step-by-step examples with screenshots demonstrating how to create Pivot Tables and basic Dashboards. In just a few short hours, you’ll learn how to:...
CreateSpace Independent Publishing Platform, 2015. — 94 p. — ISBN: 978-1522713371. Ready to learn more about Microsoft Excel, but not sure where to start? This book is tailored for beginners and will guide you through the basic functionality of Microsoft Excel. Providing a review of the most commonly used toolbar commands. How to create a new spreadsheet, including formatting,...
Syncfusion Inc, 2015. — 84 p. Categories: Microsoft Excel, Data Analysis Learn to manipulate massive amounts of data using an often overlooked feature of Microsoft Excel. Author James Beresford will demonstrate how to take control of data sets by using a tool that most readers likely already have access to. With PowerPivot Succinctly, you can take the first step toward...
Syncfusion Inc, 2015. — 94 p. Categories: Microsoft Excel, Data Analysis Learn to manipulate massive amounts of data using an often overlooked feature of Microsoft Excel. Author James Beresford will demonstrate how to take control of data sets by using a tool that most readers likely already have access to. With PowerPivot Succinctly, you can take the first step toward...
Morgan Kaufmann, 2009. – 240 p. – ISBN: 0120885824, 9780120885824 (Interactive Technologies) Although recognized as a key to the design process, prototyping often falls victim to budget cuts, deadlines, or lack of access to sophisticated tools. This can lead to sloppy and ineffective prototypes or the abandonment of them altogether. Rather than lose this important step, people...
Brooks/Cole, 2010. - 612 p. This popular best-selling book shows students and professionals how to do data analysis with Microsoft Excel. Data Analysis With Microsoft Excel teaches the fundamental concepts of statistics and how to use Microsoft Excel to solve the kind of data-intensive problems that arise in business and elsewhere. Even students with no previous experience...
John Wiley & Sons, Inc., 2011. - 738 p. Рассматриваются версии MS Excel 2007 и Excel 2010, а также более ранние версии. The newly revised step-by-step guide to using the scientific calculating power of Excel to perform a variety of chemical calculations Chemists across all subdisciplines use Excel to record data in tabular form, but few have learned to take full advantage of...
John Wiley & Sons, Inc., 2007. - 477 p. Рассматривается версия MS Excel 2003. This book shows how to implement numerical methods using Microsoft Excel, the most widely used spreadsheet software package. Excel provides at least three ways for the scientist or engineer to apply numerical methods to problems: - by implementing the methods on a worksheet, using worksheet formulas -...
Chapman and Hall/CRC, 2007. — 480 p. — ISBN: 1584888857, 9781584888857 Because the analysis of copious amounts of data and the preparation of custom reports often take away time from true research, the automation of these processes is paramount to ensure productivity. Exploring the core areas of automation, report generation, data acquisition, and data analysis, Automated Data...
2nd ed. — CRC Press, 2021. — 610 p. — ISBN: 9780367509316. This new edition covers some of the key topics relating to the latest version of MS Office through Excel 2019, including the creation of custom ribbons by injecting XML code into Excel Workbooks and how to link Excel VBA macros to customize ribbon objects. It now also provides examples in using ADO, DAO, and SQL queries...
2nd ed. — CRC Press, 2021. — 610 p. — ISBN: 9780367509316. This new edition covers some of the key topics relating to the latest version of MS Office through Excel 2019, including the creation of custom ribbons by injecting XML code into Excel Workbooks and how to link Excel VBA macros to customize ribbon objects. It now also provides examples in using ADO, DAO, and SQL queries...
2nd Edition. — Chapman and Hall/CRC, 2020. — 610 p. — (Chapman & Hall/CRC Data Mining and Knowledge Series). — ISBN: 978-1-003-05188-6 (ebk). This new edition covers some of the key topics relating to the latest version of MS Office through Excel 2019, including the creation of custom ribbons by injecting XML code into Excel Workbooks and how to link Excel VBA macros to...
2nd Edition. — Chapman and Hall/CRC, 2020. — 610 p. — (Chapman & Hall/CRC Data Mining and Knowledge Series). — ISBN: 978-1-003-05188-6 (ebk). This new edition covers some of the key topics relating to the latest version of MS Office through Excel 2019, including the creation of custom ribbons by injecting XML code into Excel Workbooks and how to link Excel VBA macros to...
Wiley, 2014. — 442 p. in color. — (Wiley Corporate F&A). — ISBN: 1118657721, 9781118657720
The advanced tools accountants need to build automated, reliable, and scalable reports using Excel Learn about the functions that work together to automate many of the processes involved in Management Reporting. See how to take advantage of the many new features of Excel 2007 and 2010....
Amazon Digital Services, 2016. — 53 p. — ASIN B01LZNJAWL.
Effective Excel tools and strategies that you can learn in a short 30 minutes! Anyone can easily look up Excel formulas and tool functions on the internet. The real challenge is knowing which tools to use and when to use a particular strategy. It is all easy if you know how to fit the pieces together, right?
This book...
John Wiley & Sons, Inc., 2019. — 401 p. Getting Started with Formulas and Functions . Tapping Into Formula and Fir>ction Fundamentals. Saving Time wth Function Tools. Saying "Arrayf for Formulas and Functions. Fixing Formula Boo Boos. Doing the Math . Caiculating Loan Payments and Interest Rates. Appreciating What You'll Gee. Depreciating What You've Goc. Using Basic Math...
For Dummies, 2022. - 419 p. Unlock the power of Excel with a step-by-step roadmap to its formulas and functions There's a Swiss Army knife in your digital toolbox that can multiply your productivity and make you the smartest guy or gal in almost any room. It's called Microsoft Excel. If you're like most people, you've barely scratched the surface of what this powerful tool's...
For Dummies, 2022. - 419 p. Unlock the power of Excel with a step-by-step roadmap to its formulas and functions There's a Swiss Army knife in your digital toolbox that can multiply your productivity and make you the smartest guy or gal in almost any room. It's called Microsoft Excel. If you're like most people, you've barely scratched the surface of what this powerful tool's...
John Wiley & Sons, Inc., 2013. – 408 p. –3rd ed. – ISBN: 1118460847, 9781118460849
Learn to use Excel for practical, day-to-day calculations
Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to...
John Wiley & Sons, Inc., 2013. – 408 p. –3rd ed. – ISBN: 1118460847, 9781118460849
Learn to use Excel for practical, day-to-day calculations
Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to...
4th ed. — Wiley, 2016. — 410 p. — ISBN: 1119076781, 9781119076780 Grab these Excel formulas and functions to make your life easier! Are you intimidated by major financial choices, like which loan to get or how to grow your savings? Don't worry—we all are! But Excel Formulas & Functions For Dummies, 4th Edition can take some of the pain out of the data organization and analysis...
5th ed. — Wiley, 2018. — 400 p. — ISBN: 1119518253. Put the power of Excel functions to work in your formulas. There are more than 400 built-in functions in Excel 2019, from AGGREGATE to Z.TEST. The question is which ones will make your work easier? How and why should you use a particular function in your formulas? Excel Formulas and Functions For Dummies offers thorough but...
2nd ed. - Wiley Publishing, Inc., 2010. – 389 p. Рассматриваются версии MS Excel 2007 и Excel 2010. This book is about the number-crunching side of Excel. Formulas are the keystone to analyzing data — that is, digging out nuggets of important information. What is the average sale? How many times did we do better than average? How many days are left on the project? How much...
Wiley-VCH, 2022. — 400 S. In Excel gibt es mehr als 400 Funktionen. Aber welche der vielen Funktionen erleichtert Ihnen Ihre Arbeit? Wie setzen Sie die Funktionen richtig ein? Wie lautet die Syntax? Dieses Buch stellt Excel-Einsteigern die 150 nützlichsten Excel-Funktionen ausführlich vor. Sie lernen, wie Sie Formeln richtig für Statistiken einsetzen, Prognosen erstellen,...
Wiley-VCH, 2022. — 400 S. In Excel gibt es mehr als 400 Funktionen. Aber welche der vielen Funktionen erleichtert Ihnen Ihre Arbeit? Wie setzen Sie die Funktionen richtig ein? Wie lautet die Syntax? Dieses Buch stellt Excel-Einsteigern die 150 nützlichsten Excel-Funktionen ausführlich vor. Sie lernen, wie Sie Formeln richtig für Statistiken einsetzen, Prognosen erstellen,...
5th Edition. — Wiley, 2018. — 400 р. There are more than 400 built-in functions in Excel 2019, from AGGREGATE to Z.TEST. The question is which ones will make your work easier? How and why should you use a particular function in your formulas? Excel Formulas and Functions For Dummies offers thorough but easy-to-read coverage of powerful Excel functions. With this book, you’ll...
Mitp, 2023. — 350 S. Mit Microsoft Excel können Sie all Ihre Tabellenkalkulationsaufgaben lösen, doch Sie müssen wissen, welche Funktionen wie miteinander kombiniert werden, um die Software effektiv einzusetzen und alltägliche Aufgaben zu meistern. Mit diesem Buch erhalten Sie 250 praktische Lösungen für gängige Aufgabenstellungen. Jede Lösung besteht aus einer kurzen...
Mitp, 2023. — 350 S. Mit Microsoft Excel können Sie all Ihre Tabellenkalkulationsaufgaben lösen, doch Sie müssen wissen, welche Funktionen wie miteinander kombiniert werden, um die Software effektiv einzusetzen und alltägliche Aufgaben zu meistern. Mit diesem Buch erhalten Sie 250 praktische Lösungen für gängige Aufgabenstellungen. Jede Lösung besteht aus einer kurzen...
Packt Publishing, 2014. — 150 p. — ISBN: 9781849698689
Business intelligence technology gives an organization the power to make decisions using large volumes of data. By obtaining an adequate amount of data and integrating data from a variety of sources, a user can get a comprehensive knowledge of their business and business strategies. PowerPivot is a free add-in to the 2010...
2nd Edition. — Pearson Education, Inc., 2009. — 1117 p. Application Architectures Excel and VBA Development Best Practices Worksheet Design Function, General, and Application-Specific Add-ins Dictator Applications Using Class Modules to Create Objects Advanced Command Bar Handling Introduction to XML The Office 2007 Ribbon User Interface Creating Cross-Version Applications...
Wiley, 2021. — 240 p. — (Portable Genius). — ISBN 1119763614. Your genius-level guide to Excel excellence Excel Portable Genius covers the key features of Microsoft Excel in a concise, fast-paced, portable format that provides the perfect quick and easy-to-follow reference for novices and experienced users alike. Written by seasoned tech expert and trainer Lisa A.Bucki, it...
Wiley, 2021. — 240 p. — (Portable Genius). — ISBN 1119763614. Your genius-level guide to Excel excellence Excel Portable Genius covers the key features of Microsoft Excel in a concise, fast-paced, portable format that provides the perfect quick and easy-to-follow reference for novices and experienced users alike. Written by seasoned tech expert and trainer Lisa A.Bucki, it...
Wiley, 2021. — 240 p. — (Portable Genius). — ISBN 1119763614. Your genius-level guide to Excel excellence Excel Portable Genius covers the key features of Microsoft Excel in a concise, fast-paced, portable format that provides the perfect quick and easy-to-follow reference for novices and experienced users alike. Written by seasoned tech expert and trainer Lisa A.Bucki, it...
CreateSpace Independent Publishing Platform, 2016. — 234 p. — ISBN: 978-1540538895. Exploring the limits of Excel is a survey trip to the boundaries of the most widely used spreadsheet software: Microsoft Excel. The book deals with the differences between actual Excel limits and claimed Excel errors, studying and analyzing Excel’s performance in extreme cases according to three...
Developer: Jignesh Parmar, 2012. Calculation of voltage drop and cable size Motor / Electrical load Calculate Voltage drop of Cable. Calculate Size of Cable. Calculate Current Capacity of Cable.
Bluerose Publishing, 2022. — 444 p. If you already know how to use Microsoft Excel but there’re a few things you can’t do, it is time to learn the strongest functionality it has, Visual Basic for Applications (VBA). Visual Basic for Applications is a programming language incorporated in Microsoft Excel, Access, PowerPoint and even Word, which let you do all things you already...
Bluerose Publishing, 2022. — 444 р. If you already know how to use Microsoft Excel but there’re a few things you can’t do, it is time to learn the strongest functionality it has, Visual Basic for Applications (VBA). Visual Basic for Applications is a programming language incorporated in Microsoft Excel, Access, PowerPoint and even Word, which let you do all things you already...
Bluerose Publishing, 2022. — 444 р. If you already know how to use Microsoft Excel but there’re a few things you can’t do, it is time to learn the strongest functionality it has, Visual Basic for Applications (VBA). Visual Basic for Applications is a programming language incorporated in Microsoft Excel, Access, PowerPoint and even Word, which let you do all things you already...
Bluerose Publishing, 2022. — 444 р. If you already know how to use Microsoft Excel but there’re a few things you can’t do, it is time to learn the strongest functionality it has, Visual Basic for Applications (VBA). Visual Basic for Applications is a programming language incorporated in Microsoft Excel, Access, PowerPoint and even Word, which let you do all things you already...
Долгопрудный: МФТИ, 2018. — 131 с. 4 файла: TXT+ XSL+2PDF Если вам надоела громоздкость и медлительность экселя и его VBA макросов, вы можете вносить и считывать информацию в экселевский файл снаружи, т.е. не открывая Эксель, используя свой C++ или assembler код. Вся изложенная информация годится для любого языка программирования, т.к рассматривается именно структура файла, а...
New Riders, 2016. - 448p. - ISBN: 978-0134268637 Data at Work was written with you, the spreadsheet user, in mind. This book will teach you how to think about and organize data in ways that directly relate to your work, using the skills you already have. In other words, you don’t need to be a graphic designer to create functional, elegant charts: this book will show you how....
5th edition. — Que Publishing, 2018. — 576 p. — ASIN B07LFJGQ79. Gain Deeper Insights, Make Smarter Decisions, and Earn More Profits It’s time to put the full power of Excel quantitative analysis behind your management decisions! Business analysis expert Conrad Carlberg shows you how to use Excel to perform core financial tasks all managers and entrepreneurs need to master:...
5th edition. — Que Publishing, 2018. — 576 p. — ASIN B07LFJGQ79. Gain Deeper Insights, Make Smarter Decisions, and Earn More Profits It’s time to put the full power of Excel quantitative analysis behind your management decisions! Business analysis expert Conrad Carlberg shows you how to use Excel to perform core financial tasks all managers and entrepreneurs need to master:...
5th edition. — Que Publishing, 2018. — 576 p. — ASIN B07LFJGQ79. Gain Deeper Insights, Make Smarter Decisions, and Earn More Profits It’s time to put the full power of Excel quantitative analysis behind your management decisions! Business analysis expert Conrad Carlberg shows you how to use Excel to perform core financial tasks all managers and entrepreneurs need to master:...
Que Publishing, 2014. - 288p. - ISBN: 978-0-7897-5168-3 + Sample Files + Errata Crunch Big Data to optimize marketing and more! Overwhelmed by all the Big Data now available to you? Not sure what questions to ask or how to ask them? Using Microsoft Excel and proven decision analytics techniques, you can distill all that data into manageable sets—and use them to optimize a wide...
CPA911 Publishing, 2007. - 289 p. Рассматривается версия MS Excel 2007. Accounting professionals learn how to get the information they need fast with this guide to Excel features that manipulate and sort financial data. Comprehensive but concise chapters explain how to automate the entry of common business formulas; how to use pivot tables to extract details; how to develop...
Que, 2004. — 542 p. Microsoft Excel is the #1 selling Windows spreadsheet with a user base over 10 million. This is the total package for anyone using Excel's database capabilities. There is complete coverage of List Management, Pivot Tables, Data Consolidation, and Working with External Data. Excel guru Tim Tow shares the tricks he has learned about data manipulation with...
Que Publishing, 2015. — 336 p. — ISBN: 0-7897-5614-5 Only sample files Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers! In More Predictive Analytics, Microsoft Excel MVP Conrad Carlberg shows how to use intuitive smoothing techniques to make remarkably accurate predictions. You won’t have to write a line of code-all you need...
Que Publishing, 2017. — 394 p. — ISBN: 978-0-7897-5785-2 Microsoft Excel can perform many statistical analyses, but thousands of business users and analysts are now reaching its limits. R, in contrast, can perform virtually any imaginable analysis—if you can get over its learning curve. In R for Microsoft Excel Users, Conrad Carlberg shows exactly how to get the most from both...
Que Publishing, 2017. — 394 p. — ISBN: 978-0-7897-5785-2 Only sample files. Microsoft Excel can perform many statistical analyses, but thousands of business users and analysts are now reaching its limits. R, in contrast, can perform virtually any imaginable analysis—if you can get over its learning curve. In R for Microsoft Excel Users, Conrad Carlberg shows exactly how to get the...
Que Publishing, 2016. — 368 p. — ISBN: 978-0789756558. This is today’s most complete guide to regression analysis with Microsoft Excel for any business analytics or research task. Drawing on 25 years of advanced statistical experience, Microsoft MVP Conrad Carlberg shows how to use Excel’s regression-related worksheet functions to perform a wide spectrum of practical analyses....
Que Publishing, 2016. — 368 p. — ISBN: 978-0-7897-5655-8 Only sample files This is today’s most complete guide to regression analysis with Microsoft Excel for any business analytics or research task. Drawing on 25 years of advanced statistical experience, Microsoft MVP Conrad Carlberg shows how to use Excel’s regression-related worksheet functions to perform a wide spectrum of...
Amazon Digital Services, 2017. — 95 p. — ASIN B071RSYBKG. A journey of a thousand miles begins with a single step. If you have to step your way through a thousand miles, will you do it? What if you have a car or a plane for your journey of a thousand miles? Excel has this very useful ability (called formula auditing) to trace precedents and dependents, which draws arrows to...
Amazon Digital Services, 2017. - 102p. - ASIN: B06XYMVLG7 Books about Excel don’t tell you how to gain an overview of the model in a spreadsheet. They talk about how to cut and paste, how to write formulas, and how to use special formulas. But do you know how all these formulas are organized in a spreadsheet model? Normally, people will have a very hard time doing this, as they...
Amazon Digital Services, 2017. - 102p. - ASIN: B06XYMVLG7 Books about Excel don’t tell you how to gain an overview of the model in a spreadsheet. They talk about how to cut and paste, how to write formulas, and how to use special formulas. But do you know how all these formulas are organized in a spreadsheet model? Normally, people will have a very hard time doing this, as they...
Amazon Digital Services, 2017. — 95 p. — ASIN B071RSYBKG. A journey of a thousand miles begins with a single step. If you have to step your way through a thousand miles, will you do it? What if you have a car or a plane for your journey of a thousand miles? Excel has this very useful ability (called formula auditing) to trace precedents and dependents, which draws arrows to...
Springer Cham, 2023. — 159 p. — (Synthesis Lectures on Mathematics & Statistics) — eBook ISBN: 978-3-031-33886-1. Includes a step-by-step guide to Monte Carlo simulations using Microsoft Excel for the analysis and visualization Provides fundamental knowledge and techniques of simulation physics, which can be extended to STEM projects Features a working introduction for those...
Springer Cham, 2023. — 159 p. — (Synthesis Lectures on Mathematics & Statistics) — eBook ISBN: 978-3-031-33886-1. Includes a step-by-step guide to Monte Carlo simulations using Microsoft Excel for the analysis and visualization Provides fundamental knowledge and techniques of simulation physics, which can be extended to STEM projects Features a working introduction for those...
Egea, 2017. - 452p. - ASIN: B06XWGV8LH 2nd.ed Excel is the most popular and widely used productivity software in all business environments, and it is an irreplaceable companion in ordinary work as well as in the analysis of large amounts of complex data. Nevertheless, the majority of users know and use only a very limited number of features, often in an elementary way. This...
Egea, 2017. - 452p. - ASIN: B06XWGV8LH 2nd.ed Excel is the most popular and widely used productivity software in all business environments, and it is an irreplaceable companion in ordinary work as well as in the analysis of large amounts of complex data. Nevertheless, the majority of users know and use only a very limited number of features, often in an elementary way. This...
Egea, 2017. - 452p. - ASIN: B06XWGV8LH 2nd.ed Excel is the most popular and widely used productivity software in all business environments, and it is an irreplaceable companion in ordinary work as well as in the analysis of large amounts of complex data. Nevertheless, the majority of users know and use only a very limited number of features, often in an elementary way. This...
Holy Macro! Books, 2006, 244 p. Рассматривается версия MS Excel 2003. Addressing a classroom teacher's need to simultaneously manage a classroom full of students, meet state-mandated assessment standards for students, and track students' performance against a rubric, this overview of Excel shows how to put its features to use immediately in a classroom. Tracking attendance,...
Holy Macro! Books, 2012. — 239 p. — ISBN: 1615470158, 9781615470150 Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the...
Файлы к книге (Collie R. DAX Formulas for PowerPivot: A Simple Guide to the Excel Revolution). Holy Macro! Books, 2012. — 239 p. — ISBN: 1615470158, 9781615470150. Файлы архивированы winrar 5.2
Holy Macro! Books, 2014. — 223 p. — ISBN: 1615470212, 9781615470211. PowerPivot is an amazing new add-in for Excel 2013 that allows business intelligence pros to process large amounts data. Although it is simple to use in a demo environment, analysts are likely to run into real-life scenarios that are difficult to solve. This guide, dedicated solely to the PowerPivot tool,...
Holy Macro! Books, 2016. — 564 p. — ISBN: 978-1-61547-039-6, 978-1-61547-226-0, 978-1-61547-349-6, 978-1-61547-126-3. True PDF Microsoft Power BI, including Power Pivot and Power Query, are a set of free add-ons to Excel that allow users to produce new kinds of reports and analyses that were simply impossible before. This book, printed in full-gorgeous color, gives you an...
Holy Macro! Books, 2016. — 308 p. — ISBN: 978-1615470396. Only Sample files! Microsoft Power BI, including Power Pivot and Power Query, are a set of free add-ons to Excel that allow users to produce new kinds of reports and analyses that were simply impossible before. This book, printed in full-gorgeous color, gives you an overview of Power BI, Power Pivot and Power Query, and...
Atlanta, Georgia: ASA Research, 2010. – 175 p. Course Information. Excel Advanced Concepts. Excel & the Internet. Functions. The IF Functions. Using Functions to Clean & Crunch data. Data Commands. Macros. Solver. Example Case Studies. Gantt Chart. Combo Chart. Organizational Chart. Portfolio – Investment Mix and Performance Tracking. Digging Deeper into Excel’s Fundamentals....
Apress, 2005. — 192 p. — ISBN: 1590595912 Excels what-if data analysis tools let you experiment with your data to project future results. In turn, these predictions will lead to better decision making and unlock the mystery of many business analysis scenarios. For example, what-if data analysis tools will enable you to forecast how lowering the price per unitwhile increasing...
Microsoft Press, 2003. — 379 p. Sharpen your data analysis skills with tools from the Microsoft Office suite. Master the tools that transform the information in spreadsheets, databases, and servers into faster, better business decisions. Packed with expert insights and practical Your Turn exercises, this essential guide shows how to use the data analysis capabilities in...
Apress, 2007. — 245 p. — ISBN: 9781590597514. Excel As Your Database guides those of you who need to manage facts and figuresyet have little experience, budget, or need for a full-scale relational database management system. Youll learn how to use Excel to enter, store, and analyze your data.This book is written and organized in a way that assumes you have some familiarity with...
New York, "Cambridge University Press", 2008, -407p.
Financial Products provides a step-by-step guide to some of the most important ideas underpinning financial mathematics. It describes and explains interest rates, discounting, arbitrage, risk neutral probabilities, forward contracts, futures, bonds, FRA and swaps. It shows howto construct both elementary and more complex...
DartnellCorp, 2017. — 416 p. — ASIN: B073P72H12. Daunted no more! Finally learn to use all the complex tools Excel has to offer. Microsoft Excel is an important tool in almost every professional environment. But most users don’t know how to take advantage of the application’s full potential. Excel is a powerhouse that can do everything from analyze complex and continuously...
DartnellCorp, 2017. — 416 p. — ASIN B073P72H12. Daunted no more! Finally learn to use all the complex tools Excel has to offer. Microsoft Excel is an important tool in almost every professional environment. But most users don’t know how to take advantage of the application’s full potential. Excel is a powerhouse that can do everything from analyze complex and continuously changing...
DartnellCorp, 2017. — 416 p. — ASIN B073P72H12. Daunted no more! Finally learn to use all the complex tools Excel has to offer. Microsoft Excel is an important tool in almost every professional environment. But most users don’t know how to take advantage of the application’s full potential. Excel is a powerhouse that can do everything from analyze complex and continuously changing...
The Dartnell Corporation, 2015. — 47 p. — ASIN B00ZCJACY8.
Analyze Complex Data more Efficiently by Mastering Excel's PivotTables!
Excel offers a huge array of data analysis features and is an important resource which businesses can use for tracking customers, finding sales trends, creating invoices, charting progress, making important calculations and doing data analyses...
Independently published, 2018. — 228 p. Microsoft Excel for Professionals covers Excel Basic to Intermediate topics such as tools, functions, formulas, tips and technique required to work efficiently and productively
Oxford University Press, Inc. – 2004, 640 pages, Corrected edition
ISBN: 0195152751, 9780195152753
Excel is by far the most widely distributed data analysis software but few users are aware of its full powers. Advanced Excel For Scientific Data Analysis takes off from where most books dealing with scientific applications of excel end. It focuses on three areas-least squares,...
Amazon Digital Services, 2017. — 125 p. — ASIN B073QSJM8P. This course builds upon the skills learned in the first course in this series DAX Power Pivot – 10 Easy Steps for Beginners. I’m going to assume you are up-to-speed with the basics but I highly recommend you check out my first eBook course first if you haven’t. You have already gotten your hands dirty with Power Pivot...
Amazon Digital Services, 2017. — 125 p. — ASIN B073QSJM8P. This course builds upon the skills learned in the first course in this series DAX Power Pivot – 10 Easy Steps for Beginners. I’m going to assume you are up-to-speed with the basics but I highly recommend you check out my first eBook course first if you haven’t. You have already gotten your hands dirty with Power Pivot...
Amazon Digital Services, 2017. — 125 p. — ASIN B073QSJM8P. This course builds upon the skills learned in the first course in this series DAX Power Pivot – 10 Easy Steps for Beginners. I’m going to assume you are up-to-speed with the basics but I highly recommend you check out my first eBook course first if you haven’t. You have already gotten your hands dirty with Power Pivot...
Independently published, 2017. — 175 p. — ISBN: 978-1520314679. How-to guide for basic and intermediate Microsoft Excel, with an emphasis on using Excel in finance applications. Coverage includes best practices, basic tools in Excel, reference and lookup functions, statistical functions, VBA macros, and user-defined functions.
Independently published, 2017. - 175p. - ISBN: 978-1520314679 How-to guide for basic and intermediate Microsoft Excel, with an emphasis on using Excel in finance applications. Coverage includes best practices, basic tools in Excel, reference and lookup functions, statistical functions, VBA macros, and user-defined functions.
Marie Eklof, 2023. — 141 p. This book will show you how to create an excel Spreadsheet from scratch. Add color to the excel spreadsheet and basic formatting. You will also learn to create Data Validation, add subjects to your data validation. You will also learn to delete data validation.
Cyan Cues, 2021. — 141 р. This book will show you how to create an excel Spreadsheet from scratch. Add color to the excel spreadsheet and basic formatting. You will also learn to create Data Validation, add subjects to your data validation. You will also learn to delete data validation. There are several reasons why I wrote this book. I wanted to have my computer notes easily...
Cyan Cues, 2021. — 141 р. This book will show you how to create an excel Spreadsheet from scratch. Add color to the excel spreadsheet and basic formatting. You will also learn to create Data Validation, add subjects to your data validation. You will also learn to delete data validation. There are several reasons why I wrote this book. I wanted to have my computer notes easily...
3rd edition. — Visual, 2010. — 368 p. — ISBN: 0470591595, 9780470591598. A great guide to Excel programming that is perfect for visual learners and takes you beyond Excel basics! This book is the perfect reference for Excel users who want to delve deeper into the application to create powerful and dynamic programs. From creating macros to customizing dialog boxes, this...
Wiley Publishing, Inc., 2007. — 259 p. Boost Your Efficiency. Work with Formulas and Functions. Copy, Format, and More. Manipulate Records. Explore the Patterns in Your Data. Create Charts. Present Worksheets. Protect. Save, and Print. Extend Excel. Customize Excel.
SAGE Publications, 2016. — 264 p. — ISBN: 978-1506303055. Written by sought-after speaker, designer, and researcher Stephanie D. H. Evergreen, Effective Data Visualization shows readers how to create Excel charts and graphs that best communicate data findings. This comprehensive how-to guide functions as a set of blueprints—supported by research and the author’s extensive...
SAGE Publications, 2016. — 264 p. — ISBN: 978-1506303055. Written by sought-after speaker, designer, and researcher Stephanie D. H. Evergreen, Effective Data Visualization shows readers how to create Excel charts and graphs that best communicate data findings. This comprehensive how-to guide functions as a set of blueprints—supported by research and the author’s extensive...
SAGE Publications, 2016. — 264 p. — ISBN: 978-1506303055. Written by sought-after speaker, designer, and researcher Stephanie D. H. Evergreen, Effective Data Visualization shows readers how to create Excel charts and graphs that best communicate data findings. This comprehensive how-to guide functions as a set of blueprints—supported by research and the author’s extensive...
2nd Edition. — SAGE Publications, 2020. — 348 p. — ISBN: 978-1544350882. Written by sought-after speaker, designer, and researcher Stephanie D. H. Evergreen, Effective Data Visualization shows readers how to create Excel charts and graphs that best communicate data findings. This comprehensive how-to guide functions as a set of blueprints―supported by research and the author’s...
2nd Edition. — SAGE Publications, 2020. — 348 p. — ISBN: 978-1544350882. Written by sought-after speaker, designer, and researcher Stephanie D. H. Evergreen, Effective Data Visualization shows readers how to create Excel charts and graphs that best communicate data findings. This comprehensive how-to guide functions as a set of blueprints―supported by research and the author’s...
2nd Edition. — SAGE Publications, 2020. — 348 p. — ISBN: 978-1544350882. Written by sought-after speaker, designer, and researcher Stephanie D. H. Evergreen, Effective Data Visualization shows readers how to create Excel charts and graphs that best communicate data findings. This comprehensive how-to guide functions as a set of blueprints―supported by research and the author’s...
Sage Alchemex. Vol 6, 2012. - 89 p.
(Автор не указан).
The book provides useful Excel 2010 techniques with the help of graphics. The reader can easily follow its content by using abundant illustrations. Short and concise, the book can be read through random pages.
Canton Local School. — 57 p.
(Выходные данные не указаны).
In Excel for Mac Product Guide, author gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others.
John Wiley and Sons, 2017. — 336 p. — (For Dummies). — ISBN 978-1-119-35754-4. Make informed business decisions with the beginner's guide to financial modeling using Microsoft Excel. Financial Modeling in Excel For Dummies is your comprehensive guide to learning how to create informative, enlightening financial models today. Not a math whiz or an Excel power-user? No problem!...
Developer: John Sokolik. This MS Excel Spreadsheet is created by mr. John Sokolik and it represents an easy way to calculate fault current by entering few values in indicated fields. You will find sheet with very nice example already fulfilled. Before starting fault current calculation, you will have to choose between Step 1a and Step 1b which are explained below. Step 1a Insert...
Microsoft Press, 2017. - 256p. - ASIN: B0713N6BBW Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these...
Microsoft Press, 2017. — 256 p. — ASIN B0713N6BBW. Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these...
Microsoft Press, 2017. — 256 p. — ASIN B0713N6BBW. True PDF Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both...
Microsoft Press, 2017. — 256 p. — ISBN: 978-1-5093-0276-5. Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both...
2nd ed. — SQLBI Corp, 2020. — 586 p. A pattern is a general, reusable solution to a frequent or common challenge. This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel.The book includes the following patterns: Time-related calculations,...
2nd ed. — SQLBI Corp, 2020. — 586 p. A pattern is a general, reusable solution to a frequent or common challenge. This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel.The book includes the following patterns: Time-related calculations,...
2nd ed. — SQLBI Corp, 2020. — 586 p. A pattern is a general, reusable solution to a frequent or common challenge. This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel.The book includes the following patterns: Time-related calculations,...
Chapman and Hall/CRC, 2017. — 300 p. — ISBN: 978-1138197152. Excel Visual Basic for Applications (VBA) can be used to automate operations in Excel and is one of the most frequently used software programs for manipulating data and building models in banks and insurance companies. An Introduction to Excel VBA Programming: with Applications in Finance and Insurance introduces...
Chapman and Hall/CRC, 2017. — 300 p. — ISBN: 978-1138197152. Excel Visual Basic for Applications (VBA) can be used to automate operations in Excel and is one of the most frequently used software programs for manipulating data and building models in banks and insurance companies. An Introduction to Excel VBA Programming: with Applications in Finance and Insurance introduces...
Pelagic Publishing, 2015. — 556 p. — ISBN: 978-1784270070. Microsoft Excel is a powerful tool that can transform the way you use data. This book explains in comprehensive and user-friendly detail how to manage, make sense of, explore and share data, giving scientists at all levels the skills they need to maximise the usefulness of their data. Readers will learn how to use Excel...
Holy Macro! Books, 2011. — 532 p. — ISBN: 978-1615470006. This enthusiastic introduction provides support for Excel beginners and focuses on using the program immediately for maximum efficiency. With 1,104 screenshots and explicit information on everything from rows, columns, and cells to subtotaling, sorting, and pivot tables, this guide aims to alleviate the frustrations that...
Holy Macro! Books, 2013. — 338 p. — ISBN: 978-1-61547-329-8 (EPUB) Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as...
Holy Macro! Books, 2013. — 338 p.— ISBN: 978-1-61547-109-6 (MOBI) Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as...
Holy Macro! Books, 2013. — 338 p. in color. — ISBN: 1615470077, 9781615470075. Файл в формате PDF, размер страницы - стандартный. Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an...
Holy Macro! Books, 2013. — 578 p. — ISBN: 978-1-61547-209-3 (PDF) Файл в формате PDF, оптимизированный для просмотра на ipad. Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an...
Holy Macro! Books, 2011. — 576 p. — ISBN: 978-1-61547-202-4. This enthusiastic introduction provides support for Excel beginners and focuses on using the program immediately for maximum efficiency. With 1,104 screenshots and explicit information on everything from rows, columns, and cells to subtotaling, sorting, and pivot tables, this guide aims to alleviate the frustrations...
Holy Macro! Books, 2011. — 576 p. — ISBN: 978-1-61547-102-7. This enthusiastic introduction provides support for Excel beginners and focuses on using the program immediately for maximum efficiency. With 1,104 screenshots and explicit information on everything from rows, columns, and cells to subtotaling, sorting, and pivot tables, this guide aims to alleviate the frustrations...
Holy Macro! Books, 2011. — 576 p. — ISBN: 978-1-61547-102-7. This enthusiastic introduction provides support for Excel beginners and focuses on using the program immediately for maximum efficiency. With 1,104 screenshots and explicit information on everything from rows, columns, and cells to subtotaling, sorting, and pivot tables, this guide aims to alleviate the frustrations...
Apress, 2014. — 216 p. — ISBN10: 1484207351, ISBN13: (electronic): 978-1-4842-0734-5. На англ. языке. Advanced Excel Essentials is the only book for the experienced Excel developer. This book starts from the assumption that you are well-versed in Excel-and builds on your skills to take them to the advanced level. It will show you the building blocks of advanced development and...
Apress, 2015. - 572p.
The book takes a hands-on approach to developing dashboards, from instructing users on advanced Excel techniques to addressing dashboard pitfalls common in the real world. Dashboards for Excel is your key to creating informative, actionable, and interactive dashboards and decision support systems. Throughout the book, the reader is challenged to think...
Apress, 2015. — 572 p. — (Series: For professionals by professionals). — ISBN-13 9781430249450. This book takes a hands-on approach to developing dashboards, from instructing users on advanced Excel techniques to addressing dashboard pitfalls common in the real world. Dashboards for Excel is your key to creating informative, actionable, and interactive dashboards and decision...
Amazon Digital Services, 2016. — 783 р. — ASIN B01HA3FB12. For a user … By a user This book is a collection of general techniques that can be easily combined to create a wide variety of spreadsheet based solutions. Written for a typical analyst/manager business owner (who spends a lot of time combining & processing inputs from different sources and then sends different outputs to...
Amazon Digital Services, 2016. — 783 р. — ASIN B01HA3FB12. For a user … By a user This book is a collection of general techniques that can be easily combined to create a wide variety of spreadsheet based solutions. Written for a typical analyst/manager business owner (who spends a lot of time combining & processing inputs from different sources and then sends different outputs to...
Amazon Digital Services, 2017. — 119 p. — ASIN: B01N7T4WDI.
People don’t stay on the same path nowadays; they have many jobs and often a few careers. Corporate loyalty is disappearing as people feel uncertain about the stability of the company they belong to and actually, what they want to do. Job security is seen as an antiquated concept and people are discovering that they...
Amazon Digital Service, 2015. — 68 p. — ASIN B00VTUNRJG. Excel is relevant for all aspects of a business and honestly, it's not hard to learn. Excel is a robust program but spreadsheets created by users are often fragile. Have you ever used Excel, submitted it and something was wrong, a slipped formulae or mistyped number? I know I have, countless times! Apparently even smart...
Amazon Digital Services, 2016. — 144 p. — ASIN B01A6468SW.
This book is for anyone who wants to be taken on a journey to learn Excel; from basic through to complex Excel functions. It doesn’t cover all functions within Excel, but gives you what I consider to be the most practical functions and how to use them. This will give you a great set of tools which you will be able to...
CreateSpace Independent Publishing Platform, 2018. — 81 p. — ISBN: N\A. This book contains a collection of tips, tricks and shortcuts presented within 20 mini-lessons. Each lesson contains step-by-step instructions for you to follow. In addition, each section contains a link to a companion video, so you can see the steps in action as well. Topics focus on functions, formulas...
CreateSpace Independent Publishing Platform, 2018. — 81 p. — ISBN: N\A. This book contains a collection of tips, tricks and shortcuts presented within 20 mini-lessons. Each lesson contains step-by-step instructions for you to follow. In addition, each section contains a link to a companion video, so you can see the steps in action as well. Topics focus on functions, formulas...
Holy Macro! Books, 2006. — 368 p. — ISBN: 1-932802-17-7. Presenting innovative Microsoft Excel techniques for top management professionals, this reference for company leaders who do not have the time to attend courses or read bulky books on the program provides basics, special shortcuts, and tips that cover the special features of Excel. Useful facts, trivia, and insider...
Amazon Digital Services LLC, 2016 — 43 p. — ASIN B01CUSXRL8. This book shows how to import and export different types of data from Excel. The focus is on working with common data types that you are most likely to see, including CSV format, raw ASCII tables, PDFs, or even images. This book walks through how to get each type of data into Excel, how to get that data out of Excel in a...
2nd.ed. - For Dummies, 2021p. - 387p. - ISBN: 1119832152 Get practical walkthroughs for the most useful Excel features Looking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you've been waiting for. This step-by-step guide is packed with exercises that walk you through the...
Wiley Publishing, Inc., 2005. — 410 p. Making Excel Work Your Way. Quick Worksheet Creation Tricks. Handy Ways to Format and Present Worksheet Data. Worksheet Formula Timesavers. Worksheet Editing Timesavers. Tips for Printing, Sharing, and Reviewing Workbooks. Streamlining Data Listing and Data Analysis. Internet-Related Timesavers. The Scary (Or Fun) Stuff.
Wiley Publishing, 2006. – 371 p. — ISBN-10: 0471798452 — ISBN-13: 978-0471798453 Язык (Language): English As its name suggests, Excel Workbook for Dummies is designed to give you the kind of hands on experience with all the major aspects of the program you need to start using the program for business or home with a certain degree of confidence and efficiency. As you’d expect...
Routledge, 2021. - 291 p. This book provides a broad introduction to the field of pricing as a tactical function in the daily operations of the firm and a toolbox for implementing and solving a wide range of pricing problems. Beyond the theoretical perspectives offered by most textbooks in the field, Essentials of Pricing Analytics supplements the concepts and models covered by...
David and Raina Hawley. Excel Hacks - Tips & Tools for Streamlining Your Spreads. O’Reilly, 2007. - 408 p. - ISBN: 978-0-596-52834-8 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...
Holy Macro! Books, 2007. - 234 pages. ISBN: 1932802150
This guide to enabling middle-grade mathematics teachers to use Microsoft Excel in the classroom focuses primarily on concepts taught in grades 4–10, with some pre-algebra lessons for higher grades. Including files available for downloading to create custom math worksheets, build self-grading interactive spreadsheets, and...
Independently published, 2019. — 344 p. — ISBN: 1672169852. Do you want to become an Expert in Microsoft Excel? Is your dream to become an advanced Excel Macro specialist? Whatever your answer may be, I am sure you wouldn’t pass up the opportunity to find out more about the subject. With Excel VBA & Excel Pivot Tables Crash Course , you can take your Excel skills to a whole new...
Jones & Bartlett Learning – 2006, 417 pages
ISBN: 159822011X, 9781598220117
Easy To Use And Equipped With A Variety Of Functions, Microsoft Excel Is The Tool Of Choice When It Comes To Crunching Numbers, Building Charts, And Analyzing Tables. But Most Users Only Scratch The Surface Of The Program’S Functionality, Especially The Built-In Formulas Designed To Make Everyday...
3rd Edition. — Mercury Learning and Information, 2014. — 450 p. — ASIN: B00Q7CP6WM, ISBN: 978-1-937585-50-1. In this completely updated edition covering Excel 2013 and previous versions, Microsoft Excel Functions & Formulas 3/e demonstrates the secrets of Excel through the use of practical and useful examples in a quick reference format. Easy to use and equipped with a variety...
3rd Edition. — Mercury Learning and Information, 2015. — 450 p. — ISBN: 978-1-937585-50-1. In this completely updated edition covering Excel 2013 and previous versions, Microsoft Excel Functions & Formulas 3/e demonstrates the secrets of Excel through the use of practical and useful examples in a quick reference format. Easy to use and equipped with a variety of functions,...
5th Edition. — Mercury Learning & Information, 2019. — 498 р. In this completely updated edition covering Excel 2019, previous versions, and Office 365, Microsoft Excel Functions & Formulas 5/E demonstrates the secrets of Excel through the use of practical and useful examples in a quick reference format. Easy to use and equipped with a variety of functions, Microsoft Excel is the...
Liaw Hock Sang, 2017. — 177 p. — ASIN: B01MZ6I7L2 No matter how complicated a program is, it is made of many smaller and tiny fundamental working parts of programming code. Each of them accomplishes a specific task. Some may just consist of only one or a few lines of code. Knowing the functions of these fundamental working parts, you can then easily write an unlimited number of...
Independently published, 2024. — 63 p. — ISBN-13 979-8322369486. Transform your data analysis journey from theory to action with this first in a new series of Guided Projects: a hands-on guide that applies your Excel prowess to the real world of healthcare data analytics. After laying the groundwork with 'Data Analysis in Microsoft Excel,' it’s time to elevate your skills from...
Independently published, 2024. – 63 p. – ISBN-13 979-8322369486. Transform your data analysis journey from theory to action with this first in a new series of Guided Projects: a hands-on guide that applies your Excel prowess to the real world of healthcare data analytics. After laying the groundwork with 'Data Analysis in Microsoft Excel,' it’s time to elevate your skills from...
CRC Press, Taylor & Francis Group, 2006. — XIV, 223 p. — ISBN13: 978-1-4200-0719-0 (eBook - PDF) English | ISBN: 0849373263 | | 248 pages | PDF | 7 MB http://avxhome.se/ebooks/engeneering_technology/0849373263.html With the many software packages available today, it's easy to overlook the computational and graphics capabilities offered by Microsoft Excel. The software is nearly...
2nd ed. — CRC Press, 2017. — 192 p. — ASIN B076DK4Z3B. Understanding the powerful computational and graphics capabilities of Microsoft Excel is an enormous benefit to engineers and technical professionals in almost any field and at all levels of experience. What Every Engineer Should Know About Excel is a practical guide to unlocking the features and functions of this program,...
2nd ed. — CRC Press, 2017. — 192 p. — ASIN B076DK4Z3B. Understanding the powerful computational and graphics capabilities of Microsoft Excel is an enormous benefit to engineers and technical professionals in almost any field and at all levels of experience. What Every Engineer Should Know About Excel is a practical guide to unlocking the features and functions of this program,...
2nd ed. — CRC Press, 2017. — 192 p. — ASIN B076DK4Z3B. Understanding the powerful computational and graphics capabilities of Microsoft Excel is an enormous benefit to engineers and technical professionals in almost any field and at all levels of experience. What Every Engineer Should Know About Excel is a practical guide to unlocking the features and functions of this program,...
Packt, 2020. — 402 p. — ISBN: 9781838824303. Implement business intelligence (BI), data modeling, and data analytics within Microsoft products such as Power BI, SQL Server, and Excel Key Features Understand DAX, from the basics through to advanced topics, and learn to build effective data models Write and use DAX functions and expressions with the help of hands-on examples...
Packt, 2020. — 402 p. — ISBN: 9781838824303. Implement business intelligence (BI), data modeling, and data analytics within Microsoft products such as Power BI, SQL Server, and Excel Key Features Understand DAX, from the basics through to advanced topics, and learn to build effective data models Write and use DAX functions and expressions with the help of hands-on examples...
Packt, 2020. — 402 p. — ISBN: 9781838824303. Implement business intelligence (BI), data modeling, and data analytics within Microsoft products such as Power BI, SQL Server, and Excel Key Features Understand DAX, from the basics through to advanced topics, and learn to build effective data models Write and use DAX functions and expressions with the help of hands-on examples...
Springer, 2021. - 427p. - ISBN: 9783030710354 Excel Crash Course for Engineers is a reader-friendly introductory guide to the features, functions, and applications of Microsoft Excel in engineering. The book provides readers with real-world examples and exercises that are directly related to engineering, and offers highly illustrated, step-by-step demonstrations of techniques...
Springer, 2021. - 427p. - ISBN: 9783030710354 Excel Crash Course for Engineers is a reader-friendly introductory guide to the features, functions, and applications of Microsoft Excel in engineering. The book provides readers with real-world examples and exercises that are directly related to engineering, and offers highly illustrated, step-by-step demonstrations of techniques...
Springer, 2021. — 254 p. — ISBN 978-3-030-71035-4. Excel Crash Course for Engineers is a reader-friendly introductory guide to the features, functions, and applications of Microsoft Excel in engineering. The book provides readers with real-world examples and exercises that are directly related to engineering, and offers highly illustrated, step-by-step demonstrations of...
Springer, 2021. — 254 p. — ISBN 978-3-030-71035-4. Excel Crash Course for Engineers is a reader-friendly introductory guide to the features, functions, and applications of Microsoft Excel in engineering. The book provides readers with real-world examples and exercises that are directly related to engineering, and offers highly illustrated, step-by-step demonstrations of...
Mercury Learning and Information, 2021. — 328 p. — ISBN: 978-1-68392-772-3. Created as a book for a first-time or beginning Excel user, it is designed to be a comprehensive, yet accessible and easy to understand introduction to using and mastering Microsoft Excel 2019 and previous versions. Starting with the basics of what spreadsheets are, and progressing through the...
Mercury Learning and Information, 2021. — 328 p. — ISBN: 978-1-68392-772-3. Created as a book for a first-time or beginning Excel user, it is designed to be a comprehensive, yet accessible and easy to understand introduction to using and mastering Microsoft Excel 2019 and previous versions. Starting with the basics of what spreadsheets are, and progressing through the...
Mercury Learning and Information, 2021. — 328 p. — ISBN: 978-1-68392-772-3. Created as a book for a first-time or beginning Excel user, it is designed to be a comprehensive, yet accessible and easy to understand introduction to using and mastering Microsoft Excel 2019 and previous versions. Starting with the basics of what spreadsheets are, and progressing through the...
Mercury Learning and Information, 2021. — 328 p. — ISBN: 978-1-68392-772-3. Created as a book for a first-time or beginning Excel user, it is designed to be a comprehensive, yet accessible and easy to understand introduction to using and mastering Microsoft Excel 2019 and previous versions. Starting with the basics of what spreadsheets are, and progressing through the...
2nd edition. — Luxembourg, 2016. — 134 p.— ASIN: B01C87EXDM. If you're looking for a "special souse" to improve your Excel skills, but never found it, then you'll be interested in this book. First, however, I need to know: Does any of these sound familiar? I have a corporate job where I work with data in Microsoft Excel. However, it takes me lots of time to process the data...
Independently published, 2021. — 355 p. — ISBN B08WPMFWXM. This is a self pace learning guide of MS Excel for everyone who wants to “Learn” or “Excel” in MS Excel. It explains approx. 95% features of MS Excel. The book is divided into 5 sections followed by Glossary of shortcuts in MSExcel Introduction To MS Excel – Meant for Beginners. MS Excel – Basic – The learners who have...
Independently published, 2021. — 355 p. — ISBN B08WPMFWXM. This is a self pace learning guide of MS Excel for everyone who wants to “Learn” or “Excel” in MS Excel. It explains approx. 95% features of MS Excel. The book is divided into 5 sections followed by Glossary of shortcuts in MSExcel Introduction To MS Excel – Meant for Beginners. MS Excel – Basic – The learners who have...
2nd.ed. - Holy Macro! Books, 2020. - 90p. - ISBN: 9781615472659 New for Office 365 customers, one single formula sitting in one single cell can return many results. Those extra results will spill into adjacent cells. This is a major change to the calculation engine in Excel. This book covers the new functions added for Dynamic Arrays: SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and...
2nd.ed. - Holy Macro! Books, 2020. - 90p. - ISBN: 9781615472659 New for Office 365 customers, one single formula sitting in one single cell can return many results. Those extra results will spill into adjacent cells. This is a major change to the calculation engine in Excel. This book covers the new functions added for Dynamic Arrays: SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and...
2nd.ed. - Holy Macro! Books, 2020. - 90p. - ISBN: 9781615472659 Code files only! New for Office 365 customers, one single formula sitting in one single cell can return many results. Those extra results will spill into adjacent cells. This is a major change to the calculation engine in Excel. This book covers the new functions added for Dynamic Arrays: SORT, SORTBY, FILTER,...
Holy Macro! Books, 2018. — 57 p. — ISBN: 978-1-61547-265-9 PDF, 978-1-61547-377-9 EPUB, 978-1-61547-165-2 MOBI. Книга не является исчерпывающим руководством. Рассказано о сути новых динамических массивов, анонсированных 24 сентября 2018 года, а также представлены 7 новых функций (SINGLE, SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY) и раскрыты перспективы их...
Holy Macro! Books, 2018. - 224p. - ISBN: 978-1615470563 The 54 essential tips that all Excel users need to know. MrExcel LIVe provides users with a concise book that can be absorbed in under an hour. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.
Holy Macro! Book, 2019. - 218p. - ISBN: 1615470638 These are the 125 essential tips that all Excel users need to know. MrExcel LX provides users with a concise book that can be absorbed in under two hours. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.
Holy Macro! Book, 2019. - 218p. - ISBN: 1615470638 These are the 125 essential tips that all Excel users need to know. MrExcel LX provides users with a concise book that can be absorbed in under two hours. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.
Holy Macro! Books, 2016. — 920 p. Updating the previous edition's tips to include features in Excel 2016, this new edition of MrExcel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. MrExcel then walks readers through the specific steps to...
Holy Macro! Books, 2017. — 553 p. — ISBN: 978-1615470495. Updating the previous edition's tips to include features in Excel 2016, this new edition of MrExcel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. MrExcel then walks readers...
Chicago, IL: Holy Macro! Books, 2015. — 290 p. — ISBN: 978-1-61547-004-2. The 40 essential tips that all Excel users need to know. Crowdsourced by more than 300 contributors who collaborated on choosing the 40 best Excel tips, MrExcel XL provides users with a concise book that can be absorbed in under an hour. Includes a bonus 30 tips, keyboard shortcuts, Excel jokes, Excel...
2009 by Bill Jelen. Published by: Holy Macro! Books. ISBN 978-1-932802-49- 8. (250 pages). Content: Section 1 - Formulas - Section 2 - Techniques - Section 3 - Macros. This book is filled with the bizarre and arcane. If you polled 1000 people who use Excel 20+ hours a week, there are probably only 2 who would find this book fascinating. If you've ever wondered why people press...
Published by: Holy Macro! Books. 2008 by Bill Jelen. First Printing: November 2007 Author: Bill Jelen Editors: Kitty Jarrett Interior Design: Cass White Cover Design: Shannon Mattiza, 6Ft4 Productions Illustrations: Bob DAmico, Millenium Design Group Cover Photo: Dallas Wallace, Paramount Photo. Pages : 930. ISBN 978-1-932802-27-6 Content : The EXCELl ENVIRONMENT - CALCULATING...
Holly Macro! Books, 2005. — 131 p. The History of Spreadsheets. 25 Wonders of the Spreadsheet World. Cool Things People Do with Excel. 25 Cool Things You Can Do with Excel.
3 Auflage. — O’Reilly GmbH & Co. KG, 2013. — 978 s. — True PDF. — ISBN: 3866452357.
На нем. языке.
Der Top-Seller jetzt auch für Excel 2013. Funktionen sind eines der leistungsfähigsten Werkzeuge innerhalb von Microsoft Excel. Allerdings bedarf es eines guten Verständnisses Ihrer Arbeitsweise, Möglichkeiten und genauen Bedeutung. Hier finden Sie alle Excel-Funktionen seit der...
Self-Published by A. T. Johnson, 2023. — 91 p. Excel For Beginners 2024 - From Beginner To Expert, From Zero to Hero An Easy Steps-By-Steps illustration Guide To Master Microsoft Excel From Beginning To Pro In Less Than 7 Days by A. T. Johnson is an excellent Excel handbook and great beginner resource as well. Microsoft Excel is an incredibly powerful tool both for personal use...
Digidiscover, 2020. — 127 p. Learn how to use Microsoft Excel with this helpful guide. Packed full of useful tips and clear explanations, fully illustrated with revision exercises after each chapter. Learn how to: •Create, edit and format charts •Link cells, worksheets and workbooks •Use complex functions and formulas •Apply auditing techniques and data validation •Create and...
Apress, 2015. - 572p. - ISBN: 978-1-4302-4945-0 Only sample files The book takes a hands-on approach to developing dashboards, from instructing users on advanced Excel techniques to addressing dashboard pitfalls common in the real world. Dashboards for Excel is your key to creating informative, actionable, and interactive dashboards and decision support systems. Throughout the...
Amazon Digital Service, 2017. - 225p. - ASIN: B0722PYYB9 Do You Want to Learn Microsoft Office Excel Spreadsheet Management up to the Professional and Advance Level? Then Designing Professional Spreadsheet Management Systems Using Microsoft Excel 2013 and 2016! written by Kelly Joseph is the all-in-one tutorial book to help you achieve your goals in Spreadsheet management and...
Amazon Digital Service, 2017. - 225p. - ASIN: B0722PYYB9 Do You Want to Learn Microsoft Office Excel Spreadsheet Management up to the Professional and Advance Level? Then Designing Professional Spreadsheet Management Systems Using Microsoft Excel 2013 and 2016! written by Kelly Joseph is the all-in-one tutorial book to help you achieve your goals in Spreadsheet management and...
K2 Enterprises. – 34 p. (Автор и год издания не указаны). Most accountants are very comfortable with Microsoft Excel and several consider themselves advanced users. Unfortunately, even the advanced users are frequently not aware of dozens of highly-useful features and techniques because they are self taught. Based on over 20 years of using and teaching spreadsheets to...
Elsevier, 2004. — 382 p. The spreadsheet has become a ubiquitous engineering tool, and Microsoft Excel is the standard spreadsheet software package. Over the years, Excel has become such a complex program that most engineers understand and use only a tiny part of its power and features. This book is aimed at electronics engineers and technicians in particular, showing them how...
Apress, 2022. - 234 p. - ISBN 148428965X. Understand the power of dynamic arrays : a single formula can generate new and vastly more efficient spreadsheet possibilities. This book introduces spreadsheet users to dynamic array functions in Microsoft Excel 365 , defines and details the distinctive ways in which they work, and shows how they can be applied to a wide swath of...
Apress, 2023. — 229 p. — eBook ISBN 978-1-4842-8966-2. Understand the power of dynamic arrays: a single formula can generate new and vastly more efficient spreadsheet possibilities. This book introduces spreadsheet users to dynamic array functions in Microsoft Excel 365, defines and details the distinctive ways in which they work, and shows how they can be applied to a wide...
Apress Media, LLC,, 2023. — 247 p. — ISBN 978-1-4842-8966-2. Understand the power of dynamic arrays: a single formula can generate new and vastly more efficient spreadsheet possibilities. This book introduces spreadsheet users to dynamic array functions in Microsoft Excel 365, defines and details the distinctive ways in which they work, and shows how they can be applied to a...
Apress Media, LLC,, 2023. — 247 p. — ISBN 978-1-4842-8966-2. Understand the power of dynamic arrays: a single formula can generate new and vastly more efficient spreadsheet possibilities. This book introduces spreadsheet users to dynamic array functions in Microsoft Excel 365, defines and details the distinctive ways in which they work, and shows how they can be applied to a...
Liew Voon Kiong, 2012. - 99p. - ASIN: B007EO0L68 Excel VBA MADE EASY is the Book written by the AUTHOR and WEBMASTER of the top Excel VBA tutorial in the web. It covers the basics of Excel VBA using many examples and sample programs. You will learn Excel VBA easily with this book as It is written in simple and plain English. By reading this book, everyone should be able to...
Liew Voon Kiong, 2012. - 99p. - ASIN: B007EO0L68 Excel VBA MADE EASY is the Book written by the AUTHOR and WEBMASTER of the top Excel VBA tutorial in the web. It covers the basics of Excel VBA using many examples and sample programs. You will learn Excel VBA easily with this book as It is written in simple and plain English. By reading this book, everyone should be able to...
O’Reilly Media, 2006. — 264 p. — ISBN 0596100736, 9780596100735. Containing many advanced features, yet simple to navigate, Excel is one of the most widely used desktop applications today. This guide for managers, accountants, and other business professionals explains how to apply Excel's statistical and programming capabilities to specific kinds of business problems. Topics...
Apress, 2023. — 260 p. Gather and analyze data successfully, identify trends, and then create overarching strategies and actionable next steps - all through Excel. This book will show even those who lack a technical background how to make advanced interactive reports with only Excel at hand. Advanced visualization is available to everyone, and this step-by-step guide will show...
Apress Media, LLC, 2023. — 260 p. — ISBN: 978-1-4842-8942-6. Gather and analyze data successfully, identify trends, and then create overarching strategies and actionable next steps - all through Excel. This book will show even those who lack a technical background how to make advanced interactive reports with only Excel at hand. Advanced visualization is available to everyone,...
Apress Media, LLC, 2023. — 260 p. — ISBN: 978-1-4842-8942-6. Gather and analyze data successfully, identify trends, and then create overarching strategies and actionable next steps - all through Excel. This book will show even those who lack a technical background how to make advanced interactive reports with only Excel at hand. Advanced visualization is available to everyone,...
Apress Media, LLC, 2023. — 260 p. — ISBN: 978-1-4842-8942-6. Gather and analyze data successfully, identify trends, and then create overarching strategies and actionable next steps - all through Excel. This book will show even those who lack a technical background how to make advanced interactive reports with only Excel at hand. Advanced visualization is available to everyone,...
Vijay Kumar, 2016. — 150 p. — ASIN B01DOHSU84. To be good at Excel you should have a better understanding of the various formulas in Excel, after all Excel is about manipulating data. The best way to do this is go through each formula examples so that you will gain more experience. This book provides more than 140 Formulas and there use with example workbook for you to...
Amazon Digital Services , 2016. - 756p. - ASIN: B01I4RC2B0 Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993,...
Amazon Digital Services , 2016. - 756p. - ASIN: B01I4RC2B0 Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993,...
Amazon Digital Services , 2016. - 756p. - ASIN: B01I4RC2B0 Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993,...
Wiley, 2021. — 352 p. — ISBN-13 978-1119698722. Large corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are looking to these tools in order to cut costs for budgetary reasons. An effective analyst not only has to have the technical skills to use Excel in a productive manner but must be able...
Wiley, 2021. — 352 p. — ISBN-13 978-1119698722. Large corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are looking to these tools in order to cut costs for budgetary reasons. An effective analyst not only has to have the technical skills to use Excel in a productive manner but must be able...
For Dummies, 2022. - 336p. - ISBN: 1119844436 Save time and become an Excel wizard with the world's leading Excel macro guide Do you love Excel and all the things you can do with it, but wish you could just work...faster? Excel macros—automated workflows that save you time and energy—might be just what you need. In Excel Macros For Dummies, you'll learn over 70 of the most...
6th Edition. — John Wiley & Sons, Inc., For Dummies, — 2022. — 435 p. — ISBN-13 9781119843078. Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies...
Independently published, 2023. — 153 S. Die leichte Tipps + Tricks-Reihe mit mehreren Teilen von Wissenssprung! 1000-fach in zahlreichen Bildungseinrichtungen bewährt optimal zum Selbstlernen, auch für Senioren 410 Bilder! alle Schritte sind Mausklick für Mausklick beschrieben fast jeder Schritt ist bebildert sehr detaillierte Schritt-für-Schritt-Anleitungen sehr einfach und...
Independently published, 2023. — 153 S. Die leichte Tipps + Tricks-Reihe mit mehreren Teilen von Wissenssprung! 1000-fach in zahlreichen Bildungseinrichtungen bewährt optimal zum Selbstlernen, auch für Senioren 410 Bilder! alle Schritte sind Mausklick für Mausklick beschrieben fast jeder Schritt ist bebildert sehr detaillierte Schritt-für-Schritt-Anleitungen sehr einfach und...
Flame Tree Publishing, 2016, -128 p. - ASIN: B01IR7ZI7W.
Microsoft Excel is an incredible application, feature-rich and easy to use if you know how. It can help with the simplest of jobs, from shopping lists to presentation of data, to more complex formulas and sorting tasks. Everyone in business, or indeed, in almost any job, needs to know how to use this fundamental modern...
Microsot press, 2020. — 176 p. — ISBN: 9780136627296. Advance your everyday proficiency with Excel! And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation for...
Microsot press, 2020. — 176 p. — ISBN: 9780136627296. !Sample files only Advance your everyday proficiency with Excel! And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers:...
Microsot press, 2020. — 176 p. — ISBN: 9780136627296. Conv! Advance your everyday proficiency with Excel! And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation...
Microsoft Press, 2020. — 198 p. — ISBN: 978-0-13-662715-9. A Microsoft Office Specialist (MOS): Expert certification validates your hands-on experience and competency with an Office product at an expert level. It demonstrates that you can apply the product's principal features at an advanced level, can complete expert tasks independently, and are ready to enter the job market.
Microsoft Press, 2020. — 198 p. — ISBN: 978-0-13-662715-9. A Microsoft Office Specialist (MOS): Expert certification validates your hands-on experience and competency with an Office product at an expert level. It demonstrates that you can apply the product's principal features at an advanced level, can complete expert tasks independently, and are ready to enter the job market.
2nd ed. — In 30 Minutes Guides, 2015. — 66 p. in color. — ISBN: 1939924308, 9781939924308
The second edition is up-to-date with new instructions and high-resolution screenshots of Excel 2013, Excel Online, and the new Google Sheets. Here are some real reader reviews of Excel Basics In 30 Minutes: “Fast and easy, this book is everything it claims to be. The material presented is...
Fourth Edition. — Pearson, 2013. — 718 p. — ISBN: 978-0-13-278865-6. For introductory courses in Engineering and Computing Based on Excel 2010, Engineering with Excel, 4e takes a comprehensive look at using Excel in engineering. This book focuses on applications and is intended to serve as both a textbook and a reference for students. Introduction To Excel Using Excel’S Ribbon...
Springer, 2016. — 1043 p. — ISBN: 978-3-319-38865-6 This introductory textbook for business statistics teaches statistical analysis and research methods via business case studies and financial data using Excel, MINITAB, and SAS. Every chapter in this textbook engages the reader with data of individual stock, stock indices, options, and futures. One studies and uses statistics...
CreateSpace Independent Publishing Platform, 2017. — 246 p. — ISBN10: 1543187242. — ISBN13: 978-1543187243. Preview ebook The third installment in the Excel University series picks up right where Volume 2 leaves off. In the final exercise of Volume 2, we created a formula-based report that required several features and functions. In Volume 3, we build that same report without...
Remylent, 2021, — 111 р. Excel makes life easier because its powerful functions are easily accessible. With the spreadsheet you can handle numbers, dates, formulas or simply text. This book will be an asset to improve your skills by learning more complex functions and finally to save a lot of time. The examples presented in this manual will help you to analyse data better. Do...
Remylent, 2021, — 111 р. Excel makes life easier because its powerful functions are easily accessible. With the spreadsheet you can handle numbers, dates, formulas or simply text. This book will be an asset to improve your skills by learning more complex functions and finally to save a lot of time. The examples presented in this manual will help you to analyse data better. Do...
IOP Publishing, Morgan & Claypool Publishers, 2016. — 92 p. — (IOP concise physics). — ISBN 9781681744636. This work will introduce the reader to Visual Basic for Applications (VBA) and demonstrate how it can greatly enhance Microsoft Excel by giving users the ability to make their own functions that can be used within a worksheet, and to create subroutines to perform...
Norman Ling, 2016. — 169 p. — ASIN: B01AZN9KVQ.
Do you have an upcoming interview involving an Excel assessment? Are you looking to sharpen up your Excel skills? Are you looking to land that prestigious corporate position that will jump start your career? Whether you are a college student or a seasoned professional, Excel Interview Workbook will teach you exactly what you need...
Microsoft Press Deutschland, 2014. — 777 p. — ISBN: 3866454708, ISBN: 978-3-8483-0192-8. На нем. языке. VBA-Experte Mourad Louha und Monika Weber haben in diesem umfassenden Lehr- und Nachschlagewerk zur Excel-Programmierung ihr Wissen gebündelt und unterstützen den Leser Schritt für Schritt beim Erlernen der Excel VBA Programmierung. Von den grundlegenden Programmiertechniken...
Grosvenor House Publishing Ltd, 2024. — 116 p. — ISBN 978-1-098-17570-2. Excel не умер: новый способ работы с электронными таблицами Excel. A new way of working with Excel spreadsheets never seen before that will transform how we work with Excel now and in the future. A game changing system of data manipulation based on a single discovery. This book will take you step by step...
BPB Publications, 2023. — 270 р. — ISBN-13 978-93-55513-786. Improve your daily work efficiency and productivity using Microsoft Excel. Key Features: Get familiar with some of the most useful basic and advanced features in Excel. Discover important Excel functions that can quickly and easily perform calculations and analysis. Get tips and tricks to become an expert in...
BPB Publications, 2023. — 270 р. — ISBN-13: 978-93-55513-786. Improve your daily work efficiency and productivity using Microsoft Excel. Key Features: Get familiar with some of the most useful basic and advanced features in Excel. Discover important Excel functions that can quickly and easily perform calculations and analysis. Get tips and tricks to become an expert in...
BPB Publications, 2023. — 270 р. — ISBN-13 978-93-55513-786. Improve your daily work efficiency and productivity using Microsoft Excel. Key Features: Get familiar with some of the most useful basic and advanced features in Excel. Discover important Excel functions that can quickly and easily perform calculations and analysis. Get tips and tricks to become an expert in...
BPB Publications, 2023. — 270 р. — ISBN 978-9355513786. Microsoft Excel is one of the most significant and widely used tools in various professions and industries. If you want to master Excel, then this book is for you.This book focuses on Excel formulas and functions that transform Excel from a simple spreadsheet into a dynamic and powerful analytics data source for business...
4th ed. — For Dummies, 2018. — 352 p. — ISBN: 978-1119518167. Take Excel to the next level. Excel is the worlds leading spreadsheet application. Its a key module in Microsoft Office”the number-one productivity suite”and it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and...
Microsot press, 2020. — 192 p. — ISBN: 0136627528 A Microsoft Office Specialist (MOS): Expert certification validates your hands-on experience and competency with an Office product at an expert level. It demonstrates that you can apply the product’s principal features at an advanced level, can complete expert tasks independently, and are ready to enter the job market.
Microsot press, 2020. — 192 p. — ISBN: 0136627528 A Microsoft Office Specialist (MOS): Expert certification validates your hands-on experience and competency with an Office product at an expert level. It demonstrates that you can apply the product’s principal features at an advanced level, can complete expert tasks independently, and are ready to enter the job market.
Microsoft Press, 2020. — 192 p. — ISBN: 0136627528. !Sample files only A Microsoft Office Specialist (MOS): Expert certification validates your hands-on experience and competency with an Office product at an expert level. It demonstrates that you can apply the product’s principal features at an advanced level, can complete expert tasks independently, and are ready to enter the...
Wiley, Hoboken, 2022. — 787 p. — ISBN: 978-1-119-83072-6. Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft Excel Microsoft Excel offers unsurpassed functionality and accessibility for data exploration and analysis to millions of users around the world. And learning to unlock its full potential is easier than you can imagine with...
5th Edition. — Wiley, 2022. — 368 р. Turn jumbles of numbers into graphics, insights, and answers with Excel With Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualizing, and analyzing data. PivotTables, charts, what-if analysis, statistical...
5th Edition. — Wiley, 2022. — 368 р. Turn jumbles of numbers into graphics, insights, and answers with Excel. With Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualizing, and analyzing data. PivotTables, charts, what-if analysis, statistical...
4th Ed. — John Wiley & Sons, Ltd. , 2018. — 353 p. — (For Dummies). — ISBN: 9781119518167, ASIN 1119518164. Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data sets. In no time, you'll discover how to mine and analyze critical data in order to make more informed business decisions. Work with external databases, PivotTables, and...
2nd Edition. — Wiley Publishing, Inc. 2010. — 307 p. PivotTables and PivotCharts, including: Building a basic PivotTable? report Pivoting fields to different areas Filtering PivotTable data Organizing PivotTable data into groups Formatting a PivotTable Changing the summary calculation Creating custom calculations Publishing a PivotTable to the Web Creating a PivotChart? from a...
Microsot press, 2020. — 217 p. — ISBN: 978-0-13-662752-4. Advance your expert-level proficiency with Excel. And earn the credential that proves it! Demonstrate your expert-level competency with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Microsoft Excel Expert (Excel and Excel 2019) certification, this official Study Guide delivers:...
Microsot press, 2020. — 217 p. — ISBN: 978-0-13-662752-4. Advance your expert-level proficiency with Excel. And earn the credential that proves it! Demonstrate your expert-level competency with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Microsoft Excel Expert (Excel and Excel 2019) certification, this official Study Guide delivers:...
John Wiley & Sons, 2022. — 309 p. — ISBN 978-1-119-93362-5. In Teach Yourself VISUALLY: Excel 365, veteran tech educator and writer Paul McFedries delivers a practical, step-by-step guide to using the latest version of the world’s most popular spreadsheet app. The book is filled with easy two-page lessons containing large-size screenshots and walkthroughs demonstrating common...
Apress, 2021. — 284 p. — ISBN 9781484266120. This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade the quality of your data analysis, dashboards, models, and templates. The...
Apress, 2021. — 284 p. — ISBN 9781484266120. This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade the quality of your data analysis, dashboards, models, and templates. The...
Б.м.: HENRY E. MEJIA, 2020. — 113 p. Welcome to a new Excel NINJA book! The fastest, the most practicebased and definitely the most straightforward Excel Book Series you will ever find! You will learn to use with confidence the most important and useful Excel Formulas. Excel Ninja Series is all about this: Learning fast Having fun while learning Learning trough practice (from...
Independently published, 2019. — 101 p. — ISBN: 978-1799147565, 1799147568. This is the 3rd Book in the Excel Champions series! Becoming an Excel Pivot Tables Champion increases your chances professional growth! If you don't believe me, continue reading. Have you ever wanted to summarize a massive Database? Pivot Tables in excel are absolutely one of the best tools, the...
Independently published, 2019. — 101 p. — ISBN: 978-1799147565, 1799147568. This is the 3rd Book in the Excel Champions series! Becoming an Excel Pivot Tables Champion increases your chances professional growth! If you don't believe me, continue reading. Have you ever wanted to summarize a massive Database? Pivot Tables in excel are absolutely one of the best tools, the...
Independently published, 2019. — 101 p. — ISBN: 978-1799147565, 1799147568. This is the 3rd Book in the Excel Champions series! Becoming an Excel Pivot Tables Champion increases your chances professional growth! If you don't believe me, continue reading. Have you ever wanted to summarize a massive Database? Pivot Tables in excel are absolutely one of the best tools, the...
Independently published, 2019. — 101 p. — ISBN: 978-1799147565, 1799147568. This is the 3rd Book in the Excel Champions series! Becoming an Excel Pivot Tables Champion increases your chances professional growth! If you don't believe me, continue reading. Have you ever wanted to summarize a massive Database? Pivot Tables in excel are absolutely one of the best tools, the...
Independently published, 2019. — 101 p. — ISBN: 978-1799147565, 1799147568. This is the 3rd Book in the Excel Champions series! Becoming an Excel Pivot Tables Champion increases your chances professional growth! If you don't believe me, continue reading. Have you ever wanted to summarize a massive Database? Pivot Tables in excel are absolutely one of the best tools, the...
No publisher, 2018. — 143 p. This is the 1st Book in the Excel Champions series! Becoming an Excel Vlookup Champion increases your chances professional growth! If you don't believe me, continue reading. “The Only Excel Vlookup book you will ever need" - Sales Manager of an Oil Products Manufacturing Company Using excel vlookup is an unbelievable advantage because you can get...
MyExcelOnline.com, 2019. — 488 р. Learn the Most Popular Excel Formulas Ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus Many More! With this book, you’ll learn to apply the must know Excel Formulas & Functions to make your data analysis & reporting easier and will save time in the process. With this book you get the following: 101 Ready Made Formulas Covering:...
MyExcelOnline.com, 2019. — 594 р. Learn the Most Popular Excel Formulas Ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus Many More! With this book, you’ll learn to apply the must know Excel Formulas & Functions to make your data analysis & reporting easier and will save time in the process. With this book you get the following: 101 Ready Made Formulas Covering:...
Microsoft Corp ., 2013. – 53 p. (Автор не указан). GeoFlow is a three dimensional (3-D) data visualization tool for Microsoft Excel 2013 that provides a powerful method for people to look at information in new ways. It enables the data discoveries that might not be seen in traditional two dimensional (2-D) tables and charts. With GeoFlow you can plot geographic and temporal...
Microsoft Corp., 2012. - 16 p. The Microsoft Office File Formats documentation provides detailed technical specifications for file formats implemented in certain Microsoft Office applications, including the binary file formats created by Microsoft Word, Microsoft Excel, and Microsoft PowerPoint and the Outlook Personal Folders (.pst) file format. Technical specifications for...
Microsoft Corp., 2012. - 1183 p. The Microsoft Office File Formats documentation provides detailed technical specifications for file formats implemented in certain Microsoft Office applications, including the binary file formats created by Microsoft Word, Microsoft Excel, and Microsoft PowerPoint and the Outlook Personal Folders (.pst) file format. Technical specifications for...
Microsoft Corp., 2012. - 1177 p. The Microsoft Office File Formats documentation provides detailed technical specifications for file formats implemented in certain Microsoft Office applications, including the binary file formats created by Microsoft Word, Microsoft Excel, and Microsoft PowerPoint and the Outlook Personal Folders (.pst) file format. Technical specifications for...
Практическое пособие от компании Microsoft Corporation. Пер. с англ. — М.: Эком, 1999. — 472 с.: ил. Очередная книга широко известной серии обучающих пособий «Шаг за шагом» посвящена новой версии популярной программы Excel. Версия Excel 2000 входит в состав пакета Office 2000 и содержит множество новых функций, делающих программу еще более удобным и производительным...
Www.capesoft.com, 2015. — 68 p. (Автор не указан). Подробное руководство по созданию макросов для программы MS Excel на языке VBA. Описана объектная модель программы MS Excel, и приведены многочисленные примеры макросов для этой программы. Templates Add an Excel Object Import From Excel templates. Classes The oiExcel Class Methods Properties Equates Dll Functions Useful...
O’Reilly Media, 2010. — 448 p. — ISBN: 0596807694, 978059680769 Do you use Excel for simple lists, but get confused and frustrated when it comes to actually doing something useful with all that data? Stop tearing your hair out: Head First Excel helps you painlessly move from spreadsheet dabbler to savvy user. Whether you're completely new to Excel or an experienced user looking...
SSMI International, 2017. - 226p. - ASIN: B06XRKNPW1 This book will not make you an ordinary Excel expert. After all, you have a full time job and Excel is just a tool to help you do it better, right? However, research shows that some 90% of spreadsheets contain errors—often serious mistakes, which destroy the value of their models. This prevents you from getting the full benefit...
SSMI International, 2017. - 226p. - ASIN: B06XRKNPW1 This book will not make you an ordinary Excel expert. After all, you have a full time job and Excel is just a tool to help you do it better, right? However, research shows that some 90% of spreadsheets contain errors—often serious mistakes, which destroy the value of their models. This prevents you from getting the full benefit...
SSMI International, 2017. - 226p. - ASIN: B06XRKNPW1 This book will not make you an ordinary Excel expert. After all, you have a full time job and Excel is just a tool to help you do it better, right? However, research shows that some 90% of spreadsheets contain errors—often serious mistakes, which destroy the value of their models. This prevents you from getting the full benefit...
MKG, 2016. — 60 p. — ASIN B01IN865GI. This particular KES deals with the interesting, exciting and highly useful, yet abstract and largely inaccessible topic of Artificial Neural Networks, with the main aim of demystifying the concepts and principles underlying its creation, training and use. Several problems can be solved using artificial neural networks, and its use sheds...
MKG, 2016. — 60 p. — ASIN B01IN865GI. This particular KES deals with the interesting, exciting and highly useful, yet abstract and largely inaccessible topic of Artificial Neural Networks, with the main aim of demystifying the concepts and principles underlying its creation, training and use. Several problems can be solved using artificial neural networks, and its use sheds...
Amazon Digital Services, 2016. - 318p. - ASIN: B01ELB97KM Making better-informed business decisions to increase productivity and profitability is arguably becoming most difficult task for every manager due to huge volume of data needed to deal with and understand. Knowing the effective and efficient approach of turning this huge raw data into relevant information to enhance...
Amazon Digital Services, 2016. - 318p. - ASIN: B01ELB97KM Making better-informed business decisions to increase productivity and profitability is arguably becoming most difficult task for every manager due to huge volume of data needed to deal with and understand. Knowing the effective and efficient approach of turning this huge raw data into relevant information to enhance...
XinXii-GD Publishing, 2017. — 202 p. Les Tableaux Croisés Dynamiques permettent des synthèses simples et rapides à mettre en place. Nous pouvons bien évidemment connecter ces tableaux aux données saisies dans un classeur Excel mais, également, et c’est là sa puissance, aux diverses données sources de l’entreprise et accéder facilement à votre système d’information. Ce livre...
Amazon Digital Services, 2017. — 31p. — ASIN: B01NGUNTUZ This lesson covers data tables. Data tables are a way to analyze different scenarios in Excel. However, you can change many variables simultaneously and see the effect instantly. Data tables let you answer questions like: 'what's the effect of increasing price by $1 increments' and 'how can I create a gird that shows the...
Amazon Digital Services, 2017. — 31p. — ASIN: B01NGUNTUZ This lesson covers data tables. Data tables are a way to analyze different scenarios in Excel. However, you can change many variables simultaneously and see the effect instantly. Data tables let you answer questions like: 'what's the effect of increasing price by $1 increments' and 'how can I create a gird that shows the...
Amazon Digital Services, 2017. — 31p. — ASIN: B01NGUNTUZ This lesson covers data tables. Data tables are a way to analyze different scenarios in Excel. However, you can change many variables simultaneously and see the effect instantly. Data tables let you answer questions like: 'what's the effect of increasing price by $1 increments' and 'how can I create a gird that shows the...
Amazon Digital Services, 2015. — 36 p. — ASIN: B00WUNS5SO.
This lesson only applies to Excel 2013 or Office 365!
This short lesson covers Excel applications (apps). Apps are almost like the apps you find on your smartphone. In the Excel world, an app is a small, programmed interface that interacts with Excel data to extend your spreadsheet's functionality.
Excel come with...
Amazon Digital Services, 2017. - 72p. - ASIN: B0725R1MW7 This Excel lesson covers the heavy duty data analysis features of Excel: Goal Seek Scenario manager Solver These features let you tell Excel to run thousands of iterations to find the best answer, whether it be a specific number, the best result (maximum value) or the lower result (minimum value). I go through each...
Amazon Digital Services, 2017. - 72p. - ASIN: B0725R1MW7 This Excel lesson covers the heavy duty data analysis features of Excel: Goal Seek Scenario manager Solver These features let you tell Excel to run thousands of iterations to find the best answer, whether it be a specific number, the best result (maximum value) or the lower result (minimum value). I go through each...
Amazon Digital Services, 2017. - 72p. - ASIN: B0725R1MW7 This Excel lesson covers the heavy duty data analysis features of Excel: Goal Seek Scenario manager Solver These features let you tell Excel to run thousands of iterations to find the best answer, whether it be a specific number, the best result (maximum value) or the lower result (minimum value). I go through each...
Amazon Digital Service, 2015. — 59 p. — ASIN: B019TJB5TM.
This lesson in the Mastering Excel series covers charts, specifically interactive charts. This lesson continues to build upon the "Mastering Excel: User Forms" lesson. The User Forms lesson covered the various form objects and how to use them. The focus in this lesson is on combining user forms and charts. You will learn...
Amazon Digital Services, 2017. - 274p. - ASIN: B01GVRQKOU This is a bundle of all the Mastering Excel lessons that cover the new Excel Power BI tools. If you want to perform heavy duty analysis on large data sets, as in well over 1,000,000 rows, this bundle is for you. These new features let Excel crunch through data extremely efficiently. Even if you don't have massive data...
Amazon Digital Services, 2017. - 274p. - ASIN: B01GVRQKOU This is a bundle of all the Mastering Excel lessons that cover the new Excel Power BI tools. If you want to perform heavy duty analysis on large data sets, as in well over 1,000,000 rows, this bundle is for you. These new features let Excel crunch through data extremely efficiently. Even if you don't have massive data...
Amazon Digital Services, 2017. - 274p. - ASIN: B01GVRQKOU This is a bundle of all the Mastering Excel lessons that cover the new Excel Power BI tools. If you want to perform heavy duty analysis on large data sets, as in well over 1,000,000 rows, this bundle is for you. These new features let Excel crunch through data extremely efficiently. Even if you don't have massive data...
Amazon Digital Services, 2016. — 71 p. — ASIN B01BD63SSU.
Welcome another lesson in the Mastering Excel series. This lesson is a slight departure from previous lessons. This lesson is looking into the future and delving into what Excel is becoming: a powerhouse for data analysis. Power Query is the first step in analyzing data, before you do any substantial analysis, you need...
Amazon Digital Services, 2016. — 82 p. — ASIN: B01DI3INBI
PowerPivot is a big deal for Excel. PowerPivot is a new feature where Excel will load data into a Data Model that can handle millions of rows. You can create relationships between tables, build hierarchies and improve the already extensive data analysis capabilities of Excel.
In this lesson, I show you how to install...
Amazon Digital Services, 2016. — 31p. — ASIN: B01NGUNTUZ This lesson focuses on an additional feature on Excel developed by Microsoft. If you routinely receive complex workbooks and you need to figure out how they work, this is the lesson for you. Inquire has many new features that let you audit and explore Excel workbooks. It's also a good tool to analyze your own workbooks to...
Amazon Digital Services, 2016. — 71 p. — ASIN: B00UHY88EY. This lesson covers user interfaces. Most Excel models are content with having users type in a number or text in a cell and then the formulas use that input. There are more user friendly way to interact with your users. In this lesson you will learn how to include option buttons, scroll bars, check boxes and other user...
9th Edition. — CreateSpace Independent Publishing Platform, 2017. — 303 p. — ISBN: 978-1544017365. These course notes are for engineers, scientists, and others interested in developing custom engineering system models. Principles and practices are established for creating integrated models using Excel and its built-in programming environment, Visual Basic for Applications...
9th Edition. — CreateSpace Independent Publishing Platform, 2017. — 303 p. — ISBN: 978-1544017365. These course notes are for engineers, scientists, and others interested in developing custom engineering system models. Principles and practices are established for creating integrated models using Excel and its built-in programming environment, Visual Basic for Applications...
CreateSpace Independent Publishing Platform, 2017. — 303 p. — ISBN: 978-1544017365. Only sample files. These course notes are for engineers, scientists, and others interested in developing custom engineering system models. Principles and practices are established for creating integrated models using Excel and its built-in programming environment, Visual Basic for Applications...
2nd Edition. — John Wiley & Sons, Inc.. 2022. — 192 р. — ISBN: 978-1119182979. SPREADSHEET APPLICATIONS IN CHEMISTRY USING Microsoft Excel Find step-by-step tutorials on scientific data processing in the latest versions of Microsoft Excel The Second Edition of Spreadsheet Applications in Chemistry Using Microsoft Excel delivers a comprehensive and up-to-date exploration of the...
Butterworth-Heinemann, 2006. — 128 p. На англ. языке. Книга прекрасно иллюстрирована и доступна для быстрого освоения работы в Excel 2003. This handy textbook covers all you need to get started with spreadsheets. Learning Made Simple books give you skills without frills. They are matched to the main qualifications, and written by experienced teachers and authors to make often...
Developer: Hemant Kashikar. This MS Excel based spread sheet is based on this concept and present a small model of electrical network that can be adapted for such motor starting case studies. This is very helpful especially for quick checks as follows: What is the largest motor size that can be started with a given generator rating What should be the rating of the generator (or...
Springer, Cham, 2022. — 170 p. — ISBN 978-3-030-94085-0. This compact text is a powerful introduction to the Excel/VBA computing environment. The book presents some of the most useful features of Excel. First by introducing mathematical puzzles that will grab the reader’s attention with the reader invited to think hard on solving those puzzles. Then, solutions are presented in...
Apress, 2020. — 361p. — ISBN: 1484264665 Explore advanced skills in Excel and gain an amazing array of tricks and tools to increase your productivity. This book discusses new techniques such as power functions, chart tricks, and many more to master Excel. Advanced Excel Success starts with a few useful data tools in Excel followed by advanced formulas that will help you...
Apress Media LLC, 2022. — 834 р. — ISBN-13: 978-1-4842-7124-7 Enhance and upgrade your Excel knowledge with this comprehensive guide to formulas in Excel. Over 150 of the most useful Excel functions are covered with numerous practical examples of their use. This book is fully updated and includes examples of the most recently released functions in 2022. It is written in a...
Apress Media LLC., 2020. — 367 p. — ISBN-13 (electronic): 978-1-4842-6467-6. Explore advanced skills in Excel and gain an amazing array of tricks and tools to increase your productivity. This book discusses new techniques such as power functions, chart tricks, and many more to master Excel. Advanced Excel Success starts with a few useful data tools in Excel followed by advanced...
Apress Media LLC., 2020. — 367 p. — ISBN-13 (electronic): 978-1-4842-6467-6. Explore advanced skills in Excel and gain an amazing array of tricks and tools to increase your productivity. This book discusses new techniques such as power functions, chart tricks, and many more to master Excel. Advanced Excel Success starts with a few useful data tools in Excel followed by advanced...
Apress Media LLC., 2020. — 367 p. — ISBN-13 (electronic): 978-1-4842-6467-6. Explore advanced skills in Excel and gain an amazing array of tricks and tools to increase your productivity. This book discusses new techniques such as power functions, chart tricks, and many more to master Excel. Advanced Excel Success starts with a few useful data tools in Excel followed by advanced...
Blue Micro Solutions, 2014. — 270 p. — ASIN: B00NI5CMSC. Yes, most of the above and much more can be achieved in Microsoft Excel if you understand some basic concepts of financial modelling and analysis. This book was written to help any users wanting to have a clear understanding of how Excel can help to perform some aspects of financial modelling and analysis using some of its...
Blue Micro Solutions, 2014. — 270 p. — ASIN: B00NI5CMSC. Yes, most of the above and much more can be achieved in Microsoft Excel if you understand some basic concepts of financial modelling and analysis. This book was written to help any users wanting to have a clear understanding of how Excel can help to perform some aspects of financial modelling and analysis using some of its...
Blue Micro Solutions, 2014. — 270 p. — ASIN: B00NI5CMSC. Yes, most of the above and much more can be achieved in Microsoft Excel if you understand some basic concepts of financial modelling and analysis. This book was written to help any users wanting to have a clear understanding of how Excel can help to perform some aspects of financial modelling and analysis using some of its...
Orange Education Pvt Ltd., 2023. — 228 p. — ISBN: 978-81-96782-61-0. Transform Your MS Excel Skills with this Ultimate Guide for Professional Success Book Description The Ultimate Excel with Power Query and ChatGPT is a revolutionary handbook to help you embark on a transformative journey through the intricate world of Excel’s lookup functions. The book dives deep into Excel’s...
Orange Education Pvt Ltd., 2023. — 228 p. — ISBN: 978-81-96782-61-0. Transform Your MS Excel Skills with this Ultimate Guide for Professional Success Book Description The Ultimate Excel with Power Query and ChatGPT is a revolutionary handbook to help you embark on a transformative journey through the intricate world of Excel’s lookup functions. The book dives deep into Excel’s...
Orange Education Pvt Ltd., 2023. — 228 p. — ISBN: 978-81-96782-61-0. Transform Your MS Excel Skills with this Ultimate Guide for Professional Success Book Description The Ultimate Excel with Power Query and ChatGPT is a revolutionary handbook to help you embark on a transformative journey through the intricate world of Excel’s lookup functions. The book dives deep into Excel’s...
Independently published, 2020. — 378 p. — ISBN: 1777410916, 978-1777410919. Dynamic Data Validation… is a Game changer in Excel, at the basic level it controls what a user can enter or cannot enter in a cell, you are in control of the user's input. It also makes data entry easier and ensures the integrity of your worksheet by avoiding typing errors when users can simply select...
GD Publishing, 2017. — 290 p. — ASIN B01MRA6NJU.
Monte Carlo Simulation with Excel. Part 1 of 2: basics + standard procedures.
Monte Carlo Simulation is a numeric technique that allows the analyst to simulate a specific formulation by running the computation a large number of times (typically in the thousands). In each model, there will be several input variables. Each input...
GD Publishing, - 436p. - ASIN: B01N7WAUTD
Monte Carlo Simulation is a numeric technique that allows the analyst to simulate a specific formulation by running the computation a large number of times (typically in the thousands). In each model, there will be several input variables. Each input variable will be modeled to behave in a way that represents reality. This could be a...
Wiley, 2016. — 387 p. — 3rd Edition. Data collection, management and analysis is the key to making effective business decisions, and if you are like most people, you probably don't take full advantage of Excel's data analysis tools. With Excel Data Analysis For Dummies, 3rd Edition, you'll learn how to leverage Microsoft Excel to take your data analysis to new heights by...
2nd ed. — John Wiley & Sons, 2014. — 360 p., in color. — (For Dummies). — ISBN: 1118898095, 9781118898093.
Harness the power of Excel to discover what your numbers are hiding Excel Data Analysis For Dummies, 2 nd Edition is the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson guides you through the basic and not–so–basic features of...
BPB Publications, 2020. - 412p. - ISBN: 978-9389845808 Explore different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends Key Features Use the Analysis ToolPak to perform complex Data analysis Get well versed with the formulas, functions, and components in Excel Handy templates to give you a head start Usage of multiple examples...
Independently published, 2017. — 42 p. — ISBN: 978-1520528366. If you are new to Excel Data Tables they can seem daunting and scary. This easy to follow and fully illustrated guide by the best selling Excel guide author, Carl Nixon, is designed to get you up to speed quickly and easily. You will be able to start producing your own Data Tables in an hour or less!
Independently published, 2017. - 48p. - ISBN: 978-1520577111 +Sample files Learn to use Excel's Solver in an Hour If you are new to Excel's Solver it can seem daunting and scary. This easy to follow and fully illustrated guide by the internationally renowned Excel consultant, Carl Nixon, is designed to get you up to speed quickly and easily. You will be able to start producing...
Developer: Jignesh Parmar. Version: 22.8.2012. This MS Excel spreadsheet calculates the following parameters: Total Lumen Output for particular Area Total No of Lighting Lamps Total No of Lighting Fixtures Number of Fittings along with the Length and Width of Room.
Urbizedge, 2015. — 194 p. — ASIN: B01255TQ84 Microsoft Excel is the world's most used business intelligence tool. Its knowledge is even compulsory for an MBA degree and the investment world depends greatly on it. This book is aimed at making you extremely good in Microsoft Excel, dashboard making and business data analysis teaching you with companion videos and practice files....
Dublin: Olas IT Software Training and Development. – 5 p. (Автор и год выпуска не указаны). To assist us in evaluating your current skill level in Microsoft Excel, please complete this questionnaire. This will ensure that individual training sessions can be tailored to suit your requirements or that you are placed on the most appropriate training programme. Excel Basic...
GreateSpace Independent Publishing, 2016. — 386 p. — ISBN: 1537137719. It's a must have standard engineering book that should have read many years ago. It addresses many articles that may not be covered by any Excel for engineering texts, such as step by step guides to create an application program and how to convert the steps into VBA code, how to perform matrix operations,...
Branko Pecar, 2016. - 354p. - ASIN: B01N9C1RI1 +Sample files This book explores the basic predictive analytics modelling techniques and puts emphasis on the time series based approach to forecasting. The methods covered in this book include basic models, such as regression, classical decomposition, exponential smoothing, etc., as well as more advanced approaches such as...
Marpes, 2021. — 280 S. Erfahren Sie, von den Grundlagen bis zu komplexen Auswertungen, wie man in Excel mit Datum und Uhrzeit arbeiten kann (ohne VBA). Es erwartet Sie: Technische Hintergründe Daten eingeben und formatieren Berechnungen durchführen Alle Funktionen zu Datum und Uhrzeit Verwendung mit anderen Funktionen
Marpes, 2021. — 280 S. Erfahren Sie, von den Grundlagen bis zu komplexen Auswertungen, wie man in Excel mit Datum und Uhrzeit arbeiten kann (ohne VBA). Es erwartet Sie: Technische Hintergründe Daten eingeben und formatieren Berechnungen durchführen Alle Funktionen zu Datum und Uhrzeit Verwendung mit anderen Funktionen
Wiley, 2014. — 480 p. — 2nd ed. — ISBN: 1118519655, 9781118519653 Learn to maintain and update scorecards and dashboards with Excel Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time–proven step–by–step processes on how to guide...
Wiley, 2014. — 480 p. — 2nd ed. — ISBN: 1118519655, 9781118519653 Learn to maintain and update scorecards and dashboards with Excel Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time–proven step–by–step processes on how to guide...
Wiley, 2014. — 480 p. — 2nd ed. — ISBN: 1118519655, 9781118519653 Learn to maintain and update scorecards and dashboards with Excel Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time–proven step–by–step processes on how to guide...
Wiley – 2009, 480 pages ISBN: 0470386819, 9780470386811 Created in Excel, balanced scorecards enable you to monitor operations and tactics, while operational dashboards is a set of indicators regarding the state of a business metric or process—both features are in high demand for many large organizations. This book serves as the first guide to focus on combining the benefits of...
Independently published, 2023. — 252 p. — ISBN 979-8395903327. One of the most common and frustrating problems in offices and for those managing household finances is having to repeat the same operations over and over again, making work increasingly stressful and less productive over time.To date, employers are looking for people who know how to use Excel correctly to speed up...
Автор не указан. — IBM Corp. 2007, 2018. — 351 с. IBM Planning Analytics for Microsoft Excel - это инструмент на основе Microsoft Excel, который профессиональные авторы отчетов используют для создания сложных, отчетов с несколькими листами и с составными запросами для нескольких баз данных. Введение Что нового в IBM Planning Analytics for Microsoft Excel 2.0.30 - Обновления...
Office Manager’s Training. – Plano, Texas: Plano Independent School District, 2010. – 29 p. (Автор не указан). Formulas & Functions. AutoCalculate. Simple Formulas. Relative vs. Absolute Reference. Relative Reference. Absolute Reference. Statistical Functions. SUM. AVERAGE. MEDIAN. MODE. COUNT. MAX. MIN. Logical Functions. IF. Nested IF. VLOOKUP. HLOOKUP. Text Functions....
Pearson, 2020. — 795 p. — ISBN-13: 978-0135452752. Now live! SUMMER 2020 DIGITAL UPDATE for digital content Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. To learn more, contact your Pearson representative. For courses covering introductory Microsoft Excel. Beyond point-and-click The Exploring Microsoft Office 365 series moves...
BPB Publications, 2024. — 330 p. — ISBN: 978-93-55519-467. Using MS Excel for powerful exploration, manipulation, and data visualization. All Rights No part of this publication may be reproduced, distributed or transmitted in any form or by any means or stored in a database or retrieval system, without the prior written permission of the publisher with the exception to the...
BPB Publications, 2024. — 330 p. — ISBN: 978-93-55519-467. Using MS Excel for powerful exploration, manipulation, and data visualization. All Rights No part of this publication may be reproduced, distributed or transmitted in any form or by any means or stored in a database or retrieval system, without the prior written permission of the publisher with the exception to the...
Reactive Publishing, 2024. — 592 p. Unlock the Ultimate Power of Excel with AI at Your Fingertips. Dive into the depths of advanced Excel techniques with "Excel with AI", the definitive guide for enthusiasts eager to harness the full potential of Excel through Artificial Intelligence (AI) and programming. Tailored for those who have mastered the basics and are now ready to...
Reactive Publishing, 2024. — 592 p. Unlock the Ultimate Power of Excel with AI at Your Fingertips. Dive into the depths of advanced Excel techniques with "Excel with AI", the definitive guide for enthusiasts eager to harness the full potential of Excel through Artificial Intelligence (AI) and programming. Tailored for those who have mastered the basics and are now ready to...
Reactive Publishing, 2024. — 592 p. Unlock the Ultimate Power of Excel with AI at Your Fingertips. Dive into the depths of advanced Excel techniques with "Excel with AI", the definitive guide for enthusiasts eager to harness the full potential of Excel through Artificial Intelligence (AI) and programming. Tailored for those who have mastered the basics and are now ready to...
CRC Press, 2023. — 224 p. Business Finance Planning with Microsoft Excel shows how to visualize, plan, and put into motion an idea for creating a start-up company. Microsoft Excel is a tool that makes it easier to build a business financial planning process for a new business venture. With an easy-to follow structure, the book flows as a six-step process: Presenting a case...
Independently published, 2021. — 152 p. — ASIN B091NGMKHB. This Book will transform you into Data Analytics Expert . In this course you will learn how to use MS Excel to read, clean, transform, visualize and analyze the data. Course Outcomes Skills Understand what is Data Analytics Change in perception to view data In depth knowledge in MS Excel Creating Interactive and deep...
Independently published, 2021. — 152 p. — ASIN B091NGMKHB. This Book will transform you into Data Analytics Expert . In this course you will learn how to use MS Excel to read, clean, transform, visualize and analyze the data. Course Outcomes Skills Understand what is Data Analytics Change in perception to view data In depth knowledge in MS Excel Creating Interactive and deep...
Independently published, 2021. — 152 p. — ASIN B091NGMKHB. This Book will transform you into Data Analytics Expert . In this course you will learn how to use MS Excel to read, clean, transform, visualize and analyze the data. Course Outcomes Skills Understand what is Data Analytics Change in perception to view data In depth knowledge in MS Excel Creating Interactive and deep...
Eyrolles, 2011. — 385 p. — ISBN: 221212659X Premier du genre en français, cet ouvrage montre comment utiliser le logiciel Excel et son solveur pour résoudre des problèmes d'optimisation complexes dans les domaines les plus divers : gestion de production, ordonnancement, transport, économie et finances, gestion des organisations, aide à la décision, etc. Le livre met l'accent sur...
Shahar Prish. Professional Excel Services. Wiley, 2007. - 472 p.
Excel spreadsheets are used practically everywhere — they are the cornerstone of many applications and businesses. Excel Services revolutionizes the spreadsheet world by introducing server-side spreadsheet calculation and rendering with unparallel Excel fidelity. This book will guide developers through...
Holy Macro! Books, 2015. — 307 p. — ISBN: 978-1-61547-034-1. Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and “M” is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this...
Holy Macro! Books, 2015. — 307 p. — ISBN: 978-1-61547-034-1. Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and “M” is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this...
Amazon Digital Services, 2014. - 655p. - ASIN: B00N0UR6KY
Step-by-Step Guide to Mastering the Most Widely Used Spreadsheet Software in the Market
Excel, the most widely used spreadsheet application on the market, can help you manage and organize your professional, personal and business life with plenty of functions and formulas at your fingertips.
Improve your CV,...
Lean Excel Books, 2015. — 147 p. — ISBN: N/A
Knowing how to use the built-in functions in Microsoft Excel will turn you into a power user! There are hundreds of functions and at first, the list can seem overwhelming. Even as a Microsoft Office Expert in Excel 2013 I do not know all of the Excel functions available. In writing this eBook, I discovered several new functions that...
Примеры к книге. — Lean Excel Books, 2015. — 147 p. — ISBN: N/A.
Knowing how to use the built-in functions in Microsoft Excel will turn you into a power user! There are hundreds of functions and at first, the list can seem overwhelming. Even as a Microsoft Office Expert in Excel 2013 I do not know all of the Excel functions available. In writing this eBook, I discovered several...
Amazon Digital Services, 2014. - 374p. - ASIN: B00IZ4CPA6 Description of the Book This book is not about learning all the powerful functionalities of Excel. It will not make you a guru on Excel. In fact, it covers a rather small subsets of functions in Excel. Rather, this book aims to help you become a better decision maker. A better manager or executive. A better homemaker or...
3rd ed. — SAGE, 2016. — 169 p. in color. — ISBN: 1483374041, 9781483374048
Ideal for those already familiar with basic Excel features, this updated Third Edition of Neil J. Salkind’s Excel Statistics: A Quick Guide shows readers how to utilize Microsoft Excel’s functions and Analysis ToolPak to answer simple and complex questions about data. Part I explores 35 Excel functions,...
Packt Publishing Pvt Ltd, 2024. — 345 p. Seamlessly integrate the Python and R programming languages with spreadsheet-based data analysis to maximize productivity Key Features Perform advanced data analysis and visualization techniques with R and Python on Excel data Use exploratory data analysis and pivot table analysis for deeper insights into your data Integrate R and Python...
Amazon Digital Services, 2015. — 160 p. — ASIN B019AB7NEA.
This book makes you awesome in excel. This book is designed for Managers, Students, Analysts etc. It covers all the important topics of Excel like Formulas, Ranges, Charts, Pivots etc. used in Industry.
Markt und Technik, 2010. — 690 S. Professionelle Excel-Lösungen zu den vielschichtigen Aufgaben in Controlling und Finanzwesen. Dieses Handbuch geht dabei nicht von den unzähligen Excel-Funktionen aus, sondern stellt die Controlling-Themen in den Mittelpunkt und ist auch danach gegliedert. Die Entwicklung einer Lösung wird Schritt für Schritt aufgezeigt, so dass sie leicht...
Markt+Technik, 2020. — 600 S. Vor Ihnen liegt die 4. Auflage des Zauberbuches, und diese sollte keine Neuauflage sein, sondern eine Überarbeitung der erfolgreichen Vorauflagen. Diese Aufgabe habe ich als langjähriger Markt+Technik-Autor übernommen, und sie ist mir nicht leichtgefallen. Meine kongenialen Kollegen Jens Fleckenstein, Walter Fricke und Boris Georgi haben ja richtig...
Schieb.de, 2010. - 105 Seiten. ISBN: N/A. На нем. языке.
In "50 Hammertipps Excel" hat Jörg Schieb die 50 besten Tipps, Tricks und Kniffe zu Microsofts Tabellenkalkulationssoftware zusammengestellt. Der PC-Profi zeigt wie Sie geheime Funktionen und versteckte Optionen nutzen, Eingaben vereinfachen, Aufgaben schneller lösen, Tabellen ansprechender gestalten, den Datenaustausch...
CreateSpace Independent Publishing Platform, 2017. - 134p. - ISBN: 978-1545075074 Tired of waiting for Excel? Use the 30 best methods described in this book to speed up Excel calculations! Learn how Microsoft Excel performs calculations Use the simple and effective step-by-step guide to master each method Get to know the impact each method will have on performance The goal of...
CreateSpace Independent Publishing Platform, 2017. - 134p. - ISBN: 978-1545075074 Tired of waiting for Excel? Use the 30 best methods described in this book to speed up Excel calculations! Learn how Microsoft Excel performs calculations Use the simple and effective step-by-step guide to master each method Get to know the impact each method will have on performance The goal of the...
John Wiley & Sons, Inc., 2013. - 530 Pages. 3rd Edition. На англ. языке. Пусть Вас не вводит в заблуждение название книги - она не учит статистике, а рассказывает как новейшие инструменты Excel возможно использовать для простейшего статистического анализа разнообразных данных. Take the mystery out of statistical terms and put Excel to work! If you need to create and interpret...
4th ed. — John Wiley & Sons, Inc., 2016. — 555 p. in color. — ISBN: 1119271150, 9781119271154 Learn all of Excel's statistical tools Test your hypotheses and draw conclusions Use Excel to give meaning to your data Use Excel to interpret stats Statistical analysis with Excel is incredibly useful—and this book shows you that it can be easy, too! You'll discover how to use Excel's...
Weinheim: Wiley-VCH, 2022. — ISBN 978-3-527-83833-2. Erfahren Sie, wie Sie mit Excel noch schneller, besser und effizienter arbeiten! Zeigen Sie im Excel-Alltag richtiges Fachwissen. Verwenden Sie gelungene Mixturen aus raffinierten Formeln und Funktionen. Holen Sie zum Beispiel mehr aus WENN-Funktionen heraus, ohne dass es ein ABER gibt. Nutzen Sie im Programm Verborgenes....
CRC Press, 2023. — 349 p. — (AK Peters Visualization Series). — ISBN 978-1-003-32155-2. This book closes the gap between what people think Excel can do and what they can achieve in the tool. Over the past few years, recognition of the importance of effectively visualizing data has led to an explosion of data analysis and visualization software tools. But for many people,...
A K Peters/CRC Press, 2023. — 390 p. — (AK Peters Visualization Series). — ISBN: 978-1-003-32155-2. This book closes the gap between what people think Excel can do and what they can achieve in the tool. Over the past few years, recognition of the importance of effectively visualizing data has led to an explosion of data analysis and visualization software tools. But for many...
A K Peters/CRC Press, 2023. — 390 p. — (AK Peters Visualization Series). — ISBN: 978-1-003-32155-2. This book closes the gap between what people think Excel can do and what they can achieve in the tool. Over the past few years, recognition of the importance of effectively visualizing data has led to an explosion of data analysis and visualization software tools. But for many...
A K Peters/CRC Press, 2023. — 390 p. — (AK Peters Visualization Series). — ISBN: 978-1-003-32155-2. This book closes the gap between what people think Excel can do and what they can achieve in the tool. Over the past few years, recognition of the importance of effectively visualizing data has led to an explosion of data analysis and visualization software tools. But for many...
Tutorials Point (I) Pvt. Ltd., 2016. — 558 p. Data Analysis with Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel. It explains in detail how to perform various data analysis functions using the features available in MS-Excel. The tutorial has plenty of screenshots that explain how to use a...
Б.м.: Ahmed Sheikh, 2021. — 93 p. Excel has its immense purposeful applications. 95% of the users apply the basic form. There are functions and advanced excel formula that can be used for complex calculations. The functions are designed for easy lookup and formatting of large pool of data whereas the advanced excel formula are implemented to get new information from a given...
Jinjer Simon. 2002 Published by Hungry Minds, Inc. 909 Third Avenue New York, NY 10022.. Excel Programming: Your visual blueprint for creating. interactive spreadsheets uses simple, straightforward. examples to teach you how to create powerful and. dynamic programs. To get the most out of this book, you should read each. chapter in order, from beginning to end. Each chapter....
BEP, 2017. - 106p. - ISBN: 1631579436 MS Excel: Let's advance to the Next Level is an attempt to take you to the next orbit of competence in this fascinating world. It is a ready reckoner for any practitioner who seeks to further his/her understanding of the tools and utilities. The author offers to make life easier for a data analyst, thus, it will be of relevance to students,...
Amazon Digital Services, 2014. — 109 p. — ASIN B00IQXAWCY. The real power behind Excel is its ability to perform What-If Analysis. It can serve as a decision making model. It can be used to test a wide variety of scenarios simply and quickly. It allows you to test different scenarios before they actually happen or before you implement them. You can perform What-If Analysis to...
Cengage Learning, 2007. — 160 p. — 3rd ed. — ISBN: 0324379048, 9780324379044 Excel Quick is designed for busy people who need a quick understanding of Excel. The goal of this tutorial is to get you up and running in Excel within one hour. Written for business students, the book has many real world examples. This tutorial covers Excel 2007, but also includes prior versions of...
Microsoft Press, 2018. — 256 p. — ISBN: 978-1509308040. Prepare for Microsoft Exam 70-779and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the...
Microsoft Press, 2018. — 256 p. — ISBN: 978-1509308040. Prepare for Microsoft Exam 70-779 and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at...
Microsoft Press, 2018. — 256 p. — ISBN: 978-1509308040. !Code files only Prepare for Microsoft Exam 70-779and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed...
CreateSpace Independent Publishing Platform, 2016. — 30 р. — ISBN: 978-1537161846. With all of the buzz about Excel lately, it is no wonder why so many people are taking an interest. Most of us learned about Excel in high school, but today’s Excel is completely different. Years ago, Excel was all about accounting, but today, it can be used in any area of your life. This book is...
CreateSpace Independent Publishing Platform, 2016. — 30 р. — ISBN: 978-1537161846. With all of the buzz about Excel lately, it is no wonder why so many people are taking an interest. Most of us learned about Excel in high school, but today’s Excel is completely different. Years ago, Excel was all about accounting, but today, it can be used in any area of your life. This book is...
CreateSpace Independent Publishing Platform, 2016. — 30 р. — ISBN: 978-1537161846. With all of the buzz about Excel lately, it is no wonder why so many people are taking an interest. Most of us learned about Excel in high school, but today’s Excel is completely different. Years ago, Excel was all about accounting, but today, it can be used in any area of your life. This book is...
Amazon Services LLC, 2019. — 259 р. This Excel bible for Beginners is a very comprehensive Excel book and you will learn all the essential tools, features and functions Excel has to offer. You will learn about the history and background of Excel. You will get to know your way around the Excel user interface by using the ribbon. You will learn how to format, manage, sort, filter...
Amazon Services LLC, 2019. — 259 р. This Excel bible for Beginners is a very comprehensive Excel book and you will learn all the essential tools, features and functions Excel has to offer. You will learn about the history and background of Excel. You will get to know your way around the Excel user interface by using the ribbon. You will learn how to format, manage, sort, filter...
Amazon.com Services LLC, 2019. — 259 р. This Excel bible for Beginners is a very comprehensive Excel book and you will learn all the essential tools, features and functions Excel has to offer. You will learn about the history and background of Excel. You will get to know your way around the Excel user interface by using the ribbon. You will learn how to format, manage, sort,...
San Francisco, CA: CBS Interactive Inc., 2018. — 48 p. The tips, tricks, and shortcuts in this ebook will help you get extra mileage from Excel’s powerful features, generate accurate results, and save time on your worksheet tasks.
Independently published, 2024. — 143 p. — ASIN B0D817539L. Welcome to "Mastering Excel with ChatGPT: A Guide to Automation and Efficiency." In this book, we explore the powerful synergy between Excel, the ubiquitous spreadsheet software, and ChatGPT, an advanced AI language model developed by OpenAI. Together, they offer a transformative approach to data processing, analysis,...
Independently published, 2024. — 143 p. — ASIN B0D817539L. Welcome to "Mastering Excel with ChatGPT: A Guide to Automation and Efficiency." In this book, we explore the powerful synergy between Excel, the ubiquitous spreadsheet software, and ChatGPT, an advanced AI language model developed by OpenAI. Together, they offer a transformative approach to data processing, analysis,...
Leanpub, 2014. — 21 p. This book is for beginners, and the goal is to get you started. R is known to have a steep learning curve: (1) data management, (2) statistics and (3) visualization. The core focus of this book will be on data management: how to import, manipulate, transform and summarize data through the use of functions. Once you are able to work with data sets,...
TeachUcomp, Inc., 2012. — 193 p.
(Автор не указан).
Welcome to Teachucomp, Inc.’s Advanced Excel course. This class caps the student’s knowledge of Microsoft Excel, one of the most popular spreadsheet programs available today. This class is designed to give the student a firm grasp of the advanced concepts in Excel.
Excel is an excellent program to learn, as the skills that...
TeachUcomp, Inc., 2012. — 157 p.
(Автор не указан).
Welcome to Teachucomp, Inc.’s Intermediate Excel course. This class expands the student’s knowledge of Microsoft Excel, one of the most popular worksheet programs available today. This class is designed to give the student a firm working knowledge of this program Excel is an excellent program to learn, as the skills that you...
TeachUcomp, Inc., 2012. — 113 p.
(Автор не указан).
Welcome to Teachucomp, Inc.’s Introductory Excel course. This class introduces the student to Microsoft Excel, one of the most popular spreadsheet programs available today. This class is designed to give the student with little or no knowledge of this program a firm skills base in Excel.
Excel is an excellent program to...
Independently published, 2021. — 603 p. — ISBN 9798517577139. Have you set out to become a pro in the use of Microsoft Excel and Power BI? Are you stuck and have been struggling to have a smooth glide through Microsoft Excel and Power BI? If yes, then, discover the keys to glide with ease in this guide! Firms, individuals, business owners, and organizations amidst others at one...
Independently published, 2021. — 603 p. — ISBN 9798517577139. Have you set out to become a pro in the use of Microsoft Excel and Power BI? Are you stuck and have been struggling to have a smooth glide through Microsoft Excel and Power BI? If yes, then, discover the keys to glide with ease in this guide! Firms, individuals, business owners, and organizations amidst others at one...
Excel Expert, 2015. — 652 p. — ASIN: B00ZXOHH9U
This comprehensive book series (7 books) will teach you everything you want and should know about Excel. The books are suitable for beginners and for advanced users.
Officially released in January 2013, the latest version of Excel 2013 took the market by its amazingly easy-to-user interface and incredibly advanced features. It is...
Arestehcd, 2023. — 215 p. Excel is one of the most widely used tools for data analysis, automation, and reporting. However, many people are not aware of its full potential as a programming tool. This book is a comprehensive guide to Excel programming, from basic macros to advanced VBA techniques. Whether you are new to Excel programming or an experienced programmer, this book...
Koko Publications, 2017. - 673p. - ASIN: B06XX9P6T5 Whether you are just starting out or an Excel novice, this book 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 to take full advantage of what this book offers. Learn to incorporate templates,...
Koko Publications, 2017. - 673p. - ASIN: B06XX9P6T5 Whether you are just starting out or an Excel novice, this book 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 to take full advantage of what this book offers. Learn to incorporate templates,...
Www.sqljason.com, 2012. – 8 p.
GeoFlow is a three dimensional (3-D) data visualization tool for Microsoft Excel 2013 that provides a powerful method for people to look at information in new ways. It enables the data discoveries that might not be seen in traditional two dimensional (2-D) tables and charts. With GeoFlow you can plot geographic and temporal data visually, analyze...
Excelforum.com; Exceltip.com, 2015. — 37 p. (Автор не указан). What are we going to learn in this book: What is Microsoft Excel? What is Ribbon in MS-Excel? How many rows and columns are there in Microsoft Excel 2003 and later versions? Which option do we use to adjust the text within a cell and what is the procedure to do it? What is the shortcut to put the filter on data in...
Independently published, 2025. — 77 p. Ready to ungrade your Excel skills? This book is your ultimate step-by-step guide to mastering Microsoft Excel with confidence. Designed for both beginners and experienced users, this book is packed with clear explanations, hands-on tutorials, and visual examples to help you unlock Excel’s full capabilities. Microsoft Excel is a powerful...
Independently published, 2025. — 77 p. Ready to ungrade your Excel skills? This book is your ultimate step-by-step guide to mastering Microsoft Excel with confidence. Designed for both beginners and experienced users, this book is packed with clear explanations, hands-on tutorials, and visual examples to help you unlock Excel’s full capabilities. Microsoft Excel is a powerful...
Chris Urban, 2016. — 192 p. — ISBN: 978-0997877304. This book is for those who are familiar with Microsoft Excel and use it on a regular basis. You know there's more out there, a way to do more, faster, and better. Learn to step up your game with Advanced Excel for Productivity, a readable and useful guide to improving everything you do in Excel. Learn advanced techniques for...
Chris Urban, 2016. — 192 p. — ISBN: 978-0997877304. This book is for those who are familiar with Microsoft Excel and use it on a regular basis. You know there's more out there, a way to do more, faster, and better. Learn to step up your game with Advanced Excel for Productivity, a readable and useful guide to improving everything you do in Excel. Learn advanced techniques for...
Independently published, 2021. — 98 p. — ASIN B08Y7PYX8T. This is a comprehensive practical manual for beginners and professionals. For you to deeply understand this application, you need a guide or coach by your side and this book is the answer your problem since Excel is a little bit logical but this guide will make it very simple to apprehend. It has some formulas and short...
Independently published, 2021. — 98 p. — ASIN B08Y7PYX8T. This is a comprehensive practical manual for beginners and professionals. For you to deeply understand this application, you need a guide or coach by your side and this book is the answer your problem since Excel is a little bit logical but this guide will make it very simple to apprehend. It has some formulas and short...
Independently published, 2021. — 98 p. — ASIN B08Y7PYX8T. This is a comprehensive practical manual for beginners and professionals. For you to deeply understand this application, you need a guide or coach by your side and this book is the answer your problem since Excel is a little bit logical but this guide will make it very simple to apprehend. It has some formulas and short...
Reactive Publishing, 2024. — 553 p. — ISBN 979-8874337056. Unlock the full potential of your financial analysis with "Machine Learning for Finance." This comprehensive guide takes you from the basics of Python programming to advanced Machine Learning techniques tailored specifically for financial applications. Perfect for finance professionals, data scientists, and anyone eager...
Reactive Publishing, 2024. — 553 p. — ISBN 979-8874337056. Unlock the full potential of your financial analysis with "Machine Learning for Finance." This comprehensive guide takes you from the basics of Python programming to advanced Machine Learning techniques tailored specifically for financial applications. Perfect for finance professionals, data scientists, and anyone eager...
Reactive Publishing, 2023-11-03. — 252 p. — ASIN: B0CMKTWWP4. Reactive Publishing Do you know your sheet? Unleash the Power of Data with "Excel Hacker: Advanced Excel with Python" Are you ready to transform your career and become a data wizard? Dive into the world of data analysis, automation, and machine learning with "Excel Hacker: Advanced Excel with Python." This...
Reactive Publishing, 2023-11-03. — 252 p. — ASIN: B0CMKTWWP4. Reactive Publishing Do you know your sheet? Unleash the Power of Data with "Excel Hacker: Advanced Excel with Python" Are you ready to transform your career and become a data wizard? Dive into the world of data analysis, automation, and machine learning with "Excel Hacker: Advanced Excel with Python." This...
Reactive Publishing, 2023-11-03. — 252 p. — ASIN: B0CMKTWWP4. Reactive Publishing Do you know your sheet? Unleash the Power of Data with "Excel Hacker: Advanced Excel with Python" Are you ready to transform your career and become a data wizard? Dive into the world of data analysis, automation, and machine learning with "Excel Hacker: Advanced Excel with Python." This...
Reactive Publishing, 2024. — 533 р. — ASIN: B0CRTKL695. Are you a finance professional who mastered the basics of VBA and are hungry for more? Do you seek the tools to harness the power of machine learning and incorporate data science into your advanced financial tasks? If the answer is a resounding "YES!", then 'Learn VBA Programming' is the definitive resource you've been...
Reactive Publishing, 2024. — 533 р. — ASIN: B0CRTKL695. Are you a finance professional who mastered the basics of VBA and are hungry for more? Do you seek the tools to harness the power of machine learning and incorporate data science into your advanced financial tasks? If the answer is a resounding "YES!", then 'Learn VBA Programming' is the definitive resource you've been...
Reactive Publishing, 2024. — 533 р. — ASIN: B0CRTKL695. Are you a finance professional who mastered the basics of VBA and are hungry for more? Do you seek the tools to harness the power of machine learning and incorporate data science into your advanced financial tasks? If the answer is a resounding "YES!", then 'Learn VBA Programming' is the definitive resource you've been...
Reactive Publishing, 2024. — 533 р. — ASIN: B0CRTKL695. Are you a finance professional who mastered the basics of VBA and are hungry for more? Do you seek the tools to harness the power of machine learning and incorporate data science into your advanced financial tasks? If the answer is a resounding "YES!", then 'Learn VBA Programming' is the definitive resource you've been...
CreateSpace Independent Publishing Platform, 2016. — 460 p. Gambling . The Die Is Cast Casting Six Dice Roulette Machine An X-O Game A Slot Machine Gamblers’ Ruin Lottery Numbers Win or Lose? A Letter Game A Three-Way Circuit Flock Behavior Statistics . Samples A Normal Distribution Distribution Simulations Discrete Distributions Peaks Confidence Margins Sample Size and...
CreateSpace Independent Publishing Platform, 2016. — 230 p. — ISBN: 978-1540445179. Covering a variety of Excel simulations by using Visual Basic (VBA), from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook. The simulations covered offer a fun alternative to the usual Excel topics and include...
Holy Macro Books, 2013. — 176 p. — ISBN: 1615470220, 9781615470228
Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook. The simulations covered offer a fun alternative to the usual Excel topics and include situations such as roulette, password...
Indianapolis, Indiana: Wiley Publishing, Inc., 2003. — 556 pages. This book is intended for spreadsheet users who want to get the most out of Excel’s charting and graphics features. Chart Basics Mastering Charts Using VBA with Charts
Wiley Publishing, Inc., 2010. – 403 pages. - 2nd Edition. This book is written for Excel 2007 and Excel 2010, so if you don’t have one of those versions, you run the risk of getting confused in a few places. Introducing VBA. What Is VBA? Jumping Right In. How VBA Works with Excel. Working In the Visual Basic Editor. Introducing the Excel Object Model. VBA Sub and Function...
Holy Macro! Books, 2017. — 178 p. — ISBN10: 161547045X. — ISBN13: 978-1615470457. This book is for you if you are being asked to use Excel more than you ever expected and you are looking for a guide to take you to what is relevant and most frequently used. It's also for you if you have seen that in your organization, it's the Excel power users who get promoted, and you want to...
Holy Macro! Books, 2017. — 172 p. — ISBN13: 978-1-61547-352-6. This book is for you if you are being asked to use Excel more than you ever expected and you are looking for a guide to take you to what is relevant and most frequently used. It's also for you if you have seen that in your organization, it's the Excel power users who get promoted, and you want to join them. This...
Holy Macro! Books, 2017. — 172 p. — ISBN13: 978-1-61547-129-4. This book is for you if you are being asked to use Excel more than you ever expected and you are looking for a guide to take you to what is relevant and most frequently used. It's also for you if you have seen that in your organization, it's the Excel power users who get promoted, and you want to join them. This...
Holy Macro! Books, 2017. — 172 p. — ISBN13: 978-1-61547-352-6. This book is for you if you are being asked to use Excel more than you ever expected and you are looking for a guide to take you to what is relevant and most frequently used. It's also for you if you have seen that in your organization, it's the Excel power users who get promoted, and you want to join them. This...
Amazon Digital Services, 2017. — 678 p. — ASIN B06XHLB2PZ. This book introduces readers to the basics of using MS Excel and gradually moves to more advanced usage of Excel Formulas and Calculations. It is a step by step guide to advance Excel and is written in the most simplest of English Language for better understanding and implementation.
Independently published, 2021. — 151 p. — ISBN B08Y83GSTH. Excel is an exceptionally powerful tool for reporting and analyzing marketing data. On the other, without the proper training, it’s easy to feel like it’s working against you. For starters, there are more than a dozen critical formulas Excel can automatically run for you so you’re not combing through hundreds of cells...
Oxford University Press, 2010. — 315 p. — ISBN: 0199296286, 9780199296286. Taking a thematic approach to the use of Excel spreadsheets in introductory business data analysis, this text has been designed to explain the overall nature of what is to be achieved and also instruction in how it is to be done. The learning approach is highly interactive and enables students to develop...
Mobo Publications, 2017. - 251p. - ASIN: B06XVK3D87 This book shows the capabilities of Microsoft Excel in teaching business statistics effectively. 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...
5th ed. — Microsoft Press, 2016. — 864 p. — ISBN: 9781509304219 Only sample files! Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable...
Orem, Utah: Sharon Parq Associates, 2012. – 1421 p. язык: английский. Вятт Аллен. Жемчуг экселеведения на каждый день. Сборник из 1772-х полезных советов по Экселю-2003, от американского экселезнавца Аллена Вятта, автора 35 компьютероведческих книг, окажется безусловно полезен как начинающим пользователям, так и умудренным опытом виртуозам таблиц, которые просматривая Tips'ы,...
Wiley, 2005. – 497 p. – ISBN: 0764588117, 9780764588112 You'll thoroughly examine the main features of Excel's reporting technology-PivotTable reports, Spreadsheet reports, parameter queries, and web components. With notes, tips, warnings, and real-world examples in each chapter, you'll be able to put your knowledge to work immediately. If you're a SQL programmer or an...
Apress, 2021. — 251 p. — ISBN 1484278410. Master Excel in less than two weeks with this unique project based book! Let’s face it, we all we all master skills in our own way, but building a soup-to-nuts project is one of the best ways to make learning stick and up and get up-to-speed quickly. Whether you are just getting started with Excel or an experienced user, this book will...
Apress, 2021. — 251 p. — ISBN 1484278410. Master Excel in less than two weeks with this unique project based book! Let’s face it, we all we all master skills in our own way, but building a soup-to-nuts project is one of the best ways to make learning stick and up and get up-to-speed quickly. Whether you are just getting started with Excel or an experienced user, this book will...
М.: Вильямс, 2006. — 464 с. — ISBN: 5-8459-0878-7. В этой книге приведены примеры того, как с помощью Microsoft Excel создавать электронные таблицы, обрабатывающие огромные массивы данных и при этом остающиеся понятными и "прозрачными" для последующих пользователей. Здесь анализируются принципы создания больших и сложных таблиц, которые легко применять и сопровождать....
М. : Издательский дом "Вильямс", 2006. — 464 с. В этой книге приведены примеры того, как с помощью Microsoft Excel создавать электронные таблицы, обрабатывающие огромные массивы данных и при этом остающиеся понятными и "прозрачными" для последующих пользователей. Здесь анализируются принципы создания больших и сложных таблиц, которые легко применять и сопровождать....
СПб.: Наука и Техника, 2019. — 386 c. — ISBN: 978-5-94387-771-1. В этой книге будет рассмотрен весь широчайший спектр возможностей Excel по проведению вычислений, построению графиков и анализу данных - от самых простых (создание и редактирование таблиц, работа с ячейками и т.д.), до расширенных возможностей (проведение расчетов (решение алгебраических уравнений, использование...
СПб.: Наука и Техника, 2019. — 386 c. — ISBN: 978-5-94387-771-1. В этой книге будет рассмотрен весь широчайший спектр возможностей Excel по проведению вычислений, построению графиков и анализу данных - от самых простых (создание и редактирование таблиц, работа с ячейками и т.д.), до расширенных возможностей (проведение расчетов (решение алгебраических уравнений, использование...
Санкт-Петербург: Диалектика, 2020. — 784 с. — ISBN 978-5-9908910-1-2. Данная книга — идеальное руководство по работе с формулами в Excel, позволяющее изучить все аспекты применения программы. Книга содержит множество полезнейших советов и готовых рецептов, которые помогут вам ускорить, упростить и лучше организовать свой рабочий процесс. Вы освоите профессиональные методики,...
Различные способы разбиения объектов на группы в Excel. Расчет абсолютных, относительных и кумулятивных частот в Excel. Способы отбора данных в Excel - от простого к сложному (расширенный фильтр и вычисляемый критерий; функция БД).
Использование условных форматов для представления данных в Excel 2003 и 2007 (лекционный материал и практическое занятие).
Содержание:
Условное форматирование - выделение дубликатов цветом.doc
Выделение дубликатов цветом.xls
Сравнение версий 2003, 2007 и 2010 (лекционные материалы)
Содержание:
Новые возможности Excel 2007.
Умные таблицы Excel 2007.
Карта_Excel_2003-2007.
Новые возможности в интерфейсе Excel 2010.
Новые возможности сводных таблиц в Excel 2010.
Пер. с англ. — М. : ООО “И.Д. Вильямс”, 2014. — 960 с.: ил.
В книге изложены принципы оценки активов и принятия финансовых решений в условиях неопределенности, позволяющие сотрудникам немедленно повысить эффективность работы своих фирм и описаны стандартные корпоративные финансовые модели, которые сопровождаются ясными и четкими инструкциями, а также примерами из реальной...
М.: Вильямс, 2005. — 560 с.
Книга написана преподавателями математики и статистики и выдержала несколько переизданий на разных языках. Авторы успешно использовали свой педагогический опыт для создания вводного курса по статистическому анализу для широкого круга читателей с разной подготовкой: от студентов математических, инженерных, биологических, медицинских и экономических...
М.: Вильямс, 2005. Компакт-диск к книге Берк К., Кэйри П. Анализ данных с помощью Microsoft Excel. С данного компакт-диска можно загрузить специализированный подключаемый модуль StatPlus, который существенно расширяет функциональные возможности Excel. Кроме того, на нем представлено 10 интерактивных учебных пособий с подробным описанием и демонстрацией основных статистических...
2-е изд., исправленное.— М.: Национальный Открытый Университет «Интуит», 2016. Курс посвящен Excel - основам программирования в Excel, связи Excel с базами данных и другими источниками данных, анализу офисной деятельности, выполняемыми средствами Excel, созданию интерактивных документов в Excel, приданию Web-страницам функциональности Excel. Он познакомит слушателей с...
2-е изд., исправленное.— М.: Национальный Открытый Университет «Интуит», 2016. Курс посвящен Excel - основам программирования в Excel, связи Excel с базами данных и другими источниками данных, анализу офисной деятельности, выполняемыми средствами Excel, созданию интерактивных документов в Excel, приданию Web-страницам функциональности Excel. Он познакомит слушателей с...
Методическое пособие. Изложены элементы численных методов в инженерных и экономических расчетах. Приведены примеры их реализации с использованием табличного процессора Excel. НГТУ: Нижний Новгород. - 2000. 37с.
Пер. с англ. — М: Издательский дом "Вильямс", 2002. — 864 с. Книга является всеобъемлющим и полезным пособием по использованию Microsoft Excel 2002 - наиболее мощной и полной по своим возможностям программы электронных таблиц.
Красногорск, 2000. (Выходные данные не указаны). Краткий курс, предназначенный для обучения созданию проектов бизнес-приложений в среде MS Excel. Освещает различные тонкости и приемы программирования. Имеется иллюстративный пример к реальному проекте Учет Спецодежды. Интерактивная система для обучения основам программирования в Excel. Основная задача разработки – предоставить...
Москва: Вильямс, 2004. — 512. В книге обсуждается использование Excel для решения прикладных научных и инженерно-физических задач. Помимо основных сведений о принципах работы в Excel, читателю предлагается большое количество практических примеров, охватывающих дифференцирование и интегрирование функций, решение уравнений, в том числе дифференциальных и интегральных, поиск...
M. : Вильямс, 2004. — 512 с. — ISBN: 5-8459-0573-7. В книге обсуждается использование Excel для решения прикладных научных и инженерно-физических задач. Помимо основных сведений о принципах работы в Excel, читателю предлагается большое количество практических примеров, охватывающих дифференцирование и интегрирование функций, решение уравнений, в том числе дифференциальных и...
Киев: МИ Стрельбицкого, 2017. — 131 с. Основное достоинство практических руководств Андрея Ветрова — невероятный, фантастический уровень доходчивости. По этим книгам ученик среднего школьного возраста сможет изучить и Word, и Excel. Эта книга научит вас пользоваться офисной программой от компании Microsoft — Excel.
Киев: МИ Стрельбицкого, 2017. — 131 с. Основное достоинство практических руководств Андрея Ветрова — невероятный, фантастический уровень доходчивости. По этим книгам ученик среднего школьного возраста сможет изучить и Word, и Excel. Эта книга научит вас пользоваться офисной программой от компании Microsoft — Excel.
Киев: МИ Стрельбицкого, 2017. — 131 с. Основное достоинство практических руководств Андрея Ветрова — невероятный, фантастический уровень доходчивости. По этим книгам ученик среднего школьного возраста сможет изучить и Word, и Excel. Эта книга научит вас пользоваться офисной программой от компании Microsoft — Excel.
6-е издание. — СПб.: Питер, 2021. — 944 с. — (IT для бизнеса). Уэйн Винстон научит вас быстро анализировать данные, принимать решения, подводить итоги, составлять отчеты, обрабатывать данные и строить аналитические модели в Microsoft Excel 2019 и Office 365. В новом шестом издании вас ждут более 800 бизнес-задач, основанных на реальных ситуациях, а также обсуждение новых...
6-е издание. — СПб.: Питер, 2021. — 944 с. — (IT для бизнеса). Уэйн Винстон научит вас быстро анализировать данные, принимать решения, подводить итоги, составлять отчеты, обрабатывать данные и строить аналитические модели в Microsoft Excel 2019 и Office 365. В новом шестом издании вас ждут более 800 бизнес-задач, основанных на реальных ситуациях, а также обсуждение новых...
Книга предназначена для самостоятельного освоения средств, методов и нюансов создания профессиональных офисных проектов на основе MS Excel. Досконально разобрана объектная модель Excel, описан объектно-ориентированный подход к программированию офисных приложений, рассмотрены вопросы создания пользовательского интерфейса и справочной системы, автоматизации операций с рабочим листом...
Практикум. — СПб.: Питер, 2003. — 240 с. Учебное пособие для студентов, изучающих математику, преподавателей, а также специалистов, по долгу службы имеющих дело с математической обработкой данных. Отличительной особенностью предлагаемого учебного пособия является рассмотрение основных разделов математики не в традиционном изложении — с использованием карандаша и бумаги, а с...
СПб.: Питер, 2006. — 368 с.: ил. — (Трюки и эффекты). — ISBN: 5-469-01223-9. Данная книга предназначена для пользователей Excel и содержит содержание приемов и методов работы, которые ввиду своей специфичности недостаточно представлены в других книгах. Изучение приведенных примеров позволит открыть неизвестные ранее возможности!
М.: ДМК Пресс, 2007. — 96 с.: ил. — ISBN: 5-9706-0036-9. Данная серия практических книг предназначена для руководителей любого уровня. Поскольку каждый управленец применяет в своей работе электронную почту, Интернет, Word и Excel и, как правило, работает в среде Windows. В связи с этим парадокс: владеть программными пакетами требуется ежедневно, а времени на освоение нет. Выход...
М.: ДМК Пресс, 2007. — 96 с. Данная серия практических книг предназначена для руководителей любого уровня, поскольку каждый управленец применяет в своей работе электронную почту, Интернет, Word и Excel и, как правило, работает в среде Windows. В связи с этим парадокс: владеть программными пакетами требуется ежедневно, а времени на освоение нет. Выход — данная серия книг,...
Пер. с англ. Е.С. Шаниной. — М.: АСТ; НТ Пресс, 2014. — 304 с.: ил. — ISBN: 978-5-17-079552-9, ISBN 978-5-94966-234-2. Задумывались ли Вы когда-нибудь, есть ли в Excel что-либо большее, чем данные, отображаемые в строках и столбцах, и красивые диаграммы ? Если Вы хотите узнать, как переместить данные в свои проекты Excel, научиться работать с XML, увидеть, как...
Пер. с англ. Е.С. Шаниной. — М.: АСТ; НТ Пресс, 2014. — 304 с.: ил. — ISBN: 978-5-17-079552-9, ISBN 978-5-94966-234-2. Задумывались ли Вы когда-нибудь, есть ли в Excel что-либо большее, чем данные, отображаемые в строках и столбцах, и красивые диаграммы ? Если Вы хотите узнать, как переместить данные в свои проекты Excel , научиться работать с XML, увидеть, как...
М.: ООО "И.Д. Вильямс", 2007. - 320 с. - ISBN: 978-5-8459-1180-3, 0-7897-3435-4
Эта книга поможет вам понять суть сводных таблиц и принципы их использования. Изучив первые две главы, вы научитесь создавать базовые сводные таблицы и сразу сможете повысить производительность работы - необходимые отчеты будут получаться в течение нескольких минут, а не часов. Освоив первые семь...
Пер. с англ. — М.: ‘Вильямс’, 2006. — 624 с. Москва Санкт-Петербург Киев В этой книге рассматривается автоматизация выполнения всевозможных задач с помощью Excel VBA - от создания простого отчета до разработки полноценного приложения Excel "с нуля". Авторы книги полагаются на достаточно высокий уровень подготовки читателя, однако допускают, что материал каждой главы не знаком...
Пер. с англ. — М.: Вильямс, 2006. — 624 с. В этой книге рассматривается автоматизация выполнения всевозможных задач с помощью Excel VBA - от создания простого отчета до разработки полноценного приложения Excel "с нуля". Авторы книги полагаются на достаточно высокий уровень подготовки читателя, однако допускают, что материал каждой главы не знаком ему в полном объеме. Особое...
М.: Издательский дом «Вильямс», 2004. — 208 с.: ил. Назначение этой книги состоит в том, чтобы предоставить читателю основной статистический аппарат, который он сможет использовать для проведения индивидуальных статистических исследований и подготовки деловых прогнозов с помощью пакета Microsoft Excel. Книга написана в простом доступном стиле. В ней широко используются...
М.: Издательский дом «Вильямс», 2004. — 208 с.: ил. Назначение этой книги состоит в том, чтобы предоставить читателю основной статистический аппарат, который он сможет использовать для проведения индивидуальных статистических исследований и подготовки деловых прогнозов с помощью пакета Microsoft Excel. Книга написана в простом доступном стиле. В ней широко используются...
СПб.: БХВ-Петербург, 2003. — 544 с.: ил.
В книге приведены формулировки задач, предназначенных для решения в электронных таблицах MS Excel и включающих как общие задания по работе в программе, так и вопросы, для успешного ответа на которые у учащихся предполагается наличие более глубоких знаний. Вспомогательные рисунки, таблицы, примеры диаграмм и графиков способствуют четкому...
СПб.: БХВ-Петербург, 2003. — 544 с.: ил. В книге приведены формулировки задач, предназначенных для решения в электронных таблицах MS Excel и включающих как общие задания по работе в программе, так и вопросы, для успешного ответа на которые у учащихся предполагается наличие более глубоких знаний. Вспомогательные рисунки, таблицы, примеры диаграмм и графиков способствуют четкому...
СПб.: Наука и Техника, 2025. — 352 с.: ил. В этом справочнике-практикуме рассмотрены все основные возможности Excel: от самых простых (создание и редактирование таблиц, работа с ячейками, списки и сортировка и т.п.), до расширенных возможностей (использование функций Excel, решение уравнений, построение графиков и диаграмм, группировка данных и использование сводных таблиц,...
Автор неизвестен / Электронное пособие.
Содержание:
Электронная таблица Понятие электронной таблицы.
Книга Excel.
Ввод данных Форматирование листа Excel.
Оформление ячеек.
Стиль.
Формат чисел.
Добавление строк и столбцов.
Размеры ячеек и их замораживание.
Контрольное упражнение.
Подведение итогов.
Формулы и функции Вычисления в Excel.
Ввод формул.
Функции.
Диапазон...
Вы привыкли работать в MS Office 2003 и вас так же, как меня, бесит, что самые обычные значки на панели инструментов в MS Office 2007 приходится искать по несколько минут? Эта программа поможет вам самому находить любые значки, не прибегая к помощи более опытных пользователей.
ШИ (ф) ЮРГТУ (НПИ), 2009г., 10 стр.
Вкратце об Excel
Рабочие книги
Рабочие листы
Листы диаграмм
Листы макросов XLM
Интерфейс пользователя Excel
Введение в ленту
Контекстные вкладки
Типы команд ленты
Панель быстрого доступа
Быстрый доступ к ленте с помощью клавиатуры
Контекстные меню
Диалоговые окна
Комбинации клавиш
Область задач
Настройка отображения
Ввод...
СПб.: БХВ-Петербург, 2007. - 320 с. - ISBN: 978-5-9775-0049-4
Обучение программированию в Microsoft Excel построено на практических примерах различной сложности. Рассмотрены простые примеры автоматизации рутинных операций и более сложные примеры, такие как создание автоматизированных бланков для заказа продукции или программирование логических игр на листе Microsoft Excel....
М.: Солон-Пресс, 2023. — 256 с., ил. — ISBN 978-5-91359-315-3. — (Библиотека студента). Книга является практическим руководством по моделированию задач с использованием приложения MS Excel и VBA. Пособие предназначено для школьников, студентов и преподавателей, которые хотят быть знакомы с MS Excel и VBA "на Вы" и научиться моделированию, разработке моделей, алгоритмов и...
М.: Солон-Пресс, 2019. — 256 с. — (Библиотека студента). Книга является практическим руководством по моделированию задач с использованием приложения MS Excel и VBA. Пособие предназначено для школьников, студентов и преподавателей, которые хотят быть знакомы с MS Excel и VBA "на Вы" и научиться моделированию, разработке моделей, алгоритмов и программ, а также приложений с...
М.: Солон-Пресс, 2019. — 256 с. — (Библиотека студента). Книга является практическим руководством по моделированию задач с использованием приложения MS Excel и VBA. Пособие предназначено для школьников, студентов и преподавателей, которые хотят быть знакомы с MS Excel и VBA "на Вы" и научиться моделированию, разработке моделей, алгоритмов и программ, а также приложений с...
Минск: Харвест, 2004. — 48 с. Прочитав новую книгу из серии «Какие кнопки нажимать», вы узнаете все о популярной среди пользователей программе - Mikrosoft Excel. Это иллюстрированное руководство по самой функциональной и в то же время простой в использовании программе электронных таблиц. В книге приведены основные сведения о создании и редактировании рабочих листов и книг, работе...
Пер. с англ. — М.: Эксмо, 2007. — 224 с.
Эта книга - карманное руководство, призванное помочь вам изучить и освоить средства анализа данных Excel (подбор параметра, таблицы подстановки, сценарии и поиск решения) для вашей собственной пользы. Существует множество задач, которые быстро и просто решаются средствами анализа данных «что - если» Microsoft Excel, например, вы можете...
М.: Эксмо, 2007. — 224 с. Пер. с англ. Эта книга - карманное руководство, призванное помочь вам изучить и освоить средства анализа данных Excel (подбор параметра, таблицы подстановки, сценарии и поиск решения) для вашей собственной пользы. Существует множество задач, которые быстро и просто решаются средствами анализа данных «что - если» Microsoft Excel, например, вы можете...
М.: Эксмо, 2007. — 224 с. Пер. с англ. Эта книга - карманное руководство, призванное помочь вам изучить и освоить средства анализа данных Excel (подбор параметра, таблицы подстановки, сценарии и поиск решения) для вашей собственной пользы. Существует множество задач, которые быстро и просто решаются средствами анализа данных «что - если» Microsoft Excel, например, вы можете...
БХВ-Петербург, 2002, 208 с.
Книга посвящена последней версии табличного процессора Microsoft Excel 2002, входящего в пакет Microsoft Office XP, и позволяет быстро научиться выполнять различные расчеты, построить и печатать диаграммы, вставлять таблицы или диаграммы в документ Microsoft Word. Большое внимание уделено вопросам обработки данных, использованию Excel в качестве базы...
Презентация к видеокурсу. — М.: Специалист, 2019. — 6 слайдов. Данный курс, расчитанный на 16 ак часов , читается в центре повышения квалификации при Бауманском университете в Москве. По ссылке Курс Microsoft Excel 3 (Анализ и визуализация данных в Microsoft Excel) нужно скачать архив с записью Вебинара этого курса и со всеми таблицами Excel , которые используются во время...
Пер. с англ. А. Ю. Гинько. – М.: ДМК Пресс, 2021. – 338 с.: ил. В этой книге поэтапно рассматриваются средства Excel, связанные с визуализацией данных, – от элементарных операций с рабочими листами до построения полноценных диаграмм и дашбордов. Вы научитесь анализировать огромные массивы данных и представлять их в сжатом и понятном виде, обеспечивать их визуальную...
Пер. с англ. А. Ю. Гинько. – М.: ДМК Пресс, 2021. – 338 с.: ил. Сопроводительные файлы к книге Куслейка Д. Визуализация данных при помощи дашбордов и отчетов в Excel - /file/4058145/
Учебное пособие. — М.: СОЛОН-Пресс, 2016. — 144 c.: ил. — (Библиотека студента). — ISBN 978-5-98003-030-1. Книга посвящена вопросу построения диаграмм при помощи программы Microsoft Excel. Подробно рассмотрены все типы диаграмм, их свойства и возможности, которыми они обладают. В тексте приведены также способы решения различных проблем и преодоления трудностей, которые могут...
М.: СОЛОН-Пресс, 2009. — 144 с. — (Библиотека студента) ISBN: 5-98003-030-1. Книга посвящена вопросу построения диаграмм при помощи программы Microsoft Excel. Подробно рассмотрены все типы диаграмм, их свойства и возможности, которыми они обладают. В тексте приведены также способы решения различных проблем и преодоления трудностей, которые могут возникнуть в процессе работы...
СПб.: Питер, 2008. — 208 с. — (Мультимедийный курс). — ISBN 978-5-388-00152-8. Трудно представить себе компьютер, на котором не установлен Microsoft Office. Этот пакет включает программы, с помощью которых решаются многие повседневные задачи студентов, бухгалтеров, инженеров, менеджеров. Можно было бы перечислить еще огромное количество профессий, для которых приложения пакета...
СПб.: Питер, 2008. — 208 с. — (Мультимедийный курс). — ISBN: 978-5-388-00152-8. Эта книга - не обычный самоучитель. Книга поможет вам разобраться в премудростях Microsoft Excel 2007. Информационная насыщенность учебного материала позволяет утверждать, что мультимедийный курс будет интересен и новичкам, и опытным пользователям, которые уже владеют основными навыками работы в...
М.: Эксмо, 2007. - 240 с.
В книге лаконично описан весь процесс принятия решения, начиная от формализации исходной проблемы, далее через построение и решение математической модели до анализа решения и формирования управленческого решения. Основное внимание уделено построению и решению математических моделей и анализу этих решений в Excel с помощью надстройки «Поиск решения» и...
М.: Юниор, 1999. — 528 с. Данная книга представляет популярную программу электронных таблиц Excel с несколько неожиданной точки зрения — как мощное средство инженерных и научных расчетов. Для решения сложных задач, таких как численное дифференцирование или интегрирование, всегда использовались специализированные пакеты прикладных программ. Сегодня ситуация изменилась коренным...
Пер. с англ. — К.: Юниор, 1999. — 528 с. Данная книга представляет популярную программу электронных таблиц Excel с несколько неожиданной точки зрения — как мощное средство инженерных и научных расчетов. Для решения сложных задач, таких как численное дифференцирование или интегрирование, всегда использовались специализированные пакеты прикладных программ. Сегодня ситуация...
М.: Книга по Требованию, 2017. — 240 с. : ил. — ISBN 978-5-519-50143-9. В этой книге практикующий IT-тренер и MVP по Excel Николай Павлов делится секретами создания и отладки сложных формул в программе Microsoft Excel. Подробно разбираются нюансы работы с дубликатами, извлечение топовых значений, сравнение списков, поиск и подстановка данных, настройка связей между таблицами и...
М.: Книга по требованию, 2014. — 360 с.
Эта книга представляет собой полноценный сборник готовых решений самых распространенных проблем и задач, с которыми сталкиваются в повседневной работе пользователи Microsoft Excel.
Материал книги охватывает все основные направления и темы: работу с текстом и датами, форматирование, вычисления с помощью формул и функций, обработку больших...
М.: Книга по требованию, 2016-2017. — 240 с.: ил. В этой книге практикующий IT-тренер и MVP по Excel Николай Павлов делится секретами создания и отладки сложных формул в программе Microsoft Excel. Подробно разбираются нюансы работы с дубликатами, извлечение топовых значений, сравнение списков, поиск и подстановка данных, настройка связей между таблицами и многое другое. Книга...
СПб.: Питер; К.: Издательская группа BHV, 2008. — 397 с. ISBN 966-552-080-6 * ISBN 978-5-94723-169-4 n Назначение данной книги — научить читателей эффективно использовать мощные средства программы Excel в задачах, относящихся к сфере экономики и организации производства. Материал излагается в доступной форме по принципу от простого к сложному. Рассматриваются такие темы, как...
Учебно-практическое пособие. — 2-е изд., дополненное. — Москва: Альфа-Пресс, 2015. — 159 с. — ISBN 978-5-94280-618-7. В настоящем пособии представлены основные правила и практические приемы работы с числовыми массивами данных на основе статистических и оптимизационных методов пакета Excel. Особое внимание уделено вопросам представления и обработки данных, исследуемых с помощью...
Лабораторный практикум по дисциплине «Информатика» для специальностей "Интеллектуальные приборы, машины и производства" и "Интегральные сенсорные системы". — Минск: БНТУ, 2005. — 38 с. В издании рассматриваются основные приемы работы в среде Microsoft Excel - эффективной программе для работы с данными, представленными в табличном виде. Приводятся определения основных понятий,...
СПб.: БХВ-Петербург, 2005. — 368 с.
Рассматриваются математические задачи (работа с массивами, задачи оптимизации, численное решение задачи Коши для обыкновенного дифференциального уравнения первого порядка и др. ), экономические задачи (нахождение платы по процентам, расчет регулярных выплат по займу, оценка эффективности капиталовложений и др. ), задачи построения различных...
СПб.: БХВ-Петербург, 2005. — 368 с.
Рассматриваются математические задачи (работа с массивами, задачи оптимизации, численное решение задачи Коши для обыкновенного дифференциального уравнения первого порядка и др. ), экономические задачи (нахождение платы по процентам, расчет регулярных выплат по займу, оценка эффективности капиталовложений и др. ), задачи построения различных...
БХВ-Петербург, 2020. — 624 с.: ил. — (В подлиннике). — ISBN: 978-5-9775-4074-2. Наиболее полное руководство по возможностям и средствам, доступным пользователям в версии Microsoft Office Excel 2019. Изложены базовые сведения о работе с табличным процессором и форматами обрабатываемых данных, возможности создания и редактирования формул и функций на рабочих листах, визуализации...
М., СПб: ДИАЛЕКТИКА, 2002, -250с.
Наглядный курс создания интерактивных электронных таблиц.
Понятие о макросах Excel, отладка макросов.
Использование редактора Visual Basic.
Основы программирования в VBA.
Настройка диалоговых окон, меню, панелей.
Автоматизация процедур.
Пер. с англ. — М.: Вильямс; Киев: Диалектика, 2004. — 528 с. Данная книга отличается от многочисленных изданий, посвященных Excel и анализу данных, необычным подходом к изложению материала. Несмотря на то, что книга адресована начинающим пользователям, к ней могут обратиться и опытные пользователи. Каждая глава книги посвящена отдельному аспекту анализа данных с помощью Excel....
Москва : СмартБук, 2013. - 429, [1] с.; ISBN 978-5-9791-0306-8 Эта книга представляет собой практическое руководство по использованию мощного инструмента (Microsoft Excel) для выполнения любой сложной задачи, например, построения финансовой модели. Кратко и внятно рассказывается об использовании электронных таблиц в финансовом планировании и бизнес-расчётах. Несмотря на быструю...
Иркутск: БГУ, 2018. — 73 с. Рассматриваются вопросы, связанные с использованием табличного процессора Microsoft Excel при осуществлении расчетно-экономической деятельности и решении иных задач. Для обучающихся по направлениям «Экономика», «Менеджмент», слушателей курсов дополнительного профессионального образования, а также практикующих бухгалтеров, аудиторов, аналитиков,...
Эком, 2002 г. - 400 стр. ISBN 5-7163-0088-X.
Книга предлагает новый подход к диагностике и разрешению проблем, возникающих
при работе с Excel. Ее отличают удобство, простота использования и высокая
скорость поиска ответов. Книга представляет собой справочник, где все проблемы
сгруппированы по главам, упорядоченным по алфавиту. Блок-схема в начале каждой
главы позволяет...
М., СПб., К.: Издательский дом "Вильямс", 2003. — 448 с. Рассматривается версия MS Excel XP (2002). В настоящее время эта книга - единственное всеобъемлющее руководство по созданию диаграмм графическими средствами Excel. В книге подробно рассмотрены типы диаграмм, способы их создания, форматирования и настройки, устранение неполадок в диаграммах, интерактивные диаграммы,...
М.: Вильямс, 2003. — 448 с.
Рассматривается версия MS Excel XP (2002).
В книге подробно рассмотрены типы диаграмм, способы их создания, форматирования и настройки, устранение неполадок в диаграммах, интерактивные диаграммы, добавление линий тренда, сглаживание и прогнозирование зависимостей, анимация и автоматизация
диаграмм средствами Visual Basic и другие вопросы....
М.: Издательский дом "Вильямс", 2002. — 624с. Эта книга предназначена для продвинутых пользователей. Содержание: Основные сведения. Использование функций в формулах. Финансовые формулы. Формулы массива. Совершенное владение формулами. Разработка пользовательских функций. Приложения. Готовые примеры в формате .xls.
М.: Вильямс, 2002. — 624 с. Именно формулы делают любую электронную таблицу действительно электронной. Чем больше Вы узнаете о формулах, тем лучше будут Ваши таблицы. Эта книга предназначена как для начинающих, так и для продвинутых пользователей. Основные сведения. Использование функций в формулах. Финансовые формулы. Формулы массива. Совершенное владение формулами. Разработка...
Лабораторный практикум (для студентов направления «Психология») – Омск: Изд-во Ом. гос. ун-та, 2011. – 48 с. ISBN: 978-5-7779-1268-8 Представлены лабораторные работы по теме «Электронные таблицы Microsoft Excel», даны методические указания по их выполнению, краткие теоретические сведения, подробно описывается ход решения, указана балльно-рейтинговая система оценки работы студентов.
Альпина Диджитал, 2016. — ISBN: 978-5-9614-4076-8. Казалось бы, термин «большие данные» понятен и доступен только специалистам. Но автор этой книги доказывает, что анализ данных можно организовать и в простом, понятном, очень эффективном и знакомом многим Excel. Причем не важно, сколько велик ваш массив данных. Техники, предложенные в этой книге, будут полезны и владельцу...
М.: Альпина Паблишер, 2016. - 485 с.
Казалось бы, термин «большие данные» понятен и доступен только специалистам. Но автор этой книги доказывает, что анализ данных можно организовать и в простом, понятном, очень эффективном и знакомом многим Excel. Причем не важно, сколько велик ваш массив данных. Техники, предложенные в этой книге, будут полезны и владельцу небольшого...
СПб.: Питер, 2006. — 368 с. : ил. Электронные таблицы применяются во множестве областей — от построения сложных финансовых отчетов и сводок до обработки массивов статистических данных. Благодаря своей выдающейся универсальности и мощи Microsoft Excel заслуженно считается одной из самых популярных программ в мире. В книге описаны всевозможные проблемы и недочеты, а также скрытые...
М.: Вильямс, 2004. —304 с. Серия: "Для "чайников". ISBN 5-8459-0227-4 (рус.) — ISBN: 0-7645-0822-9 (англ.) Harvey G.- Excel 2002 for Dummies Переводчик: Пер. с англ. Е.Н.Дериевой Данная книга — это простое и дружеское руководство по популярной программе электронных таблиц Excel 2002. В ней описаны основные технические способы создания, редактирования и печати рабочих таблиц,...
К.: Диалектика, 1996. - 320 с. - ISBN: 5-7707-9821-1 Грег Харвей, которого можно назвать великим знатоком электронных таблиц, предлагает самую свежую информацию об Excel для Windows 95 — последней версии популярной программы электронных таблиц фирмы Microsoft. Вы познакомитесь со всеми возможностями программы Excel. В результате ваши рабочие таблицы, диаграммы и отчеты,...
СПб: Питер, 2006. – 288 с. – ISBN: 5-469-00384-1, 978-5-469-00384-7. За последние десять лет Excel фундаментально изменил способы работы с числовыми данными, но большинство его возможностей все еще остается в тени. Книга "Excel. Трюки" помогает читателю перейти сразу же к практическим инструментам и методам анализа, обработки и представления данных. Прочитав эту книгу Вы...
СПб.: Питер, 2006. — 288 с. — ISBN 5-469-00384-1,978-5-469-00384-7.
В издании рассматриваются методы наиболее эффективной обработки данных, которые помогают воспользоваться всей мощью Excel и быстро добиться необходимых результатов.
Книга предназначена для студентов, аналитиков и всех пользователей компьютеров, желающих узнать о возможностях Excel, связанных с обработкой...
Киев: Диалектика, 2002. — 464 с. Книга посвящена графическому анализу статистических данных с использованием Microsoft Excel 2000. В ней рассматривается комплекс теоретических и прикладных вопросов, связанных с методологией и автоматическим построением статистических диаграмм и их применением при различных статистических методах обработки и анализа социально-экономической...
Киев: Диалектика, 2002. — 464 с. Книга посвящена графическому анализу статистических данных с использованием Microsoft Excel 2000. В ней рассматривается комплекс теоретических и прикладных вопросов, связанных с методологией и автоматическим построением статистических диаграмм и их применением при различных статистических методах обработки и анализа социально-экономической...
Методические рекомендации. — Витебск : Витебский государственный университет имени П.М. Машерова, 2021. — 48 с. Методические рекомендации разработаны в соответствии с программой дисциплины «Прикладная информатика» и могут использоваться при изучении дисциплины «Информационные технологии в экономике и бизнесе» специальности 1-26 03 01 Управление информационными ресурсами и...
Москва : Манн, Иванов и Фербер, 2023. — 496 с. ISBN 978-5-00214-072-5 Перед вами универсальный справочник по работе с Excel и Google Таблицами. Нескучное изложение всех ключевых тем, нужных большинству пользователей Excel: интерфейс, таблицы, проверка данных, формулы и функции, сводные таблицы, визуализация данных. Вас ждут более 100 функций, инструментов, нюансов и горячих...
ОГЛАВЛЕНИЕ. ФУНКЦИИ В Excel. Основные операции c книгой в Excel. Общие данные о книге. Управление листами. Структура листа. Управление столбцом (строкой). Формат ячейки. Понятие диапазона. Выделение диапазона. Ввод информации в ячейки. Автозаполнение ячеек. Раскрывающиеся списки. Объединение ячеек. Копирование содержимого ячеек. Сортировка и фильтрация. Закрепление областей...
М.: Гроссмедиа, 2005. — 512 с. — ISBN: 5-476-00111-5
В книге описаны основные методы работы с популярным продуктом Microsoft Excel, предназначенным для работы с электронными таблицами. В издании приводится огромное количество примеров и иллюстраций по работе с электронными таблицами. Читатель найдет ммного советов и приемов, которые потом может применить в самостоятельной...
М.: Гроссмедиа, 2005. — 503 с. — ISBN: 5-476-00111-5. В книге описаны основные методы работы с популярным продуктом Microsoft Excel, предназначенным для работы с электронными таблицами. В издании приводится огромное количество примеров и иллюстраций по работе с электронными таблицами. Читатель найдет много советов и приемов, которые потом может применить в самостоятельной...
Когда закончим с этим разделом, будет крайне желательно проделать аналогичную операцию с другими разделами по программам пакета Office (Word, Access и т.д.)
Комментарии