?>
IT eBooks
Download, Read, Use

Microsoft eBooks

Microsoft Excel VBA and Macros
Microsoft Excel VBA and Macros

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you wont find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Microsoft Excel. Youll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development; Work more efficiently with ranges, cells, and formulas; Generate automated reports and quickly adapt them for new requirements; Learn to automate PivotTables to summarize, analyze, explore, and present data; Leverage more of Excel VBAs power with classes, collections, and Advanced Filter; Make the most ...
Microsoft Project Step by Step
Microsoft Project Step by Step

This is learning made easy. Get more done quickly with Microsoft Project. Jump in wherever you need answers. Brisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly start a new plan, build task lists, and assign resources; Share your plan and track your progress; Capture and fine-tune work and cost details; Use Gantt charts and other views and reports to visualize project schedules; Share resources across multiple plans and consolidate projects; Manage Agile plans using the new task boards to create backlogs, plan sprints, and hold scrum meetings; Learn more about integrating Project with Microsoft 365 solutions for collaboration; Master project management best practices as you learn Project; Easily identify the features and lessons you need. ...
Microsoft Excel Inside Out
Microsoft Excel Inside Out

Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel and its latest innovations, from advanced analysis and visualizations to dashboards. Discover how experts tackle todays key tasksand challenge yourself to new levels of mastery. Save time with galleries, keyboard accelerators, and other shortcuts; Enter formulas more efficiently, and fully control operators and dates; Use new data types to return photos, arrays, or weather history and even create your own; Master Excels most widely-used functions; Integrate external data from the web and other sources; Use the new XLOOKUP function to retrieve data more efficiently, with fewer errors; Store p ...
Microsoft Office Inside Out
Microsoft Office Inside Out

Dive into the Microsoft Office application suiteand really put its productivity tools and services to work for you! This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Offices most powerful tools for productivity and decision-making. Renowned Office expert Joe Habraken offers a complete tour of Microsoft Office, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, Publisher, the 365 Online apps, and more. Discover how experts tackle todays key tasksand challenge yourself to new levels of mastery. Create amazing content faster with Offices new features, tools, and shortcuts; Share, collaborate with, and secure Office files in the cloud; Organize, edit, and format complex documents with Microsoft Word; Build tables of contents, captions, indexes, and footnotes that automatically update; Efficiently enter and manage data in Excel workbooks, and format it fo ...
Developing Microservices Architecture on Microsoft Azure with Open Source Technologies
Developing Microservices Architecture on Microsoft Azure with Open Source Technologies

Increasingly, organizations are modernizing application development by integrating open source technologies into a holistic architecture for delivering high-quality workloads to the cloud. This is a complete, step-by-step guide to building flexible microservices architecture by leveraging Microsoft Azure cloud services, together with key open source technologies such as Java, Node.JS, .NET Core and Angular. Through a realistic case study project, expert Microsoft engineers Ovais Mehboob Ahmed Khan and Arvind Chandaka guide you through every step of technical implementation required to achieve value: establishing end-to-end infrastructure, developing cloud-native applications, automating deployments, monitoring operations, and more. Microsoft engineers Ovais Mehboob Ahmed Khan and Arvind Chandaka show how to: Define application features and business requirements, and map them onto microservices using modeling techniques; Design microservices solution architecture ...
Microsoft Azure Data Solutions
Microsoft Azure Data Solutions

Cloud technologies are advancing at an accelerating pace, supplanting traditional relational and data warehouse storage solutions with novel, high-value alternatives. Now, three pioneering Azure Data consultants offer an expert introduction to the relational, non-relational, and data warehouse solutions offered by the Azure platform. Drawing on their extensive experience helping organizations get more value from the Microsoft Data Platform, the authors guide you through decision-making, implementation, operations, security, and more. Throughout, step-by-step tutorials and hands-on exercises prepare you to succeed, even if you have no cloud data experience. Three leading experts in Microsoft Azure Data Solutions show how to: Master essential concepts of data storage and processing in cloud environments; Handle the changing responsibilities of data engineers moving to the cloud; Get started with Azure data storage accounts and other data facilities; Walk through implemen ...
Microsoft Excel Data Analysis and Business Modeling, 7th Edition
Microsoft Excel Data Analysis and Business Modeling, 7th Edition

Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winstons hands-on, scenario-focused guide helps you use todays Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts. Solve real problems with Microsoft Exceland build your competitive advantage. Quickly transition from Excel basics to sophisticated analytics; Use recent Power Query enhancements to connect, combine, and transform data sources more effectively; Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA; Use New Data Types to import data including stock prices, weather, information on geographic areas, univ ...
Microsoft Excel Step by Step
Microsoft Excel Step by Step

This is learning made easy. Get more done, more quickly, with Microsoft Excel. Jump in wherever you need answersbrisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for effective visual impact; Perform calculations and find and correct errors; Manage, filter, summarize, validate, reorder, and combine data; Identify trends, illustrate processes and relationships, and dynamically analyze data; Build sophisticated forecasts, key performance indicators (KPIs), and timelines; Visualize data with customized charts, 3D maps, and other powerful tools; Import, process, summarize, and analyze huge data sets with PowerPivot and Power Query; Use powerful Excel Data Models for advanced business intelligence. ...
Microsoft Excel Pivot Table Data Crunching
Microsoft Excel Pivot Table Data Crunching

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if youve never created a pivot table before, this book will help you leverage all their flexibility and analytical power including important recent improvements in Microsoft 365 Excel. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen (MrExcel) shares practical recipes for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks youll find nowhere else. By reading this book, you will: Master easy, powerful ways to create, customize, change, and control pivot tables; Transform huge datasets into clear summary reports; Instantly highlight your most profitable customers, products, or regions; Use the data model and Power Query to quickly analyze disparate data sources; Create powerful crosstab reports with new dynamic arrays and Power Q ...
Automated Machine Learning with Microsoft Azure
Automated Machine Learning with Microsoft Azure

Automated Machine Learning with Microsoft Azure helps you to build high-performing, accurate machine learning models in record time. It allows anyone to easily harness the power of artificial intelligence and increase the productivity and profitability of your business. With a series of clicks on a guided user interface (GUI), novices and seasoned data scientists alike can train and deploy machine learning solutions to production with ease. This book will teach you how to use Azure AutoML with both the GUI as well as the AzureML Python software development kit (SDK) in a careful, step-by-step way. First, you'll learn how to prepare data, train models, and register them to your Azure Machine Learning workspace. You'll then discover how to take those models and use them to create both automated batch solutions using machine learning pipelines and real-time scoring solutions using Azure Kubernetes Service (AKS). Finally, you will be able to use AutoML on your own data to not onl ...
Microsoft 365 Compliance
Microsoft 365 Compliance

Use the information presented in this book to implement an end-to-end compliance program in your organization using Microsoft 365 tools. You will learn about the solutions available in the Microsoft 365 Compliance Center, including best practices and common pitfalls. IT professionals will benefit from the author's approach of introducing each topic within a practical business context and scenarios behind the "whys" of compliance. Compliance managers will understand how to implement their requirements in Microsoft 365. Compliance and risk management is often a board- or CEO-level issue. The risks of hefty fines and bad PR from non-compliance are severe. IT is usually responsible for implementing compliance controls and for working with compliance and legal officers to manage the day-to-day risk in an organization. After reading Microsoft 365 Compliance, you will be prepared to have a well-informed conversation with your compliance and legal officers to d ...
← Prev       Next →
Reproduction of site books is authorized only for informative purposes and strictly for personal, private use.
Only Direct Download
IT eBooks Group © 2011-2024