WEBVTT 00:00.000 --> 00:14.760 Welcome back, young Excel explorers. Today, we're about to embark on a thrilling adventure 00:14.760 --> 00:19.920 into the world of advanced Excel skills. We'll discover the magic of formulas, create 00:19.920 --> 00:26.920 a class party budget, and even make our very own colorful charts. 00:26.920 --> 00:34.320 1. Introduction to Excel formulas. Formulas in Excel are like secret codes that help us 00:34.320 --> 00:39.640 solve math puzzles in a flash. Just like a wizard uses spells, we'll use formulas to 00:39.640 --> 00:45.680 add, subtract, and more. Every formula starts with an equal sign telling Excel to get 00:45.680 --> 00:52.880 ready for some number magic. Simple formulas. We'll learn. For 00:52.880 --> 00:58.840 addition, we'll use the sum formula, like equal sign sum, a 1, a 5, adds up everything 00:58.840 --> 01:06.240 from cell A1 to A5. For subtraction, it's simple, like B1A1 subtracts the number in 01:06.240 --> 01:13.000 A1 from B1. Formulas are our superpower in Excel, turning us into math wizards in just 01:13.000 --> 01:22.600 a few clicks. 2. Using formulas in our spreadsheet. Let's dive into creating a fun budget for 01:22.600 --> 01:28.880 a class party. Imagine we're planning for snacks, decorations, and games. We'll list them 01:28.880 --> 01:34.520 down and use the sum formula to see how much our party will cost. 01:34.520 --> 01:40.960 Steps to create our party budget table. In column A, list our party items like snacks, 01:40.960 --> 01:49.200 decorations, and games. In column B, enter pretend costs next to each item. Finally, 01:49.200 --> 01:56.240 let's add them up with the sum formula in cell B4 to find our total cost. Look at that! 01:56.240 --> 02:04.280 You've created a budget and learned a cool formula. Excel is not just fun, but super helpful. 02:04.280 --> 02:12.400 In fact, Excel formulas and charts, the hidden iceberg, narrator shares an interesting fact. 02:12.400 --> 02:17.640 Did you know Excel has over 400 different functions and can make more than 20 types of 02:17.640 --> 02:24.160 charts? That's like having a box full of different magic spells and colorful paints. 02:24.160 --> 02:31.160 Hands on activity, multiplication formula, and party budget. Ready for more? Let's add 02:31.160 --> 02:36.400 a twist with a multiplication formula. We'll calculate the total cost for each party 02:36.400 --> 02:42.440 item by multiplying its cost by quantity. It's like using Excel to count how many snacks 02:42.440 --> 02:48.520 we need for everyone. Steps to calculate total costs and budget. 02:48.520 --> 02:54.400 List your items and their costs in columns A and B. In column C, enter the quantity needed 02:54.400 --> 03:04.120 for each item. Then use equal sign B2 asterisk C2 in column D to multiply cost by quantity. 03:04.120 --> 03:13.240 To see our total budget, we'll add all costs with equal sign as sum D2 D4. And guess what? 03:13.240 --> 03:17.920 Excel will show us how much money we have left for the party. Change the numbers and see 03:17.920 --> 03:23.720 how Excel updates everything instantly. Isn't that amazing? 03:23.720 --> 03:31.400 3. Sorting data in Excel. Sorting in Excel is like tidying up your toys. It helps us 03:31.400 --> 03:36.360 arrange our information neatly so it's easy to understand. Today, we'll sort a list of 03:36.360 --> 03:43.080 our favorite movies alphabetically. Steps to sort our movie list. First, list your favorite 03:43.080 --> 03:50.400 movies in Excel. Then highlight them and click sort A to Z. Watch as Excel neatly arranges 03:50.400 --> 03:56.200 them from A to Z. Now finding your favorite movie in the list is as easy as finding your 03:56.200 --> 04:07.280 favorite toy in a tidy room. 4. Creating a basic chart. Let's turn our party budget 04:07.280 --> 04:12.840 into a colorful bar chart. Charts in Excel are like painting a picture with our data, 04:12.840 --> 04:17.760 calling us things in a way that's easy and fun to understand. 04:17.760 --> 04:25.000 Steps to create a bar chart. Select your budget data. Go to insert. Click bar chart and choose 04:25.000 --> 04:31.760 a style. Give your chart a title like class party budget. Look at the colorful bars showing 04:31.760 --> 04:37.720 our costs. It's a fun picture telling us how we're spending our party budget. Wow! What 04:37.720 --> 04:42.760 a journey we've had in the world of Excel. We've turned into number wizards, sorting 04:42.760 --> 04:47.760 masters and chart artists. Get ready for more Excel adventures where we'll dive into 04:47.760 --> 04:53.040 even cooler stuff. Until then, keep exploring and having fun with Excel.