Data Analysis using EXCEL
Description:The course on Data Analysis using Excel is designed to provide you with a comprehensive understanding of Excel's data analysis capabilities and equip you with the skills to excel in this field. Whether you come from a technical or non-technical background, this course will guide you through the essential techniques and tools used to extract valuable information from data. Throughout this course, you will explore Excel's robust features for data manipulation, cleaning, and transformation. You will learn how to organize and format data effectively, perform calculations, and use built-in functions to derive insights from complex datasets.
WHO IS THIS PROGRAM FOR?Professionals from MIS / BI or any reporting function, Data Analysis executives.
WHAT WILL YOU LEARN?
- Create, Modify, and Format Pivot Tables
- Use a Macro
- Work with Multiple Worksheets
- Use Summary Functions and Customized Calculations
- Link and Update Pivot Tables
- Exploratory Data Analysis
- Data Formulas & Data Transformation
- Statistical Analysis
- Data Visualization