About the Course
In this course, you will learn how to use Microsoft Excel effectively for data summary, presentation, and other statistical work.
Why this Course is Important
In this course, you will learn how to use Microsoft Excel effectively for data summary, presentation, and other statistical work.
Duration
7 Days
Fee
1500/-
Certification
Yes
Skill You learn after Completion
Data Analysis and Visualization Techniques
Excel Sort and Filter
Data Analysis Functions in Excel
Pivot Tables and Charts
Conditional Formatting
Topics to be Covered
MODULE I
Role of Data Management
Data Types
Tabulation and Presentation of Data
Central Tendencies
Scattering of Data
MODULE II
Introduction to Spreadsheets
Excel Essentials
Functions and formulas
Data Analysis
Group, ungroup, and subtotal
Advanced charting and graphing functions
Getting the most out of PivotTable
