Essential parts of excel interface
Essential parts of excel interface | #11 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
Some parts of the Excel window (such as Ribbon and scroll bars) are standard in most other Microsoft programs. However, other features are more specific to spreadsheets, like the formula bar, worksheet tabs, and name box.
The following are the basic parts of the Microsoft Excel Window:
Quick Access Toolbar
File Tab
Title Bar
Control Buttons
Menu Bar
Ribbon/Toolbar
Dialog Box Launcher
Name Box
Formula Bar
Scroll Bars
Spreadsheet Area
Leaf Bar
Column Bar
Row Bar Cells
Cells
Status Bar
View Buttons
Zoom control
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE 👉 https://bit.ly/3Cd7tpa
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:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video we explore the essential parts of Excel interface.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:00:30 Intro & Objectives
0:00:30 - 0:07:30 Basic parts of Excel interface
0:07:30 - 0:07:45 Outro
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#Essentialpartsofexcelinterface #excel #اكسل #excelbeginner
1
view
How to use the PROPER function in Excel #excel #exceltips #shorts #ytshorts
How to use the PROPER 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
#howtousetheproperfunction #excel #اكسل #learnexcel #proper
1
view
Concatenate function with space in Excel | #11 إتعلم حيل إكسل مع دكسلو 🇹🇳
Concatenate function with space in Excel | Excel Practice Case #11
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
The word CONCATENATE means to join or combine. The CONCATENATE function in Excel is used to combine the text from different cells into one cell.
How to combine data using the CONCATENATE function (Best Method)
1 - Choose the cell in which the combined data should be placed.
2 - Enter the type =CONCAT(.
3 - The first step is to select the cell you would like to combine.
4- If you want to add spaces, commas, or other text, use quotation marks to distinguish the cells you are combining.
5 - Enter the formula after closing it with a parenthesis.
6 - Formula Example =CONCATENATE(A2, "Excel").
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3pJVurI
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 ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
#concatenatefunctionwithspace #excel #اكسل #concatenate
1
view
How to use the LEFT Function in Excel #shorts #ytshorts #exceltips
How to use the LEFT function in Excel - Excel Shorts
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
#howtousetheleftfunction #excel #اكسل #learnexcel #customformatting
How to use VLOOKUP with multiple rows in Excel | #10 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to use VLOOKUP with multiple rows in Excel | Excel Practice Case #10
VLOOKUP is one of the lookup and reference functions in Excel and Google Sheets used to find values in a specified range by “row”. It compares them row-wise until it finds a match.
In this practice case we see how to use VLOOKUP in multiple cells at once.
🙋🏼♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3PpmtDb
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:
======================
- How to use the Vlookup Function
- Understand absolute and relative cell reference
- Use the $ sign to navigate between absolute and relative cell reference
- Copy formula and change only the necessary arguments
======================
✏️ Course developed by Dexcelo.
======================
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
======================
0:00:00 - 0:02:15 Intro
0:02:15 - 0:05:01 Understand absolute and relative cell reference
0:05:01 - 0:08:24 Use VLOOKUP in multiple rows with absolute cell reference
0:08:24 - 0:10:58 Change one argument in the VLOOKUP
0:10:58 - 0:13:37 Practice Case Objectives Summary
🔗 Useful Links
======================
⚈ Microsoft Excel Help Centre https://bit.ly/3Q99vu8
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#HowtouseVLOOKUPwithmultiplerows #vlookup #naming #excel #اكسل #excelvlookup
3
views
Why is excel important for your career - Excel A to Z | #10 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
Why is excel important for your career - Excel A to Z
Microsoft Excel is one of the most significant computer programs because of the key role it plays in many sectors. It is the most widely used spreadsheet program in many corporate, classwork and even personal data organization. The initial version of Excel was introduced in 1985. It has been used to execute formula-based arithmetic and calculations and other tasks that may need mathematical calculation.
Excel has been popular among corporations, individuals, and institutions due to its versatility and ability to act as a visual basic for various applications. MS Excel's relevance may be observed in the various departmental units where it is used, as seen below:
1- Data organization
2- Graphing
3- Programming
🙋🏼♂️ 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:10 Intro
0:00:10 - 0:04:58 Different uses of Excel
0:04:58 - 0:05:07 Outro
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
⚈ Microsoft Excel Shortcuts https://bit.ly/3OY0p2h
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#Whyisexcelimportantforyourcareer #excel #اكسل #shortcuts #excelshortcuts #exceluse
1
view
Learn dates functions in Excel | #09 إتعلم حيل إكسل مع دكسلو 🇹🇳
Learn dates functions in Excel | Excel Practice Case #09
The DATE function creates a date using individual year, month, and day arguments. Each argument is provided as a number, and the result is a serial number that represents a valid Excel date. Apply a date number format to display the output from the DATE function as a date.
🙋🏼♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3Qd3gGi
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:
======================
- How to use the day function
- Extract the day name using the TEXT Function
- Use the month function
- Extract the month name using the TEXT Function
- Use the year function cells
======================
✏️ Course developed by Dexcelo.
======================
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
======================
0:00:00 - 0:00:20 Intro
0:00:20 - 0:02:10 How to use the DAY function
0:02:10 - 0:06:44 Return the day name using the TEXT Function
0:06:44 - 0:08:00 How to use the MONTH function
0:08:00 - 0:10:07 Return the month name using the TEXT Function
0:10:07 - 0:11:08 How to use the YEAR function
0:11:08 - 0:14:27 Practice Case Summary
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#learndatesfunctions #excel #اكسل #excelfunctions #customformatting #monthfunction #yearfunction
How to clear format in Excel | #08 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to clear format in Excel | Excel Practice Case #08,
To clear formatting just do the following:
1- Select the cell or range of cells from which you want to clear formatting.
2- On the Home tab, in the Editing group, click the arrow next to the Clear button.
3- Select the Clear Formats option.
🙋🏼♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3JBAAUT
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:
======================
- How to clear format
- How to clear content
- How to use the format painter
- Use the shortcuts for Undo and Redo
======================
✏️ Course developed by Dexcelo.
======================
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
======================
0:00:00 - 0:00:38 Intro
0:00:38 - 0:01:35 Clear Format
0:01:35 - 0:02:21 Use the Format Painter
0:02:21 - 0:03:10 Clear Format and Use Undo and Redo commands
0:03:10 - 0:04:05 Use Undo and Redo commands
0:04:05 - 0:05:03 Practice Case Objectives' Summary
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#howtoclearformatinexcel #excel #exceltutorial #formatpainterexcel
How to Use Conditional Formatting with a formula in Excel | #07 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to Use Conditional Formatting in Excel | Excel Practice Case #07
Conditional formatting is a feature of many spreadsheet applications that allows you to apply special formatting to cells that meet certain criteria. It is most often used to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.
🙋🏼♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3zr9riA
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:
======================
- Explore the conditional formatting dialog box
- Add a formula as a condition for formatting
- Test the conditional formatting formula
======================
✏️ Course developed by Dexcelo.
======================
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
======================
0:00:00 - 0:00:55 Intro
0:00:55 - 0:02:35 Conditional formatting dialog box
0:02:35 - 0:07:15 Conditional formatting using a formula
0:07:15 - 0:09:38 Testing the Conditional Formatting
0:09:38 - 0:11:30 Trick Objectives Summary
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#howtouseconditionnalformatting #excel #اكسل
3
views
What are Excel Shortcuts - Excel A to Z | #09 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
What are Excel Shortcuts - Excel A to Z
An often-overlooked method of increasing productivity when working in an Excel model is to use Excel shortcuts, or shortcut keys. These shortcut keys perform major functions that, when used instead of clicking in the toolbar, dramatically increase efficiency and speed.
🙋🏼♂️ 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:00:51 Microsoft Help Center
0:00:51 - 0:01:51 Explaining shortcuts
0:01:51 - 0:02:01 Outro
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
⚈ Microsoft Excel Shortcuts https://bit.ly/3OY0p2h
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#whatareexcelshortcuts #shortcuts #excelshortcuts #excel #اكسل
1
view
How to Use VLOOKUP function and name a data range in Excel | #06 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to Use VLOOKUP function and name a data range in Excel | Excel Practice Case #06
VLOOKUP stands for 'Vertical Lookup'. It is a function that makes Excel search for a certain value in a column (the so called 'table array'), in order to return a value from a different column in the same row. This video will teach you how to use the VLOOKUP function, name a range of data and we use the data validation tool to limit entries in one cell.
🙋🏼♂️ 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
#howtousevlookupfunction #vlookup #naming #excel #اكسل
5
views
How to use the sum function in Excel and currency Formatting | #05 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to use the sum function in Excel and Currency Formatting | Excel Practice Case #05
In this Excel trick we learn how to enter data in multiple cells, apply currency formatting and add a sum function using shortcuts.
The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10. =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
🙋🏼♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3p6wgUl
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:
======================
- Highlight data range and use CTRL + Enter shortcut
- Apply currency formatting
- Use the ALT + = shortcut for auto sum
- use CTRL + SHIFT + $ to apply currency formatting
======================
✏️ Course developed by Dexcelo.
======================
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
======================
0:00:00 - 0:00:27 Intro
0:00:27 - 0:01:25 Highlight data range and use CTRL + Enter shortcut
0:01:25 - 0:02:13 Use the ALT + = shortcut for auto sum
0:02:13 - 0:02:46 use CTRL + SHIFT + $ to apply currency formatting
0:02:46 - 0:04:14 Trick Objectives Summary
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#sum #sunfunction #excel #اكسل
1
view
How to use the average function in excel and go to special | #04 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to use the average function in excel and go to special | Excel Practice Case #04
In this video we illustrate the use of the average function and the Go To Special dialog box.
Excel provides a dedicated dialog box to access special groups of cells, called "Go To Special". To access this dialog with the keyboard, type Control + G, then click the Special button (or use Alt + S) on Windows. There you'll find a large list of options.
The AVERAGE Function is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. The function is used to calculate the arithmetic mean of a given set of arguments in Excel.
🙋🏼♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3OQknMt
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:
======================
- CTRL + ENTER to populate all cells with the Average Function
- Go To (F5) Shortcut, Special, Blanks to highlight all blank cells
- CTRL + Enter to put zero in all selected cells
- Average function uses Zeros in the calculations but not blanks
======================
✏️ Course developed by Dexcelo.
======================
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
======================
0:00:00 - 0:01:15 Intro
0:01:15 - 0:05:14 Using the average function
0:05:14 - 0:07:01 Go To Special
0:07:01 - 0:09:27 Objectives Summary
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#howtousetheaveragefunction #average #averagefunction #excel #اكسل #gotospecial
1
view
How to use formula reference in excel | #03 إتعلم حيل إكسل مع دكسلو 🇹🇳
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:
======================
- 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: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
#howtouseformulareference #formula #formulareference #excel #اكسل
7
views
How to customize the ribbon in Excel - Excel A to Z | #08 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
How to customize the ribbon in Excel - Excel A to Z
Most customizations to the Excel ribbon are done in the Customize the Ribbon window, which is part of Excel Options. So, to start customizing the ribbon, do one of the following: Go to File then Options then Customize Ribbon.
🙋🏼♂️ 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:40 Intro
0:00:40 - 0:05:51 Customize the Ribbon
0:05:51 - 0:06:26 Outro
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
⚈ Microsoft Excel Shortcuts https://bit.ly/3OY0p2h
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#Howtocustomizetheribbon #ribbon #shortcuts #excelshortcuts #excel #اكسل
1
view
How to use the quick access toolbar in excel - Excel A to Z | #07 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
How to use the quick access toolbar in excel - Excel A to Z
The Quick Access Toolbar is a command line that appears either above or below the main ribbon tabs in Excel, PowerPoint and Word. The Quick Access Toolbar grants direct (quick) access to a set of desired commands in a toolbar that is always visible no matter which ribbon tab is selected.
🙋🏼♂️ 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:02:30 The quick access toolbar
0:02:30 - 0:02:45 Outro
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
⚈ Microsoft Excel Shortcuts https://bit.ly/3OY0p2h
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#Howtousethequickaccesstoolbar #ribbon #shortcuts #excelshortcuts #excel #اكسل
2
views
How to save a file in Excel - Excel A to Z | #06 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
How to save a file in Excel - Excel A to Z
How to Save Workbooks in Excel
1- Click the Save button. Press Ctrl + S to quickly save a workbook. ...
2- Choose where you want to save your file: OneDrive: Save to Microsoft's cloud-based storage so 3- you can open the worksheet on another computer. ...
4- Enter a file name.
5- Click Save.
🙋🏼♂️ 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:02:00 How to save a file in Excel
0:02:00 - 0:02:08 Outro
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
⚈ Microsoft Excel Shortcuts https://bit.ly/3OY0p2h
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#Howtosaveafileinexcel #ribbon #shortcuts #excelshortcuts #excel #اكسل
1
view
Interface Excel walkthrough Part 2 - Excel A to Z | #05 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
Interface Excel walkthrough Part 2 - Excel A to Z
The Excel interface revolves around the ribbon, which is the strip of controls across the top section of the application window. The ribbon is comprised of tabs, which contain groups of controls, and this terminology is used to identify the location of tools.
🙋🏼♂️ 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:08:30 The quick access toolbar
0:08:30 - 0:08:38 Outro
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
⚈ Microsoft Excel Shortcuts https://bit.ly/3OY0p2h
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#excelinterface #ribbon #shortcuts #excelshortcuts #excel #اكسل
1
view
How to use the sumif function in Excel | #02 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to use the sumif function in Excel | Excel Practice Case #02
In this video we illustrate the use of the VLOOKUP function, name a range of data and we use the data validation tool to limit entries in one cell.
🙋🏼♂️ 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
5
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
3
views
Interface Excel walkthrough Part 1 - Excel A to Z | #04 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
Interface Excel walkthrough Part 1 - Excel A to Z
The Excel interface revolves around the ribbon, which is the strip of controls across the top section of the application window. The ribbon is comprised of tabs, which contain groups of controls, and this terminology is used to identify the location of tools.
🙋🏼♂️ 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:05:00 The quick access toolbar
0:05:00 - 0:05:17 Outro
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
⚈ Microsoft Excel Shortcuts https://bit.ly/3OY0p2h
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#excelinterface #ribbon #shortcuts #excelshortcuts #excel #اكسل
1
view
Excel start screen - Excel A to Z | #03 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
Excel start screen - Excel A to Z
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
#excelstartscreen #ribbon #shortcuts #excelshortcuts #excel #اكسل
1
view
How to launch excel - Excel A to Z | #02 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
How to launch excel - Excel A to Z
To launch Excel Select Open in Desktop App at the top of your workbook. If you don't see it, there should be a search bar along the top of your workbook. In that search bar, type open, and then select Open in Desktop App.
🙋🏼♂️ 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:01:21 How to launch excel
0:01:21 - 0:01:31 Outro
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
⚈ Microsoft Excel Shortcuts https://bit.ly/3OY0p2h
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#howtolaunchexcel #shortcuts #excelshortcuts #excel #اكسل
1
view
Excel first lesson and introduction - Excel A to Z | #01 إتعلم إكسل من الصفر مع دكسلو 🇹🇳
Excel first lesson and introduction - Excel A to Z
MS-EXCEL is a part of Microsoft Office suite software. It is an electronic spreadsheet with numerous rows and columns, used for organizing data, graphically represent data(s), and performing different calculations.
🙋🏼♂️ 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:03:01 Excel first lesson and introduction
0:03:01 - 0:03:29 Outro
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
⚈ Microsoft Excel Shortcuts https://bit.ly/3OY0p2h
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#excelfirstlesson #shortcuts #excelshortcuts #excel #اكسل
1
view