Dexcelo

Excel date and time format | Excel A to Z #21 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✅ Subtitles Available in 12 languages ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ In this session we learn that: Excel handles dates by using a serial number system. The earliest date that Excel is January 1, 1900 When you work with times, Excel works with times by using fractional days ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ 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:01:23 Intro & Objectives 0:01:23 - 0:06:42 Date Format 0:06:42 - 0:09:30 Time Format 0:06:42 - 0:10:24 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

Table Feature and Slicers in Excel | Excel Practice Case #22 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✅ Subtitles Available in 12 languages ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📊 In this Excel Practice Case you will learn how to: ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ - Use the table command to insert a Table - Use the shortcut CTRL + T to insert a Table - Name the Table: Video Games Sales - Duplicate one row and delete it using the remove duplicate command - Add total row to Global Sales - Use the slicer to apply a Nintendo Filter ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ 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:03 Intro & Objectives 0:01:23 - 0:05:44 Inserting a Table 0:05:44 - 0:06:59 Naming the Table 0:06:59 - 0:08:34 Removing Duplicates 0:08:34 - 0:09:55 Inserting total row 0:09:55 - 0:12:28 Slicer 0:12:28 - 0:14:01 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

Using SUMIFS and COUNTIFS in Excel | Excel Practice Case #21 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✅ Subtitles Available in 12 languages ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ SUMIF, SUMIFS, COUNTIF, and COUNTIFS are extremely useful and powerful for data analysis. If there was an Excel Function Hall of Fame, this family of functions ought to be included. In this Excel Practice case, I'll demonstrate the use of the SUMIFS and COUNTIFS function focusing mainly on all the different criteria types. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ 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 the SUMIFS Function to find the total order per country - Use the COUNTIFS Function to count the number of orders per country - Use the absolute and relative cell references when needed - Use the CTRL + Enter shortcut to paste the formulas - Insert a Pie Chart to present the total order amounts per country ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✏️ Course developed by Dexcelo. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00:00 - 0:03:28 Intro & Objectives 0:03:28 - 0:11:19 Using SUMIFS 0:11:19 - 0:15:56 Using COUNTIFS 0:15:56 - 0:17:06 Inserting a Pie Chart 0:17:06 - 0:18:56 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

Excel Data Types | Excel From A to Z #20 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✅ Subtitles available in 12 languages ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Excel data types are the four different kinds of values in Microsoft Excel. The four types of data are text, number, formulas and error. You may perform different functions with each type, so it's important to know which ones to use and when to use them. You may also consider that some data types may change when exporting data into a spreadsheet. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ 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: ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ - Excel numeric values - Excel text values - Excel fomulas - Excel erros ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✏️ Course developed by Dexcelo. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00:00 - 0:00:23 Intro & Objectives 0:00:23 - 0:02:38 Excel Data Types 0:02:38 - 0:08:20 Data types example 0:08:20 - 0:08:34 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

Combining VLOOKUP and IF function | Excel Practice Case #20 إتعلم حيل إكسل مع دكسلو ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✅ Subtitles Available in 12 languages ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ To use the IF and VLOOKUP functions together you should nest the VLOOKUP function inside the IF function. In this practice case we use a VLOOKUP function nested in an IF function. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ 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 to return the Qty Limit in column G - Use the IF function to apply the logical Test - Combine Vlookup with IF function to return the order value - Use CTRL + Enter to paste the formulas to column G - Test the function by simulating different values for Limit Price ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✏️ Course developed by Dexcelo. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00:00 - 0:03:00 Intro & Objectives 0:01:23 - 0:07:50 VLOOKUP 0:07:50 - 0:11:30 Nesting VLOOKUP in IF 0:12:35 - 0:14:16 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

Insert a column graph in Excel | Excel From A to Z #19 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✅ Subtitles available in 12 languages In this video we insert a simple column chart to represent the sales data from our table. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ 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: ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ - Insert a column graph ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✏️ Course developed by Dexcelo. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00:00 - 0:00:23 Intro & Objectives 0:00:23 - 0:04:30 Inserting a column graph 0:04:30 - 0:05:10 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

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

