Master Diploma in Data Analytics with A.I

Accounts Expert

Excel Advanced with AI – Live Course (Basic to Advanced)

What we&#39;ll cover in this Course -&nbsp;
1 INTRO OF COURSE 
2 ENTIRE SYLLABUS OF ADVANCED EXCEL 
3 GUI OF EXCEL 
4 FILE TAB 
5 FONT PANNEL 
6 CLIPBOARD PANNEL 
7 ALIGNMENT PANNEL 
8 NUMBERS PANNEL 
9 CONDITIONAL PANNEL 
10 FORMAT AS TABLE OPTION 
11 CELL STYLES OPTION 
12 INSERT OR DELETE 
13 FORMAT OPTIONS 
14 FILL AND CLEAR OPTION 
15 SORT AND FILTER OPTION 
16 FIND AND SELECT 
17 PIVOT TABLE 
18 PIVOT CHART 
19 PICTURE OPTION WITH DETAIL 
20 SHAPE OPTION WITH ITS MODIFICATION 
21 ICON AND 3D MODELS 
22 SMART ART AND SCREENSHOT 
23 ADD INS PANNEL 
24 3D MAP 
25 SPARKLINES PANNEL 
26 HYPERLINK OPTION 
27 TEXT PANNEL 
28 THEMES PANNEL 
29 MARGIN, ORIENTATION, AND PAGE SIZE 
30 PRINT AREA, PAGE BREAK, AND PRINT TITLES 
31 GRIDLINES, HEADING AND ARRANGE PANNEL 
32 ALL OPTIONS OF PRINT PREVIEW 
33 SPELLING, THESAURUS, AND STATISTICS 
34 SMART LOOKUP OR TRANSLATE OPTION 
35 COMMENT OPTION 
36 HOW TO SET UP THE PASSWORD ON EXCEL SHEET OR WORKBOOK 
37 WORKBOOK VIEWS 
38 ZOOM OPTIONS 
39 SHOW PANNEL IN VIEW TAB 
40 WINDOW PANEL 
41 SWITCH WINDOWS AND MACROS OPTION 
42 HOW TO IMPORT THE DATA IN EXCEL 
SR NO. TOPICS 
43 TEXT TO COLUM, FLASH FILL, AND DUPLICATE OPTIONS 
44 ADVANCE FILTER 
45 COMPLETE DATA VALIDATION OPTION 
46 CONSOLIDATE OPTION 
47 SCENARIO MANAGER 
48 GOAL SEEK AND DATA TABLE OPTION 
49 GROUP, UNGROUP AND SUBTOTAL 
50 ALL METHODS OF SUM FUNCTION 
51 DIVIDE, MULTIPLY, AND SUBTRACTION OPTION 
52 AVERAGE, COUNT, MIN, MAX 
53 ADVANCE LOOKUP FORMULA 
54 VLOOKUP ADVANCE FUNCTION 
55 HOOKUP FORMULA 
56 ROW, ROWS, COLUM,N AND COLUMNS 
57 RANDOM AND RANDOM BETWEEN FORMULA 
58 HOW TO CALCULATE EMI BY PMT FORMULA 
59 IPMT AND PPMT FORMULA 
60 AVERAGEIF AND AVERAGES 
61 COUNT, COUNT AND COUNTBLANK FORMULAS 
62 COUNTIF ANF COUNTIES 
63 UPPER, LOWER AND PROPER FORMULA 
64 LCM FORMULA 
65 POWER FORMULA 
66 TRIM AND SUBSTITUTE FORMULA 
67 IF FORMULA

Excel Advance Recorded Course for Professionals

Google Sheets Live Course: From Beginner to Expert

Q.1 What is Inside the Course? 
At the basic level, you will gain complete knowledge of the program, understand various features, and get to know how things work in Excel.
&nbsp;
Q.2&nbsp; How to Apply for the Certificate?
Watch the complete video on YouTube, submit your feedback within the video, then enroll in the free course or participate in the quiz. Your certificate will be processed and sent to your email within the next 3 days.
&nbsp;
Q.3 Kya participation certificate aur course certificate same hota hai?
No, they are not the same. 
A Participation Certificate simply indicates that you actively took part in an activity or event. 
On the other hand, a Course Certificate involves live assistance from professionals, complete training based on a project-oriented approach, and upon completion, you receive an ISO-certified and QR code-based certificate that can be verified online from anywhere.
&nbsp;
Q.4 - Professional Training me Kya Kya Milta hai?
During the professional training, you get:
<ul>
	<li>
	A mentor who guides you through every feature in detail, explaining how it is used in real companies and how to execute real-world tasks with it.
	</li>
	<li>
	Project-based training, which helps you become familiar with official tools and workflows.
	</li>
	<li>
	Access to a professional community, where you can observe the work of other members, helping you enhance and sharpen your own skills.
	</li>
	<li>
	WhatsApp assistance, where you can share your queries anytime and get support.
	</li>
	<li>
	1 hour of live interactive training daily, giving you consistent hands-on learning.
	</li>
	<li>
	A total of 1.5 months of dedicated time to sharpen your skills.
	</li>
	<li>
	Training on both free and paid AI tools, making you industry-ready.
	</li>
	<li>
	Upon completing the course, you receive an ISO Certified certificate that can be verified online, which is often required for MNCs and government jobs.
	</li>
</ul>

All Courses

Master Diploma in Data Analytics with A.I

Excel Advanced with AI – Live Course (Basic to Advanced)

Excel Advance Recorded Course for Professionals

Google Sheets Course: From Beginner to Expert

Excel Basics Mastery – Participation Certificate