Excel Tutorial
Excel Tutorial
  • Видео 198
  • Просмотров 452 213
ChatGPT is Amazing at Writing Google Sheets Formulas!
How to access ChatGPT: chat.openai.com/chat
0:00 - Intro
0:55 - Get data from another sheet
2:12 - Convert Currency
3:40 - Sum formula
3:58 - Calculate totals by currency
5:49 - Other Ideas
In this video, I'll teach you how to become a Google Sheets expert with the help of ChatGPT! You'll learn how to create formulas like a pro, giving you the skills you need to take your Google Sheets skills to the next level. Whether you're a beginner or an experienced user, this video will provide you with the knowledge and techniques you need to master Google Sheets' powerful formula features. I'll guide you through step-by-step instructions and provide you with helpful tips and tricks to make the most of Go...
Просмотров: 1 704

Видео

Build Complex Excel Formulas With ChatGPT!
Просмотров 548Год назад
ChatGPT: chat.openai.com/ Link to the excel sheet in this video: exceltutorial.net/wp-content/uploads/excel-tutorial-sheets/Excel-ai-tutorial-2.xlsx 0:00 - Intro 1:04 - Get data from another sheet 2:47 - Convert Currency 4:15 - Sum formula 4:25 - Calculate totals by currency 5:47 - Other Ideas In this video, I'll show you how to become an Excel master with the help of ChatGPT. You'll learn how ...
Use ChatGPT to Write EXCEL Formulas in Seconds!
Просмотров 3,2 тыс.2 года назад
In this video, we'll show you how ChatGPT can help you easily write basic Excel formulas in no time! 0:00 - Intro 0:27 - Populate Names 1:02 - Date calculation 1:29 - Split email address 1:58 - Where and how to use them Check out all our tutorials here on our website: www.exceltutorial.net/
Formula Auditing in Excel | How to Audit Formula in Excel
Просмотров 2772 года назад
If you're looking to audit your Excel formulas and make sure they're doing what they're supposed to be doing, then this video is for you! I'll show you how to use the Formula Auditing tools in Excel to find and fix errors in your formulas. This video will teach you: -How to audit your Excel formulas -How to find errors in your formulas -How to fix errors in your formulas Did you know that you c...
What is a Circular Reference in Excel | Fix Circular Reference in Excel
Просмотров 2542 года назад
Do you know what a circular reference is in Excel? It's basically when a formula refers to itself, and it can cause all sorts of problems in your spreadsheet. In this video I show you how to find and fix circular references, so your data is accurate and reliable. A circular reference is when a formula refers back to itself. It can happen in Excel if you accidentally create a loop in your formul...
Round Numbers to ODD or EVEN in Excel | ODD Function | EVEN Function
Просмотров 1,1 тыс.2 года назад
In this video, you'll learn how to round numbers to odd or even in Excel. This is a handy skill to have when you're working with data and want to make sure all your numbers are aligned. We'll show you how to do it both manually and with a quick shortcut, so you can get the job done quickly and easily! Learn More:- www.exceltutorial.net/ 🧑‍🏫 Round Functions and Formulas Playlist:- ruclips.net/p/...
Rounding Times in Excel | How to Round a Time in Excel | Excel Formulas
Просмотров 2852 года назад
In this video I show you how to round times in Excel. This is a really useful function for when you need to format time values into something more presentable. The process of rounding times in Excel is actually very simple, and can be done with just a few clicks. In this video I'll walk you through the steps, so that you can easily do it yourself! Learn More:- www.exceltutorial.net/ 🧑‍🏫 Round F...
MROUND Function in Excel | How to Round Numbers to the Desired Multiple
Просмотров 2,6 тыс.2 года назад
If you need to round a number to a certain multiple, the MROUND function can help. The MROUND Formula takes one argument, the number that you want to round to the desired multiple. Learn More:- www.exceltutorial.net/ 🧑‍🏫 Round Functions and Formulas Playlist:- ruclips.net/p/PLhvn6aQRdimUVHkfM00wH0UjScw_A8J33 This function is especially useful when working with financial data or other numerical ...
The TRUNC (Truncate) Function | How to Chop Off Decimals in Excel
Просмотров 1,7 тыс.2 года назад
The TRUNC (or truncate) function is a handy way to chop off decimal places. This can be really useful when you want to clean up numbers and make them easier to work with. Let's take a look at how the truncate function works, and some examples of how to use it! Learn More:- www.exceltutorial.net/ 🧑‍🏫 Round Functions and Formulas Playlist:- ruclips.net/p/PLhvn6aQRdimUVHkfM00wH0UjScw_A8J33 Lets se...
How to use INT Function in Excel | Rounds A Number Down To The Nearest Integer
Просмотров 2182 года назад
If you need to round a number down to the nearest integer, Excel has a built-in function that can do just that! The INT (integer) function will take any number and round it down to the nearest whole number. Learn More:- www.exceltutorial.net/ 🧑‍🏫 Round Functions and Formulas Playlist:- ruclips.net/p/PLhvn6aQRdimUVHkfM00wH0UjScw_A8J33 This can be useful for financial reports, data entry, or any ...
How to Use ROUNDDOWN Function in Excel | With Examples 🔥🔥
Просмотров 5742 года назад
Learn More:- www.exceltutorial.net/ 🧑‍🏫 Round Functions and Formulas Playlist:- ruclips.net/p/PLhvn6aQRdimUVHkfM00wH0UjScw_A8J33 In this video, I'm going to show you how to use the ROUNDDOWN function in Excel. ROUNDDOWN is a function that rounds numbers down. It's helpful when dealing with large numbers and it will save you time if your goal is rounding up or down all of the values in a column....
How to use ROUNDUP Function in Excel (With Examples) 🔥🔥
Просмотров 2042 года назад
Learn More:- www.exceltutorial.net/ 🧑‍🏫 Round Functions and Formulas Playlist:- ruclips.net/p/PLhvn6aQRdimUVHkfM00wH0UjScw_A8J33 In this video, we will show you how to use the ROUNDUP function in Excel. The ROUNDUP function is a built-in function in Excel that rounds a number up to the nearest integer. In other words, it will round a number up if the decimal value is greater than 0 and less tha...
How to Use ROUND Function in Excel | With Examples 🔥🔥
Просмотров 1452 года назад
Learn More:- www.exceltutorial.net/ 🧑‍🏫 Round Functions and Formulas Playlist:- ruclips.net/p/PLhvn6aQRdimUVHkfM00wH0UjScw_A8J33 In this video, I'm going to show you how to use the ROUND function in Excel. This is a very simple function that rounds numbers up or down as specified by the user. The syntax of this function is: =ROUND(number, digits). The number parameter specifies what number shou...
How to use STDEV Function in Excel | With Examples 🔥🔥🔥
Просмотров 3932 года назад
Learn More:- www.exceltutorial.net/ 🧑‍🏫 Statistical Functions Playlist:- ruclips.net/p/PLhvn6aQRdimWkjAu5tBtC37DayKJ_mWg1 In this video, we'll show you how to use the STDEV function in Excel. The STDEV function calculates the standard deviation of a given set of values. This can be helpful for determining how much variation there is in your data. We'll walk through an example so that you can se...
How to use FREQUENCY Function in Excel | With Examples
Просмотров 3182 года назад
Learn More:- www.exceltutorial.net/ 🧑‍🏫 Statistical Functions Playlist:- ruclips.net/p/PLhvn6aQRdimWkjAu5tBtC37DayKJ_mWg1 In this video, we're going to show you how to use the FREQUENCY function in Excel. This function is used to calculate how often values occur in a given set of data. It's a great way to quickly identify the most popular values in your data set. We'll show you how to use the F...
How to use MODE Function in Excel | With Examples 🔥🔥🔥
Просмотров 3752 года назад
How to use MODE Function in Excel | With Examples 🔥🔥🔥
How to Use MINIFs Function in Excel | With Examples 🔥🔥🔥
Просмотров 5462 года назад
How to Use MINIFs Function in Excel | With Examples 🔥🔥🔥
How to Use MAXIFS Function in Excel | With Examples 🔥🔥🔥
Просмотров 6442 года назад
How to Use MAXIFS Function in Excel | With Examples 🔥🔥🔥
Excel FORECAST Functions: How to Predict a Future Value 🔥
Просмотров 5952 года назад
Excel FORECAST Functions: How to Predict a Future Value 🔥
How to Use AVERAGEIFs Function in Excel: The Ultimate Guide
Просмотров 2352 года назад
How to Use AVERAGEIFs Function in Excel: The Ultimate Guide
How to Use AVERAGEIF Function in Excel | With Examples 🔥
Просмотров 2542 года назад
How to Use AVERAGEIF Function in Excel | With Examples 🔥
How to Create a Box and Whisker Plot in Excel
Просмотров 4332 года назад
How to Create a Box and Whisker Plot in Excel
How to Use PERCENTILE and QUARTILE in Excel: A Step-by-Step Guide 🔥🔥🔥
Просмотров 9 тыс.2 года назад
How to Use PERCENTILE and QUARTILE in Excel: A Step-by-Step Guide 🔥🔥🔥
How to use RANK Function in Excel | 5 Real Life Examples ⭐️⭐️⭐️⭐️
Просмотров 4692 года назад
How to use RANK Function in Excel | 5 Real Life Examples ⭐️⭐️⭐️⭐️
The Excel Trick to Change Negative Numbers to Zero & Keep Positive Numbers Unchanged
Просмотров 8 тыс.2 года назад
The Excel Trick to Change Negative Numbers to Zero & Keep Positive Numbers Unchanged
How to Generate Random Numbers In Excel? 3 EASY METHODS 😎✌️
Просмотров 1312 года назад
How to Generate Random Numbers In Excel? 3 EASY METHODS 😎✌️
How to Calculate Weighted Average in Excel? (2 Easy Steps)
Просмотров 1322 года назад
How to Calculate Weighted Average in Excel? (2 Easy Steps)
AVERAGE Functions in Excel | Everything You Need to Know!
Просмотров 1932 года назад
AVERAGE Functions in Excel | Everything You Need to Know!
9 Statistical functions in Excel you need to know | Excel Functions
Просмотров 1,3 тыс.2 года назад
9 Statistical functions in Excel you need to know | Excel Functions
Profit Margin in Excel | Calculate Gross Profit , Operating Profit and Net Profit Margin
Просмотров 7 тыс.2 года назад
Profit Margin in Excel | Calculate Gross Profit , Operating Profit and Net Profit Margin

