책 이미지
eBook 미리보기
책 정보
· 제목 : Excel Macros for Dummies (Paperback)
· 분류 : 외국도서 > 컴퓨터 > 데스크탑 애플리케이션 > 스프레드시트
· ISBN : 9781119089346
· 쪽수 : 288쪽
· 출판일 : 2015-06-02
· 분류 : 외국도서 > 컴퓨터 > 데스크탑 애플리케이션 > 스프레드시트
· ISBN : 9781119089346
· 쪽수 : 288쪽
· 출판일 : 2015-06-02
목차
Introduction 1
Part I: Holy Macro Batman! 7
Chapter 1: Macro Fundamentals 9
Chapter 2: Getting Cozy with Visual Basic Editor 29
Chapter 3: The Anatomy of Macros 43
Part II: Making Short Work of Workbook Tasks 57
Chapter 4: Working with Workbooks 59
Chapter 5: Working with Worksheets 85
Part III: Onei¿½]Touch Data Manipulation 113
Chapter 6: Feeling at Home on the Range 115
Chapter 7: Manipulating Data with Macros 137
Part IV: Macroi¿½]Charging Reports and Emails 173
Chapter 8: Automating Common Reporting Tasks 175
Chapter 9: Sending Emails from Excel 213
Part V: The Part of Tens 229
Chapter 10: Ten Handy Visual Basic Editor Tips 231
Chapter 11: Ten Places to Turn for Macro Help 239
Chapter 12: Ten Ways to Speed Up Your Macros 245
Index 255
