Build a Magic square using Excel solver
A magic square is a square array of numbers consisting of the distinct positive integers 1, 2, ..., n^2 arranged such that the sum of the n numbers in any horizontal, vertical, or main diagonal line is always the same number
In this video, creating magic square for any square array using Excel Solver add-in is discussed with an example.
Learn Excel in Tamil videos :
1. Introduction to Excel in Tamil - • Introduction to Excel in Tamil | #மைக...
2. Managing Worksheets - • Managing Excel worksheets in Tamil |...
3. Cell Basics - • Excel Cell Basics in Tamil | Cut, Co...
4. Fill Handle - • Excel Fill handle in Tamil| How to us...
5. Formulas and Functions Part I - • Excel Formulas and Functions | How to...
6. Find and Replace - • Excel - Find and Replace features | H...
7. Goto and Goto Special - • Goto, GoTo Special explained in Tamil...
8. Cell Formatting - • Excel Cell formatting in Tamil | How ...
9. Page Layout - • Page layout in Excel | எக்ஸலில் பக்கம...
10. Comments - • Excel Comments in Tamil| எக்ஸலில் எப்...
11. What is Conditional formatting - • what is Excel Conditional formatting ...
12. Built in Conditional formatting - • Built in Conditional formatting in Ta...
13. Conditional formatting rules - • Excel Conditional formatting rules i...
14. Conditional formatting with formulas - • Excel Conditional formatting with Fo...
15. Excel Tables - • Excel Tables explained in Tamil #Exce...
16. Excel SubTotal function - • Excel SubTotal function explained in ...
17. Excel SubTotal Command - • Excel SubTotal Command explained in T...
18. Excel Sorting - • Excel Sorting Data explained in Tamil...
19. Excel Filtering Data - • Excel Filtering data explained in Ta...
20. Excel Counting Functions - • Excel Five count functions explained ...
21. Basics of Data Validation - • Basics of Data Validation in Excel e...
22. Excel Drop down list and Dependent Drop Down List - • Excel Drop Down list and Dependent Dr...
23. Excel Data Validation for Dates - • Excel Data Validation for Dates | #Ex...
24. Excel Vlookup - • What is Vlookup in Excel? |#VlookupEx...
25. Excel Hlookup() - • What is Hlookup in Excel? |#HlookupEx...
26. Excel if() - • Learn Excel IF function in Tamil |Sim...
What does pivot table do in Excel? - • What does Pivot table do explained in...
28. Creation of Pivot Tables - • How to create Pivot table in Excel ex...
29. Grouping Pivot table items - • Grouping Pivot table items in Excel e...
30. Consolidate multiple worksheet in Pivot Table - • Consolidate multiple worksheets into ...
31 How to use Index Function - • How to use Index() in Excel explained...
32 How to use Match() explained in Tamil - • How to use Match() in Excel - explain...
33 Excel Charts explained in Tamil - • Excel Charts explained in Tamil | Lay...
34. How to create Column Chart - • How to create Column Chart, Stacked C...
35. How to draw simple line graph - • How to draw Simple Line graph explain...
36. How to use Sum() in Excel - • How to use Sum() in Excel explained i...
37. What if - goal seek - • How to do goal seek in Excel explaine...
38. What if : Data Table - • What is Data Table in Excel explained...
39. What if : Scenario Manager - • What-If Analysis and Scenario Manager...
40 What if : Solver Add-in - • Solver in Excel explained in Tamil | ...
41. Transportation problem using Solver add-in • Solving Transportation Problem using ...
42. Assignment Problem using Solver add-in - • Solving Assignment Problem in OR usin...
43. Shortest Path in a graph - • Finding Shortest Path in a graph usin...
Scenarios
1. Scenario 1 Fill Blanks • Excel Fill Blanks with constants or f...
2. How to draw floating bars using stacked bar in Excel - • Creating Floating bars using Stacked ...
3. How to draw floating columns in Excel - • Creating Floating columns using Stack...
4. Enhancing Line graph - • Enhancing Line graph in Excel | Infog...
5. Highlighting Max and Min value in a line chart - • Highlighting Max Min value in Line gr...
6. Array formula with Multiple Criteria - • Array formula with multiple criteria ...
Data Analysis with Excel Videos (in English) :
1. Pivot Table - • How to create a Pivot table | Data an...
2. What does Pivot table do in Excel - • What does Pivot table do in Excel ? |...
3. How to use Vlookup() in Excel - • How to use Vlookup in Excel ? | Vlook...
4. How to use Index function() - • How to use Excel Index() |Excel Index...
5. How to use Match() - • How to use Match() in Excel | Match(...
6. Vlookup Vs Index & Match - • VLOOKUP VS INDEX and MATCH in Excel |...
7. Create Charts in Excel - Introduction - • Create Charts in Excel - Introduction...
8.How to create Column Chart - • How to create Column Chart, Stacked C...
9. How to draw a simple line chart - • How to draw Simple Line graph in Exce...
10. How to do Goal Seek in Excel - • How to do goal seek in Excel #GoalSee...
11. What is What-if analysis and Data Table - • What is What if Analysis and Data Tab...
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 en...
14. Solving Transportation problem using Solver add-in - • Solving Transportation Problem using ...
@LifeLongLearning
learnwithsam.in