Create Slot Game in Excel ✅

Create Slot Game in Excel and play in Excel. I have created this game in Excel to show that excel can work as a game machine too ! 

-----Game Logic ------

In this game in Excel, on the click of the play button the slot system works and if the average of the 3 slot numbers is greater than 6 then the player will 10 points and if the average is less than 6 then the player gets -1. The total of wins and losses are maintained in the Points section using a simple VBA code.



The code for the Points calculation is

Sub points( )

Cells(15, 12) = Cells(15, 12) + Cells(1, 1)

End Sub



SLOT Machine in Excel Logic

To create the slot machine i have used the Randbetween formula of Excel which allows you to generate Random numbers.

How To Link Excel Files in Hindi

How To Link Excel Files in Hindi

Learn how to link excel files to get the data from 1 or more excel excel files into another Excel file.

Sumif Formula in Excel Hindi

100 लोगों में से 1 का डाटा टोटल करना हों तो यह फार्मूला लगाये . Excel हिंदी में Sumifफार्मूला का उपयोग करके विशिष्ट मानदंडों के आधार पर एक सीमा के योग की गणना करें।

Excel में SUMIF फॉर्मूला एक वर्कशीट फ़ंक्शन है जो एक मापदंड के आधार पर सभी संख्याओं को जोड़ता है (उदाहरण के लिए, 5000 के बराबर है)।



Calculate the the Sum of a range based on a specific criteria using the   Sumif formula in Excel Hindi.

The SUMIF Formula in Excel is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 5000).



Learn the Sumif formula to do additions based on a condition.

Parameters or Arguments of Sumif Formula



range

The range of cells that you want to apply the criteria against.

criteria

The criteria used to determine which cells to add.

sum_range

Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the sum_range.

The worksheet shown in the video is available for free download at http://www.myelesson.org



Share your views and provide comments on the video so that I can improve the learning experience.



To watch more videos and download the files visit http://www.myelesson.org

To Buy The  Full Excel Course visit . http://www.myelesson.org/product    or call 9752003788

Connect with us on Facebook - https://www.facebook.com/excelmadeasy/

Connect with us on Twitter - https://twitter.com/Excelmadeasy

Multiply 2 Columns in Excel Hindi

SUMPRODUCT formula This article describes the formula syntax and usage of the SUMPRODUCT formula in Microsoft Excel.

Description - Multiplies corresponding components in the given arrays, and returns the sum of those products.



Syntax of SUMPRODUCT formula



SUMPRODUCT(array1, [array2], [array3], ...)



The SUMPRODUCT formula syntax has the following arguments:



Array1     Required. The first array argument whose components you want to multiply and then add.



Array2, array3,...     Optional. Array arguments 2 to 255 whose components you want to multiply and then add.



Remarks

The array arguments must have the same dimensions. If they do not, SUMPRODUCT returns the #VALUE! error value.



SUMPRODUCT treats array entries that are not numeric as if they were zeros.



To watch more videos and download the files visit http://www.myelesson.org

To Buy The  Full Excel Course visit . http://www.myelesson.org/product    or call 9752003788

Connect with us on Facebook - https://www.facebook.com/excelmadeasy/

Connect with us on Twitter - https://twitter.com/Excelmadeasy

Count The Numbers of Cells Containing Numbers Excel Hindi

If you want to count the numbers of cells containing numbers in Excel the you can use the Count Formula . The COUNT Formula counts the number of cells that contain numbers, and counts numbers within the list of arguments.

Use the COUNT Formula to get the number of entries in a number field that is in a range or array of numbers.



Syntax of Count Formula



COUNT(value1, [value2], ...)



The COUNT Formula for syntax has the following arguments:



value1    Required. The first item, cell reference, or range within which you want to count numbers.



value2, ...    Optional. Up to 255 additional items, cell references, or ranges within which you want to count numbers.



 To watch more videos and download the files visit http://www.myelesson.org

To Buy The  Full Excel Course visit . http://www.myelesson.org/product    or call 9752003788

Connect with us on Facebook - https://www.facebook.com/excelmadeasy/

Connect with us on Twitter - https://twitter.com/Excelmadeasy

Sudoku Of The Day 4th Feb

Sudoku Of The Day 4th Feb. Watch the Sudoku Of The Day 4th Feb and play along, the answers are mentioned at the end of the video.

To watch more videos and download the files visit http://www.myelesson.org/downoads



Connect with us on Facebook - https://www.facebook.com/excelmadeasy/

Connect with us on Twitter - https://twitter.com/Excelmadeasy

Create Gantt Chart in Excel 2016

A Gantt chart, commonly used in project management, is one of the most popular and useful ways of showing activities (tasks or events) displayed against time.

On the left of the chart is a list of the activities and along the top is a suitable time scale. Each activity is represented by a bar; the position and length of the bar reflects the start date, duration and end date of the activity. This allows you to see at a glance:



What the various activities are

When each activity begins and ends

How long each activity is scheduled to last

Where activities overlap with other activities, and by how much

The start and end date of the whole project