Shortcuts for Data Formatting in excel @Sharpenzo#tamil #exceltips
3:42
Shortcuts for Data Formatting in excel @Sharpenzo#tamil #exceltips
Searchable Dropdown List using data Validation @Sharpenzo#tamil
11:12
Searchable Dropdown List using data Validation @Sharpenzo#tamil
Dependent Dropdown List using data Validation @Sharpenzo#tamil
6:31
Dependent Dropdown List using data Validation @Sharpenzo#tamil
INDEX Match function to lookup values of categorywise monthly Sales @Sharpenzo#tamil
5:44
INDEX Match function to lookup values of categorywise monthly Sales @Sharpenzo#tamil
Dropdown List with Conditional Formatting using data Validation @Sharpenzo#tamil
9:01
Dropdown List with Conditional Formatting using data Validation @Sharpenzo#tamil
VLOOKUP Match function to lookup category based state wise Sales @Sharpenzo#tamil
5:48
VLOOKUP Match function to lookup category based state wise Sales @Sharpenzo#tamil
🛑👉INDEX function to lookup values of Highest & Lowest Sales @Sharpenzo#tamil
5:00
🛑👉INDEX function to lookup values of Highest & Lowest Sales @Sharpenzo#tamil
🛑👉DEGT function to lookup values in both direction reverse Vlookup @Sharpenzo#tamil
5:44
🛑👉DEGT function to lookup values in both direction reverse Vlookup @Sharpenzo#tamil
🛑👉Unique function to extract the values without duplicates@Sharpenzo#tamil
8:01
🛑👉Unique function to extract the values without duplicates@Sharpenzo#tamil
🛑👉Match function with Text to fine the cell address based on input @Sharpenzo#tamil
7:42
🛑👉Match function with Text to fine the cell address based on input @Sharpenzo#tamil
🛑👉Combine multiple sheets in excel with Query function for easy data consolidation @Sharpenzo#tamil
4:42
🛑👉Combine multiple sheets in excel with Query function for easy data consolidation @Sharpenzo#tamil
🛑👉Multi User Collaboration in Excel & Google Sheets Highlight user based changes @Sharpenzo#tamil
5:41
🛑👉Multi User Collaboration in Excel & Google Sheets Highlight user based changes @Sharpenzo#tamil
🛑👉Left Mid & Right function to extract Text from cell First name Last Name #excel @Sharpenzo#tamil
8:06
🛑👉Left Mid & Right function to extract Text from cell First name Last Name #excel @Sharpenzo#tamil
🛑👉Text Length & Data Validation to collect the length based text #excel @Sharpenzo#tamil
4:11
🛑👉Text Length & Data Validation to collect the length based text #excel @Sharpenzo#tamil
🛑👉Vlookup Function to the details from employee master data #excel @Sharpenzo#tamil
5:14
🛑👉Vlookup Function to the details from employee master data #excel @Sharpenzo#tamil
🛑👉Xlookup Function to Find the Sales & profit from Vertical/horizontal data #excel @Sharpenzo#tamil
7:18
🛑👉Xlookup Function to Find the Sales & profit from Vertical/horizontal data #excel @Sharpenzo#tamil
🛑👉Hlookup Function to Find the Employee/Student details from horizontal data #excel @Sharpenzo#tamil
5:13
🛑👉Hlookup Function to Find the Employee/Student details from horizontal data #excel @Sharpenzo#tamil
🛑👉CountIf & CountIfs Function to check student marks Present & absent #excel @Sharpenzo#tamil
6:02
🛑👉CountIf & CountIfs Function to check student marks Present & absent #excel @Sharpenzo#tamil
🛑👉Count, CountA & Count Blank Function check student marks Present & absent #excel @Sharpenzo#tamil
4:32
🛑👉Count, CountA & Count Blank Function check student marks Present & absent #excel @Sharpenzo#tamil
🛑👉PIE chart to visualise Quarterly Sale's #excel @Sharpenzo#tamil
8:30
🛑👉PIE chart to visualise Quarterly Sale's #excel @Sharpenzo#tamil
🛑👉Bar Graphs to visualize the data #excel @Sharpenzo
6:25
🛑👉Bar Graphs to visualize the data #excel @Sharpenzo
🛑👉 Line graph to visualise the Monthly sales trend #excel @Sharpenzo
10:19
🛑👉 Line graph to visualise the Monthly sales trend #excel @Sharpenzo
🛑👉Convert Date in text format to Date format with Datevalue Function #tamil #excel @Sharpenzo
4:30
🛑👉Convert Date in text format to Date format with Datevalue Function #tamil #excel @Sharpenzo
🛑👉🗓️Weekday Function to the day number of any date in week #tamil #excel @Sharpenzo
5:25
🛑👉🗓️Weekday Function to the day number of any date in week #tamil #excel @Sharpenzo
🛑👉Sequence function to to generate number automatically #tamil #excel @Sharpenzo
4:59
🛑👉Sequence function to to generate number automatically #tamil #excel @Sharpenzo
🛑👉🗓️Dynamic Calendar-Any month or Year with a single click #tamil #excel @Sharpenzo
8:23
🛑👉🗓️Dynamic Calendar-Any month or Year with a single click #tamil #excel @Sharpenzo
🛑👉IF AND function to Identify the employees eligible for promotion #tamil #excel @Sharpenzo
3:15
🛑👉IF AND function to Identify the employees eligible for promotion #tamil #excel @Sharpenzo
🛑👉IF OR function to find Incentive for Employees based on sales #tamil #excel @Sharpenzo
5:08
🛑👉IF OR function to find Incentive for Employees based on sales #tamil #excel @Sharpenzo
🛑👉IF AND function to find Pass/Fail #tamil #excel @Sharpenzo
4:42
🛑👉IF AND function to find Pass/Fail #tamil #excel @Sharpenzo
🛑👉Image function to insert image & use Dynamic filters #excel #tamil @Sharpenzo
4:49
🛑👉Image function to insert image & use Dynamic filters #excel #tamil @Sharpenzo