Hello there! Today, I am going to show you how you can use Chat DPT to improve your Excel skills. Microsoft Excel is a spreadsheet program used for computations and charts, while Chat DPT is a state-of-the-art natural language processing AI.
Now, let’s see how you can combine both. As you can see on the screen, this is the interface of ChatGPT. For example, you may want to use the SUM function in Excel, but you do not know how to go about it. You can ask Chat DPT for help. Type a question like ‘Can you explain how the SUM function works in Excel?’
Chat DPT will provide you with detailed information on how the SUM function can be used, along with different examples. This way, you can see that Chat DPT can be used to improve your Excel skills.
Apart from the SUM function, you can also use other functions like AVERAGE. For example, you can ask Chat DPT ‘How can I use the AVERAGE function in Excel?’
Chat DPT will again provide you with detailed analysis and examples of how to use the AVERAGE function.
Now, let’s go to a sample worksheet. Assume we have a worksheet with marks of students in subjects like Maths, English, and Biology. We want to get the total marks. If you don’t know how to do it, you can ask Chat DPT for the formula. For example, you can type ‘How can I add cells E5 to G5?’ Chat DPT will give you the formula ‘SUM(E5:G5)’. You can copy the code and paste it in Excel to get the answer.
Similarly, you can ask Chat DPT for the formula to find the average of cells E5 to G5. Chat DPT will provide you with the formula ‘AVERAGE(E5:G5)’. You can copy the code and paste it in Excel to get the average.
By combining the power of Chat DPT and Microsoft Excel, you can improve your Excel skills. You can apply this same method to other functions in Excel as well.
To learn more, subscribe to this channel and don’t forget to like, share, and leave your comments. Keep watching for more informative videos!
