Windows 10 Inside Out, 3rd Edition
Dive into Windows 10 - and really put your Windows expertise to work. Focusing on Windows 10's newest, most powerful, and most innovative features, this supremely organized reference packs hundreds of timesaving solutions, up-to-date tips, and workarounds. From the new Timeline to key improvements in Microsoft Edge, Cortana, security, and virtualization, you'll discover how experts tackle today's essential tasks. Adapt to faster change in today's era of “Windows as a service,” as you challenge yourself to new levels of mastery.
Install, configure, and personalize the latest versions of Windows 10; Manage Windows reliability, security, and feature updates in any environment; Maximize your productivity with Windows 10's growing library of built-in apps; Pinpoint information fast with advanced Windows Search and Cortana techniques; Discover major Microsoft Edge enhancements, from extensions to accessibility; Use Cortana to perform tasks, set reminders, retrieve data, and get instan ...
Microsoft Excel 2019 Formulas and Functions
Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more powerful spreadsheets.
Use Excel 2019 and Office 365 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 the latest improvements to arrays, formula error handling, and statistics. 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 Excel's most useful functions in your everyday work. Becoming an Excel expert has never been easier!
By reading this book, you will: Improve business analyses by adding intelligence and knowledge to your models; Replace cumbersome formulas with convenient predefined functions; Radically ...
Microsoft Excel 2019 VBA and Macros
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets.
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 won't 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 Excel 2019 and Excel in Office 365. You'll 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 ...
Microsoft Excel 2019 Pivot Table Data Crunching
Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables.
Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power - including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else.
By reading this book, you will: Master easy, powerful ways to create, customize, change, and control pivot tables; Control all future pivot tables using new pivot table defaults; Transform huge data sets into clear summary reports; Instantly ...
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. ...
Microsoft Excel 2019 Step by Step
Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers - brisk lessons and detailed screenshots show you exactly what to do, step by step.
Quickly set up workbooks, enter data, and format it for easier viewing; Perform calculations and find and correct errors; Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines; Visualize data with 3D maps, funnel charts, and other powerful tools; Import, process, summarize, and analyze huge datasets with Excel's improved PowerPivot and Power Query; Build powerful data models and use them in business intelligence; Look up just the tasks and lessons you need. ...
Microsoft Word 2019 Step by Step
Get more done quickly with Microsoft Word 2019 and Word for Office 365. Jump in wherever you need answers - brisk lessons and informative screenshots show you exactly what to do, step by step.
Create great-looking, well-organized documents to enhance communication; Use headings, bookmarks, and footnotes for more intuitive access to knowledge; Visualize information by using diagrams and charts; Illustrate concepts by using 3D models, icons, and screen clippings; Collaborate, track changes, and coauthor documents in real-time; Enforce security and privacy in electronic documents; Quickly build tables of contents, indexes, and equations; Generate individualized emails, letters, labels, envelopes, directories, and catalogs; Supercharge efficiency with custom styles, themes, templates, and building blocks; Look up just the tasks and lessons you need. ...
Programming for Mixed Reality with Windows 10, Unity, Vuforia, and UrhoSharp
This is a complete guide to programming AI-powered mixed reality apps with the Windows Mixed Reality platform. Step by step, Dawid Borycki guides you through every type of mixed reality development, from simple 2D to cutting-edge apps for Microsoft HoloLens and immersive headsets. First, you'll learn to write UWP 2D apps that adapt for any Windows 10 device, transfer camera images to machine learning services, and use mobile sensor readings to control headset content. Then, building on these skills, you'll master every facet of building cross-platform 3D apps that link augmented reality content to real objects.
Advanced Microsoft technology expert Dawid Borycki shows how to: Set up a mixed reality development environment with all the tools you'll need, including HoloLens and Mixed Reality simulators; Write Universal Windows 2D apps for all Windows 10 devices, and adjust their views and capabilities to specific hardware; Render media streams, acquire video from world-facing cameras, ...
Exam Ref 70-483 Programming in C#, 2nd Edition
Prepare for the latest versions of Microsoft Exam 70-483 and help demonstrate your real-world mastery of modern C# programming. Designed for experienced C# developers ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.
Focus on the expertise measured by these objectives: Manage program flow; Create and use types; Debug applications and implement security; Implement data access.
This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have experience programming essential business logic with C# for diverse application types, hardware, and software platforms. ...
Microsoft Excel 2019 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 Wha ...
Microsoft Office 2019 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 fle ...