(Ebook) Advanced Analytics With Excel 2019: Perform Data Analysis Using Excel’s Most Popular Features by Manisha Nigam ISBN 9789389845808, 9389845807
Explore different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trendsÊKEY FEATURESÊ_ Ê Ê Use the Analysis ToolPak to perform complex Data analysis_ Ê Ê Get well versed with the formulas, functions, and components in 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 Charts types for Data visualizationÊÊDESCRIPTIONBook 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.And at last Chapter ÔGet help for your problemÕ lists few problem statements and their probable solutions with references to the Excel feature or functionality that can be used to resolve the problem.ÊÊÊWHAT WILL YOU LEARN_ Ê Ê Get familiar with the most used advanced Excel formulas and functions for Data analysis_ Ê Ê Learn how to create a Gantt / Timeline / Milestone Chart in Excel_ Ê Ê Use charts for Better Data visualization_ Ê Ê Build organization charts with SmartArt tools in Excel_ Ê Ê Use the Analysis ToolPak & Power Pivots to perform complex Data analysis_ Ê Ê Learn how to link and share workbooks for automatic updatesÊÊWHO THIS BOOK IS FORThis book is for professionals from any domain, who are searching for shortcuts & advanced methods to resolve their daily problems.ÊÊTable of Contents1.Ê Ê Ê Getting Started with Excel2.Ê Ê Ê Perform Functions with Shortcut Keys3.Ê Ê Ê Formulas and Functions4.Ê Ê Ê Data Visualization with New Chart types5.Ê Ê Ê Gantt and Milestone Chart6.Ê Ê Ê SmartArt & Organization Chart7.Ê Ê Get creative with Icons, 3D models, Digital Inking8.Ê Ê Ê Putting Data in perspective with Pivots9.Ê Ê Ê Complex Data Analysis using ToolPak10.Ê Forecasting in Excel11.Ê Mail Merge using Excel12.Ê Create Custom Excel Template13.Ê Macros in Excel14.Ê Get help for your problemISBN : 9789389845808
*Free conversion of into popular formats such as PDF, DOCX, DOC, AZW, EPUB, and MOBI after payment.
