Exploring Microsoft Excel's Hidden Treasures. Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features

David Ringstrom

David Ringstrom coined the phrase “Either you work Excel, or it works you!” after observing how many users carry out tasks inefficiently.In this book, you’ll learn how to get more done with less effort. This book will enable you to create resilient spreadsheets that are easy for others to use as well, while incorporating spreadsheet disaster preparedness techniques. The time-saving techniques covered in the book include creating custom shortcuts and icons to streamline repetitive tasks, as well as automating them with features such as Tables and Custom Views. You’ll see how Conditional Formatting enables you to apply colors, Cell icons, and other formatting on-demand as your data changes. You’ll be empowered to protect the integrity of spreadsheets and increase usability by implementing internal controls, and understand how to solve problems with What-If Analysis features. In addition, you’ll master new features and functions such as XLOOKUP, Dynamic Array functions, LET and LAMBDA, and Power Query, while learning how to leverage shortcuts and nuances in Excel.By the end of this book, you’ll have a broader awareness of how to avoid pitfalls in Excel. You’ll be empowered to work more effectively in Excel, having gained a deeper understanding of the frustrating oddities that can arise daily in Excel.

Developing Solutions for Microsoft Azure AZ-204 Exam Guide. Discover the essentials for success when developing and maintaining cloud-based solutions on Azure

Paul Ivey, Alex Ivanov

With the prevalence of cloud technologies and DevOps ways of working, the industry demands developers who can build cloud solutions and monitor them throughout their life cycle. Becoming a Microsoft-certified Azure developer can differentiate developers from the competition, but with such a plethora of information available, it can be difficult to structure learning in an effective way to obtain certification.Through easy-to-understand explanations and exercises, this book will provide a more palatable learning experience than what you may expect from an exam preparation book. You’ll start off with a recap of some important cloud concepts, such as IaaS, PaaS, and SaaS. From there, you’ll learn about each relevant solution area, with use cases. The chapters also cover different implementation methodologies, both manual and programmatic – ranging from compute resources such as App Service and serverless applications to storage, database, security, monitoring solutions, and connecting to third-party services.By the end of this book, you'll have learned everything you need to pass the AZ-204 certification exam and have a handy, on-the-job reference guide.

Advertising on Google: The High Performance Cookbook. Cracking pay-per-click on Google can increase your visitor numbers and profits. Here are over 120 practical recipes to help you set up, optimize and manage your Adwords campaign with step-by-step instructions

Kristina Cutura

Learn WinUI 3. Leverage WinUI and the Windows App SDK to create modern Windows applications with C# and XAML - Second Edition

Alvin Ashcraft

WinUI 3 takes a whole new approach to delivering Windows UI components and controls and has the ability to deliver the same features across multiple versions of Windows. Learn WinUI 3 is a comprehensive introduction to WinUI and Windows apps for anyone who is new to WinUI and XAML applications.This updated second edition begins by helping you get to grips with the latest features in WinUI and shows you how XAML is used in UI development. The next set of chapters will help you set up a new Visual Studio environment, develop a new desktop project, incorporate the Model-View-ViewModel (MVVM) pattern in a WinUI project, and develop unit tests for ViewModel commands. Next, you’ll cover the basics of data access from WinUI projects with a step-by-step approach. As you advance, you’ll discover how to leverage the Fluent Design System to design beautiful WinUI applications. You’ll also explore the contents and capabilities of the Windows Community Toolkit and learn how to create cross-platform apps with markup and code from your project using Uno Platform. The concluding chapters will teach you how to build, debug, and deploy apps to the Microsoft Store.By the end of this book, you’ll have learned how to build WinUI applications from scratch and how to modernize existing desktop apps using WinUI 3 and the Windows App SDK.

Getting Started with Microsoft Lync Server 2013. Everything you need for understanding and working with Lync 2013 in a fast-paced manner

Fabrizio Volpe

Lync 2013 is a product that enables users to IM, and have audio and video conferences, including multi-party video. The mobile client permits the use of all the features in every device with an access-from-everywhere logic. The company’s Active Directory users, SharePoint documents, and Exchange objects integrate with Lync to deliver most of the advanced features.Getting Started with Microsoft Lync Server 2013 will give you all the relevant information you need to enable voice features, select the best Lync client in different scenarios, make your Lync services available to the external users, empower the collaborative environment of Persistent Chat Server rooms, and to build an affordable unified communication system.Getting Started with Microsoft Lync Server 2013 will explore all the concepts you need to administer and plan a Lync 2013 environment in a short time, explaining the background mechanisms of the system.It begins with the deployment of a Lync frontend and SQL mirroring solution, including all the requirements and tips clearly laid out. It proceeds with the Front End pairing, mobility, and mediation server deployment with media bypass. It covers a core chapter about Enterprise Voice with a closing part on Persistent Chat and on clients with their characteristics.Getting Started with Microsoft Lync Server 2013 will give you all the relevant information you need to enable voice features, and will help to select the best Lync client in different scenarios.

Learn Blender Simulations the Right Way. Transform your artistic vision into stunning, realistic simulations with Blender 4.0 - Second Edition

Stephen Pearson

Ready to unleash the power of visual effects? From explosive movie scenes to mind-bending game animations, this second edition pushes Blender 4.0+ beyond what you thought possible. Featuring a brand-new chapter on combining multiple simulations for a burning effect and updated guidance on rendering with EEVEE, this book takes your Blender expertise to new heights.While Blender excels in 3D modeling and animation, this guide focuses specifically on VFX, helping you master realistic simulations using EEVEE and Cycles. You'll explore five physics-based simulations—Fluid, Rigid Body, Soft Body, Cloth, and Dynamic Paint—learning essential settings, troubleshooting techniques, and practical workflows. Through nine hands-on projects, including fire, waterfalls, and explosions, you’ll develop the skills to create stunning digital effects. Written by a VFX specialist who has taught thousands through best-selling courses, this book will help you build an impressive portfolio of professional-quality VFX projects in Blender and bring your creative visions to life!

Microsoft Exchange Server PowerShell Essentials. Leverage the power of basic Windows PowerShell scripts to manage your Exchange messaging environment

Biswanath Banerjee

PowerShell has become one of the most important skills in an Exchange administrator's armory. PowerShell has proved its mettle so widely that, if you're not already starting to learn PowerShell, then you're falling behind the industry. It isn't difficult to learn PowerShell at all. In fact, if you've ever run commands from a CMD prompt, then you'll be able to start using PowerShell straightaway.This book will walk you through the essentials of PowerShell in Microsoft Exchange Server and make sure you understand its nitty gritty effectively.You will first walk through the core concepts of PowerShell and their applications. This book discusses ways to automate tasks and activities that are performed by Exchange administrators and that otherwise take a lot of manual effort. Microsoft Exchange PowerShell Essentials will provide all the required details for Active Directory, System, and Exchange administrators to help them understand Windows PowerShell and build the required scripts to manage the Exchange Infrastructure.

Microsoft System Center Configuration Manager Advanced Deployment. Design, implement, and configure System Center Configuration Manager 2012 R2 with the help of real-world examples

Martyn Coupland