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. - 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...
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...
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, 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...
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...
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...
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...
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:...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
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.
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. — 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,...
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,...
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.
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...
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:...
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...
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...
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. - 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. - 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...
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...
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...
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, 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...
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...
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...
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...
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. — 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, 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...
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...
Когда закончим с этим разделом, будет крайне желательно проделать аналогичную операцию с другими разделами по программам пакета Office (Word, Access и т.д.)
Комментарии