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. 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:
- 28th Nov 2024
- 2nd Dec 2024
- 5th Dec 2024
- 9th Dec 2024
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
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
No Review Yet