Игра для Microsoft

Сводные таблицы – один из наиболее мощных инструментов в Excel. Помимо возможности быстро и удобно агрегировать исходные данные, они позволяют менять структуру анализа на лету, перемещая поля из одной области в другую. Из этой книги вы узнаете, как создавать базовые сводные таблицы, которые помогут сократить время формирования аналитических отчетов, а также более сложные таблицы с возможностью выполнения детализации и выводом сопутствующих диаграмм. К концу чтения вы сможете создавать полноценные системы отчетности на основе динамических сводных таблиц. Издание предназначено как для опытных аналитиков, так и для обычных пользователей Excel, обладающих базовыми навыками работы с программой. Для выполнения примеров, описываемых в книге, понадобится установленный Microsoft Excel на платформе Windows.

Get a firm grip on one of the most popular project management applications on the market today In Microsoft Project Fundamentals: Microsoft Project Standard 2021, Professional 2021, and Project Online Editions , accomplished project management leader Teresa Stover delivers a hands-on introduction to Microsoft’s popular project management software filled with real-world examples and plain-language guidance. The book walks you through how to plan, schedule, manage resources, track progress, and more. In the book, you’ll: Learn principles and best practices of project management while mastering Microsoft Project capabilities, calculations, and views Understand how task durations, dependencies, and date constraints power the project schedule Manage human, equipment, and material resources, including availability, cost, and task assignments Adjust the project to optimize for the project finish date, budget, and resource allocation Use Microsoft Project to manage waterfall or agile projectsIdeal for anyone seeking to unlock the potential of Microsoft’s leading project management software for their own project work, Microsoft Project Fundamentals is an essential resource for those new to Microsoft Project and project management, as well as previous users and seasoned project professionals looking for a refresher in the latest features of the newest version of Microsoft Project.

Leverage the integration of SQL Server and Office for more effective BI Applied Microsoft Business Intelligence shows you how to leverage the complete set of Microsoft tools—including Microsoft Office and SQL Server—to better analyze business data. This book provides best practices for building complete BI solutions using the full Microsoft toolset. You will learn how to effectively use SQL Server Analysis and Reporting Services, along with Excel, SharePoint, and other tools to provide effective and cohesive solutions for the enterprise. Coverage includes BI architecture, data queries, semantic models, multidimensional modeling, data analysis and visualization, performance monitoring, data mining, and more, to help you learn to perform practical business analysis and reporting. Written by an author team that includes a key member of the BI product team at Microsoft, this useful reference provides expert instruction for more effective use of the Microsoft BI toolset. Use Microsoft BI suite cohesively for more effective enterprise solutions Search, analyze, and visualize data more efficiently and completely Develop flexible and scalable tabular and multidimensional models Monitor performance, build a BI portal, and deploy and manage the BI Solution

Work seamlessly together with Microsoft Teams  It was only a matter of time before Microsoft 365 built an actual virtual office. And Microsoft Teams is it, rocketing from 13 to 75 million daily users in a single year. The new edition of  Microsoft Teams For Dummies  gives you an in-depth introductory tour through the latest version of the app, exploring the many different ways you can chat, call, meet, work remotely, and collaborate with others in real time—whether you’re using it as an all-in-one tool for working from home or as an extension to your brick-and-mortar office. Available as a stand-alone app or as part of Microsoft 365, it allows you to work seamlessly with almost any other Microsoft app.  The friendly onboarding provided by this book takes you from the basics of file-sharing, organizing teams, and using video to must-have insights into less obvious functionality, such as posting the same message to multiple channels, muffling background noise (useful if you’re working from home!), and choosing more than one feed to concentrate on when video-conferencing (allowing you to pay attention to the speaker and your team members at the same time). As well as clueing you in on how things work, you’ll also find advice on the most effective ways of using them, with best-practices recommendations and tips on integrating Microsoft Teams into your existing workflows.  Set up the interface Communicate on chat and video, inside and outside your org Integrate Microsoft Teams with your other Office apps Optimize your approach to meetings, working across large teams, and more! Whether you’re using Microsoft Teams for work, within your family, or for a collaborative hobby, you’ll find everything you need to get everyone on the same page in the same virtual room.

