Excel 2019 All-In-One: Master the new features of Excel 2019 / Office 365

Description

100% practical guide to understand and use basic to advance level Excel 2019 DESCRIPTION Excel is, by far, the most preferred spreadsheet program on this planet. People love it because of its simplicity and easy user interface. The primary focus of Excel is to perform basic to advanced level numeric calculations. Every industry, department, job role is dependent on Excel to perform day to day duties as well as data analysis and visualization. Microsoft Excel is available in both offline (Excel 2019) and online (Office 365) versions. If you are new to Excel or use this program day in day out, then this book will surely clear your logics and concepts of excel. This book starts with an introduction to Excel program and an overview of its interface and move towards an explanation of new features being introduced in Excel 2019 and Office 365, then an in-depth discussion on entering and transforming data. Understanding different formulas and functions with practical exercises. Afterwards, how to perform data analysis and present it using different data visualization tools. Finally, extracting data and automation of tasks through Macros. After going through this book, you will become conceptually strong in using various features of Excel. You will increase your productivity by understanding and using the right tool for the related data set. KEY FEATURES What’s New in Excel 2019 Office 365 Putting Data into Excel Transforming and Managing the Data Formulas and Functions Data Analysis techniques Data Visualization techniques Multiple ways of Data Extraction Automation in Excel through Macros WHAT WILL YOU LEARN By the end of the book, you will come across many case studies to put your knowledge to practice and understand many tools to solve real-life business problems such as importing data into Excel from different sources, data cleaning through various tools including flash fill, bringing data together into one place using lookup functionality, analysing it to get insights through pivot tables & what if analysis, generating forecast based on past trends, exporting final reports, understanding Power features like Power Pivot/Query/Map and automating manual processes through Macros . Remember to practice along with sample data files provided in the exercise files bundle of the book to master these techniques. WHO THIS BOOK IS FOR This book is for anyone who is either new to Excel or daily Excel user. This book will take you from basic concepts of Excel to Advanced level. Whether you belong to any industry or serving any department, as an Excel user, this book will make you a Pro in Excel. Table of Contents What’s New in Excel 2019/Office 365 Entering Data in Excel Transforming and Managing Data Formulas and Functions Data Analysis Data Visualization Data Extraction Automation in Excel through Macros

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Other editions

• 

  Excel 2019 All-In-One

  • 2019-09-20
  • 283 pages
  • Ebook
  • BPB Publications

Similar books

• 

  Excel All-in-One For Dummies

  By Greg Harvey, Paul McFedries

  Being able to control which outline level is displayed in the worksheet makes it easy to print summary reports with ... when compared to word-processing outlines is that, most often, to calculate your summary totals in the worksheet, ...

• 

  Excel 2019 All-in-One For Dummies

  By Greg Harvey

  The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries.

• 

  Excel 2019 For Dummies

  By Greg Harvey

  The bestselling Excel book on the market — now in a new edition covering the latest version of Excel!

• 

  Mastering Excel 2019: An All-in-One Tutorial Resource

  By Nathan George

  Mastering Excel 2019 is an all-in-one guide that covers all you need to quickly start creating spreadsheet solutions for your data. This book is for you whether you're a beginner, intermediate user, or a power user.

• 

  Excel 2016 All-in-One For Dummies

  By Greg Harvey

  Most worksheet outlines, however, seem backward in the sense that the highest level summary row and column are located at ... The reason that worksheet outlines often seem “backward” when compared to word-processing outlines is that, ...

• 

  Excel 2019 Bible

  By Michael Alexander, John Walkenbach, Richard Kusleika

  The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs.

• 

  Excel For Dummies

  By Greg Harvey

  Head's up - this book was published in 1994! Check out Excel 2019 For Dummies for the most up-to-date information!

• 

  Excel 2010 All-in-One For Dummies

  By Greg Harvey

  Welcome to 2010 — explore the new user experience, learn where to get help, and customize your Excel Workin' with worksheets — learn to build, format, edit, proof, manage, and print them Formula for success — find out what formulas ...

• 

  Microsoft Excel 2019 Data Analysis and Business Modeling

  By Wayne Winston

  Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers.

• 

  Microsoft Excel 2019 Step by Step

  By Curtis Frye

  The quick way to learn Microsoft Excel 2019! This is learning made easy. Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers–brisk lessons and detailed screenshots show you exactly what to do, step by step.