Excel 2019 All-in-One: Master the new features of Excel 2019 / Office 365
- Length: 284 pages
- Edition: 1
- Language: English
- Publisher: BPB Publications
- Publication Date: 2019-07-02
- ISBN-10: 9388511581
- ISBN-13: 9789388511582
- Sales Rank: #405216 (See Top 100 Books)
100% practical guide to understand and use Basic to Advance level Excel 2019
- 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
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.