Excel Basics for Beginners in Tamil

############################# Video Source: www.youtube.com/watch?v=BDjtyPYYGAQ

#Interview# #Questions# #Answers# #Excel# • This video will help to learn to solve top 10 basic excel interview questions and answers with practical. you will be able solve all these questions after watching this videos step by step explanation in Tamil • • Tricky Excel Interview Question Answer? • Create a custom list with the following names? • Get the current active workbook's file path location using a formula? • Insert a column after column H and write down the shortcut key? • Hide the entire rows from row 30 to 35 and write down the shortcut key? • Please Freeze the top first row • Protect only the Active Sheet? • Create a hyperlink in cell 'C9' to select sheet ? • Create a hyperlink in 'C11' to open https://www.google.com/ ? • Create a table with the below data and create slicer by Region • Hide the sheet name 'Hidden' by using 'Very Hidden' option • Transpose the Employee Ids to Row • From column 'D' highlight the values above 50 by using conditionla formatting. Highlight it in Green • From column 'F' highlight the duplicate values by using conditionla formatting. Highlight it in Red • • IF(Exact) • Unique Vs Duplicate • Remove Strikethrough • Find a Specific Value • Transponse Location Code Name • Find Average for multiple rows at a time • Bank Reconciliation (Debit Vs Credit) • Column Bar with Target • IF Condition with Symbol • Conditional Formating • Inserting Columns and Rows • Hide Rows and Columns • Hyperlins to open webpage • Slicers • What is Index Function? • How to use Index and Match Function? • Reverse Vlookup in Tamil • Please reach out for any support on the Ms Excel from basic to advanced level, VBA. Word, PowerPoint • Email: [email protected] • whatsapp - 9481829511

#############################

New on site