- Table View
- List View
Microsoft® Excel® 2016: Comprehensive (Shelly Cashman)
by Steven M. Freund Joy L. Starks Eric J. SchmiederIntroduce your students to the latest advancements that Microsoft® Office and Excel 2016 have to offer with MICROSOFT® OFFICE 365 & EXCEL 2016: COMPREHENSIVE -- the new edition in the acclaimed Shelly Cashman Series®. For more than three decades, the Shelly Cashman Series® has effectively introduced computer skills to millions. MICROSOFT® OFFICE 365 & EXCEL 2016: COMPREHENSIVE continues the Series’ strong history of innovation with a hallmark learning approach now enhanced to address the varied learning styles of today’s students. A trademark, step-by-step, screen-by-screen approach provides a thorough understanding of Microsoft® Excel 2016 through experimentation, critical thought, and personalization. This new edition and accompanying resources deliver effective educational materials specifically designed to engage readers, improve retention, and prepare students for future success in working with all aspects of Excel 2016.
Microsoft Excel 2016
by Ian Rutkosky Audrey Roggenkamp Nita RutkoskyMarquee 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® 2016 Workbook (Marquee Series)
by Nita Rutkosky Audrey Roggenkamp Ian RutkoskyMarquee 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® & AccessTM Integration with Office 2007
by Michael Alexander Geoffrey ClarkAlthough many people rarely go from Excel into Access or vice versa, you should know that Microsoft actually designed these applications to work together. In this book, you'll discover how Access benefits from Excel's flexible presentation layer and versatile analysis capabilities, while Access's relational database structure and robust querying tools enhance Excel. Once you learn to make the two work together, you'll find that your team's productivity is the real winner.
Microsoft® Excel Data Analysis and Business Modeling
by Wayne WinstonNow you can apply the techniques that business analysts at leading companies use to analyze and transform data into bottom line results. For more than 10 years, well- known consultant and business professor Wayne Winston has been teaching corporate clients and MBA candidates the most effective ways to use Microsoft Excel for data analysis, modeling, and decision making. This practical, business-focused guide delivers the best of Winston's classroom experience to you-from asset allocation modeling to estimating exponential growth, forecasting sales, optimizing portfolios, and other critical functions. You also get all the book's sample files on CD-ROM - ready for use in your own work.
Microsoft® Excel Data Analysis and Business Modeling
by Wayne L. WinstonMaster the techniques that business analysts at leading companies use to transform data into bottom-line results. For more than a decade, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Excel for data analysis, modeling, and decision making. Now this award-winning educator shares the best of his classroom experience in this practical, business-focused guide. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. You also get all the book's problem-and-solution files on CD--for all the practice you need to solve complex problems and work smarter with Excel. Learn how to solve real business problems with Excel! Create best, worst, and most-likely scenarios for sales Calculate how long it would take to recoup a project's startup costs Plan personal finances, such as computing loan terms or saving for retirement Estimate a product's demand curve Simulate stock performance over a year Determine which product mix will yield the greatest profits Interpret the effects of price and advertising on sales Assign a dollar value to customer loyalty Manage inventory and order quantities with precision Create customer service queues with short wait times Estimate the probabilities of equipment failure Model business uncertainties Get new perspectives on data with PivotTable dynamic views Help predict quarterly revenue, outcomes of sporting events, presidential elections, and more! On the CD: Practice files for all the book's exercises Solutions for problem sets Fully searchable eBook A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
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 2000 Server Administrator's Pocket Consultant
by William R. StanekMICROSOFT® EXCHANGE 2000 SERVER ADMINISTRATOR'S POCKET CONSULTANT is the concise, easy-to-use reference you'll want with you at all times as you support and manage Microsoft Exchange 2000 Server and Exchange 2000 Enterprise Server. Ideal at the desk or on the go from server to workstation, this hands-on, fast-answers guide focuses on what you need to do to get the job done. With extensive easy-to-read tables, lists, and step-by-step instructions, it's the portable, readable guide that will consistently save you time and effort. This hands-on guide provides fast answers to help you: Complete fundamental tasks--use administrative tools, understand integration with Windows 2000, manage and troubleshoot mail clients such as Microsoft Outlook® 2000 and Outlook Express, and configure and manage user access privileges Work with Active DirectoryTM services (ADS)--take advantage of powerful new directory services to centrally manage administration and security functions, simplify managing a large installation, and reduce your workload Administer and troubleshoot data storage--efficiently manage data and storage groups, manage public folders and Web stores, reliably back up and recover Exchange data, and import and export Exchange data Administer servers and groups--manage organizations and messaging connectors, use administration and routing groups, administer virtual servers and routing protocols, maintain and replicate the directory, and monitor Exchange 2000 Server
Microsoft® Exchange 2000 Server Hosting Series Volume 2: Deployment
by Microsoft CorporationThe Exchange 2000 Server Hosting series was created to help network managers, system integrators, and consultants involved in planning and deploying hosted Exchange 2000 implementations. This volume, Deployment, builds on that information and includes the step-by-step procedures required to implement this design. The companion volume, Planning, describes the tasks and decisions that must be completed to develop a framework suitable for hosting a large number of customers and users in a shared forest environment. While this guide is primarily focused on the Application Service Provider hosting their customers' messaging infrastructures, the issues and concepts discussed here can be used by any organization to provide access to the full range of Exchange 2000 Server facilities across a public network. This book covers the following topics: Configuring routers and switches Implementing Active Directory for hosting Installing the back-end servers Deploying ISA server Installing the front-end servers Implementing Domain Name Service for hosting Adding organizations and users The companion CD-Rom contains scripts and executable code. To run the scripts included on this CD, you will need Microsoft Internet Security and Acceleration Server 2000. Book Content: Introduction Configuring routers & switches Implementing active directory for hosting Installing the back-end servers Deploying ISA Server Installing the front-end servers Implementing domain name service for hosting Adding organizations & users CD contains group policy templates A Note Regarding the CD or DVDThe print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® Exchange 2000 Server Operations Guide
by Microsoft CorporationMicrosoft Exchange 2000 Server Operations is designed to provide the best information on how to manage Exchange in a day-to-day environment. An operations team needs to perform a wide variety of procedures, including server monitoring, backup, verification of scheduled events, protection against attack, and user support. This guide includes instructions for those procedures along with steps for dealing with unresolved issues in a timely manner. Exchange 2000 Server Operations draws from the knowledge and best practice guidelines from Microsoft Consulting Services (MCS), Microsoft's Internal Technical Support Group, and the Exchange Development Team.
Microsoft® Exchange 2000 Server Upgrade Series Volume 1: Planning
by Microsoft CorporationThe Microsoft Exchange 2000 Server Upgrade series is specifically created to assist you in the process of planning, deploying, and operating Exchange 2000 Server. Whether you are part of a large multinational organization with branch offices all over the world or a small company based in one location, the information and best practices contained in this series should save you considerable time and effort. This volume, Planning, covers essential decision points and system dependencies involved in upgrading core messaging services, migrating public folders, connectors and other web components. Also covered are deploying advanced messaging capabilities, such as Microsoft Outlook Web Access and front-end/back-end servers. The companion volume, deployment, provides flowcharts of each stage of the deployment process and the step-by-step procedures necessary for a successful result.
Microsoft® Exchange 2000 Server Upgrade Series Volume 2: Deployment
by Microsoft CorporationThe Microsoft Exchange 2000 Server Upgrade series is specifically created to assist you in the process of planning, deploying, and operating Exchange 2000 Server. Whether you are part of a large multinational organization with branch offices all over the world or a small company based in one location, the information and best practices contained in this series should save you considerable time and effort. This volume, Deployment, provides flowcharts of each stage of the deployment process and the step-by-step procedures necessary for a successful result. The companion volume, Planning, covers essential decision points and system dependencies involved in upgrading core messaging services, migrating public folders, connectors and other web components. Also covered are deploying advanced messaging capabilities, such as Microsoft Outlook Web Access and front-end back-end servers.
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 Peter De Tender Michael Van HorenbeeckThis 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 2003: Administrator’s Pocket Consultant
by William Stanek<div xmlns="http://www.w3.org/1999/xhtml"><p>The fast-answers, on-the-go guide to administering Microsoft Exchange Server 2003. This pocket-sized reference features concise tables, listings, and step-by-step instructions for concise, accurate answers on the spot.</p></div>
Microsoft® Exchange Server 2003 Administrator’s Companion
by Bill English Walter GlennThe first part of this guide outlines the new features of exchange server 2003 and its storage and routing architecture, and describes methods for assessing user needs, installing the messaging system, and migrating from a previous version. Later chapters walk through procedures for deploying Outlook 2003 and Outlook web access, connecting to other messaging systems with X. 400, protecting messages sent over the network, and tuning a server for better performance. The CD-ROM contains an evaluation version of the exchange server. Annotation ©2004 Book News, Inc. , Portland, OR (booknews. com)
Microsoft® Exchange Server 2003 Administrator's Companion
by Walter Glenn Bill EnglishGet your mission-critical messaging and collaboration systems up and running quickly with the essential guide to deploying and managing Exchange Server 2003. This comprehensive administrator's reference details system features and capabilities, sharing hands-on insights for exploiting new connectivity, information management, and security features; integration with Microsoft Windows Server 2003; and other enhancements. Whether you're migrating from a previous version of Exchange or performing a clean installation, you'll find the easy-to-follow procedures, practical workarounds, and key troubleshooting tactics you need for everyday, on-the-job results. Discover how to: Perform an enterprise needs assessment and develop your deployment plan Plan a migration strategy from Exchange Server 5.5--including planning for coexistence Prepare servers and clients; verify the installation Create security policies, manage PKI and certificates, and configure other security services Configure Internet protocols--SMTP, POP3, IMAP4, NNTP, and LDAP Set up and manage recipients, public folders, storage groups, and administrative and routing groups Exploit new interoperability and mobile access features, including enhancements to Microsoft Office Outlook 2003 and Outlook Web Access Implement backups and disaster recovery plans Monitor, troubleshoot, and tune server performance Exchange Server 2003 evaluation software inside! Try Microsoft Exchange Server 2003, Enterprise Edition, with 120-day evaluation software on CD. A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® Exchange Server 2007 Administrator's Companion
by Walter Glenn Scott Lowe Joshua MaherGet your mission-critical messaging and collaboration systems up and running with the essential guide to deploying and managing Exchange Server 2007, now updated for SP1. This comprehensive administrator's reference covers the full range of server and client deployments, unified communications, security features, performance optimization, troubleshooting, and disaster recovery. It also includes four chapters on security policy, tools, and techniques to help protect messaging systems from viruses, spam, and phishing. Written by expert authors Walter Glenn and Scott Lowe, this reference delivers comprehensive information to deploy and operate effective, reliable, and security-enhanced messaging and collaboration services.
Microsoft® Exchange Server 2007 Administrator's Companion
by Walter Glenn Scott Lowe Joshua MaherDiscover how to: Plan your deployment and install Exchange Server 2007 Implement and monitor high-availability solutions for server and disk resources Design and deploy a Unified Messaging solution Manage recipients, public folders, storage groups, and routing groups Set up and administer security policies, PKI, and Certificate Services Administer antivirus, anti-spam, and anti-phishing technologies Implement Microsoft Office Outlook 2007 and Outlook Web Access for client and mobile access Monitor, troubleshoot, and tune server performance Back up, recover, and restore Exchange Server databases PLUS--A companion CD features: Links to stress and performance tools Downloadable webcasts and virtual labs References for deployment scenarios Fully searchable eBook A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® Exchange Server 2007 Administrators Pocket Consultant
by William R. StanekHere's the utterly practical, pocket-sized reference for IT professionals who support Microsoft Exchange Server 2007, now updated for the new features in Service Pack 1 (SP1). This unique guide provides essential details for using this next-generation messaging and collaboration platform to deliver better performance, interoperability, and end-user experience. Written by award-winning author and technology expert William Stanek, this POCKET CONSULTANT puts expert advice for installation, migration, administration, and troubleshooting right at your fingertips. Featuring quick-reference tables, concise lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot--whether you're at your desk or in the field!
Microsoft® Exchange Server 2007 Administrator's Pocket Consultant
by William R. StanekPortable and precise, this pocket-sized guide delivers immediate answers for the day-to-day administration of Exchange Server 2007. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You'll get the focused information you need to solve problems and get the job done--whether you're at your desk or in the field! Get fast facts to: Configure and manage Exchange clients Set up users, contacts, distribution lists, and address books Administer permissions, rules, policies, and security settings Manage databases and storage groups Optimize message processing, logging, and anti-spam filtering Administer at the command line using Exchange Management Shell Configure SMTP, connectors, links, and Edge subscriptions Manage mobile device features and client access Back up and restore systems
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 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.