000 03004cam a22002175i 4500
005 20261109115228.0
020 _a9781394298242
041 _aENG
082 _a005.54
_bALE
100 1 _aAlexander, Michael
245 1 0 _aMicrosoft excel 365 Bible /
_cMichael Alexander, Dick Kusleika
246 _aExcel 365 bible
250 _a2nd ed.
260 _aHoboken :
_bJohn Wiley & Sons ,
_c2025.
300 _axlv, 1042 pages :
_billustrations ;
_c24 cm.
505 _aPart I: Getting Started with Excel -- Chapter 1: Introducing Excel -- Chapter 2: Entering and Editing Worksheet Data -- Chapter 3: Performing Basic Worksheet Operations -- Chapter 4: Working with Excel Ranges and Tables -- Chapter 5: Formatting Worksheets -- Chapter 6: Understanding Excel Files and Templates -- Chapter 7: Printing Your Work -- Chapter 8: Customizing the Excel User Interface -- Part II: Working with Formulas and Functions -- Chapter 9: Introducing Formulas and Functions -- Chapter 10: Understanding and Using Array Formulas -- Chapter 11: Using Common Formulas for Math and Dates -- Chapter 12: Using Formulas to Manipulate Text -- Chapter 13: Using Formulas for Conditional Analysis -- Chapter 14: Using Formulas for Matching and Lookups -- Chapter 15: Using Formulas with Conditional Formatting -- Chapter 16: Making Your Formulas Error-Free -- Part III: Creating Charts and Other Visualizations -- Chapter 17: Getting Started with Excel Charts -- Chapter 18: Using Advanced Charting Techniques -- Chapter 19: Creating Sparkline Graphics -- Chapter 20: Visualizing with Custom Number Formats and Shapes -- Part IV: Managing and Analyzing Data -- Chapter 21: Importing and Cleaning Data -- Chapter 22: Using Data Validation -- Chapter 23: Creating and Using Worksheet Outlines -- Chapter 24: Linking and Consolidating Worksheets -- Chapter 25: Introducing Pivot Tables -- Chapter 26: Analyzing Data with Pivot Tables -- Chapter 27: Performing Spreadsheet What-If Analysis -- Chapter 28: Analyzing Data Using Goal Seeking and Solver -- Chapter 29: Analyzing Data with the Analysis ToolPak -- Chapter 30: Protecting Your Work -- Part V: Understanding Power Pivot and Power Query -- Chapter 31: Introducing Power Pivot -- Chapter 32: Working Directly with the Internal Data Model -- Chapter 33: Adding Formulas to Power Pivot -- Chapter 34: Introducing Power Query -- Chapter 35: Transforming Data with Power Query -- Chapter 36: Making Queries Work Together -- Chapter 37: Enhancing Power Query Productivity -- Part VI: Automating Excel -- Chapter 38: Introducing Visual Basic for Applications -- Chapter 39: Creating Custom Worksheet Functions -- Chapter 40: Creating UserForms -- Chapter 41: Using UserForm Controls in a Worksheet -- Chapter 42: Working with Excel Events -- Chapter 43: Creating Custom Excel Add-Ins -- Chapter 44: Office Scripts for Excel.
650 _aMicrosoft Excel (Computer file)
650 _a Electronic spreadsheets
_xComputer programs
700 _aKusleika, Dick
942 _2ddc
_cBK
999 _c24576
_d24576