7019280372 / 9590544567
info@igeekstechnologies.com
Clients
Enquiry
INTERNSHIP APPLY
JOB ORIENTED TRAINING PROGRAM APPLY

Excel is an important skill to have for any job. Excel can be used for a variety of different tasks in the workplace.

It doesn't matter if you work in accounting or finance department or HR department sales and Marketing, Administration, or even the IT department, you must make use of Excel to manage data Management and Data Analysis. You've probably heard of it but it can be frustrating trying to use it but failing to get the outcomes you would like. Our MS Excel training module covers the fundamental topics and equips students with the necessary skills to handle the tasks.
Managers and executives who are already using Microsoft Excel, but now are looking to learn the more advanced options and features of Excel in order to manage their work-related worksheets more effectively.

Rating(4.5/5)

Overview of Adv Excel

Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the max. Rather than focusing on individual Excel functions and features. This hands-on training targets specific business situations, and then demonstrates how to create spreadsheets for these problem areas.

What is the Format of the Program

The Adv Excel & VBA Macros internship is delivered in two learning modes: classroom and online, to cater to your learning preferences while ensuring maximum learning efficacy.

  • Classroom batches:

    Classroom training by expert faculty at our Igeeks centres in Bangalore.

  • Online batches:

    live instructor-led virtual Classes with expert faculty for real-time learning and interaction with batch mates

Class timings for both formats are fixed and you are required to be available for your classes on time.

What Can I Learn From
this Internship?

  • The skills to import data into Excel, prepare it and set up pivot tables to analyses it
  • The knowledge to record macros and create icons on the toolbars to run them
  • Understanding of how to locate errors in formulas and evaluate them
  • The ability to use analysis tools to forecast figures based on a range of scenarios
  • Ensure important data is highlighted by summarizing large workbooks and sorting data into key elements
  • Useful practical exercises

Internship Certificate

Internship certificates are given to those interns who have completed the training and project work at a company. With the help of this certificate, they can prove their skills, talent and worth for the position.Once the students are done with their education and they are ready to take a job, this certificate becomes a key document for them.

Concepts covered in Adv Excel & VBA Macros internship

Program Fundamentals
Getting Started with Worksheets
Working with Data Ranges
functionsOverview
Formulas and Functions
VLOOKUP, HLOOKUP
Date & Time and More Functions, Name Ranges
Working with the Web and External Data
Working with Tables and Pivot Tables
Creating and Working with Charts
Excel Shortcuts
Recording and Using Macros

Learn how to automate your work in Microsoft Excel with Visual Basic for Applications.

Visual Basic for Applications (VBA) is a scripting language developed by Microsoft which allows the development of user-defined functions and the automation of certain processes and calculations. VBA is built into most Microsoft Office applications to extend their functionality. It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.

Rating(4.5/5)

Overview of Excel VBA Macro

VBA is a Programming Language for Windows Application used to automate several areas of reporting and modeling work using MS-Excel Application. VBA is also used to Automate the Routine functions performed using MS-Excel Application.

VBA is "Visual Basic for Application". It is a very powerful programming language that allows users to program macros to accomplish complex tasks within an application like Excel. With VBA for Excel you can develop small procedures (macros) that will make your professional life easier and allow you to do more in less time.

Using VBA you can accomplish a very complex tasks in excel within very few minute. VBA is very useful for client oriented work, for accountants, productions planners, production supervisors, sales people, financial analysts and other business data analysts. Complex analysis of data can be completed easily without any manual error in very less time.

What is the Format of the Program

The Adv Excel & VBA Macros internship is delivered in two learning modes: classroom and online, to cater to your learning preferences while ensuring maximum learning efficacy.

  • Classroom batches:

    Classroom training by expert faculty at our Igeeks centres in Bangalore.

  • Online batches:

    live instructor-led virtual Classes with expert faculty for real-time learning and interaction with batch mates

Class timings for both formats are fixed and you are required to be available for your classes on time.

What Can I Learn From
this Internship?

  • Create repetitive reports, dashboards or slides and looking for ways to automate
  • Learn VBA to understand and use Excel better
  • Learn to use Excel for more powerful & demanding tasks
  • Create user forms to accept or display data, validate the data entry in user forms.
  • Create Charts and Pivot Table

Concepts covered in VBA Macros internship

Introduction to Visual Basic for Applications
Basics of Excel (VBA)
Developing Macros in VBE
Excel Macro Recorder
Testing Macros in VBE
Modifying Macros in VBE
Coding Basics
Working with Application, Workbook, and worksheet
Playing around the Worksheet
Working with Classes & Objects
Error Handling in Excel
Working with Statement / Loops / Functions
Working with Database using SQL
Working with Windows and other Microsoft Programs
Forms (User Forms) in VBA for Excel
Events in VBA Code for Controls

Project Titles

To improve your practical exposure to the subject we also provide you with projects to work on VBA

Data Entry Userform in Excel Workbook using VBA

Data Entry Userform in Excel Workbook using VBA is used to enter data using userform and update data in the Excel database.