Комментарии

  • @bsa18599
    @bsa18599 5 дней назад

    Excellent! Thank you.

  • @60secexplane
    @60secexplane Месяц назад

    Thanks for help

  • @ZidanZayyid
    @ZidanZayyid Месяц назад

    thanks for the tutorial my guy, it really works. i came from indonesia thank you

  • @manu15867
    @manu15867 Месяц назад

    Thank you for the brilliant demonstration!

  • @sunnyl.817
    @sunnyl.817 Месяц назад

    Excellent, very clear and straight to the point, you are a genius.

  • @Ullamodeh
    @Ullamodeh 2 месяца назад

    wrapwords nowraprows formula not detected ?

  • @angelcb3067
    @angelcb3067 2 месяца назад

    Thanks so muchhhh

  • @LughaQuiz
    @LughaQuiz 2 месяца назад

    Thank You very much - with your help I resolved the issue

  • @jhonmercado7928
    @jhonmercado7928 2 месяца назад

    El mejor y con lo mas basico

  • @Ashu_ashir
    @Ashu_ashir 2 месяца назад

    Still showing syntax what should i do plz tell

  • @shaistaansari5626
    @shaistaansari5626 2 месяца назад

    I'm not typing formula it is written accidently

  • @AliSa-qm5xe
    @AliSa-qm5xe 3 месяца назад

    thank you soooo much the list seperator solve it , you saved my day bro

  • @ParulWork
    @ParulWork 3 месяца назад

    THANK YOU SO MUCH

  • @gerda2513
    @gerda2513 3 месяца назад

    After I switched to a new computer, I couldn't use the VLOOKUP function in Excel properly. Your solution was very helpful. Thank you.

  • @oshoanu-or5uc
    @oshoanu-or5uc 3 месяца назад

    pls, how did you get 155? is it that you added 100 + 50 ?

  • @angelitollanos4294
    @angelitollanos4294 3 месяца назад

    Thank you... Great

  • @binartiknahipon247
    @binartiknahipon247 4 месяца назад

    NOT TRUE FORMULA

  • @chuchu9064
    @chuchu9064 4 месяца назад

    Thank you so much

  • @BombayMasti
    @BombayMasti 4 месяца назад

    Thanks for the explanation, but this is not working for the formula in data validation. Normally, on any cell the formula: =TableName[ColumnName] works fine but in data validation, list field it doesn't work, gives the broken formula error.

  • @deltawing9
    @deltawing9 4 месяца назад

    Thank you for this tutorial!

  • @hanikrm3448
    @hanikrm3448 4 месяца назад

    we need u to apply this on microsoft excel 2018 please

  • @DulzuraShop
    @DulzuraShop 4 месяца назад

    Dude I was searching for the resolution of this error, and I couldn't find anything in my country, thanks blessings

  • @Bulattrowmns
    @Bulattrowmns 4 месяца назад

    Steady sir, finally can, thank you for the solution.☺☺

  • @sawaimalhi8439
    @sawaimalhi8439 5 месяцев назад

    best hay

  • @zeze200031
    @zeze200031 5 месяцев назад

    Thank you

  • @SatkarAdhikari-w6d
    @SatkarAdhikari-w6d 5 месяцев назад

    ❤❤

  • @umeshmaskar2194
    @umeshmaskar2194 5 месяцев назад

    Thank you sir

  • @level2456
    @level2456 5 месяцев назад

    Thanks. How do you convert all numbers to multiple of 1/8 in the sheet

  • @darrylbanjoo2675
    @darrylbanjoo2675 5 месяцев назад

    Excellent, very clear and straight to the point, you are a genius.

  • @rohtashgoyal2835
    @rohtashgoyal2835 5 месяцев назад

    Sir ye mera upper to show ho rha hai but ander show nahi ho rha kya kia jaye

  • @marksibert305
    @marksibert305 5 месяцев назад

    I had not "discovered", but learned. It's so silly how discover is so erroneously used.

  • @yassirhassan2052
    @yassirhassan2052 5 месяцев назад

    you saved me bro, thankyou sooooo much>

  • @farestheflower
    @farestheflower 6 месяцев назад

    you're a goat bro

  • @importedmusic
    @importedmusic 6 месяцев назад

    This doesnt do what i need. In you example James appears once on the list. In mine he appears several times but I want only to do a lookup when the last name is a certain value.

  • @pradeepchaurasia25
    @pradeepchaurasia25 6 месяцев назад

    Facing same issue

  • @Nonu-panday
    @Nonu-panday 6 месяцев назад

    Ye sb baten dekhne me bhot chhoti hai but sabsr jda important and useful and

  • @vasianduban9995
    @vasianduban9995 6 месяцев назад

    i don't see reason to explain something that would take 20seconds whole 4minutes😩😩😩

  • @simonadebisi1174
    @simonadebisi1174 7 месяцев назад

    second solution worked. thanks a lot!!!!

  • @ibgreen-petersen1630
    @ibgreen-petersen1630 7 месяцев назад

    Thank you, my problems were also related to the list separators!!

  • @prathameshmore4739
    @prathameshmore4739 7 месяцев назад

    Very nice, thanks

  • @AmeerHamza-nw9dl
    @AmeerHamza-nw9dl 8 месяцев назад

    Thank you brother

  • @minhajkp9256
    @minhajkp9256 8 месяцев назад

    Thanks🤝

  • @bulldogkarma
    @bulldogkarma 8 месяцев назад

    That's great. How would you do that in addition to deleting the ".com" as well?

  • @eskunettube1633
    @eskunettube1633 8 месяцев назад

    Great

  • @Sanju-30
    @Sanju-30 8 месяцев назад

    Thank you So much🙇

  • @zenko3490
    @zenko3490 9 месяцев назад

    Thanks!

  • @vishwaasingh2230
    @vishwaasingh2230 9 месяцев назад

    Thaks a lot dear after watching your video my problem solved 😀

  • @Love_yourself1917
    @Love_yourself1917 9 месяцев назад

    Still facing the difficulties in logical operator, can you help me out?

  • @ShubhamPawar-n8l
    @ShubhamPawar-n8l 9 месяцев назад

    Still showing syntax, what should I do

  • @Thrivinbwoy
    @Thrivinbwoy 9 месяцев назад

    So booty for excel to still be having this crap issue in 2024