AICT Academy

What you learn in this course

How to use Excel.
Formatting, Conditional formatting.
Creating sheets, Bills, Vouchers.
Insert Images, Shapes, SmartArt.
Creating Charts.
Page Setup and printing.
Maths function.
Date & Time Function.
Logical Function.
Lookup Function.
Information Function.
Financial Function.
Statistical Function.
Pivot Tables & Pivot Chart.
Error handling.
Macros, Work Automation.
Power Query.
Advance Tips and Tricks.
Dashboards.
Working with AI tools.

Course Details

Course Name :

Advance Excel With Artificial Intelligence

Skill Level :

Beginner To Advance

Course Language :

Hindi & English

Duration :

42 Days / 6 Weeks

Fees :

~~Rs.4000/-~~ Rs.500/-

Modules :

42 Modules / Topics

Certificate :

Certificate of completion.
For Yellow and above members.

Requirements :

Windows / MacOS
WhatsApp, Zoom
Copilot, ChatGPT
Excel 2013 / Sheet,
PC / Laptop / Tablet / Mobile

Membership Details

Membership

Support

Fees

white 10 days Rs.10/-
Yellow 4 Months Rs.100/-
Bronze 1 Year Rs.300/-
Silver 3 Years Rs.600/-
Gold 5 Years Rs.900/-
Platinum 7 Years Rs.1500/-

Membership Benefits

Support from our team.
42 + Extra days online lectures.
1-to-1 & Offline Suport lectures.
Recording of 42 video lectures.
Course & Lab practice eBooks.
Academy Community Support.

White Membership

Live session for 11 days only.
Support for 11 days only.
No course materials / eBook.
No video lectures Recrdings.
No certificate of completion.

What you learn in this course

How to use Excel.
Formatting, Conditional formatting.
Creating sheets, Bills, Vouchers.
Insert Images, Shapes, SmartArt.
Creating Charts.
Page Setup and printing.
Maths function.
Date & Time Function.
Logical Function.
Lookup Function.
Information Function.
Financial Function.
Statistical Function.
Pivot Tables & Pivot Chart.
Error handling.
Macros, Work Automation.
Power Query.
Advance Tips and Tricks.
Dashboards.
Working with AI tools.

Limited Time Offer

Our regular price of ~~Rs.4000/-~~ has been reduced down to Rs.500/-
(+ Membership Fees)

Excel - Masterclass Modules And Topics

Discover how you can become a excel expert within 42 days

Excel Basic (Free)

Day 1 :

Introduction to excel
Creating and saving excel
Formatting excel sheets
Inserting shapes and images
Printing sheets
Header and footers

Day 2 :

• Arithmetic function
Logical function
Creating and formatting table

Day 3 :

Creating marksheet

Day 4 :

Text function
Date and Time function

Day 5 :

Employee details

Day 6 :

Statistical function
Financial function

Day 7 :

Sales sheet

Day 8 :

Information function
Conditional formatting

Day 9 :

Salary sheet

Day 10 :

Insert charts
Sorting data
Filter data
Data validation
Data forecast

Day 11 :

Product info sheet
Import and export data
Testing your skill - 1

Advance Excel

Day 12 :

Nested if
Income tax calculation

Day 13 :

Vlookup
Salary slip

Day 14 :

Creating charts

Day 15 :

Pivot tables

Day 16 :

Pivot charts

Day 17 :

Dynamic charts

Day 18 :

Working with smart objects

Day 19 :

Advance skills - 1

Day 20 :

Invoice / Bill

Day 21 :

Hlookup
Xlookup
Index and Match

Day 22 :

Handling errors

Day 23 :

Nesting formulas

Day 24 :

Working with macros

Day 25 :

Some VBA technique

Day 26 :

Page setup and printing
Testing your skill - 2

Working with AI

Day 27 :

Understanding ChatGPT
What is OpenAI
Understanding prompts

Day 28 :

Writing prompts for excel

Day 29 :

Prompts for advance formulas

Day 30 :

Prompts for charts

Day 31 :

Advance skill - 2

Day 32 :

