책 이미지
책 정보
· 분류 : 외국도서 > 컴퓨터 > 데스크탑 애플리케이션 > 프로젝트 관리 소프트웨어
· ISBN : 9781394298242
· 쪽수 : 1088쪽
· 출판일 : 2025-04-08
목차
Introduction xli
Part I: Getting Started with Excel 1
Chapter 1: Introducing Excel 3
Chapter 2: Entering and Editing Worksheet Data 29
Chapter 3: Performing Basic Worksheet Operations 55
Chapter 4: Working with Excel Ranges and Tables 75
Chapter 5: Formatting Worksheets 125
Chapter 6: Understanding Excel Files and Templates 161
Chapter 7: Printing Your Work 181
Chapter 8: Customizing the Excel User Interface 203
Part II: Working with Formulas and Functions 213
Chapter 9: Introducing Formulas and Functions 215
Chapter 10: Understanding and Using Array Formulas 251
Chapter 11: Using Common Formulas for Math and Dates 273
Chapter 12: Using Formulas to Manipulate Text 311
Chapter 13: Using Formulas for Conditional Analysis 331
Chapter 14: Using Formulas for Matching and Lookups 347
Chapter 15: Using Formulas with Conditional Formatting 365
Chapter 16: Making Your Formulas Error-Free 379
Part III: Creating Charts and Other Visualizations 399
Chapter 17: Getting Started with Excel Charts 401
Chapter 18: Using Advanced Charting Techniques 439
Chapter 19: Creating Sparkline Graphics 473
Chapter 20: Visualizing with Custom Number Formats and Shapes 487
Part IV: Managing and Analyzing Data 519
Chapter 21: Importing and Cleaning Data 521
Chapter 22: Using Data Validation 553
Chapter 23: Creating and Using Worksheet Outlines 567
Chapter 24: Linking and Consolidating Worksheets 577
Chapter 25: Introducing Pivot Tables 597
Chapter 26: Analyzing Data with Pivot Tables 619
Chapter 27: Performing Spreadsheet What-If Analysis 653
Chapter 28: Analyzing Data Using Goal Seeking and Solver 675
Chapter 29: Analyzing Data with the Analysis ToolPak 695
Chapter 30: Protecting Your Work 707
Part V: Understanding Power Pivot and Power Query 721
Chapter 31: Introducing Power Pivot 723
Chapter 32: Working Directly with the Internal Data Model 747
Chapter 33: Adding Formulas to Power Pivot 757
Chapter 34: Introducing Power Query 787
Chapter 35: Transforming Data with Power Query 813
Chapter 36: Making Queries Work Together 845
Chapter 37: Enhancing Power Query Productivity 861
Part VI: Automating Excel 873
Chapter 38: Introducing Visual Basic for Applications 875
Chapter 39: Creating Custom Worksheet Functions 903
Chapter 40: Creating UserForms 917
Chapter 41: Using UserForm Controls in a Worksheet 939
Chapter 42: Working with Excel Events 953
Chapter 43: Creating Custom Excel Add-Ins 967
Chapter 44: Office Scripts for Excel 977
Index 1009
