Informatyka

Microsoft Excel 2019: VBA i makra

Bill Jelen, Tracy Syrstad

Uznani eksperci Bill Jelen (MrExcel) i Tracy Syrstad pokazują, jak budować wydajniejsze, bardziej niezawodne i skuteczne arkusze programu Excel. Przewodnik ten pokazuje, jak zautomatyzować praktycznie wszystkie rutynowe zadania, aby oszczędzić sobie całych godzin, dni, a może i tygodni pracy. Spraw, aby Excel wykonywał rzeczy, które uważałeś za niemożliwe. Poznaj techniki makr, których nie znajdziesz nigdzie indziej i twórz zautomatyzowane raporty. Bill Jelen i Tracy Syrstad pokazują, jak natychmiast wizualizować informacje, aby móc działać na nich, przechwytywać dane skądkolwiek i używać ich gdziekolwiek oraz automatyzować najlepsze nowe funkcje programu Excel 2019 i Excela w Office 365. Znajdziesz tu proste instrukcje krok po kroku, praktyczne przykłady oraz ponad 50 skoroszytów wypełnionych dodatkowymi przykładami, makrami i rozwiązaniami. Dzięki lekturze tej książki będziesz w stanie: Szybko opanować tworzenie makr w programie Excel Wydajniej posługiwać się zakresami, komórkami i formułami Generować zautomatyzowane raporty i szybko dostosowywać je do nowych wymagań Automatyzować tabele przestawne w celu tworzenia podsumowań, analiz, badania i prezentacji danych Używać niestandardowych okien dialogowych do zbierania danych od użytkowników Ulepszać niezawodność i elastyczność swoich makr Integrować dane z Internetu, baz danych Access i innych źródeł Automatycznie generować wykresy, wizualizacje, linie przebiegu w czasie, a nawet dokumenty programu Word Tworzyć wydajne rozwiązania przy użyciu klas, kolekcji i funkcji niestandardowych Szybciej rozwiązywać zaawansowane problemy analizy biznesowej O tej książce Przeznaczona dla każdego, kto chce wykonać więcej pracy w programie Excel w krótszym czasie.

Microsoft Excel 2019: VBA i makra

Bill Jelen, Tracy Syrstad

Uznani eksperci Bill Jelen (MrExcel) i Tracy Syrstad pokazują, jak budować wydajniejsze, bardziej niezawodne i skuteczne arkusze programu Excel. Przewodnik ten pokazuje, jak zautomatyzować praktycznie wszystkie rutynowe zadania, aby oszczędzić sobie całych godzin, dni, a może i tygodni pracy. Spraw, aby Excel wykonywał rzeczy, które uważałeś za niemożliwe. Poznaj techniki makr, których nie znajdziesz nigdzie indziej i twórz zautomatyzowane raporty. Bill Jelen i Tracy Syrstad pokazują, jak natychmiast wizualizować informacje, aby móc działać na nich, przechwytywać dane skądkolwiek i używać ich gdziekolwiek oraz automatyzować najlepsze nowe funkcje programu Excel 2019 i Excela w Office 365. Znajdziesz tu proste instrukcje krok po kroku, praktyczne przykłady oraz ponad 50 skoroszytów wypełnionych dodatkowymi przykładami, makrami i rozwiązaniami. Dzięki lekturze tej książki będziesz w stanie: Szybko opanować tworzenie makr w programie Excel Wydajniej posługiwać się zakresami, komórkami i formułami Generować zautomatyzowane raporty i szybko dostosowywać je do nowych wymagań Automatyzować tabele przestawne w celu tworzenia podsumowań, analiz, badania i prezentacji danych Używać niestandardowych okien dialogowych do zbierania danych od użytkowników Ulepszać niezawodność i elastyczność swoich makr Integrować dane z Internetu, baz danych Access i innych źródeł Automatycznie generować wykresy, wizualizacje, linie przebiegu w czasie, a nawet dokumenty programu Word Tworzyć wydajne rozwiązania przy użyciu klas, kolekcji i funkcji niestandardowych Szybciej rozwiązywać zaawansowane problemy analizy biznesowej O tej książce Przeznaczona dla każdego, kto chce wykonać więcej pracy w programie Excel w krótszym czasie.

Microsoft Excel 2021 Programming Pocket Primer. A Comprehensive Guide to Mastering Excel VBA

Mercury Learning and Information, Julitta Korol

This book, part of the successful Pocket Primer series, is designed for those who need to quickly master Excel programming fundamentals. It offers a concise, efficient introduction to VBA, ensuring you only learn what you need to feel comfortable with Excel VBA. The concepts learned in this book also apply to Access programming. The nine chapters progressively introduce you to programming in Microsoft Excel 2021.Starting with a quick guide to Excel macros and the VBA programming environment, the book moves on to fundamental concepts and writing function procedures. You will learn to add decision-making capabilities and looping statements to your programs, store and manage multiple values using arrays and collections, and utilize built-in tools for testing and debugging your code.By the end of the course, you will have a solid foundation in Excel VBA, enabling you to automate tasks and enhance your productivity. This structured approach makes the book an essential resource for mastering Excel VBA efficiently and effectively.

