Excel 2019 Bible, Alexander Michael, Kusleika Richard
Новое издание
Автор: Alexander, Michael Kusleika, Dick Walkenbach, John Название: Microsoft excel 365 bible ISBN: 1119835100 ISBN-13(EAN): 9781119835103 Издательство: Wiley Цена: 6732.00 р. Наличие на складе: Поставка под заказ. Описание:
Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365
Excel 365 is Microsoft's latest cloud-based version of its world-famous spreadsheet app. Powerful and user-friendly, it's an ideal solution for businesses and people looking to make sense of--and draw intelligence from--their data.
The Excel 365 Bible carries over the best content from the best-selling Excel 2019 Bible while reflecting how a new generation uses Excel in Excel 365. The authoring team with their decades of Excel and business intelligence experience and recognition from the Excel community as Excel MVPs delivers an accessible and authoritative roadmap to Excel 365. Interested in the basics? You'll learn to create spreadsheets and workbooks and navigate the user interface. If you're ready for more advanced topics you can skip right to the material on creating visualizations, crafting custom functions, and using Visual Basic for Applications to script automations.
You'll also get:
Over 900 pages of powerful tips, tricks, and strategies to unlock the full potential of Microsoft Excel 365
Guidance on how to import, manage, and analyze large amounts of data
Advice on how to craft predictions and "What-If Analyses" based on data you already have
Perfect for anyone new to Excel, as well as experts and advanced users, the Excel 365 Bible is your comprehensive, go-to guide for everything you need to know about the world's most popular, easy-to-use spreadsheet software.
Автор: Frye Curtis Название: Microsoft Excel 2019 Step by Step ISBN: 1509307672 ISBN-13(EAN): 9781509307678 Издательство: Pearson Education Рейтинг: Цена: 7889.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: The quick way to learn Microsoft Excel 2019
This is learning made easy. Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers-brisk lessons and detailed screenshots show you exactly what to do, step by step.
Quickly set up workbooks, enter data, and format it for easier viewing
Perform calculations and find and correct errors
Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines
Visualize data with 3D maps, funnel charts, and other powerful tools
Import, process, summarize, and analyze huge datasets with Excel's improved PowerPivot and Power Query
Build powerful data models and use them in business intelligence
Look up just the tasks and lessons you need
Автор: Walkenbach, Walkenbach John Название: Excel 2016 Bible ISBN: 1119067510 ISBN-13(EAN): 9781119067511 Издательство: Wiley Рейтинг: Цена: 6732.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: The complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs.
Автор: Harvey Greg Название: Excel 2019 All-In-One for Dummies ISBN: 111951794X ISBN-13(EAN): 9781119517948 Издательство: Wiley Рейтинг: Цена: 4434.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Make Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release.
Автор: Jelen Bill Название: Microsoft Excel 2019 Inside Out ISBN: 1509307699 ISBN-13(EAN): 9781509307692 Издательство: Неизвестно Рейтинг: Цена: 6519.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Conquer Microsoft Excel 2019-from the inside out
Dive into Microsoft Excel 2019-and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds-all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today's key tasks-and challenge yourself to new levels of mastery.
Enter formulas more efficiently, and fully control operators and dates
Master the most widely-used functions in Excel
Integrate external data from the web and other sources
Easily transform complex datasets with Power Query
Quickly summarize millions of records with Pivot Tables
Perform ad hoc analyses with slicers and other filters
Create advanced data mashups with Power Pivot
Solve complex problems with What-If, Scenario Manager, Goal Seek, and Solver
Automate repetitive tasks by editing recorded VBA code
Demystify data with conditional formatting and other visualization techniques
Use the newest maps, charts, and data types in Excel
Show geographical changes over time with animated 3D maps
Use dynamic array functions: SORT, FILTER, UNIQUE, SORTBY and SEQUENCE
Find insights using Excel's new artificial intelligence
Collaborate via Excel 2019's breakthrough CoAuthoring tools
Publish Power BI Desktop dashboards based on Excel data
Автор: Jelen Bill, Alexander Michael Название: Microsoft Excel 2019 Pivot Table Data Crunching ISBN: 1509307249 ISBN-13(EAN): 9781509307241 Издательство: Pearson Education Рейтинг: Цена: 4830.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables.
Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power-including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical "recipes" for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else. By reading this book, you will: - Master easy, powerful ways to create, customize, change, and control pivot tables - Control all future pivot tables using new pivot table defaults - Transform huge data sets into clear summary reports - Instantly highlight your most profitable customers, products, or regions - Use Power Query to quickly import, clean, shape, and analyze disparate data sources - Build geographical pivot tables with 3D Map - Construct and share state-of-the-art dynamic dashboards - Revamp analyses on the fly by dragging and dropping fields - Build dynamic self-service reporting systems - Share your pivot tables with colleagues - Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 - Automate pivot tables with macros and VBA - Save time by adapting reports with GetPivotData - Discover today's most useful pivot table tips and shortcuts
Автор: McFedries Paul Название: Microsoft Excel 2019 Formulas and Functions ISBN: 1509306196 ISBN-13(EAN): 9781509306190 Издательство: Pearson Education Рейтинг: Цена: 4830.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more powerful spreadsheets.
Use Excel 2019 and Office 365 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including the latest improvements to arrays, formula error handling, and statistics. McFedries' step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate- to advanced-level formula construction, and help you leverage Excel's most useful functions in your everyday work. Becoming an Excel expert has never been easier By reading this book, you will: - Improve business analyses by adding intelligence and knowledge to your models - Replace cumbersome formulas with convenient predefined functions - Radically simplify complex calculations with Office 365's new dynamic arrays - Use conditional formatting to reveal anomalies, problems, or opportunities - Calculate loan payments, interest costs, terms, and amortization schedules - Project the future value of investments, and plan to achieve investment goals - Master essential discounting and cash-flow analysis tools, including net present value and internal rate of return - Sort, filter, and analyze tabular data, from customers to inventory - Easily analyze huge data sets with PivotTable calculations About This Book - For everyone who wants to get more done with Microsoft Excel in less time - For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data
Описание: While most studies of the Holocaust stop in 1945, the year of the liberation and the official end of the Holocaust, Tamas Stark follows the fate of the Hungarian Jews until the Communist takeover in the late 1940s. The author goes on to cover the enlarged, war-years territory of Hungary, and then to a detailed comparison of the destruction of Jewish communities and the emigration of the survivors.
Автор: Girvin Mike Название: Ctrl+Shift+Enter Mastering Excel Array Formulas ISBN: 1615470077 ISBN-13(EAN): 9781615470075 Издательство: Gazelle Book Services Рейтинг: Цена: 6218.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: 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 how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots.
Автор: Jelen Bill Название: Mrexcel XL: The 40 Greatest Excel Tips of All Time ISBN: 1615470409 ISBN-13(EAN): 9781615470402 Издательство: Gazelle Book Services Рейтинг: Цена: 5146.00 р. Наличие на складе: Поставка под заказ.
Описание: 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 cocktails. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.
Автор: McFedries Paul Название: Teach Yourself Visually Excel 2016 ISBN: 1119074738 ISBN-13(EAN): 9781119074731 Издательство: Wiley Рейтинг: Цена: 3483.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: See your way to Excel spreadsheet stardom with this visual guide If you`re always hearing about the cool things Excel can do, here`s your chance to see how to do them!Teach Yourself Visually Excel offers you a straightforward visual approach to working with the newest version of the world`s leading spreadsheet program.
Автор: McFedries Paul Название: Teach Yourself Visually Excel 2013 ISBN: 1118505395 ISBN-13(EAN): 9781118505397 Издательство: Wiley Рейтинг: Цена: 3483.00 р. Наличие на складе: Поставка под заказ.
Описание: The step-by-step, visual way to learn Excel 2013 Excel can be complicated, but this Visual guide shows you exactly how to tackle every essential task with full-color screen shots and step-by-step instructions.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
