Microsoft Excel

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...

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...

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...

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,...

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, 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.

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...

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...

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...

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...

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...

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...

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...

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...

Maros, 2019. — 34 S. Die 21 wichtigsten Funktionen im Überblick.

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:...

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...

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...

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...

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...

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...

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.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. — 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...

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...

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...

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,...

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...

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...

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. — 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...

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...

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...

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...

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...

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...

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...

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...

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...

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-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...