Microsoft Exchange 2010 PowerShell Cookbook. This brilliant Cookbook is packed with step-by-step instructions on writing scripts for Exchange 2010. You’ll be able to use the recipes straightaway and take your Microsoft Exchange management capabilities to another level

Mike Pfeiffer, MIKE PFEIFFER

Microsoft Exchange 2013 Cookbook. Get the most out of Microsoft Exchange with this comprehensive guide. Structured around a series of clear, step-by-step exercises it will help you deploy and configure both basic and advanced features for your enterprise

Michael Van Horenbeeck, Peter De Tender

Microsoft Exchange Server 2013 PowerShell Cookbook. Benefit from over 120 recipes that tackle the everyday issues that arise with Microsoft Exchange Server. Using PowerShell you'll learn to add scripts that provide new functions and efficiencies. Only basic knowledge required. - Second Edition

Jonas Andersson, Mike Pfeiffer

Microsoft Exchange Server 2013 is a complex messaging system. Windows PowerShell 3 can be used in conjunction with Exchange Server 2013 to automate and manage routine and complex tasks to save time, money, and eliminate errors.Microsoft Exchange Server 2013 PowerShell Cookbook: Second Edition offers more than 120 recipes and solutions to everyday problems and tasks encountered in the management and administration of Exchange Server. If you want to write scripts that help you create mailboxes, monitor server resources, and generate detailed reports, then this Cookbook is for you. This practical guide to Powershell and Exchange Server 2013 will help you automate and manage time-consuming and reoccurring tasks quickly and efficiently. Starting by going through key PowerShell concepts and the Exchange Management Shell, this book will get you automating tasks that used to take hours in no time.With practical recipes on the management of recipients and mailboxes as well as distribution groups and address lists, this book will save you countless hours on repetitive tasks. Diving deeper, you will then manage your mailbox database, client access, and your transport servers with simple but effective scripts.This book finishes with advanced recipes on Exchange Server problems such as server monitoring as well as maintaining high availability and security. If you want to control every aspect of Exchange Server 2013 and learn how to save time with PowerShell, then this cookbook is for you.

Microsoft Exchange Server 2016 PowerShell Cookbook. Powerful recipes to automate time-consuming administrative tasks - Fourth Edition

Jonas Andersson, Nuno Mota, Mike Pfeiffer

We start with a set of recipes on core PowerShell concepts. This will provide you with a foundation for the examples in the book. Next, you'll see how to implement some of the common exchange management shell tasks, so you can effectively write scripts with this latest release. You will then learn to manage Exchange recipients, automate recipient-related tasks in your environment, manage mailboxes, and understand distribution group management within the Exchange Management Shell. Moving on, we'll work through several scenarios where PowerShell scripting can be used to increase your efficiency when managing databases, which are the most critical resources in your Exchange environment. Towards the end, you'll discover how to achieve Exchange High Availability and how to secure your environment, monitor the health of Exchange, and integrate Exchange with Office Online Server, Skype for Business Server, and Exchange Online (Office 365).By the end of the book, you will be able to perform administrative tasks efficiently.

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 Forefront UAG 2010 Administrator's Handbook. Integrating UAG into your organization’s network will always be a challenge, but this manual will make life easier. It’s the only book solely dedicated to UAG and covers everything with a simple, user-friendly approach

Erez Ben-Ari, Ran Dolev, Erez Y Ben

Microsoft Forefront Unified Access Gateway (UAG) is the latest in a line of Application Publishing (Reverse Proxy) and Remote Access (VPN) Server products. The broad set of features and technologies integrated into UAG makes for a steep learning curve. Understanding all the features and abilities of UAG is a complex task that can be daunting even to experienced networking and security engineers. This book is the first to be dedicated solely to Microsoft Forefront UAG. It guides you step-by-step throughout all the stages of deployment, from design to troubleshooting. Written by the absolute experts who have taken part of the product’s development, official training and support, this book covers all the primary features of UAG in a friendly style and a manner that is easy to follow. It takes you from the initial planning and design stage, through deployment and configuration, up to maintenance and troubleshooting. The book starts by introducing UAG's features and and abilities, and how your organization can benefit from them. It then goes on to guide you through planning and designing the integration of the product into your own unique environment. Further, the book guides you through the process of publishing the various applications, servers and resources - from simple web applications to complex client/server based applications. It also details the various VPN technologies that UAG provides and how to take full advantage of them. The later chapters of the book educate you with common routine “upkeep” tasks like monitoring, backup and troubleshooting of common issues. Finally, the book includes an introduction to ASP, which some of the product's features are based on, and can help the advanced administrator with enhancing and customizing the product.