|
 |
|
 |
|
|
 |
|  |
|
 Название: Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas
Автор: Alan Murray
Издательство: Apress
Год: 2022
Формат: True PDF
Страниц: 834
Размер: 78,7 Mb
Язык: English
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 manner that you can read it cover-to-cover or pick it up and learn something new in just 5 minutes.
The book begins with a primer on Excel formulas and functions. Starting from a basic level, but diving into intricate detail and building a solid understanding of the fundamentals. It may not always be sexy, but learning why, in addition to how, is important to truly understanding Excel formulas. Having strong fundamentals is the most advanced skill.
The book covers all the most popular functions in Excel including VLOOKUP, SUMPRODUCT, COUNTIFS, MATCH, SORT and so much more. You will learn how to return multiple results with a single formula. Harness the power of the dynamic array engine and functions such as SEQUENCE, SORTBY, UNIQUE, XLOOKUP and FILTER to create top N Lists, models and reports that would seem impossible without array formulas. In the final chapter, we discover the amazing LAMBDA function in Excel. Create your own Excel functions to simplify future Excel formulas and share them with others. | |
Разместил: vitvikvas 29-08-2022, 10:51 | Комментарии: 0 | Подробнее
| | | |
 |
|  |
|
|
|
|
|
|
| |
|
Название: Компьютер за 15 минут
Автор: Жуков И.
Издательство: АСТ
Год: 2016
Формат: pdf
Страниц: 287
Размер: 11 mb
Язык: Русский
Можно ли научиться работать на компьютере за 15 минут? Да, при условии, что у вас в руках правильная книга! Простая и доступная. Книга, в которой вместо длинных объяснений – иллюстрации и краткие алгоритмы. Книга, в которой нет ни одного сложного слова. | |
Разместил: na5ballov 28-08-2022, 14:22 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: Технологии поиска и хранения информации. Технологии автоматизации управления
Автор: Могилев А.В., Листрова Л.В
Издательство: Бхв - Петербург
Год: 2012
Формат: pdf
Страниц: 321
Размер: 11 Mb
Язык: Русский
Рассматриваются понятие, основные принципы построения и классификация информационных систем; базы данных как основной компонент информационной системы; основы SQL: Microsoft Access. Разобраны понятия и модели теории управления, также технологии управления, планирования и организации деятельности человека. Представлены материалы по автоматизированным информационным системам в различных сферах человеческой деятельности. | |
Разместил: rivasss 22-08-2022, 08:35 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
 Название: Power Query в Excel и Power BI: сбор, объединение и преобразование данных
Автор: Равив Гил
Издательство: БXB
Год: 2021
Формат: PDF
Страниц: 471
Размер: 17,2 Mb
Язык: Русский
В книге описан Power Query, инструмент для продвинутого бизнес-анализа, встроенный в Excel, Power BI и другие продукты Microsoft и предназначенный для подключения к источникам данных и их преобразования. Рассказано, как обрабатывать таблицы Excel без использования сложных формул и макросов, выбирать данные из нескольких источников, объединять несовпадающие таблицы, сохранять контекст при формировании запросов. Особое внимание уделено базовым и продвинутым методам отмены свертывания столбцов (Unpivot) и совместной работе над отчетами Дано введение в язык формул M и показано, как правильно формировать запросы, избегая сбоев и «ловушек». Рассмотрены вопросы текстовой аналитики и извлечения знаний из текстов, а также аналитики социальных сетей. В конце книги приведен заключительный проект, объединяющий и закрепляющий полученные навыки. | |
Разместил: vitvikvas 18-08-2022, 09:59 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
 Название: Practical Linux DevOps: Building a Linux Lab for Modern Software Development
Автор: John S. Tonello
Издательство: Apress
Год: 2022
Формат: True PDF
Страниц: 351
Размер: 10 Mb
Язык: English
This book helps Linux users and others to learn, develop and hone their Linux and DevOps skills by building a lab for learning, testing and exploring the latest Linux and open-source technologies. Having a home or work-based Linux lab is indispensable to anyone looking to experiment with the ever-evolving landscape of new software and DevOps. With open-source tools and readily available hardware, readers will end up with a lab they can use to try virtually any modern software, including Chef, Docker, Kubernetes and stalwarts like DNS, Dovecot and Postfix for email. Readers will focus on discrete projects that help them learn through doing and, as a result, acquire the skills they need to become better informed, more marketable engineers and developers, and better able to take on a wide array of software projects with confidence. | |
Разместил: vitvikvas 15-08-2022, 09:49 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
 Название: Snowflake: The Definitive Guide: Architecting, Designing, and Deploying on the Snowflake Data Cloud