Working With complex formulas

Day 33 :

More prompts for excel
Testing your skill - 3

Day 34 :

Dashboard 1 - day 1

Day 35 :

Dashboard 1 - day 2

Day 36 :

Dashboard 1 - day 3

Day 37 :

Generating reports

Day 38 :

Dashboard 2 - day 1

Day 39 :

Dashboard 2 - day 2

Day 40 :

Dashboard 2 - day 3

Day 41 :

Testing your skill-4

Day 42 :

Doubt session

Working with AI

Day 27 :

Understanding ChatGPT
What is OpenAI
Understanding prompts

Day 28 :

Writing prompts for excel

Day 29 :

Prompts for advance formulas

Day 30 :

Prompts for charts

Day 31 :

Advance skill - 2

Day 32 :

Working With complex formulas

Day 33 :

More prompts for excel
Testing your skill - 3

Day 34 :

Dashboard 1 - day 1

Day 35 :

Dashboard 1 - day 2

Day 36 :

Dashboard 1 - day 3

Day 37 :

Generating reports

Day 38 :

Dashboard 2 - day 1

Day 39 :

Dashboard 2 - day 2

Day 40 :

Dashboard 2 - day 3

Day 41 :

Testing your skill-4

Day 42 :

Doubt session

Limited Time Offer

Our regular price of ~~Rs.4000/-~~ has been reduced down to Rs.500/-
(+ Membership Fees)

How to Enroll and Join Online classes?

Discover how you can become a excel expert within 42 days

Enrollment Process

Enrollment Steps:

Click on "Enroll for Course Now" Button
Fill the Personal details in enrolment form
Select Membership type
Click on " Make Payment "
Make payment Online
Take a screenshot of successful payment
Note down the email-address
Join the WhatsApp Group

Steps only for Yellow and above members:

Send Email with following infomation
Successful Payment Screen Shot
Enrollment Details Screen Shot
You will Receive Login information email
Join the Dashboard through link in email
Complite your dashboard profile
Join academy community through dashboard

Joining Live Classes

Link in WhatsApp:

Zoom Meeting Link
Assingment Worksheet
Dialy Practice work sheet
All Other information

Software and Hardware Require:

WhatsApp App
Zoom Meeting App
Excel / Sheet
PC / Labtop / Tablet / Mobile
Stable internet connection

Enquiry, Support and Query:

Send your query on query_email only
Send other enquiry on support email
Wait for 24 working hour for respounce
Do not spam in email inbox

Getting Course Material

Link in Email:

Membership information
Dashboard login information
Members WhatsApp Group Link

Available in Dashboard:

Change your password
Complete your profile
Join academy community
Live recorded video
Course eBook
Lab Manual eBook
Complete all assignment
Complete all assessment
Complete Project (If Any)
Download your Certificate
Get Support in Community

Getting Course Material

Link in WhatsApp and Email:

Zoom Meeting
Live recorded video
Course eBook
Lab Manual eBook
Dashboard login

Available in Dashboard:

Login to your Dashboard
Change your password
Complete your profile
Join academy community
Complete all assignment
Complete all assessment
Complete Project (If Any)
Download your Certificate
Get Support in Community

Limited Time Offer

Our regular price of ~~Rs.4000/-~~ has been reduced down to Rs.500/-
(+ Membership 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

"This course is excellent. 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

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

Poonam Singh
DCA

Limited Time Offer

Our regular price of ~~Rs.4000/-~~ has been reduced down to Rs.500/-
(+ Membership Fees)

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 .

Limited Time Offer

Our regular price of ~~Rs.4000/-~~ has been reduced down to Rs.500/-
(+ Membership Fees)

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 .

From Where I can download the E-books?

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.

From Where I can download the E-books?

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.

Limited Time Offer

Our regular price of ~~Rs.4000/-~~ has been reduced down to Rs.500/-
(+ Membership Fees)

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

Enquiry: +91-7759056044
Enroll : +91-7759056044
Support: +91-7759056044

Enquiry: enquiry@aicta.in
Enroll : enroll@aicta.in
Support: support@aicta.in