发帖
雷达卡
是否需要本书——
- Introduction
- 前言
- Excel 2019 is a roll-up of most of the features introduced to Office 365 subscribers in the three years since Excel 2016 was released. Although this book title is Excel 2019 Inside Out, I don’t actually expect that many readers will be using the perpetual version of Excel 2019. Instead, most customers have switched over to Office 365, where new features are introduced monthly.
- Excel 2019是自Excel 2016发布以来三年内引入Office 365订阅者的大多数功能的汇总。虽然这本书的标题是Excel 2019 Inside Out，但我实际上并不期望很多读者会使用永久版本的Excel 2019.相反，大多数客户已经切换到Office 365，每月都会推出新功能。
- The Excel team has been responsive to items requested through the Excel.UserVoice.comwebsite, and many small features and improvements happened in Excel 2019. Here are the new features as of the official release of Office 2019:
- Excel团队已对通过Excel.UserVoice.com网站请求的项目做出响应，并且Excel 2019中发生了许多小功能和改进。以下是Office 2019正式版本中的新功能：
- • Co-authoring has been massively improved. If you have several people who must access the same workbook at the same time, you’ll have no issue as long as you save your workbook to OneDrive. Read more in Chapter 1, “What’s New in Excel 2019.”
- 共享协同已经大大改进。如果您有多个人必须同时访问同一个工作簿，只要将工作簿保存到OneDrive，就没有问题。有关详细信息，请参阅第1章“Excel 2019中的新增功能”。
- • The charting team introduced two new chart types: Funnel and Filled Map Charts. The May 2018 announcement that Excel charts would soon support custom visuals from Power BI did not make it to Excel 2019, but the update will likely roll out to Office 365 in early 2019. Read about these charts in Chapter 23, “Graphing Data Using Excel Charts.”
- 图表团队引入了两种新的图表类型：漏斗和填充地图。 2018年5月发布的Excel图表很快将支持来自Power BI的自定义视觉效果，但未进入Excel 2019，但更新可能会在2019年初推出到Office 365.请阅读第23章“使用Excel绘制数据图表”中的这些图表图表“。
- • There are new features in Power Query (found in the Get & Transform group on the Data tab). You can now Split By Delimiter to Rows instead of columns, and you can create new columns by typing examples. Read about Power Query in Chapter 13, “Transforming Data.”
- Power Query中有新功能（可在“数据”选项卡上的“获取和转换”组中找到）。您现在可以按分隔符拆分为行而不是列，您可以通过键入示例来创建新列。请阅读第13章“转换数据”中的Power Query。
- • Pivot tables will not Sum instead of Count if your data has a mix of numbers and empty cells. Another great improvement in pivot tables is the Pivot Table Defaults feature. If you want every new pivot table to start in tabular layout instead of compact layout, this feature is for you. Read more in Chapter 15, “Using Pivot Tables to Analyze Data.”
- 如果您的数据混合了数字和空单元格，则数据透视表将不会用“求和”替代“计数”。数据透视表默认值功能是数据透视表的另一项重大改进。如果您希望每个新的数据透视表以表格布局而不是紧凑布局开始，则此功能适合您。有关详细信息，请参阅第15章“使用数据透视表分析数据”。
- • Data types debut with support for Geography and Stock Quotes. It seems likely that more data types will be introduced for Office 365 subscribers. See Chapter 5, “Understanding Formulas.”
- 数据类型首次亮相，支持地理和股票行情。似乎可能会为Office 365订阅者引入更多数据类型。请参阅第5章“了解公式”。
- • Ideas is a new artificial intelligence feature. Excel analyzes up to 250,000 cells of data and uses artificial intelligence to provide more than 30 charts. For now, this feature is exclusive to Office 365. See Chapter 15, “Using Pivot Tables to Analyze Data.”
- Ideas是一种新的人工智能功能。 Excel分析多达250,000个数据单元，并使用人工智能提供超过30个图表。目前，此功能仅适用于Office 365.请参阅第15章“使用数据透视表分析数据”。
- • Excel 2019 offers six new calculation functions. CONCAT, TEXTJOIN, MAXIFS, and MINIFS are covered in Chapter 8, “Using Everyday Functions: Math, Date and Time, and Text Functions.” The new SWITCH and IFS functions are covered in Chapter 9, “Using Powerful Functions: Logical, Lookup, and Database Functions.”
- Excel 2019提供六种新的计算功能。 CONCAT，TEXTJOIN，MAXIFS和MINIFS在第8章“使用日常函数：数学，日期和时间以及文本函数”中介绍。新的SWITCH和IFS函数在第9章“使用强大函数：逻辑，查找”中介绍和数据库功能。“
- • Power Pivot is now freely available to anyone who uses Office 2019. You can insert new calculated fields using the DAX formula language. DAX improvements include the ability to add medians to pivot tables or report text in the values field of pivot tables. Read about Power Pivot in Chapter 17, “Mashing Up Data with Power Pivot.”
- 现在，任何使用Office 2019的人都可以免费使用Power Pivot。您可以使用DAX公式语言插入新的计算字段。 DAX改进包括在数据透视表的值字段中添加中间数到数据透视表或报告文本的功能。请阅读第17章“使用Power Pivot对数据进行混搭”中的Power Pivot。
- • Office 365 is getting a new ribbon interface. The icons have been redrawn, and the selected tab is now denoted with an underline instead of an outline. However, Excel 2019 is still sporting the old ribbon.
- Office 365正在获得一个新的功能区界面。图标已重新绘制，选中的选项卡现在用下划线而不是轮廓表示。然而，Excel 2019仍然是旧的功能区。
- • Excel 2019 adds support for icons and 3D objects. The icon feature offers 180 icons that you can insert. Support for 3D objects lets you rotate and view various objects in Excel.
- Excel 2019添加了对图标和3D对象的支持。图标功能提供180个可以插入的图标。支持3D对象使您可以在Excel中旋转和查看各种对象。
- • Office 365 offers seven new array formulas: SEQUENCE, RANDARRAY, SORT, SORTBY,UNIQUE, FILTER, and SINGLE. A single formula can now spill into adjacent cells, eliminating the need to press Ctrl+Shift+Enter to generate an array. These are covered in Chapter 1, “What’s New in Excel 2019.”
- Office 365提供了七个新的数组公式：SEQUENCE，RANDARRAY，SORT，SORTBY，UNIQUE，FILTER和SINGLE。单个公式现在可以扩展到相邻单元格中，无需按Ctrl+Shift+Enter即可生成数组。这些内容将在第1章“Excel 2019中的新功能”中介绍。
- • The Keep The Copy feature keeps copied cells on the Clipboard until you remove them by pressing Esc. In the past, it was often frustrating that simple tasks such as inserting one extra row would cause the Clipboard to clear. Now there’s a solution for that problem.
- “保留复制”功能可将复制的单元格保留在剪贴板上，直到按Esc键将其删除。在过去，简单的任务（例如插入一个额外的行）会导致剪贴板清除，这常常令人沮丧。现在有一个解决这个问题的方法。
- • Excel will no longer nag you when you close or save a CSV file. There used to be warnings that you would lose your formulas and formatting. These were particularly annoying when you only needed to open the CSV file to check something without making changes. Excel always threw a warning when you tried to close the file.
- 关闭或保存CSV文件时，Excel将不再烦劳您。曾经的警告说你会丢失你的公式和格式。当您只需要打开CSV文件来检查某些内容而不进行更改时，这些特别恼人。当您尝试关闭文件时，Excel始终发出警告。
- • Insert Data From Picture is a new image-recognition capability in Excel that lets you quickly convert a picture of a data table into an Excel file.
- “从图片插入数据”是Excel中的一种新的图像识别功能，可让您快速将数据表的图片转换为Excel文件。
- • Forms.Office.Com allows you to design an online survey, collect answers in real time, and then download the results to Excel. This is covered in Chapter 1, “What’s New in Excel 2019.”
- Forms.Office.Com允许您设计在线调查，实时收集答案，然后将结果下载到Excel。这将在第1章“Excel 2019中的新功能”中介绍。
- • Although this book covers VBA as the macro language, there is one new interesting feature in programmability: Any user-defined functions written in JavaScript now work in both the desktop version of Excel and in Excel Online. JavaScript is still slow and clunky compared to VBA, but it could be the hint of what’s coming in the future.
- 虽然本书将VBA作为宏语言，但可编程性还有一个新的有趣特性：用JavaScript编写的任何用户定义函数现在都可以在桌面版Excel和Excel Online中使用。与VBA相比，JavaScript仍然缓慢而笨拙，但它可能暗示未来会带来的方向。
- • Microsoft has a new focus on accessibility. The new Modern Sound Scheme provides gentle audible feedback for a number of actions in Excel. See Chapter 1, “What’s New in Excel 2019.”
- 微软重新关注可访问性。新的“实时语音方案”为Excel中的许多操作提供了温和的声音反馈。请参见第1章“Excel 2019中的新增功能”。
- • Power BI Desktop and Power BI allow you to share your Excel workbooks and dashboards over the Internet or to a tablet or phone. Chapter 28, “Sharing Dashboards with Power BI,” introduces this new functionality.
- Power BI Desktop和Power BI允许您通过Internet或平板电脑还有手机共享Excel工作簿和仪表板。第28章“使用Power BI共享仪表板”介绍了此新功能。
- • Picture transparency has been added to Office 365. Now you can see the values in cells behind your picture.
- Office 365中添加了图片透明度。现在，您可以在图片后面的单元格中查看值。
- • The algorithm for VLOOKUP has been improved. If you are doing repetitive lookups,VLOOKUP speed could be ten times faster.
- VLOOKUP的算法已得到改进。如果您正在进行重复查找，VLOOKUP速度可能会快十倍。
- WHO THIS BOOK IS FOR
- 谁适合本书
- This book is for anyone who uses Excel twenty hours a week or more. Whether you use Excel for organizing your to-do list or to analyze 5 million rows of call center data every day, this book includes the information you need to solve problems quickly and easily.
- 本书适用于每周使用Excel 20小时或更长时间的人。无论您是使用Excel来组织待办事项列表还是每天分析500万行呼叫中心数据，本书都包含您快速，轻松地解决问题所需的信息。
- Assumptions About You
- 对你的设定
- I like to believe most of my readers use Excel 40 hours a week, and those are the weeks you are on vacation. At the very least, I’m assuming you regularly use Excel for your job. You are comfortable using Excel formulas beyond AutoSum. You likely know and use VLOOKUP and Pivot Tables regularly. You are looking for the fastest and most efficient ways to finish tasks in Excel.
- 我愿意相信我的大多数读者每周都会使用Excel 40小时，而那些是您几周假期中。至少，我假设您经常使用Excel来完成工作。您可以使用AutoSum以外的Excel公式。您可能会定期了解并使用VLOOKUP和数据透视表。您正在寻找在Excel中完成任务的最快速，最有效的方法。
- HOW THIS BOOK IS ORGANIZED
- 本书组织
- This book gives you a comprehensive look at the various features you will use. This book is structured in a logical approach to all aspects of using the Windows-based versions of Excel 2019 or Excel in Office 365.
- 本书将全面介绍您将使用的各种功能。本书采用逻辑方法构建，以便在其中使用基于Windows的Excel 2019或Excel Office 365版本的各个方面。
- Part I, “The Excel Interface,” covers the ribbon, customizing Excel, and keyboard shortcuts.
- 第一部分“Excel界面”包括功能区，自定义Excel和键盘快捷键。
- Part II, “Calculating with Excel,” covers all Excel calculation functions.
- 第二部分“使用Excel计算”涵盖了所有Excel计算功能。
- Part III, “Data Analysis with Excel,” covers Power Query, Pivot Tables, and other features that help you perform data analysis.
- 第III部分“使用Excel进行数据分析”介绍了Power Query，Pivot Tables以及其他可帮助您执行数据分析的功能。
- Part IV, “Excel Visuals,” covers charting, 3D Map, and Power BI.
- 第四部分，“Excel Visuals”，包括图表，3D地图和Power BI。
- ABOUT THE COMPANION CONTENT
- 关于随书内容
- I have included the Excel workbooks I used to create the screenshots in this book to enrich your learning experience. You can download this book’s companion content from the following page:
- 我已经包含了我用来创建本书截图的Excel工作簿，以丰富您的学习体验。您可以从以下页面下载本书的配套内容：
- microsoftpressstore.com/Excel2019InsideOut/downloads
- The companion content includes the following:
- 配套内容包括以下内容：
- • Workbooks used to create the examples in the workbook
- 用于在工作簿中创建示例的工作簿
- • Sample data that you can use to practice the concepts in the book
- 可用于练习本书中概念的示例数据
- • VBA macros from Chapter 19
- 第19章中的VBA宏
提升卡
置顶卡
沉默卡
变色卡
抢沙发
千斤顶
显身卡
京公网安备 11010802022788号
