BOOKS - OS AND DB - Advanced Analytics with Excel 2019 Perform Data Analysis Using Ex...
US $6.67
232415
232415
Advanced Analytics with Excel 2019 Perform Data Analysis Using Excel’s Most Popular Features
Author: Manisha Nigam
Year: 2020
Number of pages: 701
Format: EPUB | PDF
File size: 50 MB
Language: ENG
Year: 2020
Number of pages: 701
Format: EPUB | PDF
File size: 50 MB
Language: ENG
Book explains and simplify the usage of Excel features and functionalities, with the help of examples. It starts with ‘Getting Started with Excel’ and ‘Performing functions with shortcut keys’ which will help you in getting started with Excel. Then ‘Formulas and Functions’ gives an initial understanding of what are operators, formulas, functions, their components. Further ‘Data Visualization with new Charts types’, ‘Gantt and Milestone chart’, ‘SmartArt and Organization Chart’ give details on the different chart types available in Excel.In the intermediate section, you will learn ‘Get creative with Icons, 3D models, Digital Inking’ details multiple new and improved features that got introduced to enhance the visual presentation. In the end, Chapters ‘Mail Merge using Excel’, ‘Create Custom Excel Template’ and ‘Macros in Excel’ explain the Excel features that help in automating tasks. You will learn how to generate multiple documents automatically with customization, create and use your own templates and use of macros to do repeated task automatically.