Articoli correlati a Excel 2019 Intermediate: Leverage More Powerful Tools...
Sinossi
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.
In this book, you'll learn how to:- 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!
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
(nessuna copia disponibile)
Cerca: Inserisci un desiderataNon riesci a trovare il libro che stai cercando? Continueremo a cercarlo per te. Se uno dei nostri librai lo aggiunge ad AbeBooks, ti invieremo una notifica!
Inserisci un desiderata
