29,436 views
#Excel_Tutorial#Choose_Excel#Excel#Choose_Function#Choose_Function Explanation of the Choose function, which is considered one of the most important Excel functions, as it allows you to choose from a set of options based on a specified reference number. We will also use it instead of some famous functions such as Vlookup and IF. We will also explain its use with dates. To download the work file: http://bit.ly/39TQO9g Previous videos The DGET function is one of the most powerful search functions in Excel DGET Function in Excel • The DGET function is one of the most powerful search functions in Excel... Explanation of using the Hlookup function with Match in Excel How to use Hlookup with Match in Excel • Explanation of the HLOOKUP horizontal search function in Excel... Explanation of the Slicer tool Advanced filter tool in Excel • Explanation of the Slicer tool Advanced filter tool... A detailed explanation of the opinion poll chart in Excel How to create a survey chart in excel • How to draw a survey chart ... Excel Function to Count Days in each Month • Excel Function to Count Days in each Month Explanation of the TRIM function and how to use it with the VLOOKUP function • Explanation of the TRIM function and how to use it with the D... Text Function in Excel Function to convert numeric values in Excel • Text Function in Excel Function to convert ... Cell Reference In Excel Explanation of reference cells in Excel • Learn how to fix the cell in Excel while writing... Consolidation Merging and grouping data in more than one sheet in Excel • Consolidation Merging and grouping data ... Protect Worksheet Protect a worksheet in Excel • How to protect a worksheet in Excel Exce... Subtotal Subtotal tool in Excel - Excel Online • Subtotal Subtotal tool in ... Advanced features and advantages of tables in Excel Excel Online • The importance of using Excel tables dynamically... Features and advantages of tables in Excel Tables Features in Excel • The most important features of tables in Excel ... Use CountIF Except a Value • Use CountIF Except a Value ... Function Today in Excel and its use to know the days remaining until a specific date • Function Today in Excel and its use ... A simple explanation of dealing with large data and making a summary of it by using pivot tables Pivot Tables • Pivot Tables Explanation... Explanation of advanced filtering in Excel Advanced Filter • Advanced Filter in Excel Explanation of the tool... A simple way to select and delete empty rows How to delete the Empty Rows Excel Online • The fastest way to select and delete empty rows... Search with more than one condition in Excel tables Lookup with multiple Criteria in Excel Tables Excel Online • Use the vlookup function to search with more than one... Prevent Values Duplication in Selected Column • Prevent Data Duplication in Excel Exce... How to select different cells in a column and row Select the Different Cells In Columns and Rows • How to select cells different from the column... Edit on more than one Excel Sheet At the same time - Apply Action on Multiple Sheets at the same time • Edit on more than one Excel Sheet In... Practical explanation of how to design Infographic Charts On Excel - Excel Online • How to draw a chart Infographic Ch... Explanation of the tool for dividing cell contents in Excel Text to Column Practical explanation - Excel Online • Explanation of text to columns in Excel how t... Drop-down list tool Data Validation List Explanation of entering list data https://bit.ly/2WAj1Mj The trick of copying formulas between tables in Excel without any change Copy Formulas between Tables in Excel https://bit.ly/32Vu4SQ The IF function and how to use it with the OR - AND function in Excel with practical explanation Excel Online https://bit.ly/2MHZLta Building dynamic drop-down lists using a function OFFSET and how to link more than one list https://bit.ly/31yZPPP Explanation of the function IF Error in Excel with its use to show more than one result - with practical explanation https://bit.ly/2MJaG4v Flash Fill The magic quick fill tool and how to use it to repeat the pattern of a cell - practical explanation https://bit.ly/2pcC42S Types of errors in Excel and how to solve them with a practical example for each error https://bit.ly/2MkvD5w A simple function that helps you create a random list in Excel, practical and simplified explanation https://bit.ly/2opGWB1 How to use the Max function with the If function to get the largest result with a condition https://bit.ly/2msxHjf NetworkDays NetworkDays.INTL A function to calculate the net number of working days between two dates, excluding holidays https://bit.ly/2mTQXWr A famous function in Excel that can be used to compare data between two columns!! With practical explanation https://bit.ly/2mueqxv Explanation of Circle Chart in Excel and how to write a Dynamic Text Box inside it Practical explanation Excel Online https://bit.ly/2lRMLGp Conditional Formatting of the row and column associated with the value of a merged cell in Excel with an example https://bit.ly/2m7SOqf Explanation of the variable domain function OFFSET and its most important features in Excel with practical examples for beginners Excel Online https://bit.ly/2kyL5RL Advanced dynamic search using the Index function with the Match function and its most important features with practical explanation in Excel https://bit.ly/2lzuz45 Explanation of using the Vlookup function with Match for dynamic search in large table data Practical explanation in detail https://bit.ly/2Zt4gjl Search for duplicate data and delete it Remove Duplicates in Excel Explanation https://bit.ly/2Zr3qDG Explanation of keyboard shortcuts in Excel Part Two The most important Its uses https://bit.ly/2NDJ3fp Explanation of keyboard shortcuts in Excel, part one, its most important uses https://bit.ly/2U14g42 Explanation of the Hookup function, its most important uses https://bit.ly/2Zg0LMP Explanation of the Vlookup function, its most important uses https://bit.ly/33OLtgB