Détail de l'auteur
Auteur Manisha NIGAM |
Documents disponibles écrits par cet auteur (2)
![](./images/expand_all.gif)
![](./images/collapse_all.gif)
![Tris disponibles](./images/orderby_az.gif)
Advanced Analytics with Excel 2019 : Perform Data Analysis Using Excel’s Most Popular Features / Manisha NIGAM / BPB Publications (2020)
![]()
Titre : Advanced Analytics with Excel 2019 : Perform Data Analysis Using Excel’s Most Popular Features Type de document : e-book Auteurs : Manisha NIGAM Editeur : BPB Publications Année de publication : 2020 ISBN/ISSN/EAN : 9789389845808 Note générale : copyrighted Langues : Anglais (eng) Résumé : 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 visualizationDescriptionBook 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 Contents 1. Getting Started with Excel 2. 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 problemAbout 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. Nombre d'accès : Illimité En ligne : http://library.ez.neoma-bs.fr/login?url=https://www.scholarvox.com/book/88939039 Permalink : https://cataloguelibrary.neoma-bs.fr/index.php?lvl=notice_display&id=564487 Data Analysis with Excel : Tips and tricks to kick start your excel skills / Manisha NIGAM / BPB Publications (2019)
![]()
Titre : Data Analysis with Excel : Tips and tricks to kick start your excel skills Type de document : e-book Auteurs : Manisha NIGAM Editeur : BPB Publications Année de publication : 2019 ISBN/ISSN/EAN : 9789388176675 Note générale : copyrighted Langues : Anglais (eng) Résumé : Simplify the Usage of Excel Features and Functionalities, with the Help of Examples Key FeaturesBasic components of excel, the available menu options and tools, some customizations working with multiple workbooks and worksheets, most frequently used and useful keyboard shortcuts. An initial introduction to what are formulas, functions, and their components. Usage of multiple examples to explain the application in real world scenario. Explaining of different chart types available in Excel and how best it can be used for creating different views of data, good graphics, visualizations for dashboards, and so on. Different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends. Excel features that help in automating tasks. DescriptionBook is written in a lucid manner to explain the concepts in details, with adequate emphasis on examples. The intent of this book is to explain and simplify the usage of Excel features and functionalities, with help of examples. Book will enable users in working efficiently and will increase their workplace productivity. It explains: Functions for calculationsGraphing toolsPivot tablesData analysis toolsMicro programmingAdd-ins that enable core complex operations. What You Will Learn Performing functions with shortcut keys. Formulas and functions Data visualization with new chart types Gantt and Milestone Chart Smart Art and Organization Chart Putting data in perspective with Pivots Complex data analysis using Tool Pak Forecasting in Excel Mail Merge using Excel Macros in Excel What is in Excel 2019Who This Book is For Anyone who wants to learn Excel, do the mundane task easily and quickly, do complex calculations, analysis huge data from internal or external sources, take decisions based on predictions, do forecasting, create plans and charts, monitor dashboards for progress and status, and so on.Table of Contents1. 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 and Organization Chart 7. Putting Data in perspective with Pivots 8. Complex Data Analysis using ToolPak 9. Forecasting in Excel 10. Mail Merge using Excel 11. Macros in Excel. 12. What’s in Excel 2019 About the AuthorManisha 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. LinkedIn Profile: linkedin.com/in/mnigam10 Nombre d'accès : Illimité En ligne : http://library.ez.neoma-bs.fr/login?url=https://www.scholarvox.com/book/88942163 Permalink : https://cataloguelibrary.neoma-bs.fr/index.php?lvl=notice_display&id=574474
![rss](https://cataloguelibrary.neoma-bs.fr/images/rss.png)
-
59 Rue Taittinger, 51100 Reims
-
00 33 (0)3 26 77 46 15
-
Library Campus Reims
-
1 Rue du Maréchal Juin, BP 215
76825 Mont Saint Aignan cedex -
00 33 (0)2 32 82 58 26
-