책 이미지
책 정보
· 분류 : 외국도서 > 컴퓨터 > 데스크탑 애플리케이션 > 스프레드시트
· ISBN : 9781394344635
· 쪽수 : 816쪽
· 출판일 : 2025-09-09
목차
Introduction 1
Book 1: Getting Started with Excel 5
Chapter 1: Getting Started with Spreadsheets 7
Chapter 2: Carrying Out Basic Calculations 31
Chapter 3: Formatting Cells and Worksheets 53
Chapter 4: Organizing Data and Creating Tables 79
Chapter 5: Navigating Worksheets and Workbooks 113
Book 2: Working with Formulas and Functions 129
Chapter 1: Tapping Into Formula and Function Fundamentals 131
Chapter 2: Saving Time with Function Tools 161
Chapter 3: Building Array Formulas and Functions 177
Chapter 4: Fixing Errors in Formulas 191
Book 3: Going Farther with Functions 207
Chapter 1: Calculating Loans, Interest, and Depreciation 209
Chapter 2: Performing Functional Math. 241
Chapter 3: Working with Date and Time Functions 271
Chapter 4: Manipulating Text with Functions 291
Book 4: Analyzing Data 317
Chapter 1: Using Basic Data Analysis Techniques 319
Chapter 2: Working with Data Analysis Tools 343
Chapter 3: Analyzing Table Data with Functions 365
Book 5: Summarizing, Visualizing, and Illustrating Data 377
Chapter 1: Creating Charts 379
Chapter 2: Creating and Using PivotTables 391
Chapter 3: Performing PivotTable Calculations 413
Chapter 4: Building PivotCharts 435
Book 6: Reporting and Querying Data 455
Chapter 1: Introducing Power Pivot 457
Chapter 2: Advanced Moves with PivotTables 469
Chapter 3: Working Directly with the Internal Data Model 499
Chapter 4: Adding Formulas to Power Pivot 513
Chapter 5: Meeting Power Query and Its Connection Types 531
Book 7: Creating Dashboards and Reports 559
Chapter 1: Getting in the Dashboard State of Mind 561
Chapter 2: Building a Super Model 575
Chapter 3: Dressing Up Your Data Tables 619
Chapter 4: Formatting Your Way to Visualizations 635
Chapter 5: Displaying Performance against a Target 663
Book 8: Automating Excel with Macros and VBA 679
Chapter 1: Macro Fundamentals 681
Chapter 2: Getting Cozy with the Visual Basic Editor 701
Chapter 3: The Anatomy of Macros 715
Chapter 4: Working with Workbooks 729
Index 753
![[eBook Code] R Projects For Dummies (eBook Code, 1st)](/img_thumb2/9781119446163.jpg)
![[eBook Code] Statistical Analysis with R For Dummies (eBook Code, 1st)](/img_thumb2/9781119337263.jpg)
![[eBook Code] Data Visualization with Excel Dashboards and Reports (eBook Code, 1st)](/img_thumb2/9781119698739.jpg)
![[eBook Code] Data Visualization with Excel Dashboards and Reports (eBook Code, 1st)](/img_thumb2/9781119698807.jpg)
![[eBook Code] QuickBooks Online For Dummies (eBook Code, 6th)](/img_thumb2/9781119679080.jpg)
![[eBook Code] Excel Dashboards & Reports For Dummies (eBook Code, 4th)](/img_thumb2/9781119844419.jpg)
![[eBook Code] Excel Makros für Dummies (eBook Code, 2nd)](/img_thumb2/9783527833153.jpg)
![[eBook Code] Excel 2019 Power Programming with VBA (eBook Code, 1st)](/img_thumb2/9781119514916.jpg)
![[eBook Code] Excel 2019 Power Programming with VBA (eBook Code, 1st)](/img_thumb2/9781119514947.jpg)
