eBook - ePub
Advanced Analytics with Excel 2019
Perform Data Analysis Using Excel's Most Popular Features
Manisha Nigam
This is a test
Partager le livre
- English
- ePUB (adapté aux mobiles)
- Disponible sur iOS et Android
eBook - ePub
Advanced Analytics with Excel 2019
Perform Data Analysis Using Excel's Most Popular Features
Manisha Nigam
DĂ©tails du livre
Table des matiĂšres
Citations
Ă propos de ce livre
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
-
Description
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. 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 for
This book is for professionals from any domain, who are searching for shortcuts & advanced methods to resolve their daily problems. Table of Contents
1. Getting Started with Excel
2. Perform Functions with Shortcut Keys
3. Formulas and Functions
4. Data Visualization with New Chart types
5. Gantt and Milestone Chart
6. SmartArt & Organization Chart
7. Get creative with Icons, 3D models, Digital Inking
8. Putting Data in perspective with Pivots
9. Complex Data Analysis using ToolPak
10. Forecasting in Excel
11. Mail Merge using Excel
12. Create Custom Excel Template
13. Macros in Excel
14. Get help for your problem About the Author
Manisha Nigam is a seasoned management professional with twenty plus years of information technology experience, working with multinationals across the globe. Her expertise in Excel comes from the vast experience she has in using and understanding the software over the years, that helped her in working efficiently and managing complex programs. A certified PMP (PMI â Project Management Professional), CSM (Scrum Alliance â Scrum Master), TOGAF 9.1 (The Open Group â Enterprise Architecture) and holds a post graduate degree in computer science and business management from prestigious universities in India.
Foire aux questions
Comment puis-je résilier mon abonnement ?
Il vous suffit de vous rendre dans la section compte dans paramĂštres et de cliquer sur « RĂ©silier lâabonnement ». Câest aussi simple que cela ! Une fois que vous aurez rĂ©siliĂ© votre abonnement, il restera actif pour le reste de la pĂ©riode pour laquelle vous avez payĂ©. DĂ©couvrez-en plus ici.
Puis-je / comment puis-je télécharger des livres ?
Pour le moment, tous nos livres en format ePub adaptĂ©s aux mobiles peuvent ĂȘtre tĂ©lĂ©chargĂ©s via lâapplication. La plupart de nos PDF sont Ă©galement disponibles en tĂ©lĂ©chargement et les autres seront tĂ©lĂ©chargeables trĂšs prochainement. DĂ©couvrez-en plus ici.
Quelle est la différence entre les formules tarifaires ?
Les deux abonnements vous donnent un accĂšs complet Ă la bibliothĂšque et Ă toutes les fonctionnalitĂ©s de Perlego. Les seules diffĂ©rences sont les tarifs ainsi que la pĂ©riode dâabonnement : avec lâabonnement annuel, vous Ă©conomiserez environ 30 % par rapport Ă 12 mois dâabonnement mensuel.
Quâest-ce que Perlego ?
Nous sommes un service dâabonnement Ă des ouvrages universitaires en ligne, oĂč vous pouvez accĂ©der Ă toute une bibliothĂšque pour un prix infĂ©rieur Ă celui dâun seul livre par mois. Avec plus dâun million de livres sur plus de 1 000 sujets, nous avons ce quâil vous faut ! DĂ©couvrez-en plus ici.
Prenez-vous en charge la synthÚse vocale ?
Recherchez le symbole Ăcouter sur votre prochain livre pour voir si vous pouvez lâĂ©couter. Lâoutil Ăcouter lit le texte Ă haute voix pour vous, en surlignant le passage qui est en cours de lecture. Vous pouvez le mettre sur pause, lâaccĂ©lĂ©rer ou le ralentir. DĂ©couvrez-en plus ici.
Est-ce que Advanced Analytics with Excel 2019 est un PDF/ePUB en ligne ?
Oui, vous pouvez accĂ©der Ă Advanced Analytics with Excel 2019 par Manisha Nigam en format PDF et/ou ePUB ainsi quâĂ dâautres livres populaires dans Informatica et Applicazioni desktop. Nous disposons de plus dâun million dâouvrages Ă dĂ©couvrir dans notre catalogue.
Informations
Sujet
InformaticaSous-sujet
Applicazioni desktop