Автор: Joyce Kay Avila
Издательство: O’Reilly Media
Год: 2022
Формат: ePUB
Страниц: 400
Размер: 14,7 Mb
Язык: English
Snowflake's ability to eliminate data silos and run workloads from a single platform creates opportunities to democratize data analytics, allowing users at all levels within an organization to make data-driven decisions. This clear, comprehensive guide will show you how to build integrated data applications and develop new revenue streams based on data. The author deftly unravels complex topics, provides hands-on SQL examples, and reveals how you can use the Snowflake Data Cloud to avoid replatforming or migrating data unnecessarily. | |
Разместил: vitvikvas 11-08-2022, 19:36 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
 Название: Pro Database Migration to Azure: Data Modernization for the Enterprise
Автор: Kevin Kline, Denis McDowell, Dustin Dorsey, Matt Gordon
Издательство: Apress
Год: 2022
Формат: True PDF
Страниц: 345
Размер: 10 Mb
Язык: English
Migrate your existing, on-premises applications into the Microsoft Azure cloud platform. This book covers the best practices to plan, implement, and operationalize the migration of a database application from your organization’s data center to Microsoft’s Azure cloud platform.
Data modernization and migration is a technologically complex endeavor that can also be taxing from a leadership and operational standpoint. This book covers not only the technology, but also the most important aspects of organization culture, communication, and politics that so frequently derail such projects. You will learn the most important steps to ensuring a successful migration and see battle-tested wisdom from industry veterans. From executive sponsorship, to executing the migration, to the important steps following migration, you will learn how to effectively conduct future migrations and ensure that your team and your database application delivers on the expected business value of the project. | |
Разместил: vitvikvas 11-08-2022, 16:39 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
 Название: Interactive Visual Data Analysis (AK Peters Visualization Series)
Автор: Christian Tominski, Heidrun Schumann
Издательство: A K Peters/CRC Press
Год: 2020
Формат: PDF
Страниц: 365
Размер: 13,2 Mb
Язык: English
In the age of big data, being able to make sense of data is an important key to success. Interactive Visual Data Analysis advocates the synthesis of visualization, interaction, and automatic computation to facilitate insight generation and knowledge crystallization from large and complex data.
The book provides a systematic and comprehensive overview of visual, interactive, and analytical methods. It introduces criteria for designing interactive visual data analysis solutions, discusses factors influencing the design, and examines the involved processes. The reader is made familiar with the basics of visual encoding and gets to know numerous visualization techniques for multivariate data, temporal data, geo-spatial data, and graph data. A dedicated chapter introduces general concepts for interacting with visualizations and illustrates how modern interaction technology can facilitate the visual data analysis in many ways. Addressing today’s large and complex data, the book covers relevant automatic analytical computations to support the visual data analysis. The book also sheds light on advanced concepts for visualization in multi-display environments, user guidance during the data analysis, and progressive visual data analysis. | |
Разместил: vitvikvas 10-08-2022, 05:07 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
 Название: Инструментальные средства MS Office: учебное пособие
Автор: О.В. Гаркуша
Издательство: Кубанский государственный университет
Год: 2022
Формат: PDF
Страниц: 165
Размер: 10 Mb
Язык: Русский
Содержит материал о возможностях использования средств визуального программирования и решения задач линейного программирования в приложениях MS Office. | |
Разместил: vitvikvas 8-08-2022, 16:31 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
 Название: Querying SQL Server. Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified analytics
Автор: Adam Aspin
Издательство: BPB Online
Год: 2022
Формат: True ePUB
Страниц: 622
Размер: 11 Mb
Язык: English
This book will take you on an interactive journey to master SQL querying from the most fundamental to the most advanced level using various T-SQL techniques to provide meaningful insights from your SQL Server data.
The book begins with an introduction to the fundamental concepts of both SQL and SQL Server. It then guides readers through the process of building queries, using simple and then more complex table joins and progressively more advanced data filtering, to deliver advanced queries based on a variety of SQL techniques. The reader will understand how to deliver relevant and trustworthy analysis of the data through learning how to apply fundamental computations in T-SQL, relational logic, and how to group and aggregate data. There is also coverage of other SQL concepts, such as formatting queries, writing subqueries, creating derived tables, joining and filtering tables, etc. In addition to that, the book discusses how to conduct rolling analyses, examine time-series data, and manage large and complex datasets. | |
Разместил: vitvikvas 3-08-2022, 13:59 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
Навигация
Вход на сайт
Реклама
