Excel A to Z mashup #1 (session 1 to 16)
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
4
views
Hide cells with custom formatting in Excel #exceltips #learnexcel #excel #microsoft #shortcuts
Hide cells with custom formatting in Excel #exceltips #learnexcel #excel #microsoft #shortcuts
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
1
view
Create your first workbook in excel | Excel A to Z #16 إتعلم إكسل من الصفر مع دكسلو
Create your first workbook in excel | Excel A to Z #16 إتعلم إكسل من الصفر مع دكسلو
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template.
In this lesson we explore how to create a workbook. To do so you need to:
1- Open Excel.
2- Select Blank workbook or press Ctrl+N.
3- Start typing.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ 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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
1- Open Excel.
2- Select Blank workbook or press Ctrl+N.
3- Start typing.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:00:30 Intro
0:00:30 - 0:03:43 Course conventions
0:03:43 - 0:04:27 Course objectives
0:04:27 - 0:07:05 Creating your first workbook
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial
How to freeze headers in Excel #excel #exceltips #learnexcel #shortcuts #microsoft
How to freeze headers in Excel #excel #shortcuts #excelshortcuts #exceltips #learnexcel
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
Dialog boxes and task panes in Excel | Excel A to Z #15 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
Dialog boxes and task panes in Excel | Excel A to Z #15 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video we explore the dialog boxes and task panes in Excel.
A dialog box in Excel is a screen where you input information and make choices about different aspects of the current worksheet or its content, such as data, charts, and graphic images.
The Task Pane is a rectangular window that appears docked on the right side of your Excel window. It acts as an open menu allowing you to select from a range of commands and functions. It displays a list of links and commands allowing you to perfrom different tasks depending on what you are doing at the time.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ 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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- The types of dialog boxes in Excel
- Task panes in Excel
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:01:36 Intro & Objectives
0:01:36 - 0:04:09 Dialog boxes
0:04:09 - 0:10:08 Task Panes
0:10:08 - 0:10:49 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
How to find format in Excel | Excel Practice Case #16 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to find format in Excel | Excel Practice Case #16 إتعلم حيل إكسل مع دكسلو 🇹🇳
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Excel’s Find and Replace features can find and/or replace formatting in addition to text and information. Use the Find and Replace Formatting option when you want to change all instances of a particular formatting choice at once.
In this video we explore how to use this feature.
The following steps help you make understand how this works:
Step 1: Go to Home Tab then Editing group then Find and select then Find or simply hit shortcut combo Ctrl+F
Step 2: In the dialogue box click options button and additional options will be enabled.
Step 3: Just at the right of Find what field you have preview box and on the right of it you can find format button. Click on the downward pointing arrow
Step 4: If you already have a cell that contains the format that you want to include in find results then click choose format from cell. The dialogue box will disappear and cursor will change to dropper. Click on the cell from which you want to inherit the formatting. Once clicked, find dialogue reappears with preview box displaying the formatting inherited.
In case if you do not have formatting in any cell then you can specify your own by clicking format button itself instead of clicking drop down arrow.
Step 5: Add in the text, number or value you want to find within those cells that has format specified and click find all or find next button. If you left find what field empty then excel will find all such boxes that has specified formatting.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ 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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Use CTRL + F to open the find dialog box
- Use the option button to find formatting
- Find the cells that contains the formatting and select them all with the shortcut CTRL + A
- Find the SUMIF Function using the the find option
- Find the COUNTIF Function using the the find option
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:01:23 Intro & Objectives
0:01:23 - 0:07:00 Using the find format option
0:07:00 - 0:11:30 Finding SUMIF and COUNTIF Functions
0:11:30 - 0:12:46 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
2
views
How to remove empty rows #excel #shortcuts #excelshortcuts #exceltips #learnexcel #microsoft
How to use remove empty rows #excel #shortcuts #excelshortcuts #exceltips #learnexcel
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
2
views
When to use text to column in excel | Excel Practice Case #15 إتعلم حيل إكسل مع دكسلو 🇹🇳
When to use text to column in excel | Excel Practice Case #15 إتعلم حيل إكسل مع دكسلو 🇹🇳
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video we explore the use of the text to columns command in Excel to convert CSV values into columns.
When data is imported into Excel it can be in many formats depending on the source application that has provided it.
For example, it could contain names and addresses of customers or employees, but this all ends up as a continuous text string in one column of the worksheet, instead of being separated out into individual columns e.g. name, street, city.
You can split the data by using a common delimiter character. A delimiter character is usually a comma, tab, space, or semi-colon. This character separates each chunk of data within the text string.
A big advantage of using a delimiter character is that it does not rely on fixed widths within the text. The delimiter indicates exactly where to split the text.
You may need to split the data because you may want to sort the data using a certain part of the address or to be able to filter on a particular component. If the data is used in a pivot table, you may need to have the name and address as different fields within it.
This Excel functionality Text-to-columns can be used to split text in a cell into sections based on a delimiter character.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ 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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Understand the CSV values which stands for a comma-separated values (CSV) file is a delimited text -file that uses a comma to separate values.
- Use the CTRL + Shift + Down arrow to highlight the whole CSV Data
- Use the text-to-column command under data tab, data tools group
- Use ALT + A + E shortcut to open text-to-column
- Set the parameters in the text-to-column window that best describes your data
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:02:00 Intro & Objectives
0:02:00 - 0:03:30 Finding the Text to Columns command
0:03:30 - 0:11:07 Understanding the Text to Columns wizard
0:11:07 - 0:11:51 Applying the Text to columns
0:11:51 - 0:13:38 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
3
views
Excel KeyTips and shortcut menu - Excel A to Z | #14 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
Excel KeyTips and shortcut menu - Excel A to Z | #14 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video we Excel's KeyTips and Shortcut menu.
KeyTips are sometimes known as access keys or accelerators and are used as shortcut key combinations that activate controls. KeyTips appear on the Ribbon when you press the ALT key. If your KeyTip conflicts with KeyTips for built-in controls or from other add-ins, Microsoft Office might assign non-conflicting KeyTip values automatically.
Shortcut menus provide a quick way to access the commands that you are most likely to want. These menus are context sensitive so depending on where your cursor is located will depend on the menu that gets displayed. All shortcut menus are divided into small sections (or groups) separated by horizontal lines. These are used as an indication to the commands original location on the Menu Bar. A shortcut menu is not a comprehensive list of the commands that are available and will sometimes not display the command you are looking for.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ 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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Excel KeyTips
- Excel shortcut menu
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:00:23 Intro
0:00:23 - 0:04:12 KeyTips
0:04:12 - 0:06:10 Shortcut menu
0:06:10 - 0:06:29 Outro
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial
How to extract the day in Excel #excel #excelshortcuts #learnexcel #exceltips #shortcuts #microsoft
How to extract the day in Excel #excel #excelshortcuts #learnexcel #exceltips #shortcuts #microsoft
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
How to use the COUNTIF and SUMIF function in Excel #14 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to use the COUNTIF and SUMIF function in Excel #14 إتعلم حيل إكسل مع دكسلو 🇹🇳
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ 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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:02:33 Intro & Objectives
0:02:33 - 0:05:58 Use CONCATENATE with space
0:05:58 - 0:09:07 Use Ampersand instead of CONCATENATE
0:09:07 - 0:11:00 Paste value
0:11:00 - 0:13:40 Objectives Summary
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#excel #اكسل #microsoft #learning
2
views
Excel practice cases mashup #1 (Practice cases 1 to 16)
Excel practice cases mashup #1 (Practice cases 1 to 16)
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ 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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Joining two cells in one cell
- Use the concatenate formula to join the text strings and add space in between
- Use the "&" instead of concatenate
- Paste full names as values shortcut CTRL + ALT + V + V
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
#excel #اكسل
2
views
How to use DATEDIF Function #excel #shortcuts #excelshortcuts #learnexcel #exceltips #ytshorts
How to use DATEDIF Function #excel #shortcuts #excelshortcuts #learnexcel #exceltips #ytshorts
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 🙏🙏🙏 !!!
1
view
Ribbon tabs and commands in ms excel - Excel A to Z | #10 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
Ribbon tabs and commands in ms excel - Excel A to Z | #10 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Microsoft Excel ribbon is the row of tabs and icons at the top of the Excel window that allows you to quickly find, understand and use commands for completing a certain task. It looks like a kind of complex toolbar, which it actually is.
Excel Commands
In Excel, commands have the following characteristics:
- They perform actions in the same way that users do.
- They can do anything a user can do (subject to the limits of the interface used), such as altering Excel settings, opening, closing, and editing documents, initiating recalculations, and so on.
- They can be set up to be called when certain trapped events occur.
- They can display dialog boxes and interact with the user.
- They can be linked to control objects so that they are called when some action is taken on that object, such as left-clicking.
- They are never called by Excel during a recalculation.
-They cannot be called by functions during a recalculation.
A contextual tab is a hidden tab control in the Office ribbon that is displayed in the tab row when a specified event occurs in the Office document. For example, the Table Design tab that appears on the Excel ribbon when a table is selected.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ 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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Excel ribbon
- Different types of buttons
- Excel Tabs
- Excel contextual tabs
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:00:10 Intro
0:00:10 - 0:01:10 Ribbon and Tabs
0:01:10 - 0:04:57 Button types
0:04:57 - 0:08:25 Contextual Tabs
0:08:25 - 0:08:34 Outro
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#Ribbontabsandcommandsinmsexcel #excel #اكسل #concatenate
3
views
Using ROW Function in Excel #excel #shortcuts #excelshortcuts #exceltips #learnexcel
Using ROW Function in Excel #excel #shortcuts #excelshortcuts #exceltips #learnexcel
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
#howtoconcatenatewithampersand #excel #اكسل #learnexcel #proper
1
view
TRIM function in Excel (nested in VLOOKUP) | Excel Practice Case #13
TRIM function in Excel (nested in VLOOKUP) | Excel Practice Case #13
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
When you insert a function as one of the arguments within another function in Excel, it’s called nesting functions.
What is nesting?
Nesting refers to using a function as one of the arguments inside another function.
When do you use nesting?
Nesting functions is useful when you need to make several calculations to get to your desired answer, but don’t need to see the results of those steps as you go.
In this practice case we see how to nest a TRIM function in a VLOOKUP using a very simple example.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ 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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Use VLOOKUP when you need to find things in a table or a range by row.
- When you insert a function as one of the arguments within another function in Excel, it's called nesting functions.
- TRIM helps remove the extra spaces in data and thus clean up the cells in the worksheet.
- Use TRIM nested in VLOOKUP
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:02:33 Intro & Objectives
0:02:33 - 0:05:14 Use VLOOKUP function
0:05:14 - 0:11:07 TRIM nested in a VLOOKUP
0:11:07 - 0:13:54 Objectives Summary
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#concatenatefunctionwithspace #excel #اكسل #concatenate
3
views
How to use the AutoSum feature in Excel | #01 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to use the AutoSum feature in Excel | Excel Practice Case #01
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
🙋🏼♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3SnY8ke
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:
======================
- name a range of cells
- name a table
- use a named cell and a named range in a formula
- use VLOOKUP formula
- testing the efficacy of the VLOOKUP formula by changing the referenced cells
- import and export data,
- Learn multiple shortcuts
======================
✏️ Course developed by Dexcelo.
======================
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
======================
0:00:00 - 0:01:33 Intro
0:01:33 - 0:02:38 Naming a range of data
0:02:38 - 0:06:11 Data Validation
0:06:11 - 0:11:36 VLOOKUP Function
0:11:36 - 0:13:00 Testing the data validation and the VLOOKUP
0:13:00 - 0:18:16 Trick Objectives Summary
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
9
views
How to use the Flash Fill in Excel #excel #shortcuts #exceltips #learnexcel #ytshorts
How to use the Flash Fill in Excel #excel #shortcuts #exceltips #learnexcel #ytshorts
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
#howtoconcatenatewithampersand #excel #اكسل #learnexcel #proper
2
views
Moving around an Excel worksheet | #12 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
Moving around an Excel worksheet | #12 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Excel worksheets
An Excel worksheet is a grid of cells. It can contain data, tables, charts, etc.
Learn how to quickly and efficiently navigate within an Excel spreadsheet by using some keyboard shortcuts and other Excel features. When working with a large spreadsheet, it can be easy to get lost or to have problems quickly getting to the end or beginning of your spreadsheet. These Excel tips and tricks will help you out with this issue.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ 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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Navigate within an Excel worksheet
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:00:33 Intro
0:00:33 - 0:04:40 Moving around an Excel worksheet
0:04:40 - 0:04:51 Use Ampersand instead of CONCATENATE
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#,movingaroundanexcelworsheet #excel #اكسل #navigate #navigateexcel
2
views
How to concatenate with Ampersand in Excel #excel #exceltips #excelshortcuts #ytshorts
How to use the MID function in Excel #excel #exceltips #shorts #ytshorts
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
#howtoconcatenatewithampersand #excel #اكسل #learnexcel #proper
1
view
How to calculate different types of averages in Excel
How to calculate different types of averages in Excel #12 إتعلم حيل إكسل مع دكسلو 🇹🇳
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video we use the Average, Median and the Mode functions in Excel
The average median mode are measurements of central tendency. In other words, it tells you where the “middle” of a data set it. Each of these statistics defines the middle differently:
1- The average is the average of a data set.
2- The mode is the most common number in a data set.
3- The median is the middle of the set of numbers.
Of the three, the mean is the only one that requires a formula. I like to think of it in the other dictionary sense of the word (as in, it’s “mean” as opposed to nice!). That’s because, compared to the other two, it’s not as easy to work with because of the formula.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3Rh81Pf
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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Use three types of averages
- Name a range and use it in the average functions
- Use the AVERAGE Function to return the average value
- Use the MEDIAN Function to return the the value in the middle
- Use the MODE Function to return the most frequent value
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:01:10 Intro & Objectives
0:01:10 - 0:02:18 Hiding the Ribbon
0:02:18 - 0:04:27 Naming a data range
0:04:27 - 0:06:30 Average Function
0:06:30 - 0:07:40 Median Function
0:07:40 - 0:11:07 Difference between average and median
0:11:07 - 0:13:00 Mode Function
0:13:00 - 0:17:00 Three types of averages
0:17:00 - 0:18:58 Practice case objectives summary
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#Howtocalculatedifferenttypesofaverages #excel #اكسل #concatenate
1
view
How to use the MID function in Excel - Excel Shorts #excel #exceltips #shorts #ytshorts
How to use the MID function in Excel #excel #exceltips #shorts #ytshorts
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
#howtousethemidfunction #excel #اكسل #learnexcel #proper
2
views
Weclome to Dexcelo !!
Welcome to Dexcelo ! It's great to have you here!
In this channel you will find weekly tutorials for Excel and other data analysis tools from Beginner to Advanced, including practice cases and downloadable Excel files and pdf notes.
Hopefully these videos will help you to become AWESOME with Excel so you can save time at work and become more productive.
I love to learn new tools and techniques and share these with you. I hope to inspire you to experiment and share with others.
Regards,
Dexcelo
1
view