Prashant kumar saini

We are a Group of Professionals, Who Deals with the right Demands from the Industry 

Course available for lifetime after purchase

What we'll cover in this Course - 

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


Advance Excel Course for Professionals

U2FsdGVkX18/hV8B0p4VNyv1slB7J2zoJrhTfWNbqFg=

11TH (CELL STYLES)

U2FsdGVkX19UvjI9mNzyAiDyWTVk9uyNIScGUzDM+mQ=

17TH (ENTIRE PIVOT TABLE)

U2FsdGVkX18t1TTTPlQfgZKQYN/62T4LmGO2Hs2V1E0=

34TH (SMART LOOKUP OR TRANSLATE OPTION)

PTS CAD EXPERT

Maharashtra

Hey! I’m learning with PTS CAD EXPERT and you can too. Here’s a course you might like: Advance Excel Course for Professionals by Prashant kumar saini
    https://ophec.courses.store/211241?utm_source=whatsapp&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with PTS CAD EXPERT and you can too. Here’s a course you might like: Advance Excel Course for Professionals by Prashant kumar saini
    https://ophec.courses.store/211241?utm_source=facebook&utm_medium=social-fb&utm_campaign=web-course-share

Hey! I’m learning with PTS CAD EXPERT and you can too. Here’s a course you might like: Advance Excel Course for Professionals by Prashant kumar saini
    https://ophec.courses.store/211241?utm_source=telegram&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with PTS CAD EXPERT and you can too. Here’s a course you might like: Advance Excel Course for Professionals by Prashant kumar saini
    https://ophec.courses.store/211241?utm_source=linkedin&utm_medium=social-link&utm_campaign=web-course-share

Hey! I’m learning with PTS CAD EXPERT and you can too. Here’s a course you might like: Advance Excel Course for Professionals by Prashant kumar saini
    https://ophec.courses.store/211241?utm_source=copy-link&utm_medium=social&utm_campaign=web-course-share