Microsoft Excel 2019 VBA and Macros (Business Skills)

Bill Jelen, Tracy Syrstad

買這商品的人也買了...

商品描述

Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets.

 

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions.

 

By reading this book, you will:

 

  • Quickly master Excel macro development
  • Work more efficiently with ranges, cells, and formulas
  • Generate automated reports and quickly adapt them for new requirements
  • Learn to automate pivot tables to summarize, analyze, explore, and present data
  • Use custom dialog boxes to collect data from others using Excel
  • Improve the reliability and resiliency of your macros
  • Integrate data from the internet, Access databases, and other sources
  • Automatically generate charts, visualizations, sparklines, and Word documents
  • Create powerful solutions with classes, collections, and custom functions
  • Solve sophisticated business analysis problems more rapidly

 

 

About This Book

 

  • For everyone who wants to get more done with Microsoft Excel in less time
  • For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data

 

 

商品描述(中文翻譯)

著名的Excel專家Bill Jelen(MrExcel)和Tracy Syrstad解釋了如何建立更強大、可靠和高效的Excel電子表格。

使用本指南,您可以自動化幾乎任何常規的Excel任務:節省您數小時、數天,甚至數週的時間。讓Excel做您認為不可能的事情,發現其他地方找不到的巨集技巧,並創建令人驚嘆的強大自動報告。Bill Jelen和Tracy Syrstad幫助您立即將信息可視化,使其可操作;從任何地方捕獲數據,並在任何地方使用它;以及自動化Excel 2019和Office 365中最好的新功能。您將找到簡單的、逐步的說明,實際案例研究以及50個充滿示例和易於適應的解決方案的工作簿。

通過閱讀本書,您將能夠:
- 快速掌握Excel巨集開發
- 更有效地使用範圍、單元格和公式
- 生成自動報告並快速適應新需求
- 學習自動化樞紐表以總結、分析、探索和呈現數據
- 使用自定義對話框在Excel中收集他人的數據
- 提高巨集的可靠性和彈性
- 整合來自互聯網、Access數據庫和其他來源的數據
- 自動生成圖表、可視化效果、迷你圖和Word文檔
- 使用類、集合和自定義函數創建強大的解決方案
- 更快地解決複雜的商業分析問題

關於本書:
- 適用於希望在更短時間內更高效地使用Microsoft Excel的所有人
- 適用於商業和金融專業人士、企業家、學生和其他需要高效管理和分析數據的人士