Lottery Success Strategies With Google Sheets

Name: Lottery Success Strategies With Google Sheets
Rating: 4.5 (90 reviews)

Use Google Sheets To Unlock Secrets Of The Lottery System

Created byFrantz Merine

Last updated 5/2018

English

What you'll learn

In this course, we’ll visit three different lottery games in 3 separate states. Each analysis will offer different approaches to analyzing data. We use lottery data to teach data visualization and Google Spreadsheets techniques. it's like 3 courses in one.

Course content

5 sections • 10 lectures • 1h 15m total length

Introduction1:44
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:

You will need continuous access to the internet
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
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.
Accessing Google Sheets0:49

Getting Started with Google Sheets3:21
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
Analyzing Texas Lottery Cash-5 Winning Numbers with Google Sheets17:02
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.
Cell Formatting and Conditional Formatting6:16
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.
Creating your own Quick Pick Numbers1:26
In this lesson, we'll learn how to create a set of random numbers with the RANDBETWEEN function.
Texas Cash-5 Odds1:30
In this lesson, we'll learn how to calculate lottery odds with the COMBIN function.

Virginia State Lottery Cash 4 Life16:59
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.

Requirements

In this course you will learn how to visually analyze trends and patterns in a variety of United States Lottery systems. These techniques will help you pick better lottery numbers, and you’ll learn a few cool tricks about Google’s Spreadsheet program.

Description

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 may be 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:

You will need continuous access to the internet.
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
A Google Account.

I realize why this topic continues to remain popular. We all want the 4 Gets: 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, and getting smarter are always good things. On that note, let's get started!

Who this course is for:

Anyone with an interest in unlocking the power of Google Sheets, while learning a few lottery techniques

Lottery Success Strategies With Google Sheets

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 3min

Analyzing Cash-5 Winning Numbers From The Texas Lottery with Google Sheets5 lectures • 30min

New York State Lottery Pick 10 Game1 lecture • 19min

Analyzing Virginia State Lottery Cash4Life Winning Numbers with Google Sheets1 lecture • 17min

Calculating Odds and Conclusion1 lecture • 8min

Requirements

Description

Who this course is for: