- 20
- 801
SWAMI EXCEL
Приєднався 8 лип 2020
As you may aware I'm teaching at DISHA COMPUTER institute as ADVANCED EXCEL faculty, and I have been typed with HOPE CAREER Academy, Pune for training online/offline. due to COVID-19 all face to face teaching and training is being stopped, online training having lot of demand for full course. In view of Covid-19 I have started my own UA-cam channel for them, who are unable join full course.
To Improve office work productivity, time saving & work accuracy I personally request to all please watch all the videos, comment it with your difficulties and needed training subjects if you are facing any problem in Excel. I also kindly request you to subscribe my channel to get alert for new videos.
for whole course you please contact me separately for fees, time duration, Batch and course contents.
Wish you all the best
Thanks,
Stay home, be safe
To Improve office work productivity, time saving & work accuracy I personally request to all please watch all the videos, comment it with your difficulties and needed training subjects if you are facing any problem in Excel. I also kindly request you to subscribe my channel to get alert for new videos.
for whole course you please contact me separately for fees, time duration, Batch and course contents.
Wish you all the best
Thanks,
Stay home, be safe
3/3 FORMULAS IF, NEXTEDIF, OR, AND WITH COMBINATONS, IFERROR, IFNA
FORMULAS IF, NEXTEDIF, OR, AND WITH COMBINATONS, IFERROR, IFNA
Переглядів: 15
Відео
2/3ABS, FLOOR.MATH, SUM, WITH IF_IFS_PRODUCT, COUNT WITH IF_IFS, AVERAGE WITH IF_FS
Переглядів 92 місяці тому
Formulas ABS, FLOOR.MATH, SUM, SUMIF, SUMIFS, SUMPRODUCT, COUNT, COUNTIF, COUNTIFS, AVERAGE, AVERAGEIF, AVERAGEIFS
1/3 Protections all the way, File, Sheet and within a sheet multiple passwords. with conditions
Переглядів 192 місяці тому
• “File” protection 2 ways, for opening file / read only protection • “protection” various way with conditions • “Multiple” protections for various range data
Class 30 June 24
Переглядів 142 місяці тому
Pivot table in detail Online Class recording 30 June24 • Field setting • Pivot tables options • Formula within pivot tables • Refresh • Group / ungroup • Slicer, Timeline • Change data source
IF/AND/OR/CEILING.MATH/FLOOR.MATH/SORTING/FILTER INDICATION
Переглядів 102 роки тому
IF/AND/OR/CEILING.MATH/FLOOR.MATH/SORTING/FILTER INDICATION
FIND/REPLACE to Text, Spaces, Colors, Borders or any Formats / फाइंड या रिप्लेस करो सभकुछ
Переглядів 153 роки тому
FIND/REPLACE to Text, Spaces, Colors, Borders or any Formats / ना सिर्फ शब्द को, फाइंड या रिप्लेस करो सभकुछ
ABS Formula (convert minus / negative value to plus / positive value with formula/without formula
Переглядів 283 роки тому
ABS formula (convert minus / negative values to plus / positive values with formula/without formula मायनस या निगेटिव फीगर्स कन्वर्ट पोजेटिव या प्लस फीगर्स में
AGGREGATE formula (Ignore error, hidden, subtotal values & Calculation with various conditions)
Переглядів 583 роки тому
AGGREGATE formula (Calculation with various conditions) / 3 मिनिट मे सीखो AGGREGATE फार्मूला.
EMI, Principle & Interest calculation formulas. PMT,PPMT,IPMT / आब खुदही EMI कैलकुलेशन करो
Переглядів 243 роки тому
EMI, Principle & Interest calculation formulas. PMT,PPMT,IPMT / आब खुदही EMI कैलकुलेशन करो
Cut,copy picture,format painter,Paste special,Add,subtract,Multiply,divide,Skip blank,Transpose,link
Переглядів 263 роки тому
Copy paste/ paste special. Cut,copy,copy as picture,paste,format painter,Paste special,Add,subtract,Multiply,divide,Skip blank,Transpose,Paste link कॉपी पेस्ट के २३ ऑप्शन्स डिटेल्स में
Text formu CHAR,CODE,FIXED,REPLACE,REPT,SUBSTITUTE,T,TEXT,VALUE,NUMBERVALUE,BAHTTEXT,UNICHAR,UNICODE
Переглядів 253 роки тому
Excel Text formulas. CHAR,CODE,FIXED,REPLACE,REPT,SUBSTITUTE,T,TEXT,VALUE,NUMBERVALUE,BAHTTEXT,UNICHAR,UNICODE टेक्स्ट के संबधी २७ फॉर्मुले, पार्ट 2
Text Formulas.CLEAN,CONCATENATE,DOLLAR,EXACT,FIND,Search,LEFT,LEN,LOWER,MID,PROPER,RIGHT,TRIM,UPPER
Переглядів 253 роки тому
Excel Text formulas. CLEAN,CONCATENATE,DOLLAR,EXACT,FIND,Search,LEFT,LEN,LOWER,MID,PROPER,RIGHT,TRIM,UPPER टेक्स्ट के संबधी २७ फॉर्मुले, पार्ट 1
EXCEL FLASH FILL, DOWN,UP,LEFT,RIGHT,SERIES.... & JUSTIFY, FORMULA IN WORDS / एक्सेल में फ़्लैश फिल
Переглядів 414 роки тому
EXCEL "FLASH FILL" IS NOW IN FEW SECONDS DOWN,UP,LEFT,RIGHT, SERIES.... & JUSTIFY.New learning FORMULA IN WORDS / एक्सेल में फ़्लैश फिल ऑप्शन बहुतही कामकी चीच है.
INSERT ALTERNATE BLANK ROW / COLUMN IN EXISTING DATA/एक्सिस्टिंग डाटा में ब्लेंक रो या ब्लेंक कॉलम
Переглядів 404 роки тому
HOW TO INSERT ALTERNATIVE BLANK ROW OR BLANK COLUMN IN EXISTING DATA / एक्सिस्टिंग डाटा में ब्लेंक रो या ब्लेंक कॉलम केसे इन्सर्ट करे चुटकीमे
#IFNA, IFERROR, IF, DATEDIF, IFAND, IFOR / एक्सेल के सारे इफ फॉर्मूले पार्ट 2.
Переглядів 374 роки тому
#IFNA, IFERROR, IF, DATEDIF, IFAND, IFOR / एक्सेल के सारे इफ फॉर्मूले पार्ट 2.
AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS / एक्सेल के सारे इफ फॉर्मूले पार्ट 1
Переглядів 634 роки тому
AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS / एक्सेल के सारे इफ फॉर्मूले पार्ट 1
Advanced Vlookup, Hlookup, match, lookup, lookup down to up, lookup right to left/ उलटा, टेडा, मेडा
Переглядів 1314 роки тому
Advanced Vlookup, Hlookup, match, lookup, lookup down to up, lookup right to left/ उलटा, टेडा, मेडा
Pivot table all options in detail. slicer,timeline,group,data source पिवोट टेबल डिटैल में सारे ऑप्शन
Переглядів 1464 роки тому
Pivot table all options in detail. slicer,timeline,group,data source पिवोट टेबल डिटैल में सारे ऑप्शन
How to work in one excel file at same time with multiple passwords/एकही फाइलमे सब काम करे.
Переглядів 404 роки тому
How to work in one excel file at same time with multiple passwords/एकही फाइलमे सब काम करे.
Nice
Thanks
When excel file not responding to open or any action taken, that time what to do
Just go to end task and close all excel background program , still having trouble. contact me with errors
Very nice Swami Sir
Thanks a lot
Msta
Thanks sir
Thanks sir
Mast swamibhai
Helpful 👍🏻
Thank you Sir
Nicely explained
Thanks a lot for watching my videos.
Explained so clearly.
Thank you
Very knowledgeable advance Excel information for professional growth.
Thank you sir for appreciations
Badiya,
Very good Swamiji Kam ki chiz batai Apne. Acchya explanation that. Pahile 3 videos aawaj acchi nahi aaya Rahi thi Abhi sahi aarahi hai
Thanks for sharing the information !
Thanks Aditya
Very nice Sir
Thank you sir
Excellent presentation Swami for V lookup.
Thank you sir
Really Nice Video Sir.....Vlookup awesome
Thanks for comments Rupesh sir
good
Thanks for comments
Slicer and Time line was new learning, Good information
Thank a lot.
This is very useful information. please let me know , can we use formula within pivot table?
Dear Madam, I think you are talking about my pivot table video , Yes we can use formula in pivot table I'll prepare video on it with other considering few points. thank you watching my videos
Nice information
Thank you sir