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

Par : Manisha Nigam
Offrir maintenant
Ou planifier dans votre panier
Disponible dans votre compte client Decitre ou Furet du Nord dès validation de votre commande. Le format ePub protégé est :
  • Compatible avec une lecture sur My Vivlio (smartphone, tablette, ordinateur)
  • Compatible avec une lecture sur liseuses Vivlio
  • Pour les liseuses autres que Vivlio, vous devez utiliser le logiciel Adobe Digital Edition. Non compatible avec la lecture sur les liseuses Kindle, Remarkable et Sony
  • Non compatible avec un achat hors France métropolitaine
Logo Vivlio, qui est-ce ?

Notre partenaire de plateforme de lecture numérique où vous retrouverez l'ensemble de vos ebooks gratuitement

Pour en savoir plus sur nos ebooks, consultez notre aide en ligne ici
C'est si simple ! Lisez votre ebook avec l'app Vivlio sur votre tablette, mobile ou ordinateur :
Google PlayApp Store
  • FormatePub
  • ISBN978-93-89845-80-8
  • EAN9789389845808
  • Date de parution19/06/2020
  • Protection num.Adobe DRM
  • Infos supplémentairesepub
  • ÉditeurBPB Publications

Résumé

Explore different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends 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. 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. 
Explore different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends 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. 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.