- Table View
- List View
Microsoft Excel 2010: Marquee Series
by Audrey Rutkosky Roggenkamp Denise Seguin Nita RutkoskyThis book outlines how to organize, analyze, and present data in Microsoft Excel 2010.
Microsoft Excel 2013 Inside Out
by Craig Stinson Mark DodgeYou're beyond the basics--so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Learn how the experts tackle Excel 2013--and challenge yourself to new levels of mastery. Includes companion eBook and sample files. Topics include: Customizing the Excel workspace Best practices for designing and managing worksheets Creating formulas and functions Performing statistical, what-if, and other data analysis Core to advanced charting techniques Using graphics and sparklines Managing databases and tables Automating Excel with macros and custom functions Collaborating in Excel online, in the cloud, and more Extending Excel
Microsoft Excel 2013: Data Analysis and Business Modeling
by Wayne L. WinstonMaster business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables--and how to effectively build a relational data source inside an Excel workbook. Solve real business problems with Excel--and sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple regression, and exponential smoothing Master advanced Excel functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Make your charts more effective with the Power View tool Tame complex optimization problems with Excel Solver Run Monte Carlo simulations on stock prices and bidding models Apply important modeling tools such as the Inquire add-in
Microsoft Excel 2013: Full Coverage of Excel 2013’s Top Features and Functions (Idiot's Guides)
by Michael MillerMicrosoft® Excel® can be an overwhelming and intimidating software product to use, but armed with the right book, anyone can master the basics. Packed full of color screen shots and illustrations, Idiot's Guides: Microsoft® Excel® 2013 will teach any novice how to perform all of the essential functions, including how to create a spreadsheet from scratch; build and edit basic formulas and functions; manage, sort, and edit data cleanly and efficiently; create and insert graphics; work with tables; generate readable reports; and much more.
Microsoft Excel 2013: Step by Step
by Curtis D. Frye<p>Experience learning made easy—and quickly teach yourself how to manage, analyze, and present data with Excel 2013. With Step by Step, you set the pace—building and practicing the skills you need, just when you them! Includes downloadable practice files and companion eBook.</p>
Microsoft Excel 2016
by Nita Rutkosky Ian Rutkosky Audrey RoggenkampMarquee Series: Microsoft Excel 2016 offers a highly visual, hands-on approach to learning Microsoft Excel. Ideal for 1 or 2 credit courses, this text facilitates self-paced, accelerated, and traditional learning formats.
Microsoft Excel 2019 Programming by Example: With VBA, XML, and ASP
by Julitta KorolUpdated for Excel 2019 and based on the bestselling editions from previous versions, Microsoft Excel 2019 Programming by Example with VBA, XML and ASP is a practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface (UI). The book includes companion files with all of the source code and figures used in the text (available with Amazon proof of purchase by writing to the publisher at info@merclearning.com.) <p><p> If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. More advanced topics are demonstrated via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using Classic ASP pages to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. The book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and guides you through programming advanced Excel features such as PivotTables, PivotCharts, and the Ribbon interface.
Microsoft Excel 365 Bible (Bible)
by Michael Alexander Dick KusleikaYour personal, hands-on guide to the latest and most useful features in Microsoft Excel 365 Excel 365 is Microsoft’s latest cloud-based version of its world-famous spreadsheet app. Powerful and user-friendly, it’s an ideal solution for businesses and people looking to make sense of—and draw intelligence from—their data. The Excel 365 Bible carries over the best content from the best-selling Excel 2019 Bible while reflecting how a new generation uses Excel in Excel 365. The authoring team with their decades of Excel and business intelligence experience and recognition from the Excel community as Excel MVPs delivers an accessible and authoritative roadmap to Excel 365. Interested in the basics? You’ll learn to create spreadsheets and workbooks and navigate the user interface. If you’re ready for more advanced topics you can skip right to the material on creating visualizations, crafting custom functions, and using Visual Basic for Applications to script automations. You’ll also get: Over 900 pages of powerful tips, tricks, and strategies to unlock the full potential of Microsoft Excel 365 Guidance on how to import, manage, and analyze large amounts of data Advice on how to craft predictions and “What-If Analyses” based on data you already have Perfect for anyone new to Excel, as well as experts and advanced users, the Excel 365 Bible is your comprehensive, go-to guide for everything you need to know about the world’s most popular, easy-to-use spreadsheet software.
Microsoft Excel 365 Bible (Bible)
by Michael Alexander Dick KusleikaYour complete guide to Excel 365, written for newbies all the way to seasoned professionals Neatly organised and written using accessible language, Microsoft Excel 365 Bible contains everything that readers need to know to get up and running quickly with Excel. Covering the numerous updates to Excel 365 since the previous edition was published in 2022, this Second Edition contains many useful examples and tips and tricks that cover all essential aspects of Excel—from the basics, such as navigating the user interface, to more advanced topics, such as creating visualisations and crafting custom functions. Written by an accomplished team of authors with decades of Excel and business intelligence experience, this book explores topics including: Entering and editing worksheet data, with information on data types, formulas, dates, times and other cell contents Building formulas with Excel table objects, correcting common formula errors and using formula variables Working with data series, changing basic chart elements and making use of chart customization Loading data from other sources, performing common transformations and applying conditional logic Microsoft Excel 365 Bible earns a well-deserved spot on the bookshelves of all professionals and individuals seeking to get the most out of Excel 365, from beginners with limited knowledge of the software all the way to advanced users with years of experience under their belts.
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
by Mandeep MehtaThis condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade the quality of your data analysis, dashboards, models, and templates.The Microsoft Excel Functions Quick Reference helps you set up workbooks, enter data, and format it for easier viewing. It starts by giving an overview of Excel functions explaining the different types of Excel functions available followed by an understanding of string functions and date functions. It then covers time, lookup, aggregate, and logical functions along with practice problems. Further, you will see math functions and information functions in Excel. You will also be able to create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines. Each function in the text is illustrated by helpful, illuminating examples.With this book by your side, you'll always have the answer to your Excel function syntax questions. What You Will LearnWork with basic Excel functionsUse the LOOKUP functionTake advantage of new functions in information functionsCreate a mega formulaWho This Book Is ForAdministrators, analysts, and anyone else working with Microsoft Excel.
Microsoft Exchange 2010 PowerShell Cookbook
by Mike PfeifferThis book is written in a cookbook-style format and provides practical, immediately usable task-based recipes that show you how to manage and maintain your Microsoft Exchange Server 2010 environment with Windows PowerShell 2.0. Each chapter of the book is written so that it can be used as a desktop reference, or it can be read from beginning to end, allowing you to build a solid foundation for building scripts in your Exchange environment.This book is for messaging professionals who want to learn how to build real-world scripts with Windows PowerShell 2.0 and the Exchange Management Shell. If you are a network or systems administrator responsible for managing and maintaining Exchange Server 2010, then this book is for you. The recipes in this cookbook touch on each of the core Exchange 2010 server roles and require a working knowledge of supporting technologies including Windows Server 2008 or Windows Server 2008 R2, Active Directory, and DNS. This book covers the latest additions to Exchange Server 2010 including Service Pack 1. A basic understanding of Exchange Server 2010 and Windows PowerShell 2.0 is highly recommended.
Microsoft Exchange 2013 Cookbook
by Michael Van Horenbeeck Peter De TenderThis book is a practical, hands-on guide that provides the reader with a number of clear, step-by-step exercises."Microsoft Exchange 2013 Cookbook" is targeted at network administrators who deal with the Exchange server in their day-to-day jobs. It assumes you have some practical experience with previous versions of Exchange (although this is not a requirement), without being a subject matter expert.
Microsoft Exchange Server 2007 For Dummies
by John Paul MuellerMicrosoft Exchange Server 2007 was made to help you handle e-mail, meeting management, and other essential office services. Microsoft Exchange Server 2007 For Dummies helps you get a handle on Exchange Server. Pretty slick, huh?Here's the lowdown on installing and administering Microsoft Exchange Server 2007 and taking advantage of all the enhancements in Service Pack 1. With this handy guide, you'll be able to maximize the security, reliability, and speed that Exchange Server 2007 provides.Assess your organization's needs to determine which edition of Exchange Server best meets themExplore what Exchange Server does, then plan, install, and configure itConsider how your users work with their mail and customize your set-up to facilitate their needsLearn to use the Exchange Management ConsoleUse the new Exchange Server security features to protect e-mail from viruses, spam, phishing, and other threatsSet up an offline address book, use templates, and develop custom formsCreate settings for the most efficient interaction with clients, use multiple mailboxes, and view digital certificatesManage resource scheduling and interactive calendarsTroubleshoot your configuration, perform regular maintenance, and be able to recover from mail-specific problemsMonitor Exchange Server performance and maintain databases, mail flow, and peak performanceMicrosoft Exchange Server 2007 For Dummies gets you ready to exchange problems for solutions.Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Microsoft Exchange Server 2010 - Das Handbuch
by Tony RedmondDieses Buch ist der umfassende Leitfaden zum Arbeiten mit der Unternehmenslösung für Unified Communications und Zusammenarbeit von Microsoft. Es bietet Ihnen die relevanten Informationen zu Bereitstellung, Administration, Sicherung und Support von Exchange Server 2010 (SP1) und seiner Clients. Dabei lernen Sie nicht nur, die verschiedenen Funktionen einzurichten, sondern erhalten auch zahlreiche Hintergrundinformationen und Insidertipps, wie diese Features funktionieren und Sie erfahren von einem langjährigen Exchange-Veteranen, wie Sie diese am besten einsetzen. Umfangreiches Expertenwissen in seiner besten Form: Microsoft Exchange Server 2010 - Das Handbuch.
Microsoft Exchange Server 2010 Administration Instant Reference
by Ken St. CyrQuestions about Exchange Server 2010? Flip open this easy-access guide! Have all your questions about Microsoft's new Exchange Server 2010 answered on the spot with this handy reference guide. Designed for easy access with special headings, thumb tabs, easy-to-read lists, and more, this book is the perfect quick resource for those day-to-day issues that come up just when you least expect them. Covers the number one product of its kind, Microsoft Exchange Server 2010 Offers a quick-access reference for your day-to-day administration of Exchange Server 2010 Includes thumb tabs, secondary and tertiary tables of contents, and special heading treatments to provide quick and easy lookup, as well as quick-reference tables, lists, and step-by-step instruction to provide Exchange administrators answers on the spot Keep this helpful, handy guide within easy reach.
Microsoft Exchange Server 2013
by Nathan Winters Nicolas Blank Neil JohnsonGet the knowledge you need to deploy a top-quality Exchange serviceThe latest release of Microsoft's messaging system allows for easier access to e-mail, voicemail, and calendars from a variety of devices and any location while also giving users more control and freeing up administrators to perform more critical tasks. This innovative new field guide starts with key concepts of Microsoft Exchange Server 2013 and then moves through the recommended practices and processes that are necessary to deploy a top-quality Exchange service.Focuses on the Exchange ecosystem rather than just the features and functions of the Exchange productFocuses on scenarios facing real customers and explains how problems can be solved and requirements metZooms in on both on-premises deployments as well as Exchange Online cloud deployments with Office 365Helps you thoroughly master the new version with step-by-step instruction on how to install, configure, and manage this multifaceted collaboration systemWhether you're upgrading from Exchange Server 2010 or earlier, installing for the first time, or migrating from another system, this step-by-step guide provides the hands-on instruction, practical application, and real-world advice you need.
Microsoft Exchange Server 2013 High Availability
by Nuno MotaThis book is a hands-on practical guide that provides the reader with a number of clear scenarios and examples, making it easier to understand and apply the new concepts. Each chapter can be used as a reference, or it can be read from beginning to end, allowing consultants/administrators to build a solid and highly available Exchange 2013 environment. If you are a messaging professional who wants to learn to design a highly available Exchange 2013 environment, this book is for you. Although not a definite requirement, practical experience with Exchange 2010 is expected, without being a subject matter expert.
Microsoft Exchange Server 2013 Inside Out: Connectivity, Clients, and UM
by Paul RobichauxWith a focus on connectivity, clients, and unified messaging, this book delivers the ultimate, in-depth reference to IT professionals planning and managing an Exchange Server 2013 deployment. Guided by Paul Robichaux, a Microsoft MVP and popular author, you will: Understand how Exchange Server 2013 works with previous versions Gain expert insights into supporting clients, mobile devices, and UM Take a deep dive into front-end servers; certificate and namespace management; transport rules; load balancing; client management, including Microsoft Outlook, Outlook Web App (OWA), and POP3/IMAP4; mobile devices; anti-malware and anti-spam features; Unified Messaging; Microsoft Lync; Office 365; Exchange Online.
Microsoft Exchange Server 2013 Inside Out: Mailbox and High Availability
by Tony RedmondWith a focus on mailbox and high availability features, this book delivers the ultimate, in-depth reference to IT professionals planning and managing an Exchange Server 2013 deployment. Guided by Tony Redmond, a Microsoft MVP and award-winning author, you will: Understand major changes to Exchange Server architecture Get inside insights for planning your upgrade or deployment Examine the new web-based Exchange admin center (EAC) Take a deep dive into configuring mailboxes, distribution groups, and contacts; planning and managing the Managed Store; database availability groups; mailbox replication service; compliance, data leakage, and data loss prevention; site mailboxes; modern public folders
Microsoft Exchange Server 2013 Pocket Consultant: Configuration & Clients
by William R. StanekPortable and precise, this pocket-sized guide delivers ready answers for administering configuration and clients in Exchange Server 2013. Zero in on core tasks through quick-reference tables, instructions, and lists. You'll get the focused information you need to save time and get the job done-whether at your desk or in the field. Coverage includes: Deploying Exchange Server 2013 Administration essentials Using Exchange Management Shell Managing Exchange clients User and contact administration Mailbox administration Working with Distribution Groups and Address Lists Implementing security
Microsoft Exchange Server 2013 Pocket Consultant: Databases, Services, & Management
by William R. StanekPortable and precise, this pocket-sized guide delivers ready answers for managing databases and services in Exchange Server 2013. Zero in on core tasks through quick-reference tables, instructions, and lists. You'll get the focused information you need to save time and get the job done-whether at your desk or in the field. Coverage includes: Managing databases and availability groups Core database administration Compliance and role-based access controls Managing mail flow Working with client access servers Managing mobile users Maintenance, monitoring, and queuing Backups and restorations
Microsoft Exchange Server 2013 PowerShell Cookbook: Second Edition
by Mike Pfeiffer Jonas AnderssonThis book is written in a Cookbook-style format and provides practical, immediately usable task-based recipes that show you how to manage and maintain your Microsoft Exchange Server 2013 environment with Windows PowerShell 3. Each chapter of the book is written so that it can be used as a desktop reference, or it can be read from beginning to end, allowing you to build a solid foundation for building scripts in your Exchange environment.This Cookbook is for messaging professionals who want to learn how to build real-world scripts with Windows PowerShell 3 and the Exchange Management Shell. If you are a network or systems administrator responsible for managing and maintaining Exchange Server 2013 you will find this highly useful. Only basic knowledge of Exchange Server and PowerShell are required to make the most of this book.
Microsoft Exchange Server 2016 PowerShell Cookbook - Fourth Edition
by Nuno Mota Mike Pfeiffer Jonas AnderssonMake the most of PowerShell's features to manage all aspects of your Exchange Server 2016 environment. About This Book • Learn to integrate PowerShell with Exchange Server 2016 • Write scripts and functions to run tasks automatically, and generate complex reports with PowerShell • Use these effective recipes to learn all popular and important PowersShell scripts to manage tasks and avoid errors Who This Book Is For This book is for messaging professionals who want to build real-world scripts with Windows PowerShell and the Exchange Management Shell. You'll also find it indispensable if you're a network or systems administrator responsible for managing and maintaining Exchange Server 2016. What You Will Learn • Master the new features and capabilities of PowerShell and Exchange Server 2016 • Get to grips with the core PowerShell concepts • Use simple PowerShell scripts and commands to get powerful results • Generate detailed reports, send the output of commands by email , and schedule scripts to run automatically • Import, export, and move mailboxes, and delete messages from mailboxes using the command line • Configure transport server settings such as mail relay, tracking logs, transport rules, delivery reports, and more • Manage mailbox and public folders • Monitor the health of an Exchange environment through built-in cmdlets and other methods • Integrate Exchange with Office Online Server, Skype for Business Server, and Exchange Online (Office 365) In Detail 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. Style and approach This practical guide is packed with handy recipes to help you perform common administration tasks, as well as complex tasks in Exchange Server, without any hassle.
Microsoft Exchange Server PowerShell Essentials
by Biswanath BanerjeeLeverage the power of basic Windows PowerShell scripts to manage your Exchange messaging environment About This Book * Get to grips with Windows PowerShell and how it can be used to manage various aspects of the operating system and applications * Become proficient in PowerShell and apply it to manage Exchange infrastructure on-premise or via Exchange Online as part of Office 365 * Learn to create Windows PowerShell scripts to do administrative tasks with this step-by-step, easy-to-follow guide Who This Book Is For This book is for administrators with a basic or limited understanding of Windows PowerShell and who want to increase their skill set in managing both the Exchange On Premise and Online environments. What You Will Learn * Deep dive into the Windows PowerShell basics * Create and manage Recipients and permissions * Manage Distribution Group members, permissions, and group types * Understand Certificates and Role-Based Access Control using real-world examples * Review the usage of email address, address book, and retention policies with examples * Learn to manage Exchange Client Access and Mailbox Server roles * Use PowerShell for auditing and risk management in your Exchange organization * Manage a highly available Exchange environment using PowerShell * Interact with Exchange through the use of the Exchange Web Services-managed API In Detail 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. Style and approach This book is written with its target audience in mind; concepts are explained and followed by real-life examples. A comprehensive script is provided in each chapter to give you hands-on practice with all the major commands used in it.
Microsoft Expression Web For Dummies
by Asha Dornfest Linda HeffermanExpression Web is Microsoft's newest tool for creating and maintaining dynamic Web sites. This FrontPage replacement offers all the simple "what-you-see-is-what-you-get" tools for creating a Web site along with some pumped up new features for working with Cascading Style Sheets and other design options. Microsoft Expression Web For Dummies arrives in time for early adopters to get a feel for how to build an attractive Web site. Author Linda Hefferman teams up with longtime FrontPage For Dummies author Asha Dornfest to show the easy way for first-time Web designers, FrontPage vets, or users of other Web design tools how to get results from Expression Web.