My Excel 2016 / Tracy Syrstad.

By: Syrstad, TracyMaterial type: TextTextPublisher: Up : Que Pearson, c2017Description: xvii, 458 pages : color illustrations ; 23 cmContent type: text | still image Media type: unmediated Carrier type: volumeISBN: 9789332582774 pbkSubject(s): Microsoft Excel (Computer file) | Electronic spreadsheets -- Computer programsDDC classification: 005.54
Contents:
CHAPTER 1: Understanding the microsoft excel interface --------------------- CHAPTER 2: Working with workbooks and templates ----------------------- CHAPTER 3: Working with sheets ----------------------- CHAPTER 4: Getting data onto a sheet --------------------- CHAPTER 5: Selecting and moving data on sheets -------------------- CHAPTER 6: Formatting sheets and cells ---------------------- CHAPTER 7: Advanced formatting ---------------------- CHAPTER 8: Using formulas ------------------------ CHAPTER 9: Using functions ----------------------- CHAPTER 10: Sorting data --------------------- CHAPTER 11: Filtering and consolidating data ----------------------- CHAPTER 12: Distributing and printing a workbook --------------------- CHAPTER 13: Inserting subtotals and grouping data -------------------- CHAPTER 14: Creating charts and sparklines -------------------- CHAPTER 15: Summarizing data with pivot tables -------------------- CHAPTER 16: Inserting smartArt, wordArt and pictures -----------------------
Summary: "My Excel 2016 is your must-have companion for getting most out of Excel 2016. This friendly, quick, full-color, 100% practical tutorial walks you through every task you'll want to do with Excel 2016. -- Get productive fast with Excel 2016's updated interface -- Save time and make your data easier to work with -- Efficiently enter, insert, move, and manage data -- Use templates to reuse work and get a jumpstart on new projects -- Format worksheets and charts to make them clearer and more useful -- Use intuitive sparkline charts that fit in a single cell -- Build custom formulas using powerful built-in functions -- Sort, filter, and consolidate data and eliminate duplication -- Instantly group data and generate subtotals -- Quickly summarize huge data sets with PivotTables -- Find, fix, and avoid errors that break spreadsheets or cause inaccuracies -- Communicate more powerfully using visual tools such as SmartArt and WordArt -- Precisely control what you print and how it looks -- Securely share and distribute your workbooks -- Use Excel on the Web wherever you have Internet access -- Every task is presented step-by-step, using carefully annotated, colorful screenshots, all numbered so there's no chance of getting lost or confused. Everything's clearly organized in modular, self-contained chapters designed to help you get started quickly. Throughout, the book is packed with helpful tips, lists, and quick solutions to the problems you're most likely to encounter. -- In addition, this book is part of Que's exciting new Content Update Program. As Microsoft updates features of Excel 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection" -- provided by publisher.
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Call number Status Date due Barcode Item holds
Books Books Namal Library
Computer Science
005.54 SYR-M 2017 9864 (Browse shelf (Opens below)) Available 0009864
Total holds: 0

Includes index.

CHAPTER 1: Understanding the microsoft excel interface ---------------------
CHAPTER 2: Working with workbooks and templates -----------------------
CHAPTER 3: Working with sheets -----------------------
CHAPTER 4: Getting data onto a sheet ---------------------
CHAPTER 5: Selecting and moving data on sheets --------------------
CHAPTER 6: Formatting sheets and cells ----------------------
CHAPTER 7: Advanced formatting ----------------------
CHAPTER 8: Using formulas ------------------------
CHAPTER 9: Using functions -----------------------
CHAPTER 10: Sorting data ---------------------
CHAPTER 11: Filtering and consolidating data -----------------------
CHAPTER 12: Distributing and printing a workbook ---------------------
CHAPTER 13: Inserting subtotals and grouping data --------------------
CHAPTER 14: Creating charts and sparklines --------------------
CHAPTER 15: Summarizing data with pivot tables --------------------
CHAPTER 16: Inserting smartArt, wordArt and pictures -----------------------

"My Excel 2016 is your must-have companion for getting most out of Excel 2016. This friendly, quick, full-color, 100% practical tutorial walks you through every task you'll want to do with Excel 2016. -- Get productive fast with Excel 2016's updated interface -- Save time and make your data easier to work with -- Efficiently enter, insert, move, and manage data -- Use templates to reuse work and get a jumpstart on new projects -- Format worksheets and charts to make them clearer and more useful -- Use intuitive sparkline charts that fit in a single cell -- Build custom formulas using powerful built-in functions -- Sort, filter, and consolidate data and eliminate duplication -- Instantly group data and generate subtotals -- Quickly summarize huge data sets with PivotTables -- Find, fix, and avoid errors that break spreadsheets or cause inaccuracies -- Communicate more powerfully using visual tools such as SmartArt and WordArt -- Precisely control what you print and how it looks -- Securely share and distribute your workbooks -- Use Excel on the Web wherever you have Internet access -- Every task is presented step-by-step, using carefully annotated, colorful screenshots, all numbered so there's no chance of getting lost or confused. Everything's clearly organized in modular, self-contained chapters designed to help you get started quickly. Throughout, the book is packed with helpful tips, lists, and quick solutions to the problems you're most likely to encounter. -- In addition, this book is part of Que's exciting new Content Update Program. As Microsoft updates features of Excel 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection" -- provided by publisher.

There are no comments on this title.

to post a comment.