The anatomy of an Excel formula | Excel Everything Functions #01 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ In this video we explore the anatomy of an Excel formula. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ PLEASE SUBSCRIBE ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ 🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3DgAKj0 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) An Excel formula is an expression that returns a result. 2) This result can be a value (number, string, or Boolean), multiple values, or a range. 3) Excel formulas always begin with =. 4) A function is a prewritten expression 5) A function can be included as part of a formula. 6) There are 500+ functions in Excel 2021. 7) "Function follow the same syntax: =FunctionName(argument1, argument2, ...)" 8) Arguments are separated by a comma. 9) In regions where a comma is used as a decimal separator, a semicolon “;” is used as the function argument separator. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✏️ Course developed by Dexcelo. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00:00 - 0:00:20 Intro & Objectives 0:00:20 - 0:05:41 Anatomy of an Excel Formula 🔗 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 copy data from cells in Excel #excel #microsoft #microsoftexcel #office #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. 🙋🏼‍♂️ 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

Inserting your first table in Excel | Excel A to Z #18 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ In this video we explore the Excel table feature. To make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table (previously known as an Excel list). ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ 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: ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ - Select a data range - Insert a table - Edit a table ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✏️ Course developed by Dexcelo. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00:00 - 0:01:10 Selecting the data range 0:01:10 - 0:03:33 Inserting a table 0:03:33 - 0:04:41 Exploring the Table Design Tab 0:04:41 - 0:07:48 Editing the Table 🔗 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 fill blank cells in Excel #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. 🙋🏼‍♂️ 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 merge multiple cells in Excel with TEXTJOIN | Excel Practice Case #18 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ In this video we learn a new function TEXTJOIN, introduced in Excel 2016. The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. Until recently, there were two prevalent methods to merge cell contents in Excel: the concatenation operator and CONCATENATE function. With the introduction of TEXTJOIN, it seems like a more powerful alternative has appeared, which enables you to join text in a more flexible manner including any delimiter in between. But in truth, there's much more to it! ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ 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: ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ - Merge the full address in one cell - The TEXTJOIN function combines the text from multiple ranges - TEXTJOIN accepts a delimiter to use when joining values together - Use the TEXTJOIN function to merge the cells - Use the shortcut CTRL + D to paste the formulas to the below cells - TEXTJOIN is a more compact function than CONCATENATE ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✏️ Course developed by Dexcelo. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00:00 - 0:02:27 Intro & Objectives 0:02:27 - 0:06:42 Using TEXTJOIN 0:06:42 - 0:08:24 Using CTRL + D 0:08:24 - 0:10:24 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 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. 🙋🏼‍♂️ 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

Starting with your first table in Excel | Excel A to Z #17 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ In this video we create our first Excel table and explore the autofill feature in Excel. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ 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: ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ - Create your first table - Use the autofill Feature - Enter a formula - Apply the number formatting ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✏️ Course developed by Dexcelo. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00:00 - 0:01:12 Creating headers 0:01:12 - 0:02:59 Autofill Feature 0:02:59 - 0:04:39 Using a Formula 0:04:39 - 0:07:31 Number formatting 🔗 Useful Links ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Thank you for your support 🙏🙏🙏 !!! ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Tags #excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial

Calculate dates difference in Excel | Excel Practice Case #17 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ In this video, we practice date calculations, specifically the difference between the date of an event and today's date. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ PLEASE SUBSCRIBE ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ 🆓 DOWNLOAD the Exercise file and solution for this video here 👉https://bit.ly/3UYSvu5 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: ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ - Keyboard Shortcut For Today's Date Is Ctrl + ; - Calculate Days Between Dates = Later Date - Earlier Date. - Keyboard Shortcut to apply general formatting is Ctrl + Shift + ~ (tilde in español) - Add days to a date = Date Cell + Number Of Days Cell - Use TODAY the argumentless function =Today() - Use the leap year includes 365.25 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✏️ Course developed by Dexcelo. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00:00 - 0:02:27 Intro & Objectives 0:02:27 - 0:05:48 Exam date example 0:05:48 - 0:07:26 Loan payment example 0:07:26 - 0:10:35 Days alive example 0:10:35 - 0:12:24 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 fill blank cells in Excel #exceltips #learnexcel #excel #shortcuts #excelshortcut #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