![Master Of Excel](/img/default-banner.jpg)
- 268
- 176 244
Master Of Excel
Ukraine
Registrace 23. 03. 2023
Learn Excel with me and become an Excel guru! 🤓 Here you will find Excel tips and tricks, hacks, and more exciting content! 💌 Subscribe for updates! 😊 Stay updated 👍 with our regular additions of new Excel tutorials.
📊 Welcome to my Excel Channel!
🌐 Whether you're a newbie or an analyst, enjoy the content where I uncover secrets of Excel! I'm preparing it just for YOU. 😉
🧮 Easy-to-follow tutorials, hacks, and tips are awaiting you.
Don't forget to hit the Subscribe button:) 💕
See you in the next video! ❤
🎉 If you are a beginner and want to dive into Excel easily and quickly, join my course through the link below.
Use This Coupone for FREE ACCESS: UP TO 22/08/2024
www.udemy.com/course/excel-fundamentals-crash-course-for-beginners/?couponCode=4B9DFE7F46548574162B
📊 Welcome to my Excel Channel!
🌐 Whether you're a newbie or an analyst, enjoy the content where I uncover secrets of Excel! I'm preparing it just for YOU. 😉
🧮 Easy-to-follow tutorials, hacks, and tips are awaiting you.
Don't forget to hit the Subscribe button:) 💕
See you in the next video! ❤
🎉 If you are a beginner and want to dive into Excel easily and quickly, join my course through the link below.
Use This Coupone for FREE ACCESS: UP TO 22/08/2024
www.udemy.com/course/excel-fundamentals-crash-course-for-beginners/?couponCode=4B9DFE7F46548574162B
Vlookup in multiple columns | Excel Tips & Tricks 😉
Vlookup in multiple columns | Excel Tips & Tricks
#exceltutorial #exceltricks #exceltipsandtricks #excelspreadsheettips
Learn how to use the Vlookup function in multiple columns in Excel with this helpful tutorial. Master Excel Tips & Tricks with this easy guide!
See my entire playlist of Excel videos:
czcams.com/play/PLpCjCt9Dax9GxBhXYxsCh-TESCxD8BNIc.html
💌 Join my Excel Course for Beginners by the link:
✔ www.udemy.com/course/excel-fundamentals-crash-course-for-beginners/?referralCode=4EBB1BBA8D0C2902EE04
Excel Is Easy! 🙂♥
#exceltutorial #exceltricks #exceltipsandtricks #excelspreadsheettips
Learn how to use the Vlookup function in multiple columns in Excel with this helpful tutorial. Master Excel Tips & Tricks with this easy guide!
See my entire playlist of Excel videos:
czcams.com/play/PLpCjCt9Dax9GxBhXYxsCh-TESCxD8BNIc.html
💌 Join my Excel Course for Beginners by the link:
✔ www.udemy.com/course/excel-fundamentals-crash-course-for-beginners/?referralCode=4EBB1BBA8D0C2902EE04
Excel Is Easy! 🙂♥
zhlédnutí: 214
Video
SUMPRODUCT Function in Excel | Tips & Tricks
zhlédnutí 39Před 28 dny
SUMPRODUCT Function in Excel | Tips & Tricks #exceltutorial #exceltricks #exceltipsandtricks #excel #sumproduct #excelfunction See my entire playlist of Excel videos: czcams.com/play/PLpCjCt9Dax9GxBhXYxsCh-TESCxD8BNIc.html 💌 Join my Excel Course for Beginners by the link: ✔ www.udemy.com/course/excel-fundamentals-crash-course-for-beginners/?referralCode=4EBB1BBA8D0C2902EE04 Excel Is Easy! 🙂♥
Fastest Way of Creating InterActive Dashboard in Excel | Tips & Tricks ⏫
zhlédnutí 84Před měsícem
Fastest Way of Creating InterActive Dashboard in Excel | Tips & Tricks #exceltutorial #exceltricks #exceltipsandtricks #excel #dashboardsnoexcel #dashboards See my entire playlist of Excel videos: czcams.com/play/PLpCjCt9Dax9GxBhXYxsCh-TESCxD8BNIc.html 💌 Join my Excel Course for Beginners by the link: ✔ www.udemy.com/course/excel-fundamentals-crash-course-for-beginners/?referralCode=4EBB1BBA8D0...
Use this Trick in Excel in Column Width Autofit | Excel Tips
zhlédnutí 42Před měsícem
Use this Trick in Excel in Column Width Autofit | Excel Tips #exceltutorial #exceltricks #exceltipsandtricks #excel See my entire playlist of Excel videos: czcams.com/play/PLpCjCt9Dax9GxBhXYxsCh-TESCxD8BNIc.html 💌 Join my Excel Course for Beginners by the link: ✔ www.udemy.com/course/excel-fundamentals-crash-course-for-beginners/?referralCode=4EBB1BBA8D0C2902EE04 Excel Is Easy! 🙂♥
Learn How to Simply and Easy Create a Pivot Table in Excel | Tips & Tricks 😉
zhlédnutí 113Před měsícem
. #exceltutorial #exceltricks #exceltipsandtricks #excel #pivottables #pivottable See my entire playlist of Excel videos: czcams.com/play/PLpCjCt9Dax9GxBhXYxsCh-TESCxD8BNIc.html ⌚Timelines:⌚ 00:00 intro 00:08 welcome 00:41 table step by step 01:13 drag and drop fields 01:52 filter the data 02:25 data sets More videos: Organization chart in Excel czcams.com/video/yqYL6QwfUM4/video.htmlsi=dpRCLJX...
Create Alphabet Code with Ease! 🎈 | Excel Tips & Tricks
zhlédnutí 50Před měsícem
Create Alphabet Code with Ease! 🎈 | Excel Tips & Tricks
Use Autoapply Borders Function to Avoid Manual Drawing | Excel Tips & Tricks
zhlédnutí 33Před měsícem
Use Autoapply Borders Function to Avoid Manual Drawing | Excel Tips & Tricks
Running totals in Excel | Tips & Tricks
zhlédnutí 119Před měsícem
Running totals in Excel | Tips & Tricks
Organization chart in Excel | Tips & Tricks
zhlédnutí 80Před měsícem
Organization chart in Excel | Tips & Tricks
Don't type deadlines in Excel | Tips & Tricks
zhlédnutí 70Před měsícem
Don't type deadlines in Excel | Tips & Tricks
How to Add Mr or Ms before the Value | Gender API in Excel | Tips & Tricks
zhlédnutí 29Před 2 měsíci
How to Add Mr or Ms before the Value | Gender API in Excel | Tips & Tricks
VSTACK HACK! | Combine Multiple tabs into 1️⃣ 👌| Excel Tips & Tricks
zhlédnutí 54Před 2 měsíci
VSTACK HACK! | Combine Multiple tabs into 1️⃣ 👌| Excel Tips & Tricks
Excel for Finance And Accounting | For Beginners | Lesson 6. Conditional Formatting
zhlédnutí 44Před 2 měsíci
Excel for Finance And Accounting | For Beginners | Lesson 6. Conditional Formatting
Excel trick that will save YOU tons of Time! 😃 | Excel Tips & Tricks | Filter Function
zhlédnutí 65Před 2 měsíci
Excel trick that will save YOU tons of Time! 😃 | Excel Tips & Tricks | Filter Function
Excel for Finance And Accounting | For Beginners | Lesson 5. Formatting in Cells
zhlédnutí 43Před 2 měsíci
Excel for Finance And Accounting | For Beginners | Lesson 5. Formatting in Cells
Excel for Finance And Accounting | For Beginners | Lesson 4. Formatting
zhlédnutí 34Před 2 měsíci
Excel for Finance And Accounting | For Beginners | Lesson 4. Formatting
Excel for Finance And Accounting | For Beginners | Lesson 3. Columns & Savings
zhlédnutí 31Před 2 měsíci
Excel for Finance And Accounting | For Beginners | Lesson 3. Columns & Savings
Excel for Finance And Accounting | For Beginners | Lesson 2. Data Entry Basics
zhlédnutí 60Před 3 měsíci
Excel for Finance And Accounting | For Beginners | Lesson 2. Data Entry Basics
Excel for Finance And Accounting | For Beginners | Lesson 1
zhlédnutí 272Před 3 měsíci
Excel for Finance And Accounting | For Beginners | Lesson 1
Microsoft Word For Beginners | Lesson 9 Tips and Tricks for Productivity
zhlédnutí 21Před 3 měsíci
Microsoft Word For Beginners | Lesson 9 Tips and Tricks for Productivity
Microsoft Word For Beginners | Lesson 8 Finalizing and Sharing Documents
zhlédnutí 17Před 3 měsíci
Microsoft Word For Beginners | Lesson 8 Finalizing and Sharing Documents
Microsoft Word for Beginners | Lesson 7 Collaboration and Reviewing Tools
zhlédnutí 45Před 3 měsíci
Microsoft Word for Beginners | Lesson 7 Collaboration and Reviewing Tools
Microsoft Word For Beginners - Lesson 6 Organizing Content with Tables and Lists
zhlédnutí 29Před 3 měsíci
Microsoft Word For Beginners - Lesson 6 Organizing Content with Tables and Lists
Microsoft Word For Beginners - Lesson 5 Easy Guide: Inserting Images in Microsoft Word
zhlédnutí 57Před 3 měsíci
Microsoft Word For Beginners - Lesson 5 Easy Guide: Inserting Images in Microsoft Word
How to Calculate Salary Using Start and End Hours? | Excel tips and Tricks
zhlédnutí 67Před 3 měsíci
How to Calculate Salary Using Start and End Hours? | Excel tips and Tricks
Microsoft Word For Beginners - Lesson 4 Working with Styles and Themes
zhlédnutí 28Před 4 měsíci
Microsoft Word For Beginners - Lesson 4 Working with Styles and Themes
Transfer Anything! From Excel to Word 😉👌
zhlédnutí 215Před 4 měsíci
Transfer Anything! From Excel to Word 😉👌
Thanks. Intersting. I didn´t know that option. You have a very sweet and pleasant voice
Thank You so much it definitely helped me❤❤❤❤❤
thank you so much mam
🔥🔥🔥
#shorts #shortsvideo #shortsyoutube #autoapplybordersinexcel #autoapplyborders #excelborders #autoapply
Kept the good work
Why not use If function?
What? You can just apply a formula
It didn't even work correctly lol
Excellent thanks a lot❤
Thank you) If you have any questions about "How quickly work in Excel" - feel free to ask. I'm here to help)
⭐ *Promosm*
That is a table not a chart. Generally, we don't say word has cells. Past is not paste.
that is not a table it's a range
If u also happen to have a blank cell it will also delete that. How do you delete a row that is entirely blank only with deleting a cell that may be blank where the rest of the row has data.
according to the same principle, only select not the entire sheet, but the fields of a specific table or cells in which there are empty cells. ♥ If any questons arrise don't hesitate to ask Happy learning!
iam the first commenter
Great guide!
Thanks!
The last is probably most useful
What a brilliant, easy to understand and implement, tutorial - thanks ever so much.
Hi, Thx 4 this video, pls tell me if the option crtl+Z still will be working using this condition and VBA code?
Yes, Ctrl + Z will work, but only with the table. After making changes to the VBA code and pressing Ctrl + Z, Excel will reverse the action, but this action will only be related to the table formatting, and the code entry will not change. P.S. If you need to change something in the code, you need to do it through the VBA code
macros cannot be canceled with Ctrl+Z
"📧 Hey everyone! Get ready to revolutionize your email game with this incredible Excel trick! 💼💻 In today's video, we're diving into the magic of sending emails directly from Excel using just a SINGLE FORMULA - no VBA code required! 💡 Whether you're managing communications or streamlining your workflow, this technique will save you time and effort. Let me know your thoughts in the comments below and if you have any other Excel automation topics you'd like me to explore in future videos! Keep streamlining and Excel-ing! 🚀
🖋 Hey everyone! Today, we're delving into an important topic: adding digital signatures in Excel! 💼💻 In this video, we'll explore step-by-step how to enhance the security and authenticity of your Excel documents with digital signatures. 💡 Whether you're handling sensitive data or simply want to ensure document integrity, this Excel feature is a game-changer! Let me know your thoughts in the comments below and if there are any other Excel security features you'd like me to cover in future videos! Stay secure and Excel on! 🚀
🌟 Hey everyone! I'm excited to share these top Excel hacks with you today! 💼💻 In this video, we covered some game-changing techniques: splitting data and formatting tables. 💡 Whether you're organizing large datasets or presenting your information with style, these hacks will definitely come in handy! Let me know your thoughts in the comments below and if you have any other Excel topics you'd like me to cover in future videos! Keep Excel-ing! 🚀
👨💼 Hey everyone! Thanks for tuning in to learn how to highlight the active row and column in Excel! 💼💻 It's a simple yet powerful technique that can really enhance your spreadsheet navigation. Let me know in the comments if you found this tutorial helpful or if you have any questions! Happy Excel-ing! 🚀
Hey everyone! Thanks for watching the video on the SUM function in Excel. I hope you found it helpful for your spreadsheet adventures! If you have any questions, need clarification, or have suggestions for future topics, feel free to drop a comment below. Your feedback is invaluable, and I'm here to help you excel in Excel! 👨💼💻📊
Welcome to the world of automated numbering in Excel! 🚀 Share your thoughts, questions, or any specific scenarios where you plan to apply this technique. Excited to hear how you're making your Excel game stronger! 🎬✨ #ExcelTips #AutomatedNumbering #ProductivityHacks
Welcome, Excel enthusiasts! 🚀 In this tutorial, we've delved into the incredible world of using the Macro Recorder to automate anything in Excel. 💻✨ If you found this helpful or have any questions, drop a comment below! Excited to hear about the automations you're planning to implement in your spreadsheets. Happy automating! 🎬🔧
Thank you for watching! 🚀 In this tutorial, I've covered the essentials of setting data entry limits to ensure accurate and secure information. If you have any questions or need further clarification on any point, feel free to ask. Happy data managing!
Catch the code I used in the video 👇 [Red]# "Days Overdue";[Blue]# "Days Remaining";[Green] "Today"
Good sir ji
I like this video and ❤❤❤❤
Code: Option Explicit 'Main Function to Convert Number to Words Function NumToWords(ByVal MyNumber) Dim Units As String Dim SubUnits As String Dim TempStr As String Dim DecimalPlace As Integer Dim Count As Integer ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " ' Convert MyNumber to string and trim white space MyNumber = Trim(Str(MyNumber)) ' Find position of decimal place 0 if none. DecimalPlace = InStr(MyNumber, ".") ' Convert SubUnits and set MyNumber to Units amount. If DecimalPlace > 0 Then SubUnits = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2)) MyNumber = Trim(Left(MyNumber, DecimalPlace - 1)) End If Count = 1 Do While MyNumber <> "" TempStr = GetHundreds(Right(MyNumber, 3)) If TempStr <> "" Then Units = TempStr & Place(Count) & Units If Len(MyNumber) > 3 Then MyNumber = Left(MyNumber, Len(MyNumber) - 3) Else MyNumber = "" End If Count = Count + 1 Loop NumToWords = Application.Trim(Units & SubUnits) End Function ' Converts a number from 100-999 into text Function GetHundreds(ByVal MyNumber) Dim Result As String If Val(MyNumber) = 0 Then Exit Function MyNumber = Right("000" & MyNumber, 3) ' Convert the hundreds place. If Mid(MyNumber, 1, 1) <> "0" Then Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred " End If ' Convert the tens and ones place. If Mid(MyNumber, 2, 1) <> "0" Then Result = Result & GetTens(Mid(MyNumber, 2)) Else Result = Result & GetDigit(Mid(MyNumber, 3)) End If GetHundreds = Result End Function ' Converts a number from 10 to 99 into text. Function GetTens(TensText) Dim Result As String Result = "" ' Null out the temporary function value. If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19... Select Case Val(TensText) Case 10: Result = "Ten" Case 11: Result = "Eleven" Case 12: Result = "Twelve" Case 13: Result = "Thirteen" Case 14: Result = "Fourteen" Case 15: Result = "Fifteen" Case 16: Result = "Sixteen" Case 17: Result = "Seventeen" Case 18: Result = "Eighteen" Case 19: Result = "Nineteen" Case Else End Select Else ' If value between 20-99... Select Case Val(Left(TensText, 1)) Case 2: Result = "Twenty " Case 3: Result = "Thirty " Case 4: Result = "Forty " Case 5: Result = "Fifty " Case 6: Result = "Sixty " Case 7: Result = "Seventy " Case 8: Result = "Eighty " Case 9: Result = "Ninety " Case Else End Select Result = Result & GetDigit(Right(TensText, 1)) ' Retrieve ones place. End If GetTens = Result End Function ' Converts a number from 1 to 9 into text. Function GetDigit(Digit) Select Case Val(Digit) Case 1: GetDigit = "One" Case 2: GetDigit = "Two" Case 3: GetDigit = "Three" Case 4: GetDigit = "Four" Case 5: GetDigit = "Five" Case 6: GetDigit = "Six" Case 7: GetDigit = "Seven" Case 8: GetDigit = "Eight" Case 9: GetDigit = "Nine" Case Else: GetDigit = "" End Select End Function
I'm sorry but surely flash fill is simpler and quicker
Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)
Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)
Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)
Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)
Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)
Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)
Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)
Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)
Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)
Сourse - Excel for beginners (in Ukrainian). If you are a beginner and want to dive into Excel easily and quickly, join my course through the link: www.udemy.com/course/excel-xb/?referralCode=06A38CE3082CE3CC187A. Exciting content awaits you!)
I wish I could post a table as a comment with many repeated rows of "OH MY GOD, THANK YOU".
You are welcome)
Thank you so much 😍
You are welcome!)
✨✨✨Thank you, 🙏🌺😇✨✨✨
Welcome!
@@Excel-Wizard ✨🙏✨
✨✨✨Thank you, 🙏🌺😇✨✨✨
✨🙏🏼✨
Nice voice
Thank you so much for the compliment! I'm glad you enjoyed the video. If there's anything specific you'd like to see or if you have any suggestions for future content, feel free to let me know. Your feedback means a lot! 😊
It was possible to complete this video within 3 minutes.
Thanks for your feedback! We appreciate your input. While I aim to keep the videos concise, I also want to ensure that I cover all the necessary details for a thorough understanding. If there's a specific aspect you feel could be explained more efficiently, I'll definitely take that into consideration for future content. Feel free to share any suggestions you have for improvement. Thanks for watching!
*Promo sm* ❣️
I would be happy to help. How can you perform automatic value completion in Excel of a certain cell with a number?
automatic value completion in an excel of cell with number
use "SEQUENCE" function
Miss You are doing Good but the way of teaching needs to improve as well as fluently
Hello) I get what you mean. Teaching is a learning process for me too))) 😊 Thanks a bunch for your feedback. I want you to know that I'm already brainstorming ways to make my future videos even better, including improving the fluency. Your thoughts mean a lot, and I'm grateful for your support!
@@Excel-Wizard i Joined your channel as you have good information for MS Excel learners like me. Your work is Good. I am doing my practice after watching your information Videos. Always ne happy Dear