Essential Excel 2016 : a step-by-step guide
This book shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it. Loaded with screen shots, step-by-step instructions, and reader exercises, Essential Excel 2016 makes it easy for you to get to grips with this powerful software and what it can do.What...
Saved in:
| Main Author: | |
|---|---|
| Format: | eBook Book |
| Language: | English |
| Published: |
Berkeley, CA
Apress
2016
Apress L. P |
| Edition: | 1 |
| Subjects: | |
| ISBN: | 1484221605, 9781484221600, 1484221613, 9781484221617 |
| Online Access: | Get full text |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Abstract | This book shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it. Loaded with screen shots, step-by-step instructions, and reader exercises, Essential Excel 2016 makes it easy for you to get to grips with this powerful software and what it can do.What You'll LearnHow to create amazing visualizations of your dataEasy and accurate methods for entering dataHow to extract just the information you want from imported data, and manipulate it and format it the way you wantExport your results to other programs or share with others in the cloudOrganize, Summarize, Filter, and Consolidate your Data in almost any way imaginableAudit, Validate and Protect your DataWho This Book Is ForAnyone new to Excel, or looking to take better advantage of the platform and find out its latest features |
|---|---|
| AbstractList | Loaded with screen shots, step-by-step instructions, and reader exercises, this complete guide shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it. -- This book shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it. Loaded with screen shots, step-by-step instructions, and reader exercises, Essential Excel 2016 makes it easy for you to get to grips with this powerful software and what it can do.What You'll LearnHow to create amazing visualizations of your dataEasy and accurate methods for entering dataHow to extract just the information you want from imported data, and manipulate it and format it the way you wantExport your results to other programs or share with others in the cloudOrganize, Summarize, Filter, and Consolidate your Data in almost any way imaginableAudit, Validate and Protect your DataWho This Book Is ForAnyone new to Excel, or looking to take better advantage of the platform and find out its latest features |
| Author | Slager, David |
| Author_xml | – sequence: 1 fullname: Slager, David |
| BackLink | https://cir.nii.ac.jp/crid/1130282269325739392$$DView record in CiNii |
| BookMark | eNplkE9P20AQxbcqqUpSPgA3HypVCC2Zmf1nc6NRoEiRuCCuq7WzBhPLTr0mpN8eL7FopV5mNNLvvZl5U3bUtI1n7BThAgHMPDMpRy5TSZxQIzef2BTjGCfx-e8AasKmBKgzNWjMF3acaamzVAJ8ZSchPAMAGk1SqmN2vgzBN33l6mS5L3ydRGFymbgk9H7L8z889uTxpVr7b2xSujr4k7HP2MP18n7xi6_ubm4XVyvupAZCnqphsTcqJ5kadNJAWYCmQqwFCL2mVOsyU5C7QriSsEDphCDtpXSlU4rEjP04GIdNVdehLXubt-0mkNwbm2_a-AABCTOQZwfShY1_DU9t3Qe7q_07bof3PxKK7Hx03XZV8-i7g6lFsDHgSFu0kbdRYKPi-6gYDuuqkd_Rf8bjuduu_f3iQ2_f9xdDrp2r7fLnQhqFIP4xbKrKFlWsiAIoJdKZIGVEJjISb3YThq8 |
| ContentType | eBook Book |
| Copyright | David Slager 2016 |
| Copyright_xml | – notice: David Slager 2016 |
| DBID | RYH OHILO OODEK |
| DEWEY | 005.54 |
| DOI | 10.1007/978-1-4842-2161-7 |
| DatabaseName | CiNii Complete O'Reilly Online Learning: Corporate Edition O'Reilly Online Learning: Academic/Public Library Edition |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Computer Science Business |
| DocumentTitleAlternate | Microsoft Excel (Computer file) |
| EISBN | 1484221613 9781484221617 |
| Edition | 1 |
| ExternalDocumentID | bko000120237 9781484221617 385660 EBC4751037 BB27307774 |
| Genre | Electronic books |
| GroupedDBID | 0DA 0DJ 38. AABBV AAICL AAMCO AAQZU ABARN ABMNI ABQPQ ACBPT ACLGV ACLMJ ACOOD ADCXD ADPGQ ADVEM AEIBC AEKFX AERYV AETDV AEZAY AFOJC AHWGJ AIZJB AJFER ALMA_UNASSIGNED_HOLDINGS AORVH AZZ BBABE CZZ EUKZB GEOUK IEZ JJU MYL OHILO OODEK RYH SAY SBO SWNTM TPJZQ WZN Z7R Z7S Z7U Z7X Z83 6XM DRU WZT Z7Z Z81 Z88 NUC Z7W |
| ID | FETCH-LOGICAL-a46021-85597e75b24871a470fc062c3d3036d2866f950bac3af21c14a3326e44afa5523 |
| ISBN | 1484221605 9781484221600 1484221613 9781484221617 |
| IngestDate | Sun Aug 27 04:37:22 EDT 2023 Fri Nov 08 04:50:26 EST 2024 Tue Nov 04 06:45:37 EST 2025 Fri Dec 05 21:15:56 EST 2025 Wed Dec 10 12:39:47 EST 2025 Thu Jun 26 23:16:38 EDT 2025 |
| IsPeerReviewed | false |
| IsScholarly | false |
| LCCN | 2016959787 |
| LCCallNum | HF5548.4.M523 .S53 2016 |
| LCCallNum_Ident | QA76.76.M52 |
| Language | English |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-a46021-85597e75b24871a470fc062c3d3036d2866f950bac3af21c14a3326e44afa5523 |
| Notes | Includes index |
| OCLC | 964698400 |
| PQID | EBC4751037 |
| PageCount | 684 |
| ParticipantIDs | skillsoft_books24x7_bko000120237 askewsholts_vlebooks_9781484221617 springer_books_10_1007_978_1_4842_2161_7 safari_books_v2_9781484221617 proquest_ebookcentral_EBC4751037 nii_cinii_1130282269325739392 |
| PublicationCentury | 2000 |
| PublicationDate | c2016 2016 2016-11-25T00:00:00 20161130 2016-12-29 2016. |
| PublicationDateYYYYMMDD | 2016-01-01 2016-11-25 2016-11-30 2016-12-29 |
| PublicationDate_xml | – year: 2016 text: c2016 |
| PublicationDecade | 2010 |
| PublicationPlace | Berkeley, CA |
| PublicationPlace_xml | – name: New York – name: Berkeley, CA – name: Place of publication not identified |
| PublicationYear | 2016 |
| Publisher | Apress Apress L. P |
| Publisher_xml | – name: Apress – name: Apress L. P |
| SSID | ssj0001762445 |
| Score | 2.0065374 |
| Snippet | This book shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it. Loaded with screen shots, step-by-step... Loaded with screen shots, step-by-step instructions, and reader exercises, this complete guide shows you how easy it is to create, edit, sort, analyze,... |
| SourceID | skillsoft askewsholts springer safari proquest nii |
| SourceType | Aggregation Database Publisher |
| SubjectTerms | Computer Appl. in Administrative Data Processing Computer Science Electronic spreadsheets Electronic spreadsheets -- Computer programs Information systems Microsoft and .NET Microsoft Excel (Computer file) Professional and Applied Computing |
| SubjectTermsDisplay | Electronic books. Electronic spreadsheets. Microsoft Excel (Computer file) |
| TableOfContents | Intro -- Contents at a Glance -- Contents -- About the Author -- About the Technical Reviewers -- Acknowledgments -- Chapter 1: Becoming Acquainted with Excel -- What Is Excel? -- History of Spreadsheets -- This Book -- Excel Navigation Basics -- Creating, Saving, and Opening Workbooks -- Getting to Know the Ribbon -- Ribbon Contextual Tabs -- Resizing the Ribbon -- Using Dialog Box Launchers -- Minimizing and Hiding the Ribbon -- Using Ribbon Shortcuts -- Quick Access Toolbar -- Switch Between Touch and Mouse Mode -- Identifying the Current Cell -- Entering Data into a Worksheet -- Getting Help -- Screen Tips -- Excel's Tell Me What You Want to Do Feature -- Summary -- Chapter 2: Navigating and Working with Worksheets -- Moving Between Cells Using the Keyboard -- Selecting Cells -- Selecting Cells Using a Mouse -- Selecting Cells Using a Keyboard -- Select Cells by Using Their Cell References in the Name Box -- Going Directly to Any Cell -- Worksheets -- Naming Worksheets -- Adding and Removing Worksheets -- Changing a Worksheet Tab Color -- Selecting Multiple Worksheets -- Hiding and Unhiding Worksheets -- Reordering and Copying Worksheets -- Using Tab Buttons to Move Through the Worksheets -- Summary -- Chapter 3: Best Ways to Enter and Edit Data -- Data Types -- Inserting Special Characters -- How to Change Column Widths -- Automatically Resize Column Widths to Fit Number of Characters in the Cell -- Changing the Column Width for Multiple Columns -- How to Change Row Heights -- Correcting Typing Mistakes -- Changing Specific Characters -- Returning a Cell to Its Original Value -- Clearing the Contents of a Cell That Has Already Been Accepted -- Shortcuts for Entering and Correcting Data -- Using the AutoCorrect Feature -- Using AutoComplete to Enter Data -- Pick from Drop-down List -- AutoFill -- Use AutoFill to Create Duplicate Cells AutoCalculate Tools -- AutoSum -- Handling Blank Cells in a Range -- Average, Count Numbers, Max, Min -- Viewing Formulas -- Creating Named Ranges and Constants -- Naming Ranges -- Naming Noncontiguous Ranges -- Naming Constants -- Name Manager -- Editing Named Ranges and Constants -- Deleting Named Ranges and Constants -- Using Column or Row Headings for Range Names -- Selecting Named Ranges Rather Than Typing Them into Formulas -- Absolute Cell References -- Mixed Cell References -- Order of Precedence -- Summary -- Chapter 8: Excel's Pre-existing Functions -- Excel's Built-in Functions -- Function Construction -- Functions That Sum Values -- SUM Function -- Using the Insert Function Option -- SUMIF-Adds the Cells That Meet a Specified Criteria -- Using SUMIF with the Required Arguments -- Using the Optional sum_range Argument -- SUMIFS-Adds the Cells That Meet Multiple Criteria -- Using a Cell Address Rather Than a Cell Value for a Criteria -- Handling Empty Cells in SUMIFS Functions -- IF-Returns Different Values Depending upon If a Condition Is True or False -- AND - Returns TRUE if All of Its Arguments Are TRUE -- OR-Returns TRUE If Any Argument Is TRUE -- Nested Functions -- Date Functions -- TODAY Function-Returns the Current Date -- NOW Function-Returns the Current Date and Time -- DATE Function-Returns the Serial Number of the DATE -- MONTH, DAY, and YEAR Functions -- DAYS-Returns the Number of Days Between Two Dates -- Summary -- Chapter 9: Auditing, Validating, and Protecting Your Data -- Validating Your Data and Preventing Errors -- Data Validation -- Evaluating Formulas -- Using IFERROR -- Correcting Circular References -- Formula Auditing -- Tracing Precedents and Dependents -- Using the Watch Window -- Using the Evaluate Formula Feature to Evaluate a Nested Function One Step at a Time Hierarchical Charts Page Break Preview -- Page Layout View -- Printing -- Creating a Print Area -- Adding Additional Cells to the Print Area -- Removing the Print Area -- Using Paste Special for Printing -- Dividing the Excel Window into Panes -- Freezing Rows and Columns -- Synchronizing Scrolling -- Custom Views How to Create, Show, and Delete -- Summary -- Chapter 6: Understanding Backstage -- Backstage Overview -- Info Group-Viewing, Adding, and Editing Information About the Workbook -- Properties Pane -- Protect Workbook Options -- Mark as Final -- Encrypt with Password -- Protect Workbook Structure -- Check for Issues -- Inspect Document -- Check Compatibility -- New Group-Creating a New Workbook -- Open Group-Open a Workbook -- Opening an Existing Workbook -- Opening a Workbook from the Recent List -- Keeping Workbooks on the Recent List -- Options Affecting the Open Group -- Specifying the Number of Workbooks That Appear in the Recent List -- Placing Recently Opened Workbooks in the Navigation Pane -- Save and Save As groups-Saving a Workbook Using Save or Save As -- Document Recovery -- Closed a Workbook Without Saving -- Saving Workbooks with Protections: Backups and Limiting Changes -- Print Group-Printing a Workbook -- Selecting a Printer -- Printer Settings -- Selecting to Print Active Worksheets, an Entire Workbook, or a Selected Portion -- Selecting Which Pages to Print -- Collating -- Orientation -- Selecting Paper Size -- Setting Page Margins -- Selecting Scaling Options -- Share Group-Sharing Workbooks -- Sharing Online with OneDrive -- Sharing Files Using E-mail -- Account Group -- Summary -- Chapter 7: Creating and Using Formulas -- Formulas -- Introducing Formulas -- Entering Formulas -- Typing the Formula into a Cell -- Creating the Formula by Clicking the Cells You Want to Reference -- Creating the Formula Using Your Arrow Keys -- Copying Formulas Using AutoFill to Enter a Series of Values -- Teaching Excel to Create an AutoFill Pattern -- Using the AutoFill Options Button -- Create an Autofill Custom List -- Creating, Viewing, Editing, Deleting, and Formatting Cell Comments -- How to Add a Comment -- How to View a Comment -- How to View all the Comments at the Same Time -- How to Change the Default Name for Comments -- Editing and Deleting Comments -- Printing a Comment -- Summary -- Chapter 4: Formatting and Aligning Data -- Formatting Your Text Using the Font Group -- Using Bold, Italics, Underline, and Double Underline -- Changing the Font and Its Size -- Fonts -- Font Size -- Using the Font Group's Dialog Box Launcher -- Formatting with Color -- Changing the Font Color -- Changing the Cell Background Color -- Check Which Formats Have Been Applied to the Current Cell -- Cell Borders -- Drawing Borders -- Formatting Numeric Data Using the Number Group -- Using Default Formats -- Accounting and Currency Formats -- Formatting Monetary Values -- Converting Values to Percent Style -- Converting Values to Comma Style -- Changing the Number of Decimal Places -- Accessing the Format Cell Dialog Box -- Aligning Data Using the Alignment Group -- Fitting More Text into a Cell -- Text Wrapping -- Shrinking to Fit -- Merging and Unmerging Cells -- Aligning and Indenting Text in a Cell -- Align Text Vertically and Horizontally -- Rotating Text -- Using Format Painter to Copy Formatting -- Using the Mini-Toolbars and the Context Menu -- Inserting, Deleting, Hiding, and Unhiding Rows and Columns -- Hiding and Unhiding Columns and Rows -- Hiding Columns and Rows -- Unhiding Columns and Rows -- Unhide Column A or Row 1 -- Inserting Columns and Rows -- Deleting Columns and Rows -- Inserting and Deleting Cells -- Summary -- Chapter 5: Different Ways of Viewing and Printing Your Workbook -- Views Proofreading Cell Values-Have Excel Read Back Your Entries -- Spell Checking -- Thesaurus -- Protect Worksheets and Cells from Accidental or Intentional Changes -- Protect Your Data at the Worksheet Level -- Protect Your Data at the Cell Level -- Summary -- Chapter 10: Using Hyperlinks, Combining Text, and Working with the Status Bar -- Working with Hyperlinks -- Concatenation and Flash Fill -- Using the Status Bar -- Cell Mode -- Flash Fill Blank Cells and Flash Fill Changed Cells -- Caps Lock, Num Lock -- Scroll Lock -- Fixed Decimal -- Overtype Mode -- End Mode -- Macro Recording -- Selection Mode -- Page Number -- Average, Count, Numerical Count, Minimum, Maximum, Sum -- View Shortcuts -- Zoom and Zoom Slider -- Summary -- Chapter 11: Transferring and Duplicating Data to Other Locations -- Moving and Copying Data -- Moving and Copying Cells Using the Drag-and-Drop Method -- Moving and Copying Cells Using the Cut and Copy Buttons -- Moving and Copying Cells Using the Keyboard -- Paste Button Gallery -- Copy Data to Other Worksheets Using Fill Across Worksheets -- Copy Data from One Workbook to Another -- Paste Special -- Using Paste Special -- Using Paste Special to Transpose Rows and Columns -- Using Paste Special to Perform Calculations -- Inserting Copied or Moved Cells -- Insert Copied Cells -- Insert Cut Cells -- Using the Microsoft Office Clipboard -- Entering Data into Multiple Worksheets at the Same Time -- Summary -- Chapter 12: Working with Tables -- Creating and Formatting Tables -- Sort and Filter a Table -- Adding to the Excel Table -- Filtering Data with a Slicer -- Using Themes -- Applying and Defining Cell Styles -- Conditional Formatting -- Summary -- Chapter 13: Working with Charts -- Chart Types -- Creating and Modifying Charts -- Pie Charts -- The Standard Pie Chart -- Pie of Pie Subtype -- Combination Chart |
| Title | Essential Excel 2016 : a step-by-step guide |
| URI | https://cir.nii.ac.jp/crid/1130282269325739392 https://ebookcentral.proquest.com/lib/[SITE_ID]/detail.action?docID=4751037 https://learning.oreilly.com/library/view/~/9781484221617/?ar http://link.springer.com/10.1007/978-1-4842-2161-7 https://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9781484221617 http://www.books24x7.com/marc.asp?bookid=120237 |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV3PixMxFA5uFXRPiop13WUQD0IZaNLMZMabXboKyiq4yt5CJpPI0GG2dLql-9_7JfOjP_YgHrxM25C-hO8Nyfde3nsh5J3lCVOp5iGogA05ttBQWeNsntwYm3Kaan9ryVdxeZlcX6ff25uaan-dgKiqZLNJF_9V1WiDsl3q7D-ouxeKBnyH0vGE2vE8YMT9z9axXrtEIucBn220KUfYdONRk8wMVS7C7C50n6Pft0Xeq_NH6YpY7Ee3t04AeugE-LjYiddoTEOYOZwxGvs6oPcXym1sBEzIxKXogPqFYrsr9LF60ykYzliAJh6RIxHDwH34afbt55etJwvrKeeRz5prx4y6YlrdHLrz5Lak796Yx-RY1XMs6VjuVzX2-Koo9vl-raxaou1xPS_Kssb-dO_c2tOBq6dk4FJEnpEHpnpORj3ugcc9cMgFHwIV7KIeeNRfkF8Xs6vzz2F7BUWoeOyiVxJncRkRZQyWHVVcjK0ex0xPcrf35yyJY5tG40zpibKMasrVBIzYcI45R7DyX5JBdVOZVyQw6SQ2WCBprjSnXKcW7Mpm6KYTiLJD8nYHB7ku_XF5LXeApGJITgGP1IV7UnfqDIYXg4RHrrRhyoYk6ICT_v9tjK-cTc-5cOUTnYgGUNnIX7PDIYIe56YL4xshs_mNd1uC5KHL-w7-VkhX_RqSJJVOlnTCpHj9lwmfkCfbF_oNGayWt-aUPNLrVVEvz9p37Q8F-j-v |
| linkProvider | ProQuest Ebooks |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.title=Essential+Excel+2016+%3A+a+step-by-step+guide&rft.au=Slager%2C+David&rft.date=2016-01-01&rft.pub=Apress&rft.isbn=9781484221600&rft_id=info:doi/10.1007%2F978-1-4842-2161-7&rft.externalDocID=BB27307774 |
| thumbnail_m | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fwww.safaribooksonline.com%2Flibrary%2Fcover%2F9781484221617 http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fvle.dmmserver.com%2Fmedia%2F640%2F97814842%2F9781484221617.jpg |
| thumbnail_s | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fmedia.springernature.com%2Fw306%2Fspringer-static%2Fcover-hires%2Fbook%2F978-1-4842-2161-7 |