Tap the power of Big Data with Microsoft technologies Big Data is here, and Microsoft's new Big Data platform is a valuable tool to help your company get the very most out of it. This timely book shows you how to use HDInsight along with HortonWorks Data Platform for Windows to store, manage, analyze, and share Big Data throughout the enterprise. Focusing primarily on Microsoft and HortonWorks technologies but also covering open source tools, Microsoft Big Data Solutions explains best practices, covers on-premises and cloud-based solutions, and features valuable case studies. Best of all, it helps you integrate these new solutions with technologies you already know, such as SQL Server and Hadoop. Walks you through how to integrate Big Data solutions in your company using Microsoft's HDInsight Server, HortonWorks Data Platform for Windows, and open source tools Explores both on-premises and cloud-based solutions Shows how to store, manage, analyze, and share Big Data through the enterprise Covers topics such as Microsoft's approach to Big Data, installing and configuring HortonWorks Data Platform for Windows, integrating Big Data with SQL Server, visualizing data with Microsoft and HortonWorks BI tools, and more Helps you build and execute a Big Data plan Includes contributions from the Microsoft and HortonWorks Big Data product teams If you need a detailed roadmap for designing and implementing a fully deployed Big Data solution, you'll want Microsoft Big Data Solutions.

Blow past the jargon and get hands-on, practical guidance on managing any project with Microsoft Project  Lean. Agile. Hybrid. It seems that project management these days comes with more confusing buzzwords than ever. But you can make managing your next project simple and straightforward with help from  Microsoft Project For Dummies.  This book unpacks Microsoft’s bestselling project management platform and walks you through every important feature, step-by-step, until you’re ready to take on virtually any project, no matter the size. From getting set up for the first time to creating tasks, managing resources and working with time management features, you’ll learn everything you need to know about managing a project in Microsoft’s iconic software.  You’ll also find:  Totally updated guidance that applies to both the desktop version and Microsoft’s new subscription-based Microsoft Project Online Helpful information on integrating Agile practices and techniques into your project “Golden rules” that keep a project on-track and on-time Ways to effectively manage your resources with Microsoft Project’s built-in functionality Managing a project, big or small, is no easy task. Luckily,  Microsoft Project For Dummies  can take a lot of the hassle out of your day-to-day life. Learn how to take advantage of this powerful software today!

Windows security concepts and technologies for IT beginners IT security can be a complex topic, especially for those new to the field of IT. This full-color book, with a focus on the Microsoft Technology Associate (MTA) program, offers a clear and easy-to-understand approach to Windows security risks and attacks for newcomers to the world of IT. By paring down to just the essentials, beginners gain a solid foundation of security concepts upon which more advanced topics and technologies can be built. This straightforward guide begins each chapter by laying out a list of topics to be discussed, followed by a concise discussion of the core networking skills you need to have to gain a strong handle on the subject matter. Chapters conclude with review questions and suggested labs so you can measure your level of understanding of the chapter's content. Serves as an ideal resource for gaining a solid understanding of fundamental security concepts and skills Offers a straightforward and direct approach to security basics and covers anti-malware software products, firewalls, network topologies and devices, network ports, and more Reviews all the topics you need to know for taking the MTA 98-367 exam Provides an overview of security components, looks at securing access with permissions, addresses audit policies and network auditing, and examines protecting clients and servers If you're new to IT and interested in entering the IT workforce, then Microsoft Windows Security Essentials is essential reading.

The core concepts and technologies of Windows networking Networking can be a complex topic, especially for those new to the field of IT. This focused, full-color book takes a unique approach to teaching Windows networking to beginners by stripping down a network to its bare basics, thereby making each topic clear and easy to understand. Focusing on the new Microsoft Technology Associate (MTA) program, this book pares down to just the essentials, showing beginners how to gain a solid foundation for understanding networking concepts upon which more advanced topics and technologies can be built. This straightforward guide begins each chapter by laying out a list of topics to be discussed, followed by a concise discussion of the core networking skills you need to have to gain a strong handle on the subject matter. Chapters conclude with review questions and suggested labs so you can measure your level of understanding of the chapter's content. Serves as an ideal resource for gaining a solid understanding of fundamental networking concepts and skills Offers a straightforward and direct approach to networking basics and covers network management tools, TCP/IP, the name resolution process, and network protocols and topologies Reviews all the topics you need to know for taking the MTA 98-366 exam Provides an overview of networking components, discusses connecting computers to a network, and looks at connecting networks with routers If you're new to IT and interested in entering the IT workforce, then Microsoft Windows Networking Essentials is essential reading.