Microsoft 365 Excel Beginner (2023): Fundamentals

Name: Microsoft 365 Excel Beginner (2023): Fundamentals
Author: Bob Akbar

Learn the fundamentals of Microsoft 365 Excel

Preview the first lesson free — get full access to all 5 lessons.

Course: On-Demand

Hello, my name is Bob Akbar, and. In these lessons we will cover cell. References, worksheet references, and ribbons and menus. In this lesson I will show you. How to use fundamentals of Excel and. How to use cell references. It you will notice that the cells. Are organized by letters on top and. Numbers to the side. So when we click on a cell such as this one, the B and the two are highlighted for us, which. Means that is the cell B two. We can simply enter values. And then. Comes in our ability to do something. With referencing these cells. So we can't simply just say add Jane Candy to John Candy and get a result. So what we have to do is. We have to remember that our cell. References, they are B two and B three for Jane's Candy and John's Candy. And if we simply want to see. What the sum of those two is. We have to add them together. Now a common mistake is people simply. Put in B two plus b three. And you will notice if you do. That, excel will completely ignore the fact. That you want that to be summed. And simply will type it in as a text. And you'll notice up here in the. Formula bar, it simply says b two plus b three. The way to fix this is always. Start off with an equal sign in front. And you notice when we do that, something happens. We have B two in blue, highlighted down here, b three in red, highlighted down here. And now our result for b eight. Will be the sum of b two plus b three. We can also add other cells by. Pressing the plus sign, typing them in. Or simply clicking on the cell. So if b four is the next one we want in our sum, we. Can click on that and you will. Notice the line that's circling around that. Tells us that is the next one selected. If we wanted, we can press Enter. Or plus for another value or we can simply hit Escape and it takes. Away the cell that we simply selected. So let's go ahead and add b. Four. And b five to our sum. Here. And I'm simply clicking on the cells. Easiest way to do this. And now you will notice we have. The blue number b two, the red number b three, the purple number b four, and the green number B five. And I can simply hit enter. And there we are. There is the total for the Candy. And in here I can put total. And there it is. There's our number. Total is 24. Now we can do the same thing. For the cookies. And we do the. Same thing with equals. Take the first cell, simply click in. It, hit the plus sign, second cell, third cell, and fourth cell. And there it is. Now if we want to find the average. We can take these numbers and. Divide them by how many people there were. So we are going to take the total here and divide it by four. Which is the number of people that we have 1234. We can do the same thing with the cookies. You will notice that this is the. Forward slash, not the backward slash for division. Please keep that in mind. And there it is. Now we may also want to if you take a look here, we have. Some color ink here and we can. Do that by highlighting the cells going to home. And you will notice there's a fill. Color here and we can pick the. Color that we would like. We can also do a formatting for the cells and you will notice here it says General and we can turn. It into numbers currency. So numbers we are fine with and. We will pick numbers and if we. Want to decrease or increase the decimal. Values here they are increase decimal, decrease. Decimal. And we can have the number that we desire excel, not display fractions. So decimals are the best that you're. Going to get when you format your cells. Thanks for watching. Stay tuned for the next lesson where. We will talk about worksheet references.

Beginner Provider : Bob Akbar 5 Lessons · 28m in Arabic, German, English, Spanish, French, Portuguese, Chinese

Course Description

Excel provides tools that make working with numbers easy. By understanding the fundamentals of Excel, you can simplify the math functions required in your work and perform impressive functions with a few clicks and keystrokes.

Simple calculations may be sufficient for small data sets and individual use. When working with larger sets of data for an audience, summaries and separation of data may be desirable. Target audiences often desire a summary of the data, also known as results. Excel provides multiple worksheets to assist the user in organizing data and results in separate sections.

Excel uses unique cell references to store and use data. Tables, worksheets and workbooks are utilized to keep data organized. By properly using these tools to organize various levels of data, there are simple-to-navigate options for both storage and retrieval in data calculations. Ribbons and menus provide an easy method for finding the common functions you need.

What You'll Learn

Understand cell references and how Excel uses unique cell references to store and use data
Use worksheets to organize data into separate sections
Differentiate between worksheets and workbooks
Navigate ribbons and menus to find common functions
Organize data using tables, worksheets, and workbooks for storage and retrieval

Key Takeaways

Excel provides tools that make working with numbers easy and can simplify the math functions required in your work.
Excel uses unique cell references to store and use data.
Tables, worksheets, and workbooks are utilized to keep data organized for simple-to-navigate storage and retrieval.
Excel provides multiple worksheets to help users organize data and results in separate sections.
Ribbons and menus provide an easy method for finding the common functions you need.

Frequently Asked Questions

What will I learn in this course?

This course covers the fundamentals of Microsoft 365 Excel, including understanding cell references, using worksheets to organize data, understanding ribbons and menus, and differentiating between worksheets and workbooks.

Who is this course for?

It is a beginner-level course for learners who want to understand the fundamentals of Excel and simplify the math functions required in their work.

What topics do the lessons cover?

The lessons cover Cell References, Worksheet References (Parts 1 and 2), and Ribbons and Menus (Parts 1 and 2).

What skills will I gain from this course?

You will build skills in Microsoft Excel, Spreadsheets, Excel Formulas, Excel Macros, Excel Services, and working with Tabular Data.

How does Excel help when working with larger data sets?

Excel provides multiple worksheets to help organize data and results into separate sections, and uses tables, worksheets, and workbooks to keep various levels of data organized for storage and retrieval.