Advanced analytics with excel 2019 : perform data analysis using excel's most popular features / Manisha Nigam

By:

Nigam, Manisha [author]

Material type: Text

TextPublication details: New Delhi, India : BPB Publications, c2020Description: xviii, 394 pages : illustrations ; 24 cmISBN:

9789389845808

Subject(s):

MICROSOFT EXCEL

LOC classification:

HF 5548.4.M523 .N54 2020

Contents:

1. Getting started with excel -- 2. Perform functions with shortcut keys -- 3. Formulas and functions -- 4. Data Visualization with New Chart types -- 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.

Summary: 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.

Item type:

Books

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Home library	Collection	Call number	Copy number	Status	Date due	Barcode
Books	National University - Manila	LRC - Main General Circulation	Mechanical Engineering	GC HF 5548.4.M523 .N54 2020 (Browse shelf(Opens below))	c.1	Available		NULIB000018933

Browsing LRC - Main shelves, Shelving location: General Circulation, Collection: Mechanical Engineering Close shelf browser (Hides shelf browser)

Previous					No cover image available			Next
Previous	GC GF 51 .I58 2019 vol.5 c.1 Introduction to physical hydrology /	GC GF 51 .I58 2019 vol.5 c.2 Introduction to physical hydrology /	GC HC 79.I55 .B79 2014 The second machine age : work, progress, and prosperity in a time of brilliant technologies /	GC HF 5548.4.M523 .N54 2020 Advanced analytics with excel 2019 : perform data analysis using excel's most popular features /	GC HF 5548.4.M523 .W43 2022 Excel data analysis : the ultimate practical guide to mastering data analysis using excel data and statistical tables, pivot tables and financial analysis tools /	GC K 4164.15 .C63 1995 Code on intact stability : for all types of ships covered by IMO Instruments /	GC NA 2708 .C45 2018 c.2 Design drawing /	Next

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.

There are no comments on this title.

to post a comment.