LibGuides: Microsoft Excel: Books & eBooks

Featured eBooks

Go to A-Z Databases: Books & eBooks to search for more eBooks. Must access on campus or login with your COM account for off campus access.

Want more on finding books or eBooks? Try our How to Use Books & eBooks guides.

Office 365 All-In-One for Dummies The deepest reference on Microsoft's productivity service Office 365 offers the same productivity power as past versions of Microsoft Office along with tools designed to boost collaboration in the workplace and instant access to the latest Office updates without buying a whole new software package. It's an ideal solution for both the office and home use. The author of the bestselling Office All-in-One For Dummies shares his advice on how to navigate the nuts and bolts of getting things done with Office 365. Look inside for step-by-step instructions on Excel, Outlook, Word, PowerPoint, Access, and OneNote along with a dive into the cloud services that come with Office 365. Access Office 365 Make sense of common Office tasks Use Excel, Word, outlook, PowerPoint and more Take advantage of 365 online services If you're a home or business user interested in having a complete reference on the suite, this book has you covered.
Office 365 User Guide Work with the powerful subscription software, Office 365 to increase your organization's efficiency by managing file sharing, email exchange and much more. Key Features Become well versed with Office 365 and leverage its capabilities for your business Speed up your workflow and effectively collaborate using Office Web Apps Learn to set audio and web conferences and seamlessly access your workspace Book Description Microsoft Office 365 combines the popular Office suite with next-generation cloud computing capabilities. With this user guide, you'll be able to implement its software features for effective business communication and collaboration. This book begins by providing you with a quick introduction to the user interface (UI) and the most commonly used features of Office 365. After covering the core aspects of this suite, you'll learn how to perform various email functions via Exchange. Next, you will learn how to communicate using Skype for Business and Microsoft Teams. To boost your productivity, this book will help you learn everything from using instant messaging to conducting audio and web conferences, and even accessing business information from any location. In the final chapters, you will learn to work in a systematic style using file management and collaboration with OneDrive for Business using SharePoint. By the end of this book, you'll be equipped with the knowledge you need to take full advantage of Office 365 and level up your organization's productivity. What you will learn Understand the UI of Office 365 Perform a variety of email functions through Exchange Communicate using Skype for Business and Microsoft Teams Explore file management using OneDrive for Business Collaborate using SharePoint Understand how to leverage Office 365 in your daily tasks Who this book is for If you are an IT professional who wants to upgrade your traditional Office suite, this book is for you. Users looking to learn, configure, manage, and maintain an Office 365 environment in their organization will also find this book useful. Some understanding of Microsoft Office Suite and cloud computing basics will be beneficial.
Excel 2016 All-In-One for Dummies Your one-stop guide to all things Excel 2016 Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic'and beyond. In no time, your Excel skills will go from 'meh' to excellent. Written by expert Greg Harvey, who has sold more than 4.5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel. From generating pivot tables and performing financial functions to performing error trapping and building and running macros'and everything in between'this hands-on, friendly guide makes working with Excel easier than ever before. Serves as the ideal reference for solving common questions and Excel pain points quickly and easily Helps to increase productivity and efficiency when working in Excel Fully updated for the new version of Excel Covers basic and more advanced Excel topics If working in Excel occasionally makes you want to scream, this will be the dog-eared, dust-free reference you'll turn to again and again.
Excel 2016 Formulas Leverage the full power of Excel formulas Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas. When conducting simple math or building highly complicated spreadsheets that require formulas up to the task, leveraging the right formula can heighten the accuracy and efficiency of your work, and can improve the speed with which you compile and analyze data. Understanding which formulas to use and knowing how to create a formula when you need to are essential. Access tips, tricks, and techniques that have been fully updated to reflect the latest capabilities of Microsoft Excel Create and use formulas that have the power to transform your Excel experience Leverage supplemental material online, including sample files, templates, and worksheets from the book
Microsoft Excel 2016 Tips and Tricks Step up your Excel skills with our 6-page laminated guide focusing on tips and tricks for using data efficiently while ensuring data quality. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for users at different levels. This is the second in the Excel 2016 series. Suggested uses: Workplace -- Kept conveniently at your desk for easy reference; Company Training -- reduce help-desk calls and keep productivity flowing for a team or for your entire company; Students/Teachers/Parents -- help for classroom or homework; College Professors/Students -- offers a range of guides for different levels.
Teach Yourself Visually Excel 2016 See your way to Excel spreadsheet stardom with this visual guide If you're always hearing about the cool things Excel can do, here's your chance to see how to do them!Teach Yourself Visually Excel offers you a straightforward visual approach to working with the newest version of the world's leading spreadsheet program. Packed with visually rich tutorials and step-by-step instructions that will help you take your Excel skills to new heights, this friendly and approachable guide will have you creating, editing, and manipulating Excel spreadsheets in no time! Excel can seem daunting, but with Teach Yourself Visually Excel, you'll quickly and painlessly learn how to perform dozens of tasks, including creating spreadsheets and charts, filtering and sorting data, working with PivotTables, and so much more. Covering the latest additions and changes to the newest version of Excel, a series of easy-to-follow, full-color tutorials helps you to excel at working with Excel! Tutorials and step-by-step screenshots make lessons easy to follow and understand Helps you grasp the basic functions of Excel--and beyond Walks you through Excel s new features Clearly demonstrates how to organize, present, analyze, and chart data with Excel Whether you've never used Excel or just need to brush up on its new features, Teach Yourself Visually Excel will be the dog-eared resource you'll turn to again and again.
Office 2016 All-In-One for Dummies The fast and easy way to get things done with Office Perplexed by PowerPoint? Looking to excel at Excel? From Access to Word--and every application in between--this all-encompassing guide provides plain-English guidance on mastering the entire Microsoft Office suite. Through easy-to-follow instruction, you'll quickly get up and running with Excel, Word, PowerPoint, Outlook, Access, Publisher, Charts and Graphics, OneNote, and more--and make your work and home life easier, more productive, and more streamlined. Microsoft Office is the leading productivity tool in the world. From word processing to business communication to data crunching, it requires a lot of knowledge to operate it--let alone master it. Luckily, Office 2016 All-in-One For Dummies is here to deliver the breadth of information you need to complete basic tasks and drill down into Office's advanced features. Create customized documents and add graphic elements, proofing, and citations in Word Build a worksheet, create formulas, and perform basic data analysis in Excel Create a notebook and organize your thoughts in Notes Manage messages, tasks, contacts, and calendars in Outlook Clocking in at over 800 pages, Office 2016 All-in-One For Dummies will be the singular Microsoft Office resource you'll turn to again and again.
Office 2016 Simplified Start learning the latest in Office Office Simplified is the quick, easy, full-color guide to the new features and tools of the latest version of Office. With a clear, highly visual, introductory style of instruction, this book gives you step-by-step directions alongside illustrative screen shots to help you learn Microsoft's bestselling productivity software. You'll take a tour through all Office applications, and learn how the new tools can make your workday easier. The simplified approach eliminates unnecessary information, focusing instead on the essentials you need to know to get things done. Organized for easy navigation, this helpful guide is designed to be used both as a start-to-finish tutorial and as a handy desk reference when you run into unfamiliar territory. Whether you're upgrading from a previous version or using the Office suite of applications for the first time, this book has you covered every step of the way. You'll find the answers you need, new tools you can use, and the step-by-step guidance that helps you get it right on the first try. Get acquainted with the Office workflow Walk through Word, Excel, PowerPoint, Outlook, and Publisher Follow along with practical examples to tackle dozens of tasks Compose documents, create spreadsheets, organize your email, and more This book provides the ideal rundown of Microsoft Office's full feature set and capabilities. Even experienced users may learn something they never realized they were missing. If you need to get things done with minimal interruption to your workflow, Office Simplified will get you up to speed quickly and easily.
Teach Yourself Visually Office 2016 Quickly and efficiently learn the latest version of Office Are you a visual learner who wants to spend more time working in Microsoft Office than trying to figure out how the programs actually work? Teach Yourself Visually Office offers you a straightforward, visual approach to making your work life more efficient and productive using the latest version of the Microsoft Office suite. Featuring visually rich tutorials and step-by-step instructions that will help you make the most of this power-packed suite of office productivity tools, it covers everything you need to compute, document, graph, chart, present, and organize your way to success in the workplace--from the most basic to the most advanced. The Microsoft Office suite can be intimidating to the uninitiated, but it doesn't have to be. Through a series of easy-to-follow, full-color two-page tutorials, you'll quickly get up and running on working in Word, excelling at Excel, powering through PowerPoint, keeping in touch on Outlook, managing data in Access, and propelling your way through Publisher like a pro! Highly visual tutorials and step-by-step screenshots make lessons easy to follow and understand Helps you grasp the basic functions of Microsoft Office--and beyond Walks you through Microsoft Office's new features Demonstrates how to use the Microsoft Office suite to make your work life more streamlined and effective Whether you're looking to discover what's new in the latest release of Microsoft Office or don't know Access from Word, this visual guide makes learning easy!