Sharpenz

Shortcuts for Data Formatting in excel @Sharpenzo#tamil #exceltips

Searchable Dropdown List using data Validation @Sharpenzo#tamil

Dependent Dropdown List using data Validation @Sharpenzo#tamil

INDEX Match function to lookup values of categorywise monthly Sales @Sharpenzo#tamil

Dropdown List with Conditional Formatting using data Validation @Sharpenzo#tamil

VLOOKUP Match function to lookup category based state wise Sales @Sharpenzo#tamil

🛑👉INDEX function to lookup values of Highest & Lowest Sales @Sharpenzo#tamil

🛑👉DEGT function to lookup values in both direction reverse Vlookup @Sharpenzo#tamil

🛑👉Unique function to extract the values without duplicates@Sharpenzo#tamil

🛑👉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

🛑👉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

🛑👉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

🛑👉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

🛑👉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

🛑👉PIE chart to visualise Quarterly Sale's #excel @Sharpenzo#tamil

🛑👉Bar Graphs to visualize the data #excel @Sharpenzo

🛑👉 Line graph to visualise the Monthly sales trend #excel @Sharpenzo

🛑👉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

🛑👉Sequence function to to generate number automatically #tamil #excel @Sharpenzo

🛑👉🗓️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

🛑👉IF OR function to find Incentive for Employees based on sales #tamil #excel @Sharpenzo

🛑👉IF AND function to find Pass/Fail #tamil #excel @Sharpenzo

🛑👉Image function to insert image & use Dynamic filters #excel #tamil @Sharpenzo