Append data from multiple Worksheets into a single sheet By Column using VBA

VBA to Append the data in multiple Worksheets to a newly created Worksheet in the same workbook at the end of the column.

SQL is useful for creating and querying relational databases.

Get Started to become a hands-on expert on Advanced SQL! We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.

Rating(4.5/5)

Overview of SQL

SQL is the standard programming language used to design, create and manage relational databases. Relational systems are made up of a set of tables containing rows and columns of data. Each column in a table represents a category of data, such as a customer name or address, and each row contains a data value for the intersecting column.

Functions of SQL include

What is the Format of the Program

The Adv SQL internship is delivered in two learning modes: classroom and online, to cater to your learning preferences while ensuring maximum learning efficacy.

  • Classroom batches:

    Classroom training by expert faculty at our Igeeks centres in Bangalore.

  • Online batches:

    live instructor-led virtual Classes with expert faculty for real-time learning and interaction with batch mates

Class timings for both formats are fixed and you are required to be available for your classes on time.

What Can I Learn From
this Internship?

  • This SQL Internship is designed for anyone planning to work with databases, especially in the roles of system administrators and application developers.
  • To learn the basic SQL commands, including SELECT, INSERT INTO, UPDATE, DELETE FROM, and more. Each SQL command comes with clear and concise examples.

Concepts covered in SQL internship

SQL
Categories of SQL Statements
The CREATE Statement
The DROP Command
The ALTER Command
DML Statements
The SELECT Statement
The INSERT Statement
Transaction Control
Working with character functions
SQL Operators
SQL FUNCTIONS
Joining Tables
Groups

Project Titles

To improve your practical exposure to the subject we also provide you with projects to work on Excel & VBA

Online Phone Shop Display

To create an online phone shop, we need to store some data and then retrieve it when the user clicks on details. In this project, we will first add and then retrieve the data.

Book Store Inventory Management

This is an exciting and easy project where a user can check all the books online. They can also order a book online, in which case the inventory will get updated, and the book count will reduce.

Student Registration for an Online Portal

In this simple project, we will get the student details and insert them into the database. A unique student roll number (student_id) will be generated once the registration is complete.

Choose Your Pricing Plan

Our courses are provided at the best rates in the industry across various plans that fit perfectly in your budget and offer you the best of services.

Mentor-Led
1 month Internship

5000

  • Internship Offer Letter
  • 1 Project Assistance.
  • Project Report Materials.
  • Internship Certificate on successful project completion
  • 1 month
  • 20 + hours of Mentorship
Proceed

Mentor-Led
2 month Internship

12000

  • Internship Offer Letter
  • Course Completion Certificate
  • 2 projects Assistance.
  • Internship Certificate on successful project completion
  • Final Year Project Assistance.
  • 2 months.
  • 40 + hours of Mentorship.
Proceed

Mentor-Led
3 month Internship

24000

  • In depth course.
  • Internship Offer Letter.
  • Course Completion Certificate
  • 5 projects Assistance.
  • Internship Certificate on successful project completion
  • Resume and Interview Preparation Assistance
  • 100% Placement Assistance
  • 3 months.
  • 80 + hours of Mentorship.
Proceed

Hear From Our Success Stories

igeeks_quot.png

