Teach Yourself VISUALLY Excel 365

ISBN-13: 9781119933625 / Angielski / Miękka / 2022 / 352 str.

McFedries

Spis treści

Chapter 1 Getting Started with ExcelGetting to Know Excel 4Start Excel on the Desktop 6Navigate to Excel for the Web 7Tour the Excel Window 8Work with the Excel Ribbon 9Chapter 2 Entering DataLearning the Layout of a Worksheet 12Understanding the Types of Data You Can Use 13Enter Text into a Cell 14Enter a Number into a Cell 16Enter a Date or Time into a Cell 18Edit Cell Data 20Delete Data from a Cell 22Chapter 3 Working with RangesSelect a Range 26Fill a Range with the Same Data 28Fill a Range with a Series of Values 30Flash Fill a Range 32Move or Copy a Range 34Insert a Row or Column 36Insert a Cell or Range 38Delete Data from a Range 40Delete a Range 42Hide a Row or Column 44Freeze Rows or Columns 46Merge Two or More Cells 48Chapter 4 Working with Range NamesUnderstanding the Benefits of Using Range Names 52Define a Range Name 54Using Worksheet Text to Define a Range Name 56Navigate a Workbook Using Range Names 58Change a Range Name 60Delete a Range Name 62Chapter 5 Formatting Excel RangesChange the Font and Font Size 66Apply Font Effects 68Change the Font Color 70Align Text Within a Cell 72Center Text Across Multiple Columns 74Rotate Text Within a Cell 76Add a Background Color to a Range 78Apply a Number Format 80Change the Number of Decimal Places Displayed 82Apply a Conditional Format to a Range 84Apply a Style to a Range 86Change the Column Width 88Change the Row Height 90Wrap Text Within a Cell 92Add Borders to a Range 94Copy Formatting from One Cell to Another 96Chapter 6 Building FormulasUnderstanding Excel Formulas 100Build a Formula 102Understanding Excel Functions 104Add a Function to a Formula 106Add a Range of Numbers 108Build an AutoSum Formula 110Add a Range Name to a Formula 112Reference Another Worksheet Range in a Formula 114Move or Copy a Formula 116Switch to Absolute Cell References 118Troubleshoot Formula Errors 120Chapter 7 Manipulating WorksheetsNavigate a Worksheet 124Rename a Worksheet 125Create a New Worksheet 126Move a Worksheet 128Copy a Worksheet 130Delete a Worksheet 132Zoom In on or Out of a Worksheet 134Split a Worksheet into Two Panes 136Hide and Unhide a Worksheet 138Chapter 8 Dealing with WorkbooksCreate a New Blank Workbook 142Create a New Workbook from a Template 144Save a Workbook 146Open a Workbook 147Find Text in a Workbook 148Replace Text in a Workbook 150Chapter 9 Formatting WorkbooksModify the Workbook Colors 154Set the Workbook Fonts 156Choose Workbook Effects 158Apply a Workbook Theme 160Add a Workbook Header 162Add a Workbook Footer 164Chapter 10 Importing Data into ExcelUnderstanding External Data 168Import Data from an Access Table 170Import Data from a Word Table 172Import Data from a Text File 174Import Data from a Web Page 176Import Data from an XML File 178Refresh Imported Data 180Separate Cell Text into Columns 182Chapter 11 Working with TablesUnderstanding Tables 186Get to Know Table Features 187Convert a Range to a Table 188Select Table Data 190Insert a Table Row 192Insert a Table Column 193Delete a Table Row 194Delete a Table Column 195Add a Column Subtotal 196Convert a Table to a Range 198Apply a Table Style 199Chapter 12 Analyzing with PivotTablesUnderstanding PivotTables 202Explore PivotTable Features 203Build a PivotTable from an Excel Range or Table 204Refresh PivotTable Data 206Add Multiple Fields to the Row or Column Area 208Add Multiple Fields to the Data Area 210Move a Field to a Different Area 212Group PivotTable Values 214Apply a PivotTable Filter 216Chapter 13 Analyzing DataSort a Range or Table 220Filter a Range or Table 222Set Data Validation Rules 224Create a Data Table 226Summarize Data with Subtotals 228Group Related Data 230Analyze Data with Goal Seek 232Highlight Cells That Meet Some Criteria 234Highlight the Top or Bottom Values in a Range 236Analyze Cell Values with Data Bars 238Analyze Cell Values with Color Scales 240Analyze Cell Values with Icon Sets 242Chapter 14 Visualizing Data with ChartsExamine Chart Elements 246Understanding Chart Types 247Create a Chart 248Create a Recommended Chart 250Add Chart Titles 252Add Data Labels 253Position the Chart Legend 254Display Chart Gridlines 255Display a Data Table 256Change the Chart Layout and Style 257Select a Different Chart Type 258Change the Chart Source Data 260Move or Resize a Chart 262Chapter 15 Adding Worksheet GraphicsDraw a Shape 266Insert an Online Image 268Insert a Photo from Your PC 270Insert a SmartArt Graphic 272Move or Resize a Graphic 274Format a Picture 276Chapter 16 Collaborating with OthersAdd a Comment to a Cell 280Protect a Worksheet's Data 282Protect a Workbook's Structure 284Save a Workbook to Your OneDrive 286Send a Workbook as an Email Attachment 288Save Excel Data as a Web Page 290Make a Workbook Compatible with Earlier Versions of Excel 292Mark Up a Worksheet with Digital Ink 294Collaborate on a Workbook Online 296Index 298