Office eBooks
Pro Exchange 2019 and 2016 Administration, 2nd Edition
Use this one-stop resource for both basic and advanced administration of Exchange Server 2019 and 2016. It will help you in running an Exchange environment, whether it be 100% on-premises or a hybrid configuration with Exchange Online (as part of Office 365). This revised version is divided into four sections, describing Exchange infrastructure, upgrading Exchange server, integration with Office 365, and security and compliance. In the first section, you will go through a short introduction of Exchange server followed by its installation and configuration. You will learn client access along with Exchange mailbox and managing Exchange recipients. In the second section, you will learn how to upgrade from Exchange 2010 to 2016 and from 2013 to Exchange 2019. The third section is dedicated to the Exchange integration with Office 365, followed by the last section that teaches you how to secure your Exchange environment and its compliance. After reading this book, ...
Use this one-stop resource for both basic and advanced administration of Exchange Server 2019 and 2016. It will help you in running an Exchange environment, whether it be 100% on-premises or a hybrid configuration with Exchange Online (as part of Office 365). This revised version is divided into four sections, describing Exchange infrastructure, upgrading Exchange server, integration with Office 365, and security and compliance. In the first section, you will go through a short introduction of Exchange server followed by its installation and configuration. You will learn client access along with Exchange mailbox and managing Exchange recipients. In the second section, you will learn how to upgrade from Exchange 2010 to 2016 and from 2013 to Exchange 2019. The third section is dedicated to the Exchange integration with Office 365, followed by the last section that teaches you how to secure your Exchange environment and its compliance. After reading this book, ...
Microsoft Excel Formulas and Functions
Use Excel 365 and Excel 2021 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 recent improvements ranging from dynamic arrays to XLOOKUP and LET. 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 Excels most useful functions in your everyday work. By reading this book, you will: Improve business analyses by adding intelligence and knowledge to your models; Replace cumbersome formulas with convenient predefined functions; Use modern lookups to make your formulas more powerful and flexible; Simplify complex calculations with dynamic arrays in Excel 365 and Excel 2021; Use conditional formatting to reveal anom ...
Use Excel 365 and Excel 2021 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 recent improvements ranging from dynamic arrays to XLOOKUP and LET. 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 Excels most useful functions in your everyday work. By reading this book, you will: Improve business analyses by adding intelligence and knowledge to your models; Replace cumbersome formulas with convenient predefined functions; Use modern lookups to make your formulas more powerful and flexible; Simplify complex calculations with dynamic arrays in Excel 365 and Excel 2021; Use conditional formatting to reveal anom ...
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 of User ...
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 of User ...
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 powerful ...
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 powerful ...
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 ...
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 ...
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, universities, movi ...
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, universities, movi ...
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. ...
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
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 Query; Build ge ...
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 Query; Build ge ...
The Project Managers Guide to Microsoft Project 2019
This guide is an all-in-one training resource and reference that covers all versions found in the Microsoft Project 2019 suite. It is not a "how-to" manual covering the features and functions of the software, but is designed to explain and demonstrate why those features and functions are important to you as a project manager, allowing you to maximize the value of Microsoft Project 2019. Each aspect of project-manager-specific coverage was selectively compiled by author and Microsoft Project expert Cicala over more than two decades of consulting, project management training, and managing real-world projects using Microsoft Project. Readers will appreciate the robust index and intuitively organized and learning-oriented chapters, and sub-sections for quick reference and problem solving. "Try it" exercises at the close of every chapter help ensure understanding of the content. ...
This guide is an all-in-one training resource and reference that covers all versions found in the Microsoft Project 2019 suite. It is not a "how-to" manual covering the features and functions of the software, but is designed to explain and demonstrate why those features and functions are important to you as a project manager, allowing you to maximize the value of Microsoft Project 2019. Each aspect of project-manager-specific coverage was selectively compiled by author and Microsoft Project expert Cicala over more than two decades of consulting, project management training, and managing real-world projects using Microsoft Project. Readers will appreciate the robust index and intuitively organized and learning-oriented chapters, and sub-sections for quick reference and problem solving. "Try it" exercises at the close of every chapter help ensure understanding of the content. ...
Microsoft Office 2019 Step by Step
Get more done quickly with Office 2019. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step. Covers Word, Excel, PowerPoint and Outlook; Format Word documents for maximum visual impact; Build powerful, reliable Excel workbooks for analysis and reporting; Prepare highly effective PowerPoint presentations; Use Outlook to organize your email, calendar, and contacts; Includes downloadable practice files. ...
Get more done quickly with Office 2019. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step. Covers Word, Excel, PowerPoint and Outlook; Format Word documents for maximum visual impact; Build powerful, reliable Excel workbooks for analysis and reporting; Prepare highly effective PowerPoint presentations; Use Outlook to organize your email, calendar, and contacts; Includes downloadable practice files. ...
Agile Office 365
Plan, deploy, and run Office 365 using an agile project management approach. This soup-to-nuts guide teaches you how to apply agile techniques in order to make your Office 365 implementation a success, even as the Microsoft Office 365 platform continues to evolve and introduce new features. The author's approach to teaching time- and resource-saving concepts mirrors the process a team might typically encounter in delivering software projects. Learning begins with an overview of Office 365 and Agile. From there, you delve into topics correlating to product conception, execution, and deployment. The book wraps up with a comprehensive discussion on how Office 365, straight out of the box, can be used as a tool to manage Office 365 deployments and other types of projects. Understand what Office 365 is and why it is the world's most popular online business app; Adapt your delivery process to work with Office 365 and its regular u ...
Plan, deploy, and run Office 365 using an agile project management approach. This soup-to-nuts guide teaches you how to apply agile techniques in order to make your Office 365 implementation a success, even as the Microsoft Office 365 platform continues to evolve and introduce new features. The author's approach to teaching time- and resource-saving concepts mirrors the process a team might typically encounter in delivering software projects. Learning begins with an overview of Office 365 and Agile. From there, you delve into topics correlating to product conception, execution, and deployment. The book wraps up with a comprehensive discussion on how Office 365, straight out of the box, can be used as a tool to manage Office 365 deployments and other types of projects. Understand what Office 365 is and why it is the world's most popular online business app; Adapt your delivery process to work with Office 365 and its regular u ...