APCER – Data Analytics
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:
- 13th Feb 2025
- 17th Feb 2025
- 20th Feb 2025
- 24th Feb 2025
Start time: 10:30 am
End time: 01:30 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
Day 2 – Excel (Data Mastery) & Introduction to Power BI & Data Visualization
Day 3 – Essential Concepts, Calculations and Interactive Dashboards
Day 4 – Power BI Service & Advanced Concepts
Leave us a review
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
It was a great experience. A lot of things were learned which would help me in my workplace. Thank you for explaining in such a detailed way.
This was a very informative course.