Advance Excel With AI and Data Analytics
Course Details
Course
ADXLAI
Class Type
Webinar
Duration
6 Weeks
Lead Instructor
Name
Basant Kumar
Professional
HDSE (2000)
Experience
25+ Years
Webinar Details
Language
Hindi & English
Class Time
19:00 (IST)
Platform
Zoom
Course Modules
Module 1
Basic Excel
Module 2
Advace Excel
Module 3
AI Intergation

Masterclass in Advance Excel and Data Analytics

AI in Excel refers to the integration of learning capabilities of artificial intelligence to enhance spreadsheet functionality, task automation, and provide data driven acumen. This includes features like formula generation, data analysis, and predictive modeling.

Basic Excel
Duration
1 Week
Fees
Rs. 1200 11/-
Support
1 Week
Recordings
No
eBooks
No
Extra days
No
Certificate
No
Dashboard
No
Advance Excel
Duration
4 Week
Fees
Rs. 2500 /-
Support
6 Months
Recordings
Yes
eBooks
Yes
Extra days
6 days
Certificate
Yes
Dashboard
Yes
Adv. Excel with AI
Duration
6 Week
Fees
Rs. 4000 /-
Support
1 Year
Recordings
Yes
eBooks
Yes
Extra days
10 days
Certificate
Yes
Dashboard
Yes
Data Analytics with Excel
Duration
9 Week
Fees
Rs. 7000 /-
Support
1 Year
Recordings
Yes
eBooks
Yes
Extra days
10 days
Certificate
Yes
Dashboard
Yes

# Admission for Data Analytics with Excel is based on the merit list of final assessment of Advance Excel with AI.

 

Limited Time Offer

The regular price of online courses has been reduced upto 60% of course fees.

 

Excel - Masterclass Modules And Topics

Excel Basic
  • Introduction to excel
  • Creating and saving excel
  • Formatting excel sheets
  • Working with table
  • Creating marksheet
  • Inserting shapes & images
  • Arithmetic function
  • Logical function
  • Salary sheet
  • Text function
  • Date and Time function
  • Sorting data
  • Filter data
  • Lookup function
  • Payslip
  • Insert charts
  • Conditional formatting
  • Data validation
  • Header and footers
  • Printing sheets
Advance Excel
  • Information function
  • Nested if
  • Income tax calculation
  • Statistical function
  • Financial function
  • EMI Calculation
  • Pivot tables and charts
  • Statistical function
  • Lookup function
  • Payslip
  • Conditional formatting
  • Data validation
  • Page Setup
  • Dynamic charts
  • Invoice / Bill
  • Xlookup
  • Index and Match
  • Error Handling
  • Data Cleaning
  • Nesting formulas
Adv. Excel With AI
  • Working with macros
  • Dynamic charts
  • Smart Objects
  • Working With VBA
  • Dashboard 1
  • Dashboard 2
  • Dashboard 3
  • Understanding AI Tools
  • Understanding prompts
  • Integrating AI in Excel
  • Writing prompts
  • Prompts for formule
  • Prompts for charts
  • Prompt for Sort & Filter
  • Conditional Lookup
  • Prompts for Pivot
  • Prompts for Dashboard
  • Prompts for Dashboard
  • Testing your skill
  • Assingment
 

Limited Time Offer

The regular price of online courses has been reduced upto 60% of course fees.

 

How to Enroll and Join Online classes?

Enrollment Process
  • Click on the "Enroll Now" Button
  • Fill in the details in the enrolment form.
  • Select the course from the list.
  • Click on the “Register Now” button.
  • Take a screenshot of the registration details.
  • Join the WhatsApp Group.
  • Payment links will be available in the webinar only.
  • Please send the following images via email after payment:-
  • Registration Details Screenshot.
  • Successful Payment Screenshot.
  • You will receive the following information in the email:-
  • Dashboard joining link.
  • Dashboard Username & Password.
  • Complete your dashboard profile.
  • uploat Current Photo
  • Upload Aadhar Card.
  • Upload Highest Qualification Certificate.
