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...
Uloženo v:
| Hlavní autor: | |
|---|---|
| Médium: | E-kniha Kniha |
| Jazyk: | angličtina |
| Vydáno: |
Berkeley, CA
Apress
2016
Apress L. P |
| Vydání: | 1 |
| Témata: | |
| ISBN: | 1484221605, 9781484221600, 1484221613, 9781484221617 |
| On-line přístup: | Získat plný text |
| Tagy: |
Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
|
Obsah:
- 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