Take a look at our COM054000 books. Shulph carries a great selection of COM054000 books, and we are always adding more.
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.
100% practical guide to understand and use Basic to Advance level Excel 2019 Key Features What’s New in Excel 2019 / Office 365 Putting Data into Excel Transforming and Managing the Data Formulas and Functions Data Analysis techniques Data Visualization techniques Multiple ways of Data Extraction Automation in Excel through Macros Description Excel is, by far, the most preferred spreadsheet program on this planet. People love it because of its simplicity and easy user interface. The primary focus of Excel is to perform basic to advanced level numeric calculations. Every industry, department, job role is dependent on Excel to perform day to day duties as well as data analysis and visualization. Microsoft Excel is available in both offline (Excel 2019) and online (Office 365) versions. If you are new to Excel or use this program day in day out, then this book will surely clear your logics and concepts of excel. This book starts with an introduction to Excel program and an overview of its interface and move towards an explanation of new features being introduced in Excel 2019 and Office 365, then an in-depth discussion on entering and transforming data. Understanding different formulas and functions with practical exercises. Afterwards, how to perform data analysis and present it using different data visualization tools. Finally, extracting data and automation of tasks through Macros. After going through this book, you will become conceptually strong in using various features of Excel. You will increase your productivity by understanding and using the right tool for the related data set. What Will You Learn By the end of the book, you will come across many case studies to put your knowledge to practice and understand many tools to solve real-life business problems such as importing data into Excel from different sources, data cleaning through various tools including flash fill, bringing data together into one place using lookup functionality, analysing it to get insights through pivot tables & what if analysis, generating forecast based on past trends, exporting final reports, understanding Power features like Power Pivot/Query/Map and automating manual processes through Macros . Remember to practice along with sample data files provided in the exercise files bundle of the book to master these techniques. Who This Book Is For This book is for anyone who is either new to Excel or daily Excel user. This book will take you from basic concepts of Excel to Advanced level. Whether you belong to any industry or serving any department, as an Excel user, this book will make you a Pro in Excel. Table of Contents 1. What’s New in Excel 2019/Office 365 2. Entering Data in Excel 3. Transforming and Managing Data 4. Formulas and Functions 5. Data Analysis 6. Data Visualization 7. Data Extraction 8. Automation in Excel through Macros About the Author Lokesh Lalwani, is a Microsoft Certified Office Expert with over a decade of experience in the field of training. He is a seasoned entrepreneur and Co-founder of a renowned corporate training firm - Nurture Tech Academy. He has conducted 1,000 plus corporate workshops on various technologies like Advanced Excel, Business Presentations, Power BI etc. and trained over 12,000 professionals. He is also sharing his knowledge through 5 pre-recorded courses, on above mentioned technologies, over world’s most popular E-learning platforms with an average rating of 4.5/5 from over 15,000 learners. He believes in “life is learning”. His Blog: https://www.nurturetechacademy.in/blog/ His LinkedIn Profile: https://in.linkedin.com/in/lokesh-lalwani-7a6b6b55