Excel Automation Internship – 12th December Batch

This Internship training leverages advanced Microsoft Excel skills in Data Analysis, Excel Data Visualization with Excel Pivot Tables, Excel Pivot Charts, Interactive Excel Dashboards, and automation in Excel using VBA Macros to work on real industry challenges.
Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this internship will position you ahead of others. This internship will guide you right from basics to master some of the most advanced features in Excel.
Who this Internship is for:
- If you are looking to improve your Microsoft Excel Skills
- If you want to learn how to create Excel Charts, Formulas and Functions and Excel Shortcuts
- If you want to learn the foundation of how to create Excel Dynamic Dashboards
- If you want to learn how to develop excel data automation using Macros
- Anyone who wants to learn Excel.Note: Your internship will be begun on the 12th Of Dec, kindly login and check the details for your live introductory meeting link in your live introductory curriculum session ( only after successful registration )
Internship Features
- Lectures 29
- Quizzes 7
- Duration 18 hours
- Skill level Beginner
- Language English
- Students 446
- Assessments Yes
-
Training Week- 1
- EA Live Introductory Session Details
- EA 1) Introduction
- EA Quiz 1: Introduction to Excel
- EA 2) Understanding Formulas in Excel
- EA Quiz 2: Understanding Formulas in Excel
- EA 3) Understanding Pivot Tables, Charts and Graphs
- EA Quiz 3: Understanding Pivot Tables, Charts and Graphs
- EA Assignment 1: Data Visualization
- EA 4) Conditional Formatting, Lookup, VLookup
- EA Quiz 4: Conditional Formatting, Lookup, VLookup
- EA 5) Data Validation, Text to columns, Concatenation
- EA Quiz 5: Data Validation, Text to columns, Concatenation
- EA 6) Understanding Functions in Excel
- EA Quiz 6: Understanding Functions in Excel
-
Training Week- 2
- EA 7) Combination of Logical functions and Conditional formatting
- EA Quiz 7: Combination of Logical functions and Conditional formatting
- EA 8) Developing Dashboard with Excel
- EA Assignment 2: Development of Dashboard on Excel
- EA 9) Introduction to Macros in Excel
- EA 10) Macro Recording
- EA Assignment 3: Automation Using Macros
- EA 11) Filter Records using Macros
-
Training Week- 3
-
Internship Week- 1
Your Internship Project is divided in ten steps. Understand the problem well and then work your way through the steps.
-
Internship Week- 2
Follow the process of Project Submission to ensure on-time and correct submission