Lottery Success Strategies With Google Sheets

Thank you for subscribing to this course. 

This course is about using Google Sheets to analyze and understand systems around you. In this case, the lottery system 

Google Sheets is a free spreadsheet program from Google that allows you to analyze, calculate, and visualize data- 

Once students begin to see the power and capabilities of a spreadsheet,  the topic of "how do I crack the lottery code" with spreadsheet power always comes up. 

We'll use lottery data to demonstrate some of the features available in Google Sheets that maybe helpful in your work, life, or studies.  You will also learn how to gain insights into your state lottery games,  while learning a few tips, tricks and shortcuts about them as well - 

What do you need for this course:

1. You will need continuous access to the internet 
2.  A laptop or desktop computer. Although a handheld device is fine for viewing content, you'll need a desktop or laptop computer to perform some of the exercises
3. A Google Account. My guess is that you already have a Google account. If not, you can sign up for a free account @ accounts.google.com..

I realize why this topic continues to remain popular. 

We all want the  4Gets: Get FIT, Get Rich, Get Love, Get Lifestyle.  Keep in mind. Life is not all about money. You are not truly rich, until you have something money cannot buy. Getting Fit, finding love, living your ideal lifestyle, getting smarter are always good things. On that note, let's get started. 

In this Lecture, you will learn:

• The structure of a Google Spreadsheet
• How to move around a Spreadsheet with keyboard shortcuts
• How to select a range of cells
• The 3 things you can enter into a Google Spreadsheet

In this Lecture, you will learn how to:

• Import data from the Texas Lottery System into Google Sheets

• Combine Columns

• Automacitlly fill ranges with data

• Insert Columns and Rows into a spreadsheet

• Align Content within Cells

• Merge Cells

▪ Name a range of cells

▪ Format cells with alternating colors

▪ Automatically size columns

▪ Use the Frequency formula to determine how many times a number was drawn

▪ Use the Special Paste function in Google Sheets

▪ Create a filter to Sort Data

▪ Create a Column Chart to analyze Data

▪ Use the Mode formula to find the ost frequently occurring number in a numeric data set.

In this lesson, we'll learn how to customize the look and feel of the Google  spreadsheet. We will add fill color to cells; to help distinguish them from the rest of the worksheet.

We will also apply Conditional formatting. Conditional formatting is a feature of Google Sheets which allows you to apply a format to a cell or a range of cells based on certain criteria. 

In this lesson, we'll learn how to create a set of random numbers with the RANDBETWEEN function.

In this lesson, we'll learn how to calculate lottery odds with the COMBIN function. 

In this lesson, we'll learn how to:

▪ Import data into Google Sheets
▪ Combine Columns
▪ Automatically fill ranges with data
▪ Insert Columns and Rows into a spreadsheet
▪ Align content within Cells
▪ Merge Cells
▪ Name a range of cells
▪ Format cells with alternating colors
▪ Automatically size columns
▪ Use the Frequency formula to determine how many times a number was drawn
▪ Use the Paste Special function in Google Sheets
▪ Create a filter to sort data
▪ Create Charts to analyze Data
▪ Use the Mode formula to find the most frequently occurring number in a numeric data set.
▪ Format Cells.
▪ Calculate lottery odds with the COMBIN function.