How to create and Use Excel Macro explained in Tamil | Record, save and run a macro | Macros & VBA
Macros help you to save time on repetitive tasks involved in data manipulation and data reports that are required to be done frequently.
In this video, you can learn
Why a macro is required
How to create a macro, name, save and edit it.
How to get developer tab in Excel
Where to save macro and the file extension
Learn Excel in Tamil videos :
1. Introduction to Excel in Tamil - • Introduction to Excel in Tamil | #மைக்ரோசா...
2. Managing Worksheets - • Managing Excel worksheets in Tamil | Resi...
3. Cell Basics - • Excel Cell Basics in Tamil | Cut, Copy, P...
4. Fill Handle - • Excel Fill handle in Tamil| How to use fil...
5. Formulas and Functions Part I - • Excel Formulas and Functions | How to use ...
6. Find and Replace - • Excel - Find and Replace features | How to...
7. Goto and Goto Special - • Goto, GoTo Special explained in Tamil |How...
8. Cell Formatting - • Excel Cell formatting in Tamil | How to fo...
9. Page Layout - • Page layout in Excel | எக்ஸலில் பக்கம்வடிவ...
10. Comments - • Excel Comments in Tamil| எக்ஸலில் எப்படிசி...
11. What is Conditional formatting - • what is Excel Conditional formatting expl...
12. Built in Conditional formatting - • Built in Conditional formatting in Tamil |...
13. Conditional formatting rules - • Excel Conditional formatting rules in Tam...
14. Conditional formatting with formulas - • Excel Conditional formatting with Formula...
15. Excel Tables - • Excel Tables explained in Tamil #ExcelTabl...
16. Excel SubTotal function - • Excel SubTotal function explained in Tamil...
17. Excel SubTotal Command - • Excel SubTotal Command explained in Tamil ...
18. Excel Sorting - • Excel Sorting Data explained in Tamil #Exc...
19. Excel Filtering Data - • Excel Filtering data explained in Tamil #...
20. Excel Counting Functions - • Excel Five count functions explained in Ta...
21. Basics of Data Validation - • Basics of Data Validation in Excel explai...
22. Excel Drop down list and Dependent Drop Down List - • Excel Drop Down list and Dependent Drop Do...
23. Excel Data Validation for Dates - • Excel Data Validation for Dates | #ExcelDa...
24. Excel Vlookup - • What is Vlookup in Excel? |#VlookupExcel |...
25. Excel Hlookup() - • What is Hlookup in Excel? |#HlookupExcel |...
26. Excel if() - • Learn Excel IF function in Tamil |Simple I...
What does pivot table do in Excel? - • What does Pivot table do explained in Tami...
28. Creation of Pivot Tables - • How to create Pivot table in Excel explain...
29. Grouping Pivot table items - • Grouping Pivot table items in Excel explai...
30. Consolidate multiple worksheet in Pivot Table - • Consolidate multiple worksheets into one P...
31 How to use Index Function - • How to use Index() in Excel explained in T...
32 How to use Match() explained in Tamil - • How to use Match() in Excel - explained in...
33 Excel Charts explained in Tamil - • Excel Charts explained in Tamil | Layout o...
34. How to create Column Chart - • How to create Column Chart, Stacked Column...
35. How to draw simple line graph - • How to draw Simple Line graph explained in...
36. How to use Sum() in Excel - • How to use Sum() in Excel explained in Tam...
37. What if - goal seek - • How to do goal seek in Excel explained in ...
38. What if : Data Table - • What is Data Table in Excel explained in T...
39. What if : Scenario Manager - • What-If Analysis and Scenario Manager expl...
40 What if : Solver Add-in - • Solver in Excel explained in Tamil | #Exce...
41. Transportation problem using Solver add-in • Solving Transportation Problem using Solve...
42. Assignment Problem using Solver add-in - • Solving Assignment Problem in OR using Ex...
43. Shortest Path in a graph - • Finding Shortest Path in a graph using Sol...
44. Travelling Salesman Problem - • Travelling Salesman Problem using Solver i...
45. Magic square - • Build a Magic square using Excel solver #...
46. System of Linear Equations - • Solving System of Linear Equations using E...
Scenarios
1. Scenario 1 Fill Blanks • Excel Fill Blanks with constants or formul...
2. How to draw floating bars using stacked bar in Excel - • Creating Floating bars using Stacked Bar i...
3. How to draw floating columns in Excel - • Creating Floating columns using Stacked co...
4. Enhancing Line graph - • Enhancing Line graph in Excel | Infographi...
5. Highlighting Max and Min value in a line chart - • Highlighting Max Min value in Line graph ...
6. Array formula with Multiple Criteria - • Array formula with multiple criteria using...
Data Analysis with Excel Videos (in English) :
1. Pivot Table - • How to create a Pivot table | Data analysi...
2. What does Pivot table do in Excel - • What does Pivot table do in Excel ? | Pivo...
3. How to use Vlookup() in Excel - • How to use Vlookup in Excel ? | Vlookup Ex...
4. How to use Index function() - • How to use Excel Index() |Excel Index() ex...
5. How to use Match() - • How to use Match() in Excel | Match() + A...
6. Vlookup Vs Index & Match - • VLOOKUP VS INDEX and MATCH in Excel | How ...
7. Create Charts in Excel - Introduction - • Create Charts in Excel - Introduction | Ch...
8.How to create Column Chart - • How to create Column Chart, Stacked Column...
9. How to draw a simple line chart - • How to draw Simple Line graph in Excel | T...
10. How to do Goal Seek in Excel - • How to do goal seek in Excel #GoalSeek #Wh...
11. What is What-if analysis and Data Table - • What is What if Analysis and Data Table in...
12. What-If analysis and Scenario Manager - • What-If Analysis and Scenario Manager | #...
13. What is Solver add-in and how to enable it - • What is a Solver add-in and how to enable ...
14. Solving Transportation problem using Solver add-in - • Solving Transportation Problem using Solve...
@LifeLongLearning
learnwithsam.in