Overview

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 your time going over the basics again. Instead, we delve 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. Buy now and get started today with increasing your productivity!

Full Product Details

9781916211315

Table of Contents

Reviews

Author Information

Tab Content 6

Customer Reviews

Recent Reviews

Countries Available