All Content
Timespan
explore our new search
10X Your Excel Skills with ChatGPT
Excel
Jan 13, 2023 8:00 AM

10X Your Excel Skills with ChatGPT

by HubSite 365 about Kevin Stratvert

Content Creator & former Microsoft Product Manager

Pro UserM365 All about AIExcelM365 Hot News

In this step-by-step tutorial, learn how you can exponentially improve your Excel skills using OpenAI's ChatGPT artificial intelligence. Write nested functions

In this step-by-step tutorial, learn how you can exponentially improve your Excel skills using OpenAI's ChatGPT artificial intelligence. Write nested functions with ease, calculate the number of unique text values in a list, write a basic invoicing macro, and more, all with just a few clicks and a few basic refinements.

RESOURCES

In this Video

00:00 Introduction

00:50 Get ChatGPT

01:04 Simple sum example

02:44 Profit example

03:30 Lookup functions

05:16 Left and find nested function

06:26 Unique count nested function

07:43 Write macros

10:51 Wrap up

What is chatGPT?

chatGPT is a variant of the GPT (Generative Pre-trained Transformer) language model that has been fine-tuned for chatbot applications. It is designed to generate human-like responses to user input in real-time, allowing it to engage in conversation with users in a natural and expressive way.

GPT is a type of transformer-based language model developed by OpenAI. It is trained on a large dataset of text and learns to predict the next word in a sequence based on the context of the previous words. This allows it to generate coherent and coherently formatted text that can be used for a variety of natural language processing tasks, including language translation, question answering, and text generation.

To create chatGPT, the original GPT model was fine-tuned on a dataset of conversations, which means that it was further trained on a specific task (in this case, chatbot conversations) in order to improve its performance. This fine-tuning process adjusts the model's internal weights and biases to better suit the task at hand, allowing it to generate more appropriate responses to user input.

Overall, chatGPT is a powerful tool for creating chatbots that can hold natural and expressive conversations with users. It can be used to build chatbots for a wide range of applications, including customer service, e-commerce, and social media.

https://chat.openai.com/chat

Best ChatGPT Resources

Overview about 101 solutions for AI with ChatGPT

https://enchanting-trader-463.notion.site/Best-ChatGPT-Resources-101-94a7c6dbabcc4febbfb498c555d6ef5f