This tutorial teaches how to use Excel formulas, macros, and AI-powered tools like GPT chat to efficiently analyze data and create tables, including identifying the highest paid themes in Google AdSense.

• 💻
  00:00

  Excel is a great tool for organizing and querying data, but its full potential can be difficult to exploit without knowledge of formulas and macros, which Tito Savage will teach in this video.
• 💻
  00:41

  Create tables in Excel with AI using gpt chat without prior knowledge of Excel, including a table of Autonomous communities, their capitals, and total population.

  • Learn how to easily create tables in Excel using artificial intelligence with gpt chat, without needing any prior knowledge of Excel.
  • Creating a table with the names of Autonomous communities, their capitals, and total population can be done by executing a code and cleaning it later.
• 💉
  02:52

  To paste a table without any format in Excel, double click the space between two cells to adjust the size of the cell to the number of letters it has and then change the design.
• 💰
  03:59

  Create a table of the top 10 highest paid themes in Google AdSense by extracting data from a blogger30 article and using HGPT to structure the information.
• 💡
  05:22

  Bing added a competition column to their keyword table, while GPT chat AI can help calculate the mean CPC for top Google Adsense themes.

  • Add a competition column to the table alongside the CPC to show the difficulty of the keyword, which Bing has already implemented.
  • Using GPT chat's artificial intelligence, we can create formulas to manipulate data, such as calculating the mean of CPC for the best paid themes for Google Adsense.
• 💻
  07:21

  Calculate the average cost of a column in Excel by specifying the data range and using a formula in either English or Spanish.

  • Create an average column in Excel by specifying the data range and using a formula in English on GPT Chat to avoid issues with Spanish attributes.
  • Create an Excel formula in Spanish to calculate the average cost of a column with data between cell b2 and cell b11.
• 💻
  09:19

  Learn how to work with Excel using Artificial Intelligence macros, including a simple example of finding the best paid theme.
• 💻
  10:24

  Use GPT chat to create a Macro in Excel that displays the best paid themes in a table on sheet 3.

  • Create a Macro for Excel using GPT chat to display the best paid themes in a table, with the data located on sheet 3 and the developer tab activated through file options.
  • Activate the developer programmer tab, insert the Macro code given by chat gpt into a module in the visual basic editor, save and execute the Macro in sheet 3 using the Macro dialog box.
  • Using GPT chat, clear instructions can be given to artificial intelligence to execute tasks, as demonstrated in the video where the best paid theme was found to be insurance with a cost of 13.28.