책 이미지
책 정보
· 분류 : 외국도서 > 컴퓨터 > 데스크탑 애플리케이션 > 스프레드시트
· ISBN : 9781394317103
· 쪽수 : 464쪽
· 출판일 : 2025-05-06
목차
Introduction 1
Part 1: Explaining Excel Fundamentals 7
Chapter 1: Getting Started with Spreadsheets 9
Chapter 2: Carrying Out Basic Calculations 37
Chapter 3: Formatting Cells and Worksheets 61
Chapter 4: Sifting Through Data. 93
Chapter 5: Tackling Tables 115
Part 2: Mastering Formulas and Functions 135
Chapter 6: Leveraging Lookup Formulas 137
Chapter 7: Transforming Text and Numbers 163
Chapter 8: Harnessing Logic Functions 191
Chapter 9: Carving Data with Dynamic Arrays 219
Chapter 10: Tracing and Debugging Formulas 239
Part 3: Expanding Beyond the Basics. 259
Chapter 11: Navigating Through Worksheets and Workbooks 261
Chapter 12: Visualizing and Summarizing Data. 281
Chapter 13: Contemplating Conditional Formatting 311
Chapter 14: User-Proofing Excel Spreadsheets 339
Part 4: Automating Analysis 365
Chapter 15: Accessing Artificial Intelligence 367
Chapter 16: Recording Macros 379
Part 5: The Part of Tens 407
Chapter 17: Ten Timesaving Keyboard Shortcuts 409
Chapter 18: Ten Disaster Recovery Techniques 417
Index 431
