SalePaperback
Adobe Flash Professional CS6 Training Guide ₹270 ₹243
Save: 10%
Advanced AutoCAD 2018: A Problem-Solving Approach (3D & Advanced) ₹1,199 ₹1,079
Save: 10%
Advanced Analytics with Excel 2019
Publisher:
BPB Publications
| Author:
Manisha Nigam
| Language:
English
| Format:
Paperback
₹699 ₹629
Save: 10%
In stock
Ships within:
1-4 Days
In stock
ISBN:
SKU 9789389845808 Category Computer Engineering/IT Engineering
Category: Computer Engineering/IT Engineering
Page Extent:
446
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.
Rated 0 out of 5
0 reviews
Rated 5 out of 5
0
Rated 4 out of 5
0
Rated 3 out of 5
0
Rated 2 out of 5
0
Rated 1 out of 5
0
Be the first to review “Advanced Analytics with Excel 2019” Cancel reply
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.
About 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.
Rated 0 out of 5
0 reviews
Rated 5 out of 5
0
Rated 4 out of 5
0
Rated 3 out of 5
0
Rated 2 out of 5
0
Rated 1 out of 5
0
Reviews
Clear filtersThere are no reviews yet.
Be the first to review “Advanced Analytics with Excel 2019” Cancel reply
[wt-related-products product_id="test001"]
Related products
RELATED PRODUCTS
8088 AND 8086 MICROPROCESSOR (ADAP), 4TH EDITION
Save: 15%
CAD/CAM: COMPUTER-AIDED DESIGN AND MANUFACTURING
Save: 15%
The 8051 Microcontrollers Embeded Systems 2/Ed
Save: 15%
Reviews
Clear filtersThere are no reviews yet.