Excel 2019 All-in-One

by Lokesh Lalwani

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 (5-7 points)(each point should be 70 characters with space)Whatâ??s New in Excel 2019 Office 365Putting Data into ExcelTransforming and Managing the DataFormulas and FunctionsData Analysis techniquesData Visualization techniquesMultiple ways of Data ExtractionAutomation in Excel through Macros

286 pages, Kindle Edition

Published December 16, 2019