Amazon cover image
Image from Amazon.com

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

By: Material type: TextTextPublication details: New Delhi, India : BPB Publications, c2020Description: xviii, 394 pages : illustrations ; 24 cmISBN:
  • 9789389845808
Subject(s): 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.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Home library Collection Call number Copy number Status Date due Barcode
Books 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

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.

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.