Format:
1 Online-Ressource (387 Seiten)
Edition:
2nd ed
ISBN:
9781119832164
Note:
Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- Conventions Used in This Book -- Foolish Assumptions -- Beyond the Book -- Icons Used in This Book -- Where to Go from Here -- Part 1 Building Worksheets -- Chapter 1 Getting Familiar with the Excel Interface -- Launching Excel -- Identifying the Parts of the Excel Window -- Selecting Commands in the Backstage View -- Selecting Commands from the Ribbon -- Adding a custom tab to the Excel Ribbon -- Adding commands to groups on your custom tab -- Selecting Commands on the Quick Access Toolbar -- Displaying the Quick Access toolbar -- Customizing the Quick Access toolbar -- Adding more commands to the Quick Access toolbar -- Chapter 2 Entering the Worksheet Data -- Opening a New Workbook -- Moving Around the Workbook -- Moving within the displayed area -- Moving to a new area of the worksheet -- Moving to a different sheet in the workbook -- Selecting Cell Ranges -- Making Cell Entries -- Entering data in a single cell -- Entering data in a range -- Filling in a data series with the fill handle -- Copying a formula with the fill handle -- Saving the Spreadsheet Data in a Workbook File -- Chapter 3 Formatting the Worksheet -- Resizing Columns and Rows -- Making column widths suit the data -- Manipulating the height of certain rows -- Cell Formatting Techniques -- Formatting cells with the Ribbon's Home tab -- Formatting cells with the Format Cells dialog box -- Using cell styles -- Using conditional formatting -- Hiding Columns and Rows -- Chapter 4 Printing Worksheet Reports -- Previewing Pages in the Worksheet and Backstage View -- Adjusting Page Breaks -- Adding Headers and Footers -- Adding Print Titles to a Report -- Modifying the Print Settings for a Report -- Printing All or Part of the Workbook -- Printing a range -- Printing the entire workbook
,
Printing charts in the worksheet -- Printing the worksheet formulas -- Chapter 5 Modifying the Worksheet -- Finding and Identifying the Region That Needs Editing -- Selecting the Ranges to Edit -- Editing Data Entries -- Deleting and Inserting Data and Cells -- Moving and Copying Data and Cells -- Adding Notes to the Worksheet -- Using Find and Replace and Spell Checking -- Editing Multiple Worksheets -- Part 2 Using Formulas and Functions -- Chapter 6 Building Formulas -- Building Formulas -- Building formulas by hand -- Building formulas with built-in functions -- Editing formulas -- Altering the natural order of operations -- Using External Reference Links -- Controlling When Formulas Are Recalculated -- Chapter 7 Copying and Correcting Formulas -- Copying Formulas with Relative References -- Copying Formulas with Absolute References -- Copying Formulas with Mixed References -- Using Range Names in Formulas -- Building Array Formulas -- Tracing and Eliminating Formula Errors -- Dealing with Circular References -- Chapter 8 Creating Date and Time Formulas -- Constructing Date and Time Formulas -- Working with Simple Date Functions -- Working with Excel's Fancier Date Functions -- Working with the Time Functions -- Chapter 9 Financial Formulas and Functions -- Working with Financial Functions -- Using the Basic Investment Functions -- Figuring the Depreciation of an Asset -- Chapter 10 Using Math Functions -- Rounding Off Values -- Finding Products, Powers, and Square Roots -- Doing Fancier Sums -- Summing products, squares, and their differences -- Conditional totals -- Chapter 11 Using Common Statistical Functions -- Computing Averages -- Finding the Highest and Lowest Values -- Counting Cells -- Using the Statistical Functions in Analysis ToolPak Add-in -- Chapter 12 Using Lookup Functions -- Looking Up Stuff with XLOOKUP.
,
Returning Single Values from a Lookup Table -- Performing a horizontal lookup -- Performing a vertical lookup -- Chapter 13 Using Logical Functions -- Working with the Logical Functions -- Constructing Decision-Making Formulas -- Choosing between alternate values -- Selecting between alternate calculations -- Nesting IF functions -- Constructing Error-Trapping Formulas -- Chapter 14 Text Formulas and Functions -- Constructing Text Formulas -- Using Text Functions -- Part 3 Working with Graphics -- Chapter 15 Charting Worksheet Data -- Understanding Excel Charts -- Creating Charts -- Formatting Charts -- Editing Charts -- Chapter 16 Adding Graphics to Worksheets -- Understanding Graphic Objects -- Adding Various Types of Graphic Objects -- Inserting prefab art -- Importing graphics files -- Adding graphic shapes and text boxes -- Constructing WordArt -- Constructing SmartArt -- Part 4 Managing and Securing Data -- Chapter 17 Building and Maintaining Tables -- Creating a Table -- Adding records to a new table -- Editing records in the data form -- Sorting Tables -- Using sorting keys -- Sorting a table on multiple keys -- Sorting the fields (columns) in a table -- Subtotaling a Table -- Filtering a Table -- Querying External Database Tables -- Chapter 18 Protecting Workbooks and Worksheet Data -- Password-Protecting the Workbook -- Protecting the Worksheet -- Doing Data Entry in a Protected Worksheet -- Protecting the Entire Workbook -- Part 5 Doing Data Analysis -- Chapter 19 Performing What-If Analysis -- Performing What-If Analysis with Data Tables -- Creating a single-variable data table -- Creating a two-variable data table -- Analyzing Data with Scenarios -- Goal Seeking in a Worksheet -- Creating Complex Models with Solver -- Chapter 20 Generating PivotTables -- Working with PivotTables -- Creating PivotTables -- Modifying the PivotTable
,
Modifying the PivotTable formatting -- Pivoting the PivotTable's fields -- Changing the PivotTable summary function and adding calculated fields -- Creating PivotCharts -- Part 6 Macros and Visual Basic for Applications -- Chapter 21 Using Macros -- Creating Macros -- Recording and playing back macros -- Recording macros with relative cell references -- Assigning Macros to the Quick Access Toolbar -- Assigning Macros to the Ribbon -- Chapter 22 Using the Visual Basic Editor -- Using the Visual Basic Editor -- Editing a recorded macro -- Adding a dialog box that processes user input -- Creating User-Defined Functions -- Using a custom function in your worksheet -- Saving custom functions in add-in files -- Part 7 The Part of Tens -- Chapter 23 Top Ten Features in Excel -- The Excel Ribbon and Backstage View -- Conditional Formatting -- PivotTable Filtering with Slicers -- Home Tab Formatting and Editing -- Insert Tab Charting -- Format as Table -- The Zoom Slider on the Status Bar -- Page Layout View -- Style Galleries -- Live Preview -- Chapter 24 Top Ten Tips for Using Excel Like a Pro -- Generating New Workbooks from Templates -- Organizing Data on Different Worksheets -- Creating Data Series with AutoFill -- Using Range Names -- Freezing Column and Row Headings -- Preventing Data Entry Errors with Data Validation -- Trapping Error Values -- Saving Memory by Using Array Formulas -- Using Outlines to Control the Display of Data -- Using View Side by Side to Work with Two Workbooks -- Index -- EULA.
Additional Edition:
Erscheint auch als Druck-Ausgabe McFedries, Paul Excel Workbook for Dummies Newark : John Wiley & Sons, Incorporated,c2022 ISBN 9781119832157
Language:
English
Author information:
McFedries, Paul 1959-
Bookmarklink
