- Table View
- List View
Microsoft® Excel® 2010 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. Discover how the experts tackle Excel 2010-and challenge yourself to new levels of mastery!Learn expert techniques for designing powerful spreadsheets Apply built-in functions-or write your own-and carry out complex calculations Use rich charting and graphic capabilities to visualize data Perform sophisticated data analysis: financial, statistical, and "what-if" Design PivotTable reports to dynamically analyze data Share and collaborate with others-while managing sensitive data Link and embed Excel data into other documents Create macros with Microsoft Visual Basic® for Applications Sample spreadsheets from inside the book Add-ins and other resources to help you extend Microsoft Office programs Links to demos, user communities, and product support
Microsoft® Excel 2010, Introductory
by William R. Pasewark Scott G. Pasewark Carolyn Denny Pasewark Jan Pasewark Stogner Beth Pasewark Wadsworth Robin M. RomerMicrosoft Excel 2010 Introductory, part of the Origins Series, is designed for beginning users of Microsoft Office 2010. This self-paced, step-by-step book with corresponding screenshots makes learning easy and enjoyable. Students will learn the new features of excel through a variety of activities, simulations, and case studies. End-of-lesson exercises reinforce the skills covered in each lesson.
Microsoft Excel 2010 Levels 1 and 2
by Nita Rutkosky Denise Seguin Audrey Rutkosky RoggenkampBenchmark Microsoft Excel 2010 is designed for students who want to learn how to use this powerful spreadsheet program to manipulate numerical data in resolving issues related to finances or other numbers-based information. No prior knowledge of spreadsheets is required.
Microsoft® Excel® 2010 Step by Step
by Curtis D. FryeExperience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
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 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: Building Data Models with PowerPivot
by Marco Russo Alberto FerrariYour guide to quickly turn data into results. Transform your skills, data, and business--and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel® 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results--no programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint®
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 Inside Out
by Mark Dodge Craig StinsonYou'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 Plain & Simple
by Curtis D. FryeGet the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before. Here's WHAT you'll learn: Manage your financial data and personal expenses Get started quickly with prebuilt templates Create formulas and functions to do the hard work Sort, filter, update, and copy your data Use charts and graphics to bring data to life Collaborate with colleagues by sharing spreadsheets online Here's HOW you'll learn it: Jump in whenever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help apply what you learn right away
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.