Excel - Using functions Tutorial
In this video, you will learn about using functions in Microsoft 365. The video covers the basics of functions and demonstrates how to use them effectively in various Microsoft 365 applications.
This will help you enhance your productivity and make the most out of the Microsoft 365 suite.
- 5:12
- 4371 views
-
Remove a watermark
- 2:20
- Viewed 39976 times
-
Change the default font for your emails
- 1:09
- Viewed 23593 times
-
Collapsible headings
- 3:03
- Viewed 20294 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 20257 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 19709 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 16964 times
-
Create automatic reminders
- 4:10
- Viewed 13135 times
-
Protect a document shared by password
- 1:41
- Viewed 12057 times
-
Morph transition
- 0:43
- Viewed 11230 times
-
Add a sound effect to a transition
- 3:45
- Viewed 10732 times
-
Remove a watermark
- 2:20
- Viewed 39976 times
-
Change the default font for your emails
- 1:09
- Viewed 23593 times
-
Collapsible headings
- 3:03
- Viewed 20294 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 20257 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 19709 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 16964 times
-
Create automatic reminders
- 4:10
- Viewed 13135 times
-
Protect a document shared by password
- 1:41
- Viewed 12057 times
-
Morph transition
- 0:43
- Viewed 11230 times
-
Add a sound effect to a transition
- 3:45
- Viewed 10732 times
-
Block the transfer of a Teams meeting
- 02:40
- Viewed 20 times
-
Control the start of recording and transcription in Teams
- 03:03
- Viewed 21 times
-
Manage access to recordings and transcripts in Teams
- 02:59
- Viewed 19 times
-
Enable voice isolation in Teams
- 02:14
- Viewed 32 times
-
Add a collaborative page to a Teams channel
- 03:06
- Viewed 18 times
-
Manage a channel’s files with the Shared tab in Teams
- 03:34
- Viewed 29 times
-
Track conversations and organize channels in Teams
- 03:26
- Viewed 20 times
-
Create a team and set up the first channel in Teams
- 03:02
- Viewed 21 times
-
Create a newsletter in Outlook
- 02:23
- Viewed 56 times
-
Create an issue in an Outlook newsletter
- 03:27
- Viewed 60 times
Objectifs :
This video aims to teach users how to effectively use the AutoSum, SUM, PRODUCT, and basic arithmetic functions in Excel to perform calculations efficiently. It covers the syntax of these functions, how to handle ranges of cells, and the use of keyboard shortcuts to streamline the process.
Chapitres :
-
Introduction to AutoSum
AutoSum is a powerful feature in Excel that simplifies the process of adding adjacent cells in rows and columns. Instead of manually typing cell references like A3, A4, A5, and A6, users can simply click the cell to the right of a row or below a column. By navigating to the Home tab and selecting AutoSum, users can quickly verify the formula and execute the addition. -
Understanding the SUM Function
The SUM function is a predefined formula that saves time when adding numbers. The syntax for the SUM function is as follows: SUM(number1, number2, ...). For example, the formula SUM(A3:A6) adds all cells from A3 through A6. It is important to note that when using AutoSum, if there are empty cells in the range, it may not recognize the entire column. -
Adding Non-Adjacent Cells
To add cells that are not adjacent, users can hold down the Ctrl key, click on the desired cells, and press Enter. This method allows the SUM function to include only the selected cells containing numbers while ignoring any empty cells. -
Subtraction in Excel
While there is no dedicated subtraction function in Excel, users can perform subtraction using a basic formula. This involves taking a number or cell and subtracting the next number or cell. For example, to subtract values, the formula would look like: =A1 - A2. -
Using Keyboard Shortcuts
The keyboard shortcut for AutoSum is Alt + =, followed by pressing Enter. This shortcut allows for quick calculations without navigating through menus. -
Multiplication with the PRODUCT Function
To multiply numbers or cells, users can utilize the PRODUCT function. The syntax is similar to the SUM function: PRODUCT(number1, number2, ...). To multiply a range of cells, hold down the Ctrl key, select the desired cells, and press Enter. This function also ignores empty cells. -
Division in Excel
Division can be performed using a basic formula where a number or cell is divided by the next number or cell. Users can also divide the result of one function, such as PRODUCT, by another function, such as SUM. For example, the formula =PRODUCT(B3:B6)/SUM(C3:C6) divides the product of the cells in B3 through B6 by the sum of the cells in C3 through C6.
FAQ :
What is AutoSum and how do I use it?
AutoSum is a feature in spreadsheet software that allows you to quickly add adjacent cells. To use it, click the cell to the right of a row or below a column, then click on the AutoSum button in the Home tab. Verify the formula and click AutoSum again to add the cells automatically.
What is the syntax of the SUM function?
The syntax of the SUM function is SUM(number1, number2, ...), where you can input numbers or cell references separated by commas. For example, SUM(A3:A6) adds all the values from cells A3 to A6.
How can I add non-adjacent cells using the SUM function?
To add non-adjacent cells, hold down the Ctrl key while clicking on the desired cells and ranges, then press Enter. This will use the SUM function to add the selected cells while ignoring any empty cells.
Is there a subtraction function in spreadsheets?
No, there isn't a specific subtraction function. To subtract, you can use a basic formula like 'number1 - number2'.
How do I multiply numbers in a spreadsheet?
You can multiply numbers using the PRODUCT function. The syntax is PRODUCT(number1, number2, ...). To multiply a range of cells, hold down the Ctrl key, select the desired cells, and press Enter.
Can I divide the results of one function by another?
Yes, you can divide the results of one function by another. For example, you can divide the result of the PRODUCT function by the result of the SUM function using a formula like 'PRODUCT(B3:B6) / SUM(C3:C6)'.
Quelques cas d'usages :
Budget Calculation
Using the SUM function to calculate the total expenses in a budget spreadsheet by adding up all the costs listed in adjacent cells.
Sales Data Analysis
Applying AutoSum to quickly find the total sales figures for a month by selecting the relevant cells in a sales report.
Inventory Management
Utilizing the PRODUCT function to calculate the total value of inventory by multiplying the quantity of items by their unit price.
Financial Reporting
Creating a financial report that uses both SUM and PRODUCT functions to analyze revenue and expenses, providing insights into profitability.
Performance Metrics
Employing the SUM function to aggregate performance metrics across different departments, allowing for a comprehensive overview of organizational performance.
Glossaire :
AutoSum
A feature in spreadsheet software that automatically adds adjacent cells in rows and columns.
SUM function
A predefined formula used to add a range of numbers or cell references. The syntax is SUM(number1, number2, ...).
Syntax
The set of rules that defines the combinations of symbols that are considered to be correctly structured formulas in a programming language.
Range
A selection of two or more cells in a spreadsheet, typically defined by the first and last cell in the selection (e.g., A3:A6).
Ctrl key
A modifier key on a keyboard that, when pressed in combination with other keys, performs special functions.
Product function
A predefined formula used to multiply a range of numbers or cell references. The syntax is PRODUCT(number1, number2, ...).
Division
The mathematical operation of dividing one number by another, typically represented by the forward slash (/) symbol.
Basic formula
A simple mathematical expression that performs calculations using numbers or cell references.