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...
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...
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,...
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
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...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
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...
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...
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.
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...
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...
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...
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,...
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...
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, 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...
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....
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...
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...
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...
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, 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, 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...
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...
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...
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...
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...
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. — 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...
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...
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...
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...
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
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...
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, 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, 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...
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 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...
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...
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...
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...
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,...
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.
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...
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., 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...
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...
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. — 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...
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...
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...
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...
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...
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...
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...
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:...
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:...
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...
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...
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...
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...
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...
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...
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....
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. — 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,...
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...
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...
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...
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...
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...
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. - 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,...
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, 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, 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...
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...
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...
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...
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...
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. — 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...
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...
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...
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...
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...
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,...
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...
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...
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...
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...
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...
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...
М.: Эксмо, 2007. — 224 с. Пер. с англ. Эта книга - карманное руководство, призванное помочь вам изучить и освоить средства анализа данных Excel (подбор параметра, таблицы подстановки, сценарии и поиск решения) для вашей собственной пользы. Существует множество задач, которые быстро и просто решаются средствами анализа данных «что - если» Microsoft Excel, например, вы можете...
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, 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...
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...
Когда закончим с этим разделом, будет крайне желательно проделать аналогичную операцию с другими разделами по программам пакета Office (Word, Access и т.д.)
Комментарии