Nigam M. Advanced Analytics with Excel 2019: Perform Data Analysis Using Excel’s Most Popular Features

BPB Publications, 2020. - 412p. - ISBN: 978-9389845808.Explore different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends.Key FeaturesUse the Analysis ToolPak to perform complex Data analysis.
Get well versed in the formulas, functions, and components of Excel.
Handy templates to give you a head start.
Usage of multiple examples to explain the application in a real-world scenario.
Implement macros for your everyday tasks that will help you save your time.
Explore different Chart types for Data visualization.DescriptionThe book explains and simplifies 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, and their components. Further ‘Data Visualization with new Charts types’, ‘Gantt and Milestone chart’, and ‘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 were 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 templates, and use macros to do repeated tasks automatically.And lastly Chapter ‘Get help for your problem’ lists a few problem statements and their probable solutions with references to the Excel feature or functionality that can be used to resolve the problem.