Spreadsheet
Formula Generation in Excel:
Create a formula to [goal] in cell [range of cells]
• Create a formula to calculate the sum in cells Al to A10
• Create a formula to calculate the average in cells H10 to H20
• Create a formula that sums only the expenses that have the status “No” in column C
Explain formula
Explain the meaning of the formula [formula]
• Explain the meaning of the formula -SUM(A1:A10)
• Explain the meaning of the formula -AVERAGE(H10:H20)
• Explain the meaning of the formula =SUMIF(CI:C13, No”, BÀ B13)
Google Sheets
Create a formula to [goal] in cell (range of cells]
• Create a formula in Google Sheets to calculate the sum in cells Al to A10
• Create a formula in Google Sheets that puts data from one sheet into the current sheet
• Explain this Google Sheet command: [insert command]
Advanced Formulas, Macros and VBA
I have a table with numbers in column A that have the format: (xx) xxx-xxxx Extract the numbers
within parenthesis using Excel
• Create a macro that calculates the average of cells. C2 to D9 and inserts the result in cell F3
• Create a macro that sorts sheets by tab name using VBA.
Foreign Language
Ask questions:
What’s the difference between [word] and [word2] in [language)? Provide X examples
• What’s the difference between por and para in Spanish? Provide 2 examples
• What’s the difference between tu and você in Portuguese? Provide 4 examples
Conversation:
Act as a language partner. You’ll start a conversation with me about [topic] in [language.
In every response, you should provide your opinion and then ask me a question to keep the
conversation going.
Write essays in any level:
Write a [level] [type of essay) in [language), about [topic]. It must be X words long.
Pronunciation:
Create a table with 2 columns: In the first column type the language] words: [word, word2… In the second column, you should provide the phonetic transcription.
Content creation
Ideas Generation
Give me ideas for [type of content] about [subject]. covering topics like [topicl, topic2…]
• Give me ideas for a blog post about writing covering topics like writing tools and writer’s block.
• Give me ideas for a podcast about technology covering topics like Al and machine learning.
• Give me ideas for a YouTube video about best books to read covering only self-help books.
Content Creation
Outlines
Create an outline for [type of content]
• Write a BI report in English about pollution. It Course Quiz:
must be 500 words long
• Write a A2 letter in Spanish about your.
financial situation. It must be 300 words long
Write a C1 review in Portuguese about a tech
product. It must be 500 words long.
.
Create an outline for a blog post about productivity
• Create an outline for a book “how to learn to learn a
foreign language in 3 months”
Create an outline for a course “how to learn Python
for data science”
.
Vocabulary:
Thumbnail:
Create a table of difficult words from the previous Act as a prompt generator for Midjourney’s Al. Your job is
essay and translate them into [language]
to describe (object) as concisely as possible. Always give 3
different and contrasting versions of a [object] and include
any random artist name prefixed by “in the style of “
Turn a [list] into [type of quiz]
Turn a list of facts about world history into a multiple-
choice quiz
Turn a list of facts about biology into true/false
question
Giveaway:
Choose X random contest winner(s) from a long list of
names or emails: [insert names or emails]
Programming
Coding Questions:
How to [action] in [programming language)?
• How to merge dictionaries in Python?
• How to join two datasets in Python?
What’s the difference between (concept)) and (concept2) in [language)?
• What’s the difference between lists and dictionaries in Python?
• What’s the difference between OOP and functional programming?
Explain the [concept] in [language]
• Explain the while loop in Python
Explain the try/except in Python to a child
.
Advice:
I want to learn [language] for [field]. Create a roadmap to learn [language]
• I want to learn Python for data science. Create a roadmap to learn Python
I want to learn JavaScript for web development. Create a roadmap to learn it
I want to automate (app). Provide steps to [task) with [language]
.
I want to automate Gmail, Provide steps to sending emails with Python
.
I want to automate Tinder. Provide steps to swipe right with Python
Simulate a job interview for a [position) by asking and answering questions as if
you are a potential employer and I’m the candidate. Consider that [details]
Web Development:
I want to build a [type of website). Can you generate some HTML for my website?
• I want to build a job board website. Can you generate some HTML for my
website?
. I want to build a price comparison website. Can you generate some HTML for
my website?
Additional steps:
• Can you center the content in the HTML page, add a line break between the
inputs and add an image on a logo?
• Add CSS to customize the size of the logo image
Data Science Questions:
Where can I find data for my [describe project)?
• Where can I find data for my credit card fraud detection project?
• Where can I find data for my customer churn prediction project?
How to (action) my dataset?
• How to oversample/undersample my dataset?
How to split my dataset into train and test sets with Python?
.
Best practices:
Can you (best practice) my code?
Data Science
. Can you optimize the following Python code?
. Can you simplify the following R code?
. Can you document my code?
. Can you check for readability in my code?
Automate Data Science Tasks:
• Translate my Python code to R
• Turn this SQL code to Python pandas code
• Format my SQL code by converting the reserved keywords to uppercase
• Create a SQL query that [describe query]
• Write a regex in Python that [describe regex]
Data Science Workflow:
Web scraping (only working for a few websites)
• Web scrape [website] using [language) and [library]
Generate data
• Act as a fake data generator. Create a dataset that has X rows and Y
columns: [column1, column2,…]
Train Classification model
• I have a dataset of [describe dataset), build a machine learning model that
predicts [target variable]
Automation:
• Send the message “[type message)” on Whatsapp using Python and pywhatkit
• Send an email from [email_1] to (email_2) with the subject [email subject and the
content (email content] using Python
• Use Python to rename all the file extension files in my directory. Add the word
[word] to each name
Artificial
Tune Hyperparameter
• I’ve trained a (model name]. Write code to tune the hyperparameters
Feature Importance
• I’ve trained a [model name]. Write code to find the most important features
in the model
Corner
Formula Generation in Excel:
Create a formula to [goal] in cell [range of cells]
Spreadsheet
.
• Create a formula to calculate the sum in cells Al to
A10
• Create a formula to calculate the average in cells
H10 to H20
• Create a formula that sums only the expenses that
have the status “No” in column C
Explain formula
Explain the meaning of the formula [formula]
.
Explain the meaning of the formula
-SUM(A1:A10)
Explain the meaning of the formula
-AVERAGE(H10:H20)
.
Explain the meaning of the formula
=SUMIF(CI:C13, No”, BÀ B13)
Google Sheets
Create a formula to [goal] in cell (range of cells]
• Create a formula in Google Sheets to calculate the
sum in cells Al to A10
• Create a formula in Google Sheets that puts data
from one sheet into the current sheet
• Explain this Google Sheet command: [insert command]
Foreign Language
Ask questions:
What’s the difference between [word] and
[word2] in [language)? Provide X examples
• What’s the difference between por and para
in Spanish? Provide 2 examples
• What’s the difference between tu and você in
Portuguese? Provide 4 examples
Advanced Formiulas, Macros and VBA
. I have a table with phone numbers in column A that
have the format: (xxx) xxx-xxxx Extract the numbers
within parenthesis using Excel
• Create a macro that calculates the average of cells.
B1 to BIO and inserts the result in cell C1
• Create a macro that sorts sheets by tab name using
VBA.
Conversation:
Act as a language partner. You’ll start a
conversation with me about [topic] in [language.
In every response, you should provide your
opinion and then ask me a question to keep the
conversation going.
Write essays in any level:
Write a [level] [type of essay) in [language), about
[topic]. It must be X words long.
Pronunciation:
Create a table with 2 columns: In the first column
type the language] words: [word, word2… In
the second column, you should provide the
phonetic transcription.
Ideas Generation:
Give me ideas for [type of content] about [subject].
covering topics like [topicl, topic2…]
Artificial Corner
• Give me ideas for a blog post about writing covering
topics like writing tools and writer’s block.
• Give me ideas for a podcast about technology
covering topics like Al and machine learning.
Give me ideas for a YouTube video about best books
to read covering only self-help books.
.
Content Creation
Outlines
Create an outline for [type of content]
• Write a BI report in English about pollution. It Course Quiz:
must be 500 words long
• Write a A2 letter in Spanish about your.
financial situation. It must be 300 words long
Write a C1 review in Portuguese about a tech
product. It must be 500 words long.
.
Create an outline for a blog post about productivity
• Create an outline for a book “how to learn to learn a
foreign language in 3 months”
Create an outline for a course “how to learn Python
for data science”
.
Vocabulary:
Thumbnail:
Create a table of difficult words from the previous Act as a prompt generator for Midjourney’s Al. Your job is
essay and translate them into [language]
to describe (object) as concisely as possible. Always give 3
different and contrasting versions of a [object] and include
any random artist name prefixed by “in the style of “
Turn a [list] into [type of quiz]
Turn a list of facts about world history into a multiple-
choice quiz
Turn a list of facts about biology into true/false
question
Giveaway:
Choose X random contest winner(s) from a long list of
names or emails: [insert names or emails]
Programming
Coding Questions:
How to [action] in [programming language)?
• How to merge dictionaries in Python?
• How to join two datasets in Python?
What’s the difference between (concept)) and (concept2) in [language)?
• What’s the difference between lists and dictionaries in Python?
• What’s the difference between OOP and functional programming?
Explain the [concept] in [language]
• Explain the while loop in Python
Explain the try/except in Python to a child
.
Advice:
I want to learn [language] for [field]. Create a roadmap to learn [language]
• I want to learn Python for data science. Create a roadmap to learn Python
I want to learn JavaScript for web development. Create a roadmap to learn it
I want to automate (app). Provide steps to [task) with [language]
.
I want to automate Gmail, Provide steps to sending emails with Python
.
I want to automate Tinder. Provide steps to swipe right with Python
Simulate a job interview for a [position) by asking and answering questions as if
you are a potential employer and I’m the candidate. Consider that [details]
Web Development:
I want to build a [type of website). Can you generate some HTML for my website?
• I want to build a job board website. Can you generate some HTML for my
website?
. I want to build a price comparison website. Can you generate some HTML for
my website?
Additional steps:
• Can you center the content in the HTML page, add a line break between the
inputs and add an image on a logo?
• Add CSS to customize the size of the logo image
Data Science Questions:
Where can I find data for my [describe project)?
• Where can I find data for my credit card fraud detection project?
• Where can I find data for my customer churn prediction project?
How to (action) my dataset?
• How to oversample/undersample my dataset?
How to split my dataset into train and test sets with Python?
.
Best practices:
Can you (best practice) my code?
Data Science
. Can you optimize the following Python code?
. Can you simplify the following R code?
. Can you document my code?
. Can you check for readability in my code?
Automate Data Science Tasks:
• Translate my Python code to R
• Turn this SQL code to Python pandas code
• Format my SQL code by converting the reserved keywords to uppercase
• Create a SQL query that [describe query]
• Write a regex in Python that [describe regex]
Data Science Workflow:
Web scraping (only working for a few websites)
• Web scrape [website] using [language) and [library]
Generate data
• Act as a fake data generator. Create a dataset that has X rows and Y
columns: [column1, column2,…]
Train Classification model
• I have a dataset of [describe dataset), build a machine learning model that
predicts [target variable]
Automation:
• Send the message “[type message)” on Whatsapp using Python and pywhatkit
• Send an email from [email_1] to (email_2) with the subject [email subject and the
content (email content] using Python
• Use Python to rename all the file extension files in my directory. Add the word
[word] to each name
Artificial
Tune Hyperparameter
• I’ve trained a (model name]. Write code to tune the hyperparameters
Feature Importance
• I’ve trained a [model name]. Write code to find the most important features
in the model
Corner
Spreadsheet
Excel Formulas:
To achieve a certain goal in a specific range of cells, create a formula.
Examples: • To calculate the sum in cells A1 to A10, create a formula. • To calculate the average in cells H10 to H20, create a formula. • To sum only the expenses that have the status “No” in column C, create a formula.
Formula Explanation:
Understand the meaning of a formula.
Examples: • The meaning of the formula -SUM(A1:A10) • The meaning of the formula -AVERAGE(H10:H20) • The meaning of the formula =SUMIF(C1:C13,”No”, B1:B13)
Google Sheets:
Create a formula in a specific range of cells.
Examples: • To calculate the sum in cells A1 to A10 using Google Sheets, create a formula. • To transfer data from one sheet to the current sheet using Google Sheets, create a formula. • Explain this Google Sheets command: [insert command]
Advanced Formulas, Macros, and VBA:
Extract phone numbers from a table with numbers in column A that have the format: (xx) xxx-xxxx using Excel. Create a macro that calculates the average of cells C2 to D9 and inserts the result in cell F3. Sort sheets by tab name using VBA.
Foreign Language:
Ask questions about differences between words in a specific language and provide examples.
Examples: • What is the difference between “por” and “para” in Spanish? Provide 2 examples. • What is the difference between “tu” and “você” in Portuguese? Provide 4 examples.
Conversation:
Act as a language partner and start a conversation in a specific language about a topic. Provide your opinion and ask a question in response to keep the conversation going.
Essay Writing:
Write an essay of a certain level and type in a specific language about a topic. The essay must be a certain number of words long.
Pronunciation:
Create a table with two columns. In the first column, type words in a specific language. In the second column, provide the phonetic transcription.
Content Creation:
Ideas Generation:
Provide ideas for a specific type of content about a subject. The ideas should cover topics such as [topic 1, topic 2…]
Examples: • Provide ideas for a blog post about writing covering topics like writing tools and writer’s block. • Provide ideas for a podcast about technology covering topics like AI and machine learning. • Provide ideas for a YouTube video about the best self-help books to read.
Content Creation Outlines:
Create an outline for a specific type of content.
Examples: • Write a BI report in English about pollution. The report must be 500 words long. • Write an A2 letter in Spanish about your financial situation. The letter must be 300 words long. • Write a C1 review in Portuguese about a tech product. The review must be 500 words long. • Create an outline for a blog post about productivity. • Create an outline for a book “How to Learn a Foreign Language in 3 Months.” • Create an outline for a course “How to Learn Python for Data Science.”
Vocabulary:
Create a table of difficult words from a previous essay and translate them into a specific language.
Thumbnail:
Create a prompt generator for Midjourney’s AI. The task is to describe an object as concisely as possible, always giving three different and contrasting versions of the object and including any random artist name prefixed by “in the style of.”
Quizzes:
Turn a list of facts into a multiple-choice or true/false quiz.
Giveaway:
Choose X random contest winner(s) from a long list of names or emails.
Programming:
Coding Questions:
Provide instructions on how to perform