Teaching is good for interns mostly practically knowledge provide .....Nice atmosphere.....friendly staff......i joined python(data science &ml domain internship..... Best Place for internship in Bangalore.

igeeks_user_icon.jpg
paviksha yadla
igeeks_quot.png

A very nice place to do internships. The faculty are well trained and have 20+ years of IT Experience. Training is very good and they guide you well with the projects.

igeeks_user_icon.jpg
Likhith M
igeeks_quot.png

Good Teaching. They were really kind and also has an environment that helps you to target your career growth. I learnt lot of things from them. Igeeks team was very helpful

igeeks_user_icon.jpg
Sheryl Austin
igeeks_quot.png

Best place to get your internship done, they were really kind and knowledge full, Innovative and Interactive Learning environment that helps you to target your career growth. I learnt lot of things from them. Igeeks team really work hard towards progress of the intern.

igeeks_user_icon.jpg
Sanjay Kousal
igeeks_quot.png

I completed my internship on Data Science, Machine Learning with Python and it was amazing experience with igeeks. Trainers are very talented and helps us to grow more. I learned a lot of things from this internship, hope it will definitely …

igeeks_user_icon.jpg
Mitra D
igeeks_quot.png

It was very useful experience. I'm very glad to have this experience with igeeks technology. I learnt something about new by gaining knowledge. Thank for this opportunity

igeeks_user_icon.jpg
Nisarga V S
igeeks_quot.png

The ANDROID internship which I undertook in this igeeks technologies was so helpful and they thought me in a very easy way and classes was very easy to understand and it was very helpful to gain good knowledge in Android and also like to personally thanks to my mentor Mr. Sharath who given the guidance for me..

igeeks_user_icon.jpg
Chaitanya Karumudi
igeeks_quot.png

I did my Internship and Project on Machine Learning with Python here. I learnt Python and Machine Learning & Data Science from Somasekara sir. He taught me the concepts in depth. And the staffs here were too friendly. I would suggest college students to do their internship or projects in IGEEKS Technologies, Bangalore.

igeeks_user_icon.jpg
Snehapriya Sahitya
igeeks_quot.png

I am Sravanthi from MSRIT, really thank full to Igeeks Technologies for giving me opportunity to do internship in your company and we had enjoyed our internship by doing project on Machine Learning with Python and I am thank full to my mentor Mr.Somasekhar Sir and HR Team members for completing our internship successfully.

igeeks_user_icon.jpg
Sravanthi msrit
igeeks_quot.png

It was good learning experience and staffs were helping in all perspectives

igeeks_user_icon.jpg
Priyadharshini Mi
igeeks_quot.png

It was very good.thank you IGEEKS staff.

igeeks_user_icon.jpg
nanda kishore
igeeks_quot.png

I did my internship on IOT domain.I got an excellent teaching guide.its nice to do internship here, Also i gained knowledge about projects.Very good company for doing internship. The Internship which was conducted by igeeks was really awesome and worthful. I am suggesting the juniors to do the internship at igeeks, Bangalore, to learn the IoT and to gain the hands on experience.

igeeks_user_icon.jpg
gopal nanda
softexter facebook
info@igeekstechnologies.com   |   +917019280372

Quick Links

Our Services

Contact

JAYANAGAR OFFICE:

#65, ‘Bhagyadeep’, 8th 'B' Main, 27th Cross,Jayanagar 3rd Block (Next to Pizza Hut),Bangalore 560011.

Phone No: 7019280372

Site Powered & Promoted By Softexer Pvt. Ltd.

Internship Program in India,Internship program in India for engineering Students,iot-internship-in-india,top-trending Internship courses,machine-learning-internship-in-india,robotics-internship-in-india,summer internship,winter internships,internship-for-mba-students,internship-for-bba-students,internship-for-mca-students,internship-for-bca-students,Content Writing Internship,Digital Marketing Internship,Electronics Internship,online internship with certificate,Summer Internship 2021,Online Internship,Internship in vijaynagar,Banglore,Internship in Bangalore,Summer Internship,Internship 2021,Internship for ECE/CSE/M.TEch/B.Tech,internship for mca,paid internships in bangalore,internship in pune for computer engineering students,internship for mtech,internship for m tech students,internships for mtech students,m tech internship,internship in bangalore,internships in bangalore,mtech internship,m tech internships,internship for mtech students,mtech internship,internship for m.tech,internships in hyderabad for cse students,internships for m.tech students,vlsi companies in bangalore,embedded companies in pune,m tech projects,mca internship,summer training for mechanical engineering students,internships for engineering students in bangalore,internship for mechanical engineering,summer internship in bangalore,internship for mca students in bangalore,internship for mca,paid internships in bangalore,internship in pune for computer engineering students,internship in vlsi,internship bangalore,internship in india for engineering students,internship in bangalore for engineering students,m tech in delhi,Internship for ECE/CSE/M.TEch/B.Tech, Internship program , MCA students internship in Bangalore,VTU INTERNSHIP,PYTHON INTERNSHIP,BE internship in bangalore,VTU Internship for Electrical Students,Internships in Bagalkot,Summer Training Internship,Ai Internship Online,Internship for Engineering students. Internships in Bangalore for M.tech, B.Tech, BE, MCA CSE, ECE students, best summer internship in Bangalore, Internship opportunities in Bangalore for Engineering and computer science student,Internships in Bangalore, Internship in Bangalore, internship bangalore, Internship at Bangalore,internships in bangalore for ece students, internships in bangalore for cse students, internship in bangalore for computer science students,Internship for ece, students,internship for be final year students in Bangalore,internship for electronics & communication engineering students, internship on latest technologies and domains, internship 2021, best internship program, internship near your place,INTERNSHIP IN BANGALORE,Internship in Bangalore for BE CSE Students,Internship for CSE,Internship for IT,Internship for ECE,Internship for EEE, Internship for MECH,Machine Learning Internship,Artificial Intelligence Internship,Data Science Internship,Python Internship,Internship for Civil,internship for EIE,internship for ICE,Internship for EEE,Internship for MECH,Internship for BE Final Year CS | IS Students in Bangalore,VTU INTERNSHIP PROGRAMS IN BANGALORE,FINAL YEAR INTERNSHIP,Internships in Belgaum,Intenship in Manipal,Internship in Tumkur,Internship in Hubballi,Internship in Dharwad,Internship in Bagalkot,Internship in Davangere,Inernship in Gulbarga,Internship in Chickballapur,Internship in Bellary,Internship in Ramanagara,Internship in Bijapur,internship in Hassan,Internship in Kolar,Internship in Chitradurga,Internship in Puttur,Internship in Ranebennur,Internship in Mandya,Internship in Bhatkal,Internship in Gadag,Internship in Bhalki,Internship in Tiptur.