George - Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery)
Here you can read online George - Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery) full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2019, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery): summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery)" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
Gain expert skills in Excel 2019 and easily perform complex tasksWhether you have basic Excel skills or youre 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 dataExcel 2019 Advanced Topics focuses on a selection of topics relevant to real-world productivity tasks youre likely to perform at home or at work requiring more than a basic knowledge of Excel. Even if youre an Excel power user, youll 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, youll 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.
George: author's other books
Who wrote Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery)? Find out the surname, the name of the author of the book and a list of all author's works by series.
George
Dick Kusleika
Michael Alexander
John Wiley
David Hawley
Tom Urtis
Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery) — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery)" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Light
Font size:
↓
↑
Reset
Interval:
↓
↑
Bookmark:
Make
Excel 2019 Advanced Topics
Leverage More Powerful Tools to Enhance Your Productivity
Nathan George
Other Books by Author
Excel 2019 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
Excel 2019 Functions: 70 Top Excel Functions Made Easy
Copyright Nathan George 2019
All rights reserved. The right of Nathan George to be identified as the author of this work has been asserted by him in accordance with the Copyright, Designs and Patents Act, 1988. It is illegal to copy, distribute, or create derivative works from this book in whole or in part or to contribute to the copying, distribution, or creating of derivative works of this book.
***
The information given in this book is given in good faith and belief in its accuracy at the time of publication. The author and publishers disclaim any liability arising directly or indirectly from the use, or misuse, of the information contained in this book.
Table of Contents
Introduction
Excel 2019 Advanced Topics covers a selection of topics that will enable you to take advantage of more powerful features in Excel 2019 in creating quick and robust solutions for your data. My Excel 2019 Basics book covered the essentials of Excel and how to use Excel tools to create solutions for common Excel tasks. Excel 2019 Advanced Topics does not rehash the content of that book. Rather, it goes beyond the basics and covers intermediate to advanced topics. The aim of this book is to provide you with tools and techniques that enable you to solve data challenges that require more than just a basic knowledge of Excel.
With Excel 2019 Advanced Topics , youll learn how to use features that make Excel one of the best data processing and analysis tools in the market. The topics covered include, automating Excel tasks with macros, analysing alternate data sets and creating data projections with What-If Analysis, analysing large data sets with pivot tables and pivot charts, solving complex problems with advanced functions, consolidating data from different worksheets, removing duplicate data, troubleshooting formula errors, and many more. Unlike many other books, this book does not only show you how to use specific features, but also in what context those features need to be used.
Who Is This Book For?
Excel 2019 Advanced Topics is for you if you want to go beyond the basics and become an Excel power user. In this book youll learn how to use some of the more powerful tools to address complex tasks and create quicker results. This is not an exhaustive guide on advanced Excel, but a selection of intermediate to advanced topics relevant to real world productivity tasks youre likely to encounter at home or at work requiring more than a basic knowledge of Excel.
This book assumes you have some basic knowledge of Excel. For brevity, this book does not cover the topics already covered in my Excel 2019 Basics book (unless absolutely necessary for the flow of the lesson). If you need to brush up on the basics (or if youre new to Excel), then my Excel 2019 Basics book covers all the fundamentals youll need to use this book.
Excel 2019 Advanced Topics is aimed at readers with Microsoft Excel 2019, however, many of the core Excel features remain the same for earlier versions of the software like Excel 2016 and 2013. So, you would still find many of the lessons in this book relevant even if you have an earlier version of Excel.
As much as possible, I point out the features new in Excel 2019 when covered. Note however that if youre using an earlier version of Excel, some of the file related tasks described in this book may not match your old version of Excel. This is due to Microsoft changing command options and the screens for many file-related tasks compared to older versions.
How to Use This Book
This book can be used as a step-by-step training guide as well as a reference manual that you come back to from time to time. You can read it cover to cover or skip to certain parts that cover topics you want to learn. Although the chapters have been organised in a logical manner, the book has been designed to enable you to read a chapter as a standalone tutorial to learn how to carry out a certain task.
There are many ways to carry out the same task in Excel, so, for brevity, I have focused on the most efficient way of carrying out a task. On some occasions, however, I also provided alternative ways to carry out a task.
As much as possible, the menu items and commands mentioned are bolded to distinguish them from the other text. I have also included many images to illustrate the features and tasks being discussed.
Assumptions
The software and hardware assumptions made when writing this book is that you already have Excel 2019 installed on your computer and that youre working on the Windows 10 platform.
Important : Excel 2019 is the first version of Excel that is not compatible with previous versions of Windows. If you have an earlier version of Windows, for example, Windows 7 or 8, and youre subscribed to Office 365, then the newest version of Excel you can run will be Excel 2016. Excel 2016 has all the power of Excel 2019 apart from a few added features and some screens that look different. If you are running Excel 2016 you can still use this book (as long as youre aware that some of the screens shown may look slightly different).
If you are using Excel 2019 on a Mac, then simply substitute any Windows keyboard commands mentioned in the book for the Mac equivalent. All the features within Excel remain the same for both platforms.
If youre using Excel on a tablet or touchscreen device, again, simply substitute any keyboard commands mentioned in the book with the equivalent on your touchscreen device.
Practice Files
Downloadable Excel files have been provided to save you a lot of typing if you want to practice in Excel as you follow the examples in the book. All examples are fully detailed in the book and these files have simply been provided to save you some typing, so theyre optional. You can practice by changing the data to view different results. Please note that practice files have only been included for chapters where the examples use a sizable amount of sample data. You can download the file with the following weblink:
https://ngdigital.s3.amazonaws.com/Excel2019AdvancedTopicsPracticeFiles.zip
Note : You would need to have Excel installed on your computer to open and use these files (preferably Excel 2013 and above). Also, the files have been zipped into one download. Windows 10 comes with the functionality to unzip files but if your OS does not have this functionality, youll need to get a piece of software like WinZip or WinRAR to unzip the file.
Improvements in Excel 2019
Ink Improvements
Improved inking and drawing features are available under Draw that enable you to use a drawing tablet to enter math formulas or freestyle drawing in your worksheet.
Better Cell Selection
Have your ever selected too many cells on your worksheet or the wrong ones? You can now deselect cells you dont want to be part of your selection without having to start over.
Improved Autocomplete
The autocomplete is smarter in Excel 2019. For example, let's say you want to use the FORMULATEXT function, but you can't remember the exact spelling, you can just type in =TEXT and the autocomplete menu will list all the functions that contain "TEXT" in their name, including FORMULATEXT. In previous editions, you would need to start spelling the name correctly for autocomplete to find it.
Light
Font size:
↓
↑
Reset
Interval:
↓
↑
Bookmark:
Make
Similar books «Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery)»
Look at similar books to Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery). We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Dick Kusleika
Michael Alexander
John Wiley
David Hawley
Tom Urtis
Reviews about «Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery)»
Discussion, reviews of the book Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery) and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.