COM081000 books

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.

Practical guidance to Implement AGILE, KANBAN, XP and SCRUM with 600+ Expert Solutions included Key Features -Supportive materials for PMI-ACP and SAFe exam preparation. -Proven use-cases on implementation of Kanban, Agile and Scrum across business projects. -600+ interview questions, quizzes and business solutions to acquire lucrative Agile project management jobs. Description This book is a pragmatic guidance teaching modern IT professionals how to improvise and scale up IT delivery capabilities using leading project management methodologies including Agile and Kanban. It is equipped with use-cases and hundreds of solutions and the readers will learn to examine the strength of their project management function and how to improvise it. The book brings exclusive knowledge on several strategies to put into implementation in the event of natural disaster like Covid-19 and for future crisis management. You will be acquainted with the popular tools and technologies that your organization can make use of it for better collaboration on projects. You will learn the various project performance metrics for each of these project management methodologies. As an added advantage of this book, you can get yourself ready for one of the popular and critical professional examinations like PMP-ACP and SAFe. What you will learn -Gain strong hold on concepts of KANBAN, XP, FDD, DSDM, SCRUMBAN and SCRUM. -Exclusive coverage on strategies to beat Covid-19 Pandemic and future crisis management.. -Learn to build Organizational Resilience and enterprise maturity model.. -Ready guidance to prepare for PMI-ACP and SAFe certification.. -Tricky Real-world Agile SCRUM & KANBAN Case Studies, Demos and tools. Who this book is for This book is for Scrum Masters, Product Owners, Developers, CXOs and professionals closely associated with Agile Scrum, Kanban, XP projects to further improve their knowledge of Agile with valuable pragmatic insights. Experienced-level professionals and Agile enthusiasts having relevant experience can also acquire an in-depth knowledge of the advanced concepts in project management. Table of Contents 1. Key success factors for adopting Agile SCRUM Kanban in any organizations 2. Why Personal Agility matters 3. Tricky Real-world Agile SCRUM & KANBAN Case Studies, Demos and tools 4. Agile SCRUM KANBAN Maturity assessment Nuts & Bolts 5. Useful Tips & techniques for successful Agile transformation in any Organization and The Art of Agile Development 6. Common Agile SCRUM KANBAN misconceptions 7. Key Takeaways 8. Glossary 9. Quiz Session 10. Test your Knowledge About the Authors Sudipta Malakar is an accomplished SAP Agile Practice Area Head, Certified IT Sr. Program Manager, Agile Coach – Advanced level, Harvard Business School, USA alumnus with more than seventeen years of experience in directing SAP DEV teams in supporting many major Global fortune 500 clients in multiple large accounts. He is Certified Sr. Program Manager (MSP Practitioner), Sr. Project Manager (PRINCE2 Practitioner), PMP®, PARP®, CSP®, ICP-ACC®, ITIL(F), Certified Agile Leader(CDL), CLMM, CMM, Advanced Certified Scrum Master(A-CSM) ®, CSPO®, CSM®, KMP2, KMP1, TKP®, ISO 9001 Lead Auditor, Lean Six Sigma Master Black Belt, CMMi (Expert). He worked in various IT companies like IBM, Wipro, Satyam, Tech Mahindra, Patni, Syntel and played very crucial Sr. Management / Agile Coach role in various global clients like Sterlite, Lufthansa, Nestle, PMI, Suncor, IPA, Canadian Pacific railways, Sony, Volvo, Allstate, BOC Linde etc. LinkedIn: https://www.linkedin.com/in/sudipta-malakar-csp-klmm-cdl-kmm-cspo-kmp-a-csm-icp-acc-tkp-3a794213a/

A pragmatic guide that will teach you to implement Agile, SCRUM and Kanban in your organization. Key Features Expert-guided techniques for successful Agile transformation in your organization. Solution-focused responses on interview questions of Agile SCRUM, XP, DSDM, KANBAN and SCRUMBAN. Reference guide to prepare for leading PMI-ACP and SAFe Certification exam. Description This book is for businesses that aspire to improve agility, deliver fit-for-purpose products and services, delight customers, and provide the security of long-term survival associated with mature businesses that consistently meet or exceed customer expectations. Learn a lean approach by seeing how Kanban made a difference in four real-world situations. You'll explore how different teams used Kanban to make paradigm-changing improvements in software development. These teams were struggling with overwork, unclear priorities, and a lack of direction. As you discover what worked for them, you'll understand how to make significant changes in real-life situations. The Artefact has been developed as a resource to understand, evaluate, and use Agile and Hybrid Agile approaches. This practice guide will help you understand when, where, and how to apply Agile approaches and provides practical tools for practitioners and organizations wanting to increase agility. What you will learn Explore and learn how to build Organizational Resilience and Enterprise Maturity Model. Step-by-step solutions to implement Portfolio Kanban and Upstream Kanban. Deep dive into Agile SHIFT framework and Hybrid Agile framework. Exciting case studies and practical demonstrations on Agile SCRUM & KANBAN. Expert-ready guidance on overcoming common Agile project management misconceptions. Who this book is for This book is appealing to decision makers, product owners, project team members who can make use of this guide in improvising the productivity and efficient management of business operations without much of hassle. Table of Contents 1. Key success factors for adopting Agile SCRUM Kanban in any organization 2. Lessons learnt and pragmatic approach – Agile Scrum Kanban 3. Tricky real-world Agile SCRUM & KANBAN case studies, demos and tools 4. Agile SCRUM KANBAN Maturity assessment Nuts & Bolts 5. Useful tips & techniques for successful Agile transformation in any organization and the art of Agile development 6. Use of Agile for students and parents 7. Common Agile SCRUM KANBAN misconceptions 8. Key takeaways 9. Interview questions and answers on Agile SCRUM KANBAN 10. Glossary 11. Quiz session 12. Test your knowledge About the Authors Sudipta Malakar is an accomplished SAP practice area head, Certified IT Sr. program manager, Agile coach – Advanced level, Harvard Business School, USA, alumnus, patent holder, and an International bestselling author & speaker with more than 17 years of experience in directing SAP DEV teams in supporting many major Global fortune 500 clients in multiple large accounts. He is a certified sr. program manager (MSP practitioner), a sr. project manager (PRINCE2 Practitioner), PMP®, CSP®, ITIL(F), a certified Agile Leader(CDL), CLMM, CMM, and an advanced certified Scrum Master (A-CSM) ®, CSPO®, CSM®, KMP2, KMP1, ICP-ACC®, TKP®, ISO 9001 Lead Auditor, Lean Six Sigma Master Black Belt, CMMi (Expert). He worked in various IT companies like IBM, Wipro, Satyam, Tech Mahindra, Patni, and Syntel, and he played a crucial sr. management/Agile coach role for various global clients like Sterlite, Lufthansa, Nestle, PMI, Suncor, IPA, Canadian Pacific railways, Sony, Volvo, Allstate, and BOC Linde. LinkedIn Profile: https://www.linkedin.com/in/sudipta-malakar-csp-klmm-cdl-kmm-cspo-kmp-a-csm-icp-acc-tkp-3a794213a/