دانلود کتاب Advanced Analytics with Excel 2019: Perform Data Analysis Using ExcelÖs Most Popular Features (English Editions) – تجزیه و تحلیل پیشرفته با Excel 2019: انجام تجزیه و تحلیل داده ها با استفاده از محبوب ترین ویژگی های ExcelÖ (نسخه های انگلیسی)

توضیحات

Explore different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends

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.

————————————————————–

ترجمه ماشینی :

روش‌ها و روش‌های مختلف را برای ادغام داده‌ها، تجزیه و تحلیل پیچیده، و پیش‌بینی یا پیش‌بینی بر اساس روندها کاوش کنید ویژگی‌های کلیدی

توضیح

b> کتاب استفاده از ویژگی‌ها و قابلیت‌های اکسل را با کمک مثال‌ها توضیح داده و ساده‌سازی می‌کند. با شروع کار با اکسل و انجام عملکردها با کلیدهای میانبر شروع می شود که به شما در شروع کار با اکسل کمک می کند. سپس Formulas and Functions درک اولیه ای از عملگرها، فرمول ها، توابع و اجزای آنها به دست می دهد. تجسم بیشتر داده ها با انواع نمودارهای جدید، نمودار گانت و مایل استون، SmartArt و نمودار سازمانی جزئیات انواع نمودارهای مختلف موجود در ا