- Main
- Computers - Applications & Software
- Excel 2019 Advanced Topics: Leverage...
Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery)
George, Nathan你有多喜欢这本书?
下载文件的质量如何?
下载该书,以评价其质量
下载文件的质量如何?
Gain expert skills in Excel 2019 and easily perform complex tasks
Whether you have basic Excel skills or you're a power user, Excel 2019 Advanced Topics is full of tips, techniques and tools that will save you time and effort in performing challenging tasks in Excel. When building complicated spreadsheets solutions, using the right tool in Excel can increase the accuracy and efficiency of your work. This book does not only show you how to use specific features but also in what context those features need to be used.
Get real-world solutions for your data
Excel 2019 Advanced Topics focuses on a selection of topics relevant to real-world productivity tasks you’re likely to perform at home or at work requiring more than a basic knowledge of Excel. Even if you’re an Excel power user, you’ll find lots of ideas and tips in this book that will save your time and effort.
Includes tons of examples and readymade formulas that you can copy and use in your own worksheets. The downloadable Excel practice files will also save you typing if you want to practice as you follow the examples detailed in the book.
In this book, you'll learn how to:
Remove duplicate values or rows from a data list.
Delete blank rows in your data list.
Consolidate data from different worksheets or workbooks.
Import and use data from external sources like Microsoft Access databases, CSV text files, and Internet web pages.
Troubleshoot and fix errors in formulas with various debugging tools.
Use functions like IFS and SUMIFS to create simpler but more efficient conditional formulas in place of convoluted nested IF functions.
Manipulate text with LEFT, RIGHT or MID functions.
Carry out financial calculations with functions like PV, FV and NPV.
Use Macros to automate Excel tasks.
Analyze different data scenarios and create projections with What-If Analysis tools.
Dynamically analyze large sets of data with Pivot Tables and Pivot Charts.
Protect your workbook, worksheets, or specific cells in your worksheets from unauthorised or accidental changes.
Whether you have basic Excel skills or you're a power user, Excel 2019 Advanced Topics is full of tips, techniques and tools that will save you time and effort in performing challenging tasks in Excel. When building complicated spreadsheets solutions, using the right tool in Excel can increase the accuracy and efficiency of your work. This book does not only show you how to use specific features but also in what context those features need to be used.
Get real-world solutions for your data
Excel 2019 Advanced Topics focuses on a selection of topics relevant to real-world productivity tasks you’re likely to perform at home or at work requiring more than a basic knowledge of Excel. Even if you’re an Excel power user, you’ll find lots of ideas and tips in this book that will save your time and effort.
Includes tons of examples and readymade formulas that you can copy and use in your own worksheets. The downloadable Excel practice files will also save you typing if you want to practice as you follow the examples detailed in the book.
In this book, you'll learn how to:
Remove duplicate values or rows from a data list.
Delete blank rows in your data list.
Consolidate data from different worksheets or workbooks.
Import and use data from external sources like Microsoft Access databases, CSV text files, and Internet web pages.
Troubleshoot and fix errors in formulas with various debugging tools.
Use functions like IFS and SUMIFS to create simpler but more efficient conditional formulas in place of convoluted nested IF functions.
Manipulate text with LEFT, RIGHT or MID functions.
Carry out financial calculations with functions like PV, FV and NPV.
Use Macros to automate Excel tasks.
Analyze different data scenarios and create projections with What-If Analysis tools.
Dynamically analyze large sets of data with Pivot Tables and Pivot Charts.
Protect your workbook, worksheets, or specific cells in your worksheets from unauthorised or accidental changes.
年:
2020
语言:
english
页:
279
文件:
PDF, 8.22 MB
您的标签:
IPFS:
CID , CID Blake2b
english, 2020
在1-5分钟内,文件将被发送到您的电子邮件。
该文件将通过电报信使发送给您。 您最多可能需要 1-5 分钟才能收到它。
注意:确保您已将您的帐户链接到 Z-Library Telegram 机器人。
该文件将发送到您的 Kindle 帐户。 您最多可能需要 1-5 分钟才能收到它。
请注意:您需要验证要发送到Kindle的每本书。检查您的邮箱中是否有来自亚马逊Kindle的验证电子邮件。
正在转换
转换为 失败