Home
Blog
All Courses
Pages
Internship
Contact Us
Privacy Policy
➥ Artham Research
Register
Login
✕
Home
All Courses
Internship
Internship- Data Analytics
Internship- Data Analytics
Curriculum
3 Sections
18 Lessons
4 Weeks
Expand all sections
Collapse all sections
Milestone 1
Intro to Data Analytics & Excel Interface Types of Data, Tables, Formatting
6
1.1
Introduction to Analytics
3 Hours
1.2
Text and Logical Functions
3 Hours
1.3
Lookup Functions
3 Hours
1.4
Date and Time Functions Number Formatting
3 Hours
1.5
Pivot Tables and Pivot Charts
3 Hours
1.6
Conditional Formatting and Data Validation
3 Hours
Milestone 2
6
2.1
Sorting, Filtering, and Subtotals Named Ranges
3 Hours
2.2
What-If Analysis
3 Hours
2.3
Charts and Graphs
3 Hours
2.4
Interactive Dashboards Using Form Controls & Charts
3 Hours
2.5
Reporting and Forecasting
3 Hours
2.6
Mini Project
3 Hours
Milestone 3
6
3.1
Intro to Macros
3 Hours
3.2
VBA Editor
3 Hours
3.3
Control Structures
3 Hours
3.4
Automating Reports
3 Hours
3.5
User Form
3 Hours
3.6
Debugging & Error Handling
3 Hours
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content
