Conquer Microsoft Office 2019–from the inside out! Dive into Microsoft Office 2019–and really put its productivity toolsand services to work! This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Office’s most powerful tools for productivity and decision-making. Renowned Office expert Joe Habraken offers a complete tour of Office 2019 and Office 365, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, Publisher, online Office apps, and more. Discover how experts tackle today’s key tasks–and challenge yourself to new levels of mastery. Create amazing content faster with Office’s 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 for easy understanding Build flexible, reliable Excel workbooks with formulas and functions Integrate data from external sources, including web tables, text files, and more Transform data into insight with Excel charts, Sparklines, and PivotTables Quickly create presentations with PowerPoint themes, Reuse Slides, and Libraries Build more impactful slides with advanced formatting, SmartArt, animation, transitions, and multimedia Use PowerPoint 2019 tools to present more effectively, both in person and online Systematically improve email productivity and security with Outlook 2019 Manage appointments and tasks, and quickly plan meetings

Conquer Microsoft Office 365 Administration–from the inside out! Dive into Microsoft Office 365 Administration–and really put your Office 365 expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to plan, implement, and operate Microsoft Office 365 in any environment. In this completely revamped Second Edition, a new author team thoroughly reviews the administration tools and capabilities available in the latest versions of Microsoft Office 365, and also adds extensive new coverage of Azure cloud services and SharePoint. Discover how experts tackle today’s essential tasks–and challenge yourself to new levels of mastery. • Install, customize, and use Office 365’s portal, dashboard, and admin centers • Make optimal decisions about tenancy, licensing, infrastructure, and hybrid options • Prepare your environment for the cloud • Manage Office 365 identity and access via federation services, password and directory synchronization, authentication, and AAD Connect • Implement alerts and threat management in the Security & Compliance Center • Establish Office 365 data classifications, loss prevention plans, and governance • Prepare your on-premises environment to connect with Exchange Online • Manage resource types, billing and licensing, service health reporting, and support • Move mailboxes to Exchange Online via cutover, staged, and express migrations • Establish hybrid environments with the Office 365 Hybrid Configuration Wizard • Administer Exchange Online, from recipients and transport to malware filtering • Understand, plan, and deploy Skype for Business Online Current Book Service In addition, this book is part of the Current Book Service from Microsoft Press. Books in this program receive periodic updates to address significant software changes for 12 to 18 months following the original publication date via a free Web Edition. Learn more at https://www.microsoftpressstore.com/cbs.

Conquer Microsoft Office—from the inside out! Dive into the Microsoft Office application suite—and really put its productivity tools and services to work for you! This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to make the most of Office's 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 today's key tasks—and challenge yourself to new levels of mastery. Create amazing content faster with Office's 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 for easy understanding. Build flexible, reliable Excel workbooks with formulas and functions—including XLOOKUP and other enhancements. Integrate data from external sources, including stock and currency data, and Wolfram curated knowledge. Transform data into insight with Pivot Tables and Excel charts — including new recommended charts and the Quick Analysis gallery. Quickly create presentations with PowerPoint themes, Reuse Slides, and Libraries. Build more impactful slides with advanced formatting, SmartArt, animation, transitions, media, and free stock images. Use PowerPoint tools to present more effectively—in person or online via Microsoft Teams. Systematically improve email productivity and security with Outlook. Manage appointments and tasks and quickly plan meetings.

Provides timesaving tips, tricks, shortcuts, solutions, and troubleshooting guidelines for Microsoft Excel, Outlook, Word, PowerPoint, and other applications, and explores new features and capabilities of Office 2013.

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

Conquer Microsoft Office 365 administration—from the inside out! Dive into Office 365 administration—and really put your systems expertise to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. Discover how the experts tackle deployment, configuration, and management—and challenge yourself to new levels of mastery. Simplify enterprise deployment with planning tools and tasks Automate Office 365 processes with Windows PowerShell Manage user identity with Active Directory and Single Sign-On Monitor and maintain the health of Office 365 with Microsoft System Center Implement Microsoft Exchange Online, SharePoint Online, and Lync Online Control variables in an Exchange Server hybrid implementation Customize and deploy Office 365 Professional Plus Explore real-world scenarios and apply insider management tips For Intermediate to Advanced IT Professionals