Most items will be dispatched the same or the next working day. An apparently unread copy in perfect condition. Dust cover is intact with no nicks or tears. Spine has no signs of creasing. Pages are clean and not marred by notes or folds of any kind. Bestandsnummer des Verk�ufers wbs5372317657

Verk�ufer kontaktieren

Diesen Artikel melden

Bibliografische Details

Titel: Advanced Analytics with Excel 2019: Perform ...

Verlag: BPB Publications

Erscheinungsdatum: 2020

Einband: Softcover

Zustand: Like New

�ber diesen Titel

Inhaltsangabe:

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.

�ber die Autorin bzw. den Autor:

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.

��ber diesen Titel� kann sich auf eine andere Ausgabe dieses Titels beziehen.

Anbieterinformationen

Zur Homepage des Verk�ufers

Unternehmensdaten des Verk�ufers

Revival Books Ltd
Unit 11 Hugh Business Park, Bacup Road, Waterfoot, Rossendale, BB4 7BT, United Kingdom

Gesch�ftsbedingungen:

WeBuyBooks
Hall Carr Mill
Fallbarn Road
Rawtenstall
Lancashire BB4 7NX

Email: Sales@webuybooks.co.uk
Tel: 01706 227207

Company Reg. No. 07693718
VAT Number 901 5786 27

Authorised Representatives: Michael Lane and Damian Carr

Versandinformationen:

Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.

Zahlungsarten
akzeptiert von diesem Verk�ufer

Zu Kaufgesuchen hinzuf�gen

Verwandte Artikel zu Advanced Analytics with Excel 2019: Perform Data Analysis...

Advanced Analytics with Excel 2019: Perform Data Analysis Using Excel� s Most Popular Features (English Editions)

Nigam, Manisha

Gebraucht - Softcover

Unternehmensdaten des Verk�ufers