Excel 2019 Intermediate: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery) - Softcover

Inhaltsangabe

Easily Solve Complex Data Challenges in Excel

Whether you have basic Excel skills or you're a power user, Excel 2019 Intermediate is full of techniques and tips that will enable you to take advantage of more powerful tools in Excel to boost your productivity. 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.

Gain Expert Skills in Excel

Excel 2019 Intermediate assumes you have a basic knowledge of Excel, so unlike some other Excel books, it does not waste time and space going over the basics again. Instead, it delves straight into 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 already an Excel power user, you’ll find lots of methods and tips in this book that will come in handy.

This book includes over 120 screenshots to illustrate the concepts and examples covered. You can also download the provided Excel practice files, which will save you lots of typing if you want to practice, hands-on, as you follow the examples detailed in the book.

• Remove duplicate 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 formulas with multiple conditions instead 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.

Scroll up and click the Add to Cart button on the top-right side of the page to get started today!

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.