How to hide cells with custom formatting #excel #microsoft #اكسل #microsoftexcel #data #datascience
How to hide cells with custom formatting #excel #microsoft #اكسل #microsoftexcel #data #datascience
This is the ? Don't spend the night at work series ? for Excel shorts. Each time we show you an excel trick that enables you to work faster, more efficiently and with increased precision, thereby saving you time and improving your productivity.
Excel A to Z mashup #1 (session 1 to 16)
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Excel is the most powerful tool to manage and analyse various types of Data. This Microsoft Excel tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process. This Excel for beginners course will help you learn Excel basics.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
??♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE ? https://bit.ly/3cQUVZZ
SUPPORT THE CHANNEL
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
?Teespring Merch&Books ? https://bit.ly/3S1fa7n
Social Media / Contact us
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
?Dexcelo on TikTok ? https://bit.ly/3JgslNU
? Business Inquiries ? dexcelo03@gmail.com
? In this course you will learn how to:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
? Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support ??? !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial
...
https://www.youtube.com/watch?v=fDlxBu_ys7k
How to use VLOOKUP #exceltips #learnexcel #excel #microsoft #shortcuts #tutorial #data #learning
This is the ? Don't spend the night at work series ? for Excel shorts. Each time we show you an excel trick that enables you to work faster, more efficiently and with increased precision, thereby saving you time and improving your productivity.
??♂️ PLEASE SUBSCRIBE
✅ SUBSCRIBE HERE ? [https://bit.ly/3cQUVZZ](https://bit.ly/3cQUVZZ)
SUPPORT THE CHANNEL
?Teespring Merch&Books ? [https://bit.ly/3S1fa7n](https://bit.ly/3S1fa7n)
Social Media / Contact Me
?Dexcelo on TikTok ? [https://bit.ly/3JgslNU](https://bit.ly/3JgslNU)
? Business Inquiries ? [dexcelo03@gmail.com](mailto:dexcelo03@gmail.com)
? In this course you will learn how to:
- Excel Shortcuts
- Excel Tricks
======================
✏️ Course developed by Dexcelo.
? Useful Links
⚈ Microsoft Excel Help Center [https://bit.ly/3Q99vu8](https://bit.ly/3Q99vu8)
⚈ Microsoft Excel Shortcuts [https://bit.ly/3OY0p2h](https://bit.ly/3OY0p2h)
# ======================
Thank you for your support ??? !!!
Tags
#excel #excelshortcuts #learnexcel #exceltips #shortcuts #microsoft #microsoftexcel
...
https://www.youtube.com/watch?v=m2wv1frYjpU
How to use formula reference in excel | Excel Practice Case #03 إتعلم حيل إكسل مع دكسلو
What does it mean to use an absolute cell reference in a formula?
In contrast, the definition of absolute cell reference is one that does not change when it's moved, copied or filled. This way, the reference points back to the same cell, no matter where it appears in the workbook. It's indicated by a dollar sign in the column or row coordinate.
??♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE ? https://bit.ly/3cQUVZZ
? DOWNLOAD the Exercise file and solution for this video here ?
SUPPORT THE CHANNEL
======================
?Teespring Merch&Books ? https://bit.ly/3S1fa7n
Social Media / Contact Me
======================
?Dexcelo on TikTok ? https://bit.ly/3JgslNU
? Business Inquiries ? dexcelo03@gmail.com
? In this course you will learn how to:
======================
- Create formula based on cell reference input
- Absolute and relative cell reference
- SUM Function with ALT + =
- Testing different hypothesis
======================
✏️ Course developed by Dexcelo.
======================
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
======================
0:00:00 - 0:01:08 Intro
0:01:33 - 0:07:18 Create formula based on cell reference input
0:07:18 - 0:12:18 Absolute and relative cell reference
0:12:18 - 0:13:38 SUM Function with ALT + =
0:13:38 - 0:15:32 Testing different hypothesis
0:15:32 - 0:17:07 Trick Objectives Summary
? Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
======================
Thank you for your support ??? !!!
======================
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial
...
https://www.youtube.com/watch?v=0EH7gFhQhqM
How to Use AutoFill in Excel | Excel A to Z #24
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ Subtitles Available in 12 languages
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
What is Excel AutoFill?
Excel has a feature that helps you automatically enter data.
If you are entering a predictable series (e.g. 1, 2, 3…; days of the week; hours of the day) you can use the AutoFill command to automatically extend the sequence.
You can also use this for formulas – set up the formula once, then use the AutoFill to propagate it to the other cells.
In this session we see some examples on how to use the AutoFill features in Excel.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
??♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE ? https://bit.ly/3cQUVZZ
? DOWNLOAD the Exercise file and solution for this video here ?
SUPPORT THE CHANNEL
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
?Teespring Merch&Books ? https://bit.ly/3S1fa7n
Social Media / Contact us
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
?Dexcelo on TikTok ? https://bit.ly/3JgslNU
? Business Inquiries ? dexcelo03@gmail.com
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:01:23 Intro & Objectives
0:01:23 - 0:14:40 AutoFill Examples
0:14:40 - 0:15:15 Objectives Summary
? Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support ??? !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial
...
https://www.youtube.com/watch?v=Eb5stnz_B3w
Using INDEX and MATCH in Excel | Excel Practice Case #24
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ Subtitles Available in 12 languages
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
? In this Excel Practice Case you will learn how to:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Understand the MATCH function
Understand the INDEX function
Use VLOOKUP to return value in the right column
Use INDEX and MATCH to return value in right Column
Use INDEX and MATCH to return value in Left Column
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
??♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE ? https://bit.ly/3cQUVZZ
? DOWNLOAD the Exercise file and solution for this video here ?
SUPPORT THE CHANNEL
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
?Teespring Merch&Books ? https://bit.ly/3S1fa7n
Social Media / Contact us
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
?Dexcelo on TikTok ? https://bit.ly/3JgslNU
? Business Inquiries ? dexcelo03@gmail.com
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:02:56 Intro & Objectives
0:02:56 - 0:05:56 Using VLOOKUP
0:05:56 - 0:17:02 Using INDEX and MATCH
0:17:02 - 0:19:11 Objectives Summary
? Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support ??? !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial
...
https://www.youtube.com/watch?v=4CTu0SIQl3Q
Using the Excel IF function | Excel Practice Case #19
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this practice case we explore the use of the IF function in a live example.
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
??♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE ? https://bit.ly/3cQUVZZ
? DOWNLOAD the Exercise file and solution for this video here ?
SUPPORT THE CHANNEL
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
?Teespring Merch&Books ? https://bit.ly/3S1fa7n
Social Media / Contact us
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
?Dexcelo on TikTok ? https://bit.ly/3JgslNU
? Business Inquiries ? dexcelo03@gmail.com
? In this course you will learn how to:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Join text using CONCATENATE
- Join text using JOINTEXT function
- Join text using the "&"
- Use the IF function to extract the order number
- Make the extraction interactive according to country selection
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:02:40 Intro & Objectives
0:02:40 - 0:08:23 Joining Text
0:08:23 - 0:12:12 Using IF function and simulation
0:12:12 - 0:13:40 Objectives Summary
? Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support ??? !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial
...
https://www.youtube.com/watch?v=NvFIXMfpJv0
Excel start screen | Excel A to Z #03 إتعلم إكسل من الصفر مع دكسلو
Start screen is the first screen of Excel, when you open Excel application.
??♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE ? https://bit.ly/3cQUVZZ
SUPPORT THE CHANNEL
======================
?Teespring Merch&Books ? https://bit.ly/3S1fa7n
Social Media / Contact Me
======================
?Dexcelo on TikTok ? https://bit.ly/3JgslNU
? Business Inquiries ? dexcelo03@gmail.com
? In this course you will learn how to:
======================
- Excel Shortcuts
- Microsoft Excel Help Center
======================
✏️ Course developed by Dexcelo.
======================
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
======================
0:00:00 - 0:00:20 Intro
0:00:20 - 0:04:28 The quick access toolbar
0:04:28 - 0:04:32 Outro
? Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
⚈ Microsoft Excel Shortcuts https://bit.ly/3OY0p2h
======================
Thank you for your support ??? !!!
======================
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial
...
https://www.youtube.com/watch?v=hhrP0Upws8Q