Рет қаралды 133
In this video, we are diving into the world of Excel with a little help from ChatGPT. If you are an Excel beginner looking to enhance your skills, you have come to the right place. Today, we will be focusing on the SUM function and how you can use it to analyse data effectively.
What you will learn:
1. Using the SUM function: We will start with the basics, showing you how to use the SUM function to total numbers in Excel.
2. Real world example: We will apply what we have learned to a real world dataset - the populations of European countries.
3. Top 10 Countries by Population: We will list the top 10 European countries by population and calculate their total population.
4. Calculating Percentages: Finally, we will show you how to calculate the percentage each country contributes to the total population.
Why Watch?
By the end of this tutorial, you will be able to:
Confidently use the SUM function in Excel.
Analyse data to find total values and percentages.
Steps Covered:
Entering Data: Input population data for each country.
Summing Up: Use the SUM function to find the total population of these top 10 countries.
Percentage Calculation: Calculate what percentage each country contributes to the total population.
Don't forget to like, subscribe, and hit the bell icon to stay updated with more tutorials and tips to boost your Excel skills. If you have any questions or topics you would like us to cover, leave a comment below. Let us get started and make Excel work for you.
#ExcelTips #ExcelForBeginners #ExcelwithChatGPT