Joining Live Classes
    Link in WhatsApp:-
  • Zoom Meeting Link
  • Assingment Worksheet
  • Dialy Practice work sheet
  • All Other information
    Pre-requiremnt:-
  • How to Operate Computer
  • Operating Windows & MAC OS
    Software and Hardware Require:-
  • WhatsApp App
  • Zoom Meeting App
  • Excel / Sheet
  • PC / Labtop / Tablet / Mobile
  • Stable internet connection
    Inquiry, Support and Query:-
  • Send your query on query_email only.
  • Send other Inquiry on support email.
  • Wait for 24 working hour for respounce.
  • Contact only on official numbers & emails.
  • Do not spam in email inbox.
Getting Course Material
    Link in Email:
  • Membership information
  • Dashboard login information
  • Members WhatsApp Group Link
  • Complite after first login:
  • Change your password.
  • Complete your dashboard profile.
  • upload Current Photo
  • Upload Aadhar Card.
  • Upload Highest Qualification Certificate.
  • Available in Dashboard:
  • Recorded video lectures.
  • Course eBook.
  • Lab Manual eBook.
  • Certificate Provided after:
  • Complete all assignment.
  • Complete all assessment.
  • Complete Project (If Any).
  • Download your Certificate.
  • Get Support in Community.
 

Limited Time Offer

The regular price of online courses has been reduced upto 60% of course fees.

 

About Us?

Know your Mentor.
Basant Kumar
Basant Kumar is an experience mentor in Software Developer, Database Administrator, Web Developer and Hardware Engineer. He works as Software Development from 2001, Database Administrator since 2007, Web Developer from 2010.
He complicated his Graduate and Masters from Commerce Department, Allahabad University, Professional education from Aptech Allahabad and schooling from Kendriya Vidyalaya, Pune, Maharastra. He is student of MCA & B.Com in AU. He studies Higher Diploma in Software Engineering (HDSE). Database Management, Web Design and Development, and Hardware and Networking from NSIC Okhla Delhi.
Throughout his college years and before completing his professional education he joined institute for part-time teaching since 1997 in field of computers software. He is now enjoying his life in New Delhi since 2003. In addition to software development, building websites, he also works to improve online courses and open education through simple, usable design.
    Software Knowledge:-
  • Programming : R, C++, PHP, Java, Python, Visual Studio, Dot.Net.
  • Software : Microsoft Excel, word, PowerPoint, Photoshop, CorelDRAW
  • Data Analysis : Power BI, VBA, Tableau.
  • Accounting : Tally, Marg.
  • Database : SQL, MySQL, Oracle with D2K, Microsoft Access.
  • Website : HTML, CSS, JavaScript, React, Angular, Jscript, Bootstrap.
    Mentor for following course :-
  • Artificial Intelligence
  • Data Analysis
  • Advance Excel and AI
  • Software Development
  • Website development
  • Graphic Designing
  • Accounts Assistance
Know your Institute.
ACADEMY
Artificial
Intelligence
And Computer
Technology
AICT
Since 2012 after establishment “SHINE Computer and Technology Institute (SCTI)” as a training center in affiliation with Indira Gandhi Computer Saksharta Mission (IGCSM) and MARG ERP. And also from 2016 to 2019 we had collaboration with Annamalai University to train their students in different Diploma and Graduation courses. In 2017 we merge with “Artificial Intelligence and Computer Technology (AICT)” in as single entity named “Artificial intelligence and Computer Technology (AICT).
We Completed many projects with Government of India, such as Pradhan Mantri Kaushal Vikas Yojana, Pradhan Mantri Youth Training Program, Skill India Mission, Digital India Mission, NDLM, till now we trained more than 1500 accountants with MARG Academy, and more than 7000 skilled youth under various government projects, and Office Assistants with IGCSM more than 9000 trainees in different diploma courses such as Tally, Accountants, DIT, ADCA, Web designers, Programmes.
Certification Validation : Certificates are valid in India and Word wide in Government sector as well as Private sector.
    Registration and Affiliations with :-
  • ISO 9001:2015 Certificate since 2015
  • Govt. of NCT Delhi Since 2016
  • Indira Gandhi Computer Saksharta Mission (IGCSM) since 2013
  • MARG ERP Academy Since 2017
  • MSME Delhi Since 2017
  • SoftDot for Government projects Since 2016 to 2020
  • Annamalai University From 2016 to 2019
Course offered in various catogeries :-
  • Artificial Intelligence
  • Advance Excel and AI
  • Database Administrator (SQL)
  • Software Development
  • Website development
  • Diploma Courses
  • DIT, ADCA, ADWD, ADSD.
  • Data Analysis
  • SEO
  • Digital Marketing
  • Graphic Designing
  • Accounts Assistance
  • Office Assistant
  • Basic, Tally, Python
 

Limited Time Offer

The regular price of online courses has been reduced upto 60% of course fees.

 

Testimonials

3000+ Satisfied Students in Advance Excel

"The course has been a game changer as the ability to automate was something I longed for in order to be more effective as a professional. This course is the complete package for skilling up."

Jay Prakash Roy
DIT

"The skill I have developed have given me the confidence to tackle advanced problems in an investment and banking environment. The tutorials are practical, to the point and are relevant to professionals."

Mohit Kumar
Adv Excel

"I was a complete beginner in Excel, but this course made me an expert. The instructor explains complex concepts in a simple ad understandable way. I learned a lot from this course."

Jaya Pandey
eAccounting

"I applied many of the skill I learnt through your Excel course to automate many aspects of my work and it has been a huge help. My next step is to improve my VBA skills!"

Ramveer Singh
ADCA

"This course was a revelation. The instructor was knowledgeable and the content was well structured. I would recommend this to anyone looking to upskill."

Deepika
CCC

"This course transformed my career. The lessons were to follow and immediately applicable to my career goals as a financial analyst. I would highly recommend this course."

Rajeev Ranjan
DIT

"It's simply awesome. If you want to know even more about advance excel just attend this master class."

Reenu Pramod
Basic

"This is the best course I've been Enroled in so far. Just getting those insights from this master course."

Lokesh
DIT

"Today spend a amazing session to learn new thigs about excel. The session made felt its worth my time."

Poonam Singh
DCA
 

Who can Join this course?

Every day you wait is a day you fall further behind in the rapidly evolving world. Don't let your doubts and hesitations hold you back from incredible potential.

 

Aspiring Business Owner

Who are aiming to enhance their analytical skills through hands-on experience with real-world datasets.

Freshers with no experiences

Freshers, eager to learn skill through hands-on work with real-world datasets, aim to get job at leading firms.

Undergraduate Students

Who wants to develop a strong foundation and enhance career prospects, whose aim to get job at leading firms.

Working Professionals

Who wat to stay updated with industry trends and make significant contributions.

Recent Graduates

Who want to bridge the gap between academic learning and real-world application.

Career Switchers

Who want to acquire practical skill and knowledge for a successful transition.

HomeMaker

Who want to work from home to earn some extra money to support their family in their free time.

Part Time Job Seekers

Who want to work in their free time and want some extra income and also want to enhance their skill and knowledge.

Golden-Ager

Who want to acquire practical skill and knowledge to use their experence in new era and earn extra income .

Golden-Ager

Who want to acquire practical skill and knowledge to use their experence in new era and earn extra income .

Frequently Asked Question (FAQ)

How do you deliver your courses?

After signing up and payment, we will email you a link to our training dashboard. All courses consist of video lessons and exercise files, accessible on any device.

Are you certified by a governing body?

We are accredited by The IGCSM (Indira Gandhi Computer Shaksharta Mission) governing body, a recognized accreditation center in the Delhi. We are also certified by An ISO 9001-9015.

How long will it take to learn these skills?

It depends on your commitment. Our students have seen results from as little as 30 minutes a day. The Key is applying the skills as much as learning them.

Why choose your courses?

Our trainers have 20+ years of real-world experience. We focus on what works and leave out unnecessary, information, saving your time.

How should I prepare for this course?

You just need a stable internet connection, a pen, a paper and a curious mind to imbibe- implement-improve your skill set and mindset.

What if I not able to attend the live Session?

Video Recording are Available for every live session. you can watch it when you get time from your dashboard.

Is this Course is interactive?

Yes, This online masterclass is highly interactive! You will not only enjoy live video and audio but also interact with the trainer through 'raise hand', 'Chats', 'in doubt session' .

How will I join the online live session?

The Zoom link would be shared 1 hour before the live session via exclusive WhatsApp group and reminder 10 minutes before session. By clicking on link you join the session .

How can I download eBooks?

Once you book your ticket, you will receive an email on your registered email ID which will contain a link to download the e-book. Click on the link to download and start learning.

How can I download eBooks?

Once you book your ticket, you will receive an email on your registered email ID which will contain a link to download the e-book. Click on the link to download and start learning.

Contact Us

  •      383-A, Bank Street
  •      Munirka, New Delhi - 110067
  • Delhi, India