APCER – Data Analytics -Oct 2025
By Manvirender
Categories: B2B
About Course
This course is designed to give a practical exposure to one of the most sought after Data skills- Excel and PowerBI. Whether you are a beginner, a budding data enthusiast or someone looking to explore Data Science, this course would train you on exactly what industry is looking for. The course has been created to cater to both : technical or non-technical professionals
Session Plan:
- 6th Oct 2025
- 10th Oct 2025
- 13th Oct 2025
- 17th Oct 2025
Start time: 10:00 am
End time: 01:00 pm
Course Content
Day 1 – Excel (Basics, Personalizing & Presenting Your Work)
-
Knowing excel and its prowess
10:00 -
Walkthrough important excel elements
05:00 -
Essential Keyboard Shortcuts
20:00 -
Quiz-Basics of Excel
-
Cell Basics and referencing: Your Building Blocks
20:00 -
Quiz – Cell Referencing
-
Data types in excel
00:00 -
Vlookup and Data Validation
00:00 -
Quiz-vlookup and data validation
-
Data aggregations, granularity and pivot tables
00:00 -
Conditional Formatting: Highlighting What Matters
55:00 -
Quiz-Pivot Table and Conditional Formatting
