- Видео 350
- Просмотров 246 620
Excel Online Advisor
Индия
Добавлен 26 май 2020
Thanks for watching! 🙏 If you found this video helpful, please subscribe📌 to our RUclips channel for more tips and tricks.
Excel Online Advisor is a 100% FREE RUclips channel that helps you learn Excel and save time with your everyday tasks. Learn how to use formulas, pivot tables, macros, VBA, charts📈, dashboards, and more.
Subscribe to our channel for "how-to" tutorial style videos on a wide range of Excel topics. We also offer one-o-one assistance on Instagram at @exceladvisorr & Telegram.
Excel Online Advisor is a 100% FREE RUclips channel that helps you learn Excel and save time with your everyday tasks. Learn how to use formulas, pivot tables, macros, VBA, charts📈, dashboards, and more.
Subscribe to our channel for "how-to" tutorial style videos on a wide range of Excel topics. We also offer one-o-one assistance on Instagram at @exceladvisorr & Telegram.
How to Convert Number to Words in Excel | Automatic Number to Words in Excel | Hindi
Learn how to convert numbers into words in Excel using VBA code! This method is valid for all Excel versions, including Excel 2019, Excel 2016, and beyond. Simplify your workflow and automate tasks with this quick VBA tutorial!
VBA Link - drive.google.com/file/d/10kPtk4ilX91YLW2n2Qf0Dgjc82zG038e/view?usp=sharing
------------------------------------------------------------------------------------------------------
Welcome to Excel Online Advisor, where we share expert tips and tricks for mastering Microsoft Excel.
✅ Need Help ? Ping Here (Telegram) - t.me/+UAVHfg7OMBk5M2M1
✅ Instagram - excelonlineadvisor
✅ RUclips - www.youtube.com/@excelonlineadvisor?sub_confirmation=1
VBA Link - drive.google.com/file/d/10kPtk4ilX91YLW2n2Qf0Dgjc82zG038e/view?usp=sharing
------------------------------------------------------------------------------------------------------
Welcome to Excel Online Advisor, where we share expert tips and tricks for mastering Microsoft Excel.
✅ Need Help ? Ping Here (Telegram) - t.me/+UAVHfg7OMBk5M2M1
✅ Instagram - excelonlineadvisor
✅ RUclips - www.youtube.com/@excelonlineadvisor?sub_confirmation=1
Просмотров: 369
Видео
Excel Tips & Tricks For Interview | Excel Interview
Просмотров 11421 день назад
Prepare for your next job interview with the top 50 Excel interview questions, covering essential topics for roles like data analyst, office manager, and more. This video provides comprehensive questions and answers to boost your Excel skills and help you succeed in any Excel-based interview. Perfect for both beginners and professionals looking to enhance their Excel knowledge! Welcome to Excel...
Export Bank Statement in Excel | PDF in Excel
Просмотров 110Месяц назад
Export Bank Statement in Excel | PDF in Excel
How to Create Dream11 Team Combinations #winningtricks
Просмотров 7022 месяца назад
How to Create Dream11 Team Combinations #winningtricks
How to Convert Number in Words in Excel | Excel365
Просмотров 4353 месяца назад
How to Convert Number in Words in Excel | Excel365
How IPO Allotment Works ? Dashboard for Beginners
Просмотров 1784 месяца назад
How IPO Allotment Works ? Dashboard for Beginners
How to Convert Numbers into Lakh & Crore - Excel Tricks & Tips #excel
Просмотров 2,1 тыс.5 месяцев назад
How to Convert Numbers into Lakh & Crore - Excel Tricks & Tips #excel
REGEXEXTRACT Function | Excel 2024 | Tutorials |
Просмотров 4046 месяцев назад
REGEXEXTRACT Function | Excel 2024 | Tutorials |
GROUPBY Function in excel #excel2024
Просмотров 2097 месяцев назад
GROUPBY Function in excel #excel2024
Go to Dialog Box (All Options Explained)
Просмотров 44910 месяцев назад
Go to Dialog Box (All Options Explained)
H Lookup in Excel | Horizontal Lookup in Excel with Example
Просмотров 28910 месяцев назад
H Lookup in Excel | Horizontal Lookup in Excel with Example
How to convert Number into Lakh - Excel Tricks & Tips
Просмотров 17 тыс.10 месяцев назад
How to convert Number into Lakh - Excel Tricks & Tips
How to Create Thermometer CHART IN EXCEL (Step By Step) #excelcharts
Просмотров 34911 месяцев назад
How to Create Thermometer CHART IN EXCEL (Step By Step) #excelcharts
Microsoft Excel Community Q&A | Excel Questions | Freelancer #exceltutoring
Просмотров 51Год назад
Microsoft Excel Community Q&A | Excel Questions | Freelancer #exceltutoring
2023 Excel Tricks You need to Know #exceltips
Просмотров 148Год назад
2023 Excel Tricks You need to Know #exceltips
How to use LAMBDA Function with VLOOKUP in Excel #part2
Просмотров 136Год назад
How to use LAMBDA Function with VLOOKUP in Excel #part2
Named Ranges In Excel | How to Create Bulk Named Ranges #microsoftexcel #excelhacks
Просмотров 349Год назад
Named Ranges In Excel | How to Create Bulk Named Ranges #microsoftexcel #excelhacks
Top 30 Excel Interview Questions for 2023 || HR Verified ☑️
Просмотров 149Год назад
Top 30 Excel Interview Questions for 2023 || HR Verified ☑️
Choose Function in Excel | How to use Choose Function
Просмотров 146Год назад
Choose Function in Excel | How to use Choose Function
Excel Data Formatting Tricks - ☑️ Valid For All Excel Versions #shortcuts
Просмотров 131Год назад
Excel Data Formatting Tricks - ☑️ Valid For All Excel Versions #shortcuts
How to Open Excel File Without Using a Keyboard - #excelshortcuts
Просмотров 82Год назад
How to Open Excel File Without Using a Keyboard - #excelshortcuts
Feel free to ask your Excel query on this group t.me/+UAVHfg7OMBk5M2M1
Excel 2024 Shortcuts Revealed! - ruclips.net/video/e8O4ukrzhaA/видео.html
How to Convert Number to Words in Excel - ruclips.net/user/shortsT4_outAWocQ
How to Convert Number in Words in OLD Excel VERSION - ruclips.net/video/TpFFpB4mLPE/видео.html
VBA Link - shorturl.at/ECWh1
If we don't hv office365 then how can use this
You can use TRANSLATE Function
@excelonlineadvisor no this function is not in my laptop doesn't work
Which version you are using ? OR you can use VBA for this. Let me know if you required the VBA
@@poojajayara9013 Pls Check this For Old Version of Excel - ruclips.net/video/TpFFpB4mLPE/видео.htmlfeature=shared
Comment Next Video's Topic Which you want to Learn
Comment Next Video's Topic Which you want to Learn!!
Comment Next Video's Topic Which you want to Learn!!
Informative
How to get the delimiters in lakh format
Check out the PINNED Comment
Thank you very much. But can you please advise how can I have commas in lakhs, crore format instead of millions which is default in excel. I know the regional settings option but that applies to all excel files but I want to be applied in few specific columns in excel files?
To convert a number into the Indian format, follow these steps: Western Method Select the data >> Press CTRL + 1 >> Go to Number >> Check Use 1000 Separator. Indian Method Select the data >> Press CTRL + 1 >> Go to Custom Formatting >> Delete General >> Type #,##,##0 >> Click OK. These are temporary solutions. For a permanent fix, you need to change the regional settings of your computer. I'll be uploading a video on this soon!
COMMENT Next Video's Topic which you want to learn
Wow, this comes handy. 👍
Glad you liked it!!!
Hey, I gave this trick a shot for converting crore values, and it worked perfectly on one sheet. But on another sheet, the % sign just won't go away. Any idea why that might be happening?
In the custom formatting, before the 1 percentage sign press alt + J to give line space and then wrap the text to remove % sign
So helpful! I've subscribed!
♥️
Thanks Sir, very prodcutive........sir, same thing will help in google sheet, please advise
Will upload for Google sheet soon !!! Thanks for the feedback
Export Bank Statement in Excel - ruclips.net/video/99h7NN4DkG0/видео.html
AWESOME VIDEO MAN!!!! U SAVED MY (CAREER) LIFE
Glad you liked it!!! Best of Luck for your career 😉
Did you figure out all three answers?
Feel free to ask your Excel query on this group GROUP LINK - t.me/+UAVHfg7OMBk5M2M1
I wish you would post the answers too. Anyway, I’ve already encountered most of these questions, but it’s great to learn about the others before my next interview.
Thanks for the feedback.
Feel free to ask your Excel query on - t.me/+UAVHfg7OMBk5M2M1
Telegram GROUP LINK - t.me/+UAVHfg7OMBk5M2M1
Sub ProtectAllSheets() Dim ws As Worksheet Dim pwd As String pwd = InputBox("Enter password to protect all sheets:") For Each ws In ThisWorkbook.Worksheets ws.Protect Password:=pwd, DrawingObjects:=True, Contents:=True, Scenarios:=True Next ws MsgBox "All sheets have been protected with the password: " & pwd End Sub
Interesting
Comment Below If You Have Any Questions
Comment Below If You Have Any Questions
UPDATED VIDEO - ruclips.net/video/99h7NN4DkG0/видео.html
Hash # kya करता है
Is video se aapko samaj aajayega - Custom Formatting in Excel ruclips.net/video/ltWz96FDRUg/видео.html
Es video m voice bahut low hai, please firse new video download Kare
Sure
ruclips.net/video/99h7NN4DkG0/видео.html
Comment Next Video's Topic which you want to learn!!
Follow For More !!!
Feel free to ask your Excel query on - t.me/+UAVHfg7OMBk5M2M1
Well explained
Glad you liked it ❤️
%% not remove according to your process
Which version you are using ? Pls check pinned comment
I don't have the pdf option in the from file dropdown
Which Excel Version you are using ?
Save it for Later & Follow @excelonlineadvisor For More !!
VBA Link - drive.google.com/file/d/19kF2MW1e7ILTFenjjV5_AdGT5tAVDB3b/view?usp=sharing
Hi As Try, but the unwanted percentage sign is showing after putting the same in the formatting, me also facing same issue
Did you try pressing Ctrl + J to remove it ? I have other methods uploaded on my channel for the same, feel free to check the same. Check this ruclips.net/video/ICL15ALV9Gs/видео.html
Invoice for Veteran - drive.google.com/file/d/1yKAOF8qd7MARhPsIzIISCzsl5GfE41S4/view?usp=sharing
Invoice for Beginner - drive.google.com/file/d/1G8RyAB7rI2rWmIBhiaeAswEi2o4a6IH4/view?usp=sharing
Comment For Any Doubt/Suggestions
Please Reply
Pls check - How to Convert Numbers into Lakh & Crore - Excel Tricks & Tips #excel ruclips.net/video/ICL15ALV9Gs/видео.html
There is a telegram link in bio to DM me
Hi As Try, but the unwanted percentage sign is showing after putting the same in the formatting
Did you try pressing Ctrl + J to remove it ? I have other methods uploaded on my channel for the same, feel free to check the same.
Once you get the result , please do wrap text , the percentage sign will go
Comment if you have any Doubts/Suggestions
Follow to Learn More About Excel
But i not overcome my Excel solution
Feel free to Ping me for any help. Telegram link is in bio
@excelonlineadvisor thanks
nice❤
Glad you liked it!
Follow For More!!!