Microsoft 365 Excel Beginner (2023): Formulas and Functions

Name: Microsoft 365 Excel Beginner (2023): Formulas and Functions
Author: Bob Akbar

Use built-In and custom formulas and functions

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

Course: On-Demand

Hello, my name is Bob Akbar and. In these lessons you will learn formulas and functions. These consist of common math functions, date functions and creating formulas. In this lesson you will learn common math functions. You will notice that we have a nice table set up here where we have the person, the date and the sale. We have multiple people listed, multiple dates and multiple sales. The first thing that I want to show you is a very simple way of getting a sum total as we are asking for here in C eleven. And what you do is you click. Your mouse in the first row and. You drag down all the way to your final destination, c eleven, where you want the answer. And you will notice up here there. Is a button on your ribbon called AutoSum and this will provide you with the total automatically. There it is, 23, 39 and that. Is exactly what we have here. Now what we want to do is. We have these functions here, total. And in this one we also use. The sum function where it is the. Sum of c two through c nine. And that gave us the same answer as we have down here. You notice if we clicked on here since we highlighted all these cells, it has c two through c ten and c ten is empty. So let's go and construct this sum function together. We will start as always by hitting. The equal sign and we will start. To type in sum. And you notice the function shows up here. We can click on that or we can open our parentheses. If you click on that it will give you the guidance to follow to the next step. And it says a one to a three. So this is the example giving you a range of where the numbers should be. Add all the numbers in a range. Of cells and we will put in. C two. To c nine, close our. Parentheses and press Enter. And you will notice before we do that, it is highlighted properly in here. And there it is. The next one that we want to do is the average, how much was the average sale? And if we take a look at. That, the function is called average c two to c nine. That is the proper range and let's. Do this one together as well. We put equals. AV and you notice. Once we start typing this Excel is helpful. It lets us select from a list of possible functions. So we will pick average. It gives us the proper guidance where it gives us a description, the arithmetic mean, which is the average that we want, the common average. And it also gives us an example which is the average and the range of the numbers to put in there. And end our range is c two to c nine. And there it is, it's highlighted and. It is ready to go and.

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

Course Description

Excel provides easy-to-use yet powerful features for data summaries. These lessons cover the common math functions for totals, averages, minimum and maximum, as well as rounding. While these functions are applicable to most other data types, there are unique individual functions specific to date data. Finally, you will learn how to create customized formulas for your needs.

The date functions provide unique abilities such as counting the number of days in a week or month, including a distinction for working days. When combined with the common math functions, you can gain an accurate view and summary of data for measured activity. For example, you might calculate results based upon available dates for projects. You will learn how to automate the input process while avoiding common errors when working with data. By understanding formulas and functions, you can gather, analyze, and present your data, in a comprehensive method and in a wide range of situations.

What You'll Learn

Apply common Excel math functions for totals, averages, minimum, maximum, and rounding
Use date functions to count days in a week or month, including distinctions for working days
Create customized formulas tailored to your specific data needs
Combine math and date functions to summarize and measure activity accurately
Automate the data input process while avoiding common errors
Gather, analyze, and present data comprehensively across a wide range of situations

Key Takeaways

Excel offers easy-to-use yet powerful features for summarizing data.
Common math functions handle totals, averages, minimum, maximum, and rounding, and apply to most data types.
Date functions provide unique abilities such as counting days in a week or month and distinguishing working days.
Combining date functions with common math functions gives an accurate view and summary of measured activity, such as calculating results based on available project dates.
Understanding formulas and functions lets you automate input and avoid common errors when working with data.

Frequently Asked Questions

What will I learn in this course?

You will learn to understand common Excel functions, automate function and formula input, and optimize data work in Excel, covering math functions, date functions, and creating customized formulas.

What topics do the lessons cover?

The lessons cover Common Math Functions (Parts 1 and 2), Date Functions, and Creating Formulas.

Who is this course for?

It is a beginner-level course on Microsoft 365 Excel (2023) focused on formulas and functions, suitable for those learning to summarize, analyze, and present data in Excel.

What skills does this course help build?

It builds skills in Microsoft Excel, Spreadsheets, Excel Formulas, Excel Macros, Excel Solver, and Math Functions.

How do date functions help when working with data?

Date functions let you count the number of days in a week or month, including a distinction for working days, and when combined with common math functions they help calculate results such as those based on available dates for projects.