Advanced Analytics with Excel 2019 Manisha Nigam
(ebook)
(audiobook)
(audiobook)
- Autor:
- Manisha Nigam
- Wydawnictwo:
- BPB Publications
- Ocena:
- Stron:
- 414
- Dostępne formaty:
-
ePubMobi
Zostało Ci
na świąteczne zamówienie
opcje wysyłki »
opcje wysyłki »
Opis
książki
:
Advanced Analytics with Excel 2019
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.
Key Features
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
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.
Szczegóły książki
- ISBN Ebooka:
- 978-93-898-4580-8, 9789389845808
- Data wydania ebooka :
-
2024-12-12
Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna
z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie.
Jeśli masz wątpliwości skontaktuj się z nami sklep@helion.pl.
- Język publikacji:
- 1
- Rozmiar pliku ePub:
- 33MB
- Rozmiar pliku Mobi:
- 33MB
BPB Publications - inne książki
-
Description This book comprehensively covers essential topics ranging from the fundamentals of cybersecurity to advanced hacking concepts, cyber law, malware detection, wireless networking, and strategies for staying secure in the digital world. This book starts with networking and security basics, covering network models, communication protocols,-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Unlock the power of AWS and elevate your cloud expertise with "Mastering AWS for Cloud Professionals." This comprehensive guide illuminates the path to cloud mastery, offering a blend of theoretical knowledge and practical expertise. Dive deep into Amazon Web Services (AWS), exploring its vast potential to revolutionize business operati-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description This book explores how AI, blockchain, and the IoT can work together to build a more sustainable and efficient tech ecosystem. This book breaks down complex concepts, making them accessible to readers of all backgrounds. By focusing on the convergence of these technologies, it reveals how they are shaping a future where autonomous syste-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description This book offers a comprehensive overview of the Mendix platform from a developer's perspective. This powerful technology breaks down barriers, allowing anyone, with or without coding experience, to build custom applications quickly and efficiently with a solid foundation for platform evaluation. Key topics include Mendix's database des-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description This book will cover the entire System Center at the latest release of 2022. Here, we will cover various grounds by not only covering the purpose of each product within the System Center suite but also introducing all the latest features and updates that come with each product. Windows System Center 2022 is a complete toolkit for simpli-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Introducing "Salesforce Automation with Salesforce Flow and Apex", a practical guide designed for anyone wanting to learn Salesforce automation. Whether you are just starting out or looking to build on your existing skills, this book is here to help you navigate the world of Salesforce flow and automation techniques. This book provides-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Adopting AI for Business Transformation offers a comprehensive guide for businesses ready to transition into AI and automation and transform their operations and ways of working. The book focuses on various industries providing practical insights and step-by-step guides for AI adoption and integration. Through real-world examples, exper-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Mastering AWS Elastic Kubernetes Services" is your comprehensive guide to understanding and implementing AWS EKS. This book helps you master Kubernetes, the industry-standard container orchestration platform, on the robust and scalable Amazon Web Services (AWS) cloud. This book is a complete guide to Kubernetes and AWS EKS, starting wit-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description PostgreSQL, a robust and versatile relational database management system (RDBMS), is gaining immense popularity due to its reliability, scalability, and rich feature set. This book is your indispensable companion to mastering PostgreSQL, helping you become a great PostgreSQL developer and create amazing database-driven applications. Thi-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Get answers to frequently asked questions on Data Science and Machine Learning using R Key Features Understand the capabilities of the R programming language Most of the machine learning algorithms and their R implementation covered in depth Answers on conceptual data science concepts are also covered Description This book prepares you for the-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
Dzięki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep@helion.pl
Proszę wybrać ocenę!
Proszę wpisać opinię!
Książka drukowana
Proszę czekać...
Oceny i opinie klientów: Advanced Analytics with Excel 2019 Manisha Nigam (0)
Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.