Excel - Nested IF functions Tutorial
In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers how to find documents, images, videos, people, and conversations using the search bar located at the top of your Microsoft Office apps.
It also demonstrates how to access your most recently used documents and run an online search in the Microsoft Bing search engine.
This powerful tool helps you search your documents stored across your online storage services and gain time and efficiency in your searches.
This will help you improve your productivity and find the information you need quickly and easily in the Microsoft 365 environment.
- 3:30
- 3168 views
-
Excel - Sort and filter data
- 1:38
- Viewed 3028 times
-
Excel - Advanced IF functions
- 3:22
- Viewed 3362 times
-
Excel - Manage drop-down lists
- 6:12
- Viewed 3847 times
-
Excel - Sort details
- 4:46
- Viewed 3517 times
-
Excel - AutoFilter details
- 3:27
- Viewed 3563 times
-
Excel - Drop-down list settings
- 4:14
- Viewed 3536 times
-
Excel - Input and error messages
- 2:52
- Viewed 3493 times
-
Excel - Conditionally format dates
- 2:38
- Viewed 3454 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4723 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4432 times
-
Ink Equation
- 0:41
- Viewed 4392 times
-
3D Maps
- 1:41
- Viewed 4293 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4016 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4007 times
-
Manage conditional formatting
- 4:30
- Viewed 3982 times
-
Create a combo chart
- 1:47
- Viewed 3975 times
-
Create a PivotTable report manually
- 4:59
- Viewed 3909 times
-
Start using Excel
- 4:22
- Viewed 3902 times
-
More complex formulas
- 4:17
- Viewed 3881 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 3871 times
-
Manage drop-down lists
- 6:12
- Viewed 3847 times
-
The SUMIF function
- 5:27
- Viewed 3838 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 3826 times
-
A closer look at the ribbon
- 3:55
- Viewed 3805 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 3802 times
-
New Chart types
- 1:52
- Viewed 3800 times
-
Functions and formulas
- 3:24
- Viewed 3765 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3755 times
-
The SUM function
- 4:37
- Viewed 3744 times
-
Using functions
- 5:12
- Viewed 3732 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3723 times
-
AVERAGEIF function
- 3:04
- Viewed 3719 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 3701 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3700 times
-
Advanced formulas and references
- 4:06
- Viewed 3698 times
-
Freeze panes in detail
- 3:30
- Viewed 3660 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3651 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3629 times
-
AutoFill
- 2:55
- Viewed 3624 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3622 times
-
Customize charts
- 4:28
- Viewed 3621 times
-
Add numbers
- 2:54
- Viewed 3611 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3609 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3600 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3598 times
-
A first look at Excel 2016
- 3:22
- Viewed 3594 times
-
More print options
- 5:59
- Viewed 3585 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3581 times
-
IF with AND and OR
- 3:35
- Viewed 3580 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3573 times
-
Subtract time
- 3:58
- Viewed 3568 times
-
How things are organized
- 1:58
- Viewed 3567 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3565 times
-
AutoFilter details
- 3:27
- Viewed 3563 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3555 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3543 times
-
Advanced filter details
- 4:13
- Viewed 3537 times
-
Drop-down list settings
- 4:14
- Viewed 3536 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3534 times
-
Insert columns and rows
- 4:16
- Viewed 3532 times
-
Introduction to Excel
- 0:59
- Viewed 3520 times
-
Sort details
- 4:46
- Viewed 3517 times
-
Insert headers and footers
- 2:02
- Viewed 3511 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3501 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3500 times
-
Header and footer details
- 3:41
- Viewed 3497 times
-
Work with macros
- 4:40
- Viewed 3495 times
-
Input and error messages
- 2:52
- Viewed 3493 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3492 times
-
Save your macro
- 2:59
- Viewed 3457 times
-
Conditionally format dates
- 2:38
- Viewed 3454 times
-
Assign a button to a macro
- 2:49
- Viewed 3454 times
-
Operator order
- 2:04
- Viewed 3428 times
-
Basic math
- 2:28
- Viewed 3427 times
-
Copying formulas
- 3:00
- Viewed 3399 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3364 times
-
Improved version history
- 0:51
- Viewed 3362 times
-
Advanced IF functions
- 3:22
- Viewed 3362 times
-
TEXTJOIN
- 0:47
- Viewed 3330 times
-
Copy a chart
- 2:59
- Viewed 3322 times
-
IFS
- 1:05
- Viewed 3314 times
-
One click Forecasting
- 1:01
- Viewed 3307 times
-
Cell references
- 1:34
- Viewed 3303 times
-
Use conditional formatting
- 2:02
- Viewed 3302 times
-
Conditionally format text
- 2:12
- Viewed 3278 times
-
How to create a table
- 2:11
- Viewed 3273 times
-
Save, publish, and share
- 2:22
- Viewed 3266 times
-
Use slicers to filter data
- 1:25
- Viewed 3263 times
-
Add formulas and references
- 2:52
- Viewed 3250 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3242 times
-
Get going fast
- 1:38
- Viewed 3231 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3229 times
-
Weighted average
- 2:06
- Viewed 3222 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3210 times
-
Freeze or lock panes
- 1:06
- Viewed 3186 times
-
Map Chart in Excel
- 0:31
- Viewed 3133 times
-
Drop-down lists
- 0:55
- Viewed 3122 times
-
Average a group of numbers
- 2:01
- Viewed 3111 times
-
Create a chart
- 0:52
- Viewed 3100 times
-
Flash Fill
- 2:59
- Viewed 3097 times
-
CONCAT
- 0:51
- Viewed 3093 times
-
SWITCH
- 1:03
- Viewed 3063 times
-
Edit a macro
- 3:29
- Viewed 3060 times
-
Sort and filter data
- 1:38
- Viewed 3028 times
-
Share documents
- 1:13
- Viewed 2959 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 2933 times
-
Microsoft Search
- 0:34
- Viewed 2907 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 2858 times
-
Page numbers in depth
- 3:06
- Viewed 2808 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 2705 times
-
Funnel Chart
- 0:33
- Viewed 2645 times
-
Accessibility in Excel
- 1:12
- Viewed 2636 times
-
Check Accessibility in Excel
- 1:51
- Viewed 2614 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2389 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2340 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2230 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2226 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2159 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2129 times
-
Text before & after Function
- 4:57
- Viewed 2021 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 1807 times
-
Change chart type
- 1:29
- Viewed 1766 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1218 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1047 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 911 times
-
Format Data with Copilot
- 1:52
- Viewed 854 times
-
Use Copilot with Right-Click
- 01:45
- Viewed 79 times
-
Generate formulas from a concept
- 01:02
- Viewed 64 times
-
Remove a watermark
- 2:20
- Viewed 12219 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4723 times
-
Align flow chart shapes and add connectors
- 4:48
- Viewed 4693 times
-
Change font size, line spacing, and indentation
- 5:09
- Viewed 4662 times
-
Insert items in a presentation
- 2:38
- Viewed 4613 times
-
Trigger text to play over a video
- 2:58
- Viewed 4491 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4432 times
-
Ink Equation
- 0:41
- Viewed 4392 times
-
Change list formatting on the slide master
- 5:22
- Viewed 4390 times
-
3D Maps
- 1:41
- Viewed 4293 times
-
Print Notes Pages as handouts
- 3:15
- Viewed 4197 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 4171 times
-
Add headers and footers to slides
- 3:52
- Viewed 4125 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4016 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4007 times
-
Manage conditional formatting
- 4:30
- Viewed 3982 times
-
Create a combo chart
- 1:47
- Viewed 3975 times
-
Convert handwritten texts or drawings with Powerpoint
- 0:33
- Viewed 3936 times
-
Add sound effects to an animation
- 4:29
- Viewed 3908 times
-
Start using Excel
- 4:22
- Viewed 3902 times
-
More complex formulas
- 4:17
- Viewed 3881 times
-
Create a new slide master and layouts
- 5:13
- Viewed 3871 times
-
Manage drop-down lists
- 6:12
- Viewed 3847 times
-
The SUMIF function
- 5:27
- Viewed 3838 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 3836 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 3826 times
-
Animate charts and SmartArt
- 3:36
- Viewed 3818 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 3802 times
-
New Chart types
- 1:52
- Viewed 3800 times
-
Functions and formulas
- 3:24
- Viewed 3765 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3755 times
-
The SUM function
- 4:37
- Viewed 3744 times
-
Work with a motion path
- 2:50
- Viewed 3737 times
-
Using functions
- 5:12
- Viewed 3732 times
-
Customize the slide master
- 4:38
- Viewed 3730 times
-
Add a sound effect to a transition
- 3:45
- Viewed 3728 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3723 times
-
AVERAGEIF function
- 3:04
- Viewed 3719 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 3701 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3700 times
-
Advanced formulas and references
- 4:06
- Viewed 3698 times
-
Prepare a basic handout
- 4:30
- Viewed 3690 times
-
Freeze panes in detail
- 3:30
- Viewed 3660 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3651 times
-
Create a flow chart
- 3:27
- Viewed 3631 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3629 times
-
Animate pictures, shapes, text, and other objects
- 4:02
- Viewed 3624 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3622 times
-
Customize charts
- 4:28
- Viewed 3621 times
-
Add numbers
- 2:54
- Viewed 3611 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3609 times
-
Create slide content and save the template
- 4:50
- Viewed 3602 times
-
More print options
- 5:59
- Viewed 3585 times
-
Use slide masters to customize a presentation
- 3:07
- Viewed 3585 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3581 times
-
IF with AND and OR
- 3:35
- Viewed 3580 times
-
Finalize and review a presentation
- 2:02
- Viewed 3572 times
-
Subtract time
- 3:58
- Viewed 3568 times
-
Customize colors and save the theme
- 4:45
- Viewed 3566 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3565 times
-
AutoFilter details
- 3:27
- Viewed 3563 times
-
Build an org chart using the text pane
- 4:00
- Viewed 3560 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3555 times
-
Advanced filter details
- 4:13
- Viewed 3537 times
-
Drop-down list settings
- 4:14
- Viewed 3536 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3534 times
-
Work with handout masters
- 4:34
- Viewed 3533 times
-
Insert columns and rows
- 4:16
- Viewed 3532 times
-
Sort details
- 4:46
- Viewed 3517 times
-
Insert headers and footers
- 2:02
- Viewed 3511 times
-
Trigger an animation effect
- 2:29
- Viewed 3509 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3501 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3500 times
-
Header and footer details
- 3:41
- Viewed 3497 times
-
Work with macros
- 4:40
- Viewed 3495 times
-
Input and error messages
- 2:52
- Viewed 3493 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3492 times
-
Animate pictures and shapes
- 4:17
- Viewed 3490 times
-
Create slicers
- 3:55
- Viewed 3484 times
-
Backgrounds in PowerPoint: First Steps
- 3:20
- Viewed 3473 times
-
Save your macro
- 2:59
- Viewed 3457 times
-
Conditionally format dates
- 2:38
- Viewed 3454 times
-
Assign a button to a macro
- 2:49
- Viewed 3454 times
-
Change the theme background
- 5:38
- Viewed 3452 times
-
Create quick measures
- 3:02
- Viewed 3451 times
-
Picture backgrounds: Two methods
- 4:58
- Viewed 3444 times
-
Add a picture watermark
- 4:36
- Viewed 3443 times
-
Screen recording
- 0:49
- Viewed 3431 times
-
Operator order
- 2:04
- Viewed 3428 times
-
Basic math
- 2:28
- Viewed 3427 times
-
Create a template from a presentation
- 3:09
- Viewed 3408 times
-
Print handouts
- 4:32
- Viewed 3407 times
-
Copying formulas
- 3:00
- Viewed 3399 times
-
Print slides, notes, or handouts
- 2:48
- Viewed 3389 times
-
Improved version history
- 0:51
- Viewed 3362 times
-
Advanced IF functions
- 3:22
- Viewed 3362 times
-
Customize the design and layouts
- 5:06
- Viewed 3361 times
-
Customize master layouts
- 4:57
- Viewed 3342 times
-
Create custom animations with motion paths
- 3:39
- Viewed 3324 times
-
Copy a chart
- 2:59
- Viewed 3322 times
-
One click Forecasting
- 1:01
- Viewed 3307 times
-
Cell references
- 1:34
- Viewed 3303 times
-
Use conditional formatting
- 2:02
- Viewed 3302 times
-
Conditionally format text
- 2:12
- Viewed 3278 times
-
Create an automated workflow for Microsoft Forms with Power Automate
- 5:09
- Viewed 3276 times
-
How to create a table
- 2:11
- Viewed 3273 times
-
Use slicers to filter data
- 1:25
- Viewed 3263 times
-
Combine a path with other effects
- 4:49
- Viewed 3261 times
-
Add formulas and references
- 2:52
- Viewed 3250 times
-
Removing backgrounds in PowerPoint
- 2:45
- Viewed 3250 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3242 times
-
Apply and change a theme
- 5:13
- Viewed 3234 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3229 times
-
Weighted average
- 2:06
- Viewed 3222 times
-
Add headers and footers to a presentation
- 2:50
- Viewed 3221 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3210 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3204 times
-
Freeze or lock panes
- 1:06
- Viewed 3186 times
-
Edit headers and footers for handouts
- 2:43
- Viewed 3174 times
-
90 seconds about PowerPoint Slide Masters
- 1:17
- Viewed 3162 times
-
Add a "Date" field to your form or quiz in Microsoft Forms
- 1:06
- Viewed 3145 times
-
Ink Equation
- 0:40
- Viewed 3133 times
-
Conditional formatting
- 3:35
- Viewed 3133 times
-
Apply paths to layered pictures
- 5:28
- Viewed 3126 times
-
Drop-down lists
- 0:55
- Viewed 3122 times
-
Prepare and run your presentation
- 1:28
- Viewed 3120 times
-
Use the drill down filter
- 4:41
- Viewed 3116 times
-
Average a group of numbers
- 2:01
- Viewed 3111 times
-
Build an org chart using SmartArt Tools
- 5:09
- Viewed 3106 times
-
Add staff members
- 2:57
- Viewed 3106 times
-
Animate text
- 4:14
- Viewed 3100 times
-
Design motion paths
- 2:30
- Viewed 3097 times
-
Create a sequence with line paths
- 6:42
- Viewed 3094 times
-
New chart types
- 0:39
- Viewed 3092 times
-
Create an org chart
- 3:09
- Viewed 3069 times
-
Creating and managing a group
- 1:56
- Viewed 3062 times
-
Edit a macro
- 3:29
- Viewed 3060 times
-
Sort and filter data
- 1:38
- Viewed 3028 times
-
Calculate function
- 4:22
- Viewed 3028 times
-
Multiple choice questions in Microsoft Forms
- 2:14
- Viewed 2984 times
-
Present Live
- 3:13
- Viewed 2957 times
-
Make a reservation [Staff]
- 1:55
- Viewed 2923 times
-
Add bullets to text
- 2:24
- Viewed 2906 times
-
Create a new calendar
- 2:55
- Viewed 2897 times
-
Trigger a video
- 4:06
- Viewed 2868 times
-
How to add branching logic in Microsoft Forms
- 1:55
- Viewed 2845 times
-
Start using PowerPoint
- 2:06
- Viewed 2814 times
-
Turn on the drill down feature
- 2:23
- Viewed 2806 times
-
Measure how people feel about something with the Likert scale in Microsoft Forms
- 2:02
- Viewed 2804 times
-
Save time by creating your form with quick import
- 2:20
- Viewed 2793 times
-
Turn your Excel tables into real lists!
- 1:12
- Viewed 2786 times
-
Integrate Bookings into TEAMS
- 1:36
- Viewed 2755 times
-
Manage interactions
- 1:56
- Viewed 2739 times
-
Manage relations between data sources
- 2:37
- Viewed 2671 times
-
Make a reservation [Customer]
- 2:13
- Viewed 2667 times
-
Add an alert to a visual
- 2:24
- Viewed 2655 times
-
Complete and Share a Schedule
- 2:02
- Viewed 2604 times
-
Create a Schedule and Organise it with the Help of Groups
- 1:42
- Viewed 2575 times
-
Research in your notes
- 1:13
- Viewed 2563 times
-
Add a service
- 2:03
- Viewed 2537 times
-
What are measures?
- 2:58
- Viewed 2536 times
-
Create custom fields
- 1:21
- Viewed 2533 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2531 times
-
Use template to prepare your Agile SCRUM meeting
- 2:50
- Viewed 2490 times
-
Create and organise a group
- 1:30
- Viewed 2483 times
-
Organise notes
- 2:57
- Viewed 2470 times
-
How Clock In Works
- 0:22
- Viewed 2430 times
-
Get a rating in Microsoft Forms
- 1:32
- Viewed 2414 times
-
Manage our recent documents
- 2:24
- Viewed 2387 times
-
Create a Microsoft Forms form directly in OneDrive
- 1:33
- Viewed 2387 times
-
Make better tables
- 10 min
- Viewed 2383 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2347 times
-
Creating and managing campaigns
- 1:39
- Viewed 2313 times
-
Add a Visio diagram
- 1:23
- Viewed 2254 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2230 times
-
Draw, sketch or handwrite notes
- 1:25
- Viewed 2210 times
-
Send your notes by email
- 0:42
- Viewed 2207 times
-
Password protect your notes
- 1:43
- Viewed 2204 times
-
Easily measure user experience with Net Promoter Score in Microsoft Forms
- 1:32
- Viewed 2182 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2159 times
-
Create your first form or quiz in Microsoft Forms
- 2:12
- Viewed 2153 times
-
Create a new shared booking page
- 2:32
- Viewed 2139 times
-
Add an Excel spreadsheet
- 1:31
- Viewed 2128 times
-
Insert online videos
- 0:41
- Viewed 2124 times
-
Imbrication OneNote / Teams
- 1:03
- Viewed 2119 times
-
Save, share and share everything
- 0:49
- Viewed 2102 times
-
Add files
- 1:26
- Viewed 2075 times
-
See who's collaborating
- 2:01
- Viewed 2064 times
-
Imbrication OneNote / Outlook
- 1:37
- Viewed 2053 times
-
Add items
- 2:04
- Viewed 2049 times
-
How to Copy a Schedule
- 0:39
- Viewed 2047 times
-
Creating or editing office documents in Engage
- 0:44
- Viewed 2039 times
-
Text before & after Function
- 4:57
- Viewed 2021 times
-
Sync and sharing
- 0:28
- Viewed 2012 times
-
Use formatting toolbar and styles to format forms and quizzes
- 1:55
- Viewed 1989 times
-
Upload an existing video from your device
- 1:11
- Viewed 1986 times
-
Use page templates
- 2:19
- Viewed 1984 times
-
Install Office on 5 devices
- 1:53
- Viewed 1979 times
-
Add staff
- 2:36
- Viewed 1960 times
-
Make a reservation Employee]
- 1:50
- Viewed 1953 times
-
Create a video from the web app
- 1:20
- Viewed 1924 times
-
Meeting recordings in Microsoft Teams
- 1:13
- Viewed 1918 times
-
Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms
- 2:14
- Viewed 1911 times
-
Record a live PowerPoint presentation
- 1:18
- Viewed 1890 times
-
Create a video from the mobile app
- 1:13
- Viewed 1880 times
-
Add or edit a thumbnail
- 0:59
- Viewed 1877 times
-
Use "Text" fields to create a contact form
- 2:16
- Viewed 1856 times
-
Let responders submit files in Microsoft Forms
- 1:58
- Viewed 1841 times
-
Change chart type
- 1:29
- Viewed 1766 times
-
Create custom fields
- 1:12
- Viewed 1657 times
-
Engaging and animating a group
- 1:55
- Viewed 1636 times
-
Send a single form in multiple languages
- 1:21
- Viewed 1623 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 1616 times
-
Make a reservation [Customer]
- 1:51
- Viewed 1492 times
-
Save a PowerPoint presentation
- 1:10
- Viewed 1445 times
-
Add a service
- 2:28
- Viewed 1416 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 1312 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 1269 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1218 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 1201 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 1128 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 1122 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1047 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 1028 times
-
Draft an Email with Copilot
- 2:35
- Viewed 1023 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 911 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 897 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 888 times
-
Format Data with Copilot
- 1:52
- Viewed 854 times
-
Optimize Email Writing with Copilot Coaching
- 1:41
- Viewed 835 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 822 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 812 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 757 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 255 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 250 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 171 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 146 times
-
Edit and customize views
- 01:55
- Viewed 141 times
-
Save and Print a Message
- 01:48
- Viewed 139 times
-
Create different types of events
- 01:46
- Viewed 137 times
-
Create and add a signature to messages
- 01:26
- Viewed 135 times
-
Sort and filter emails
- 02:51
- Viewed 129 times
-
Create a reminder for yourself
- 01:59
- Viewed 127 times
-
Manage Teams online meeting options
- 01:56
- Viewed 122 times
-
Change the default font of your emails
- 01:05
- Viewed 120 times
-
Search options
- 01:23
- Viewed 116 times
-
Create an Email Template
- 01:40
- Viewed 86 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 83 times
-
Make changes to a text
- 01:05
- Viewed 82 times
-
Delay Email Delivery
- 01:10
- Viewed 73 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 73 times
-
Translate Emails in Outlook
- 01:32
- Viewed 73 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 71 times
-
Improve Email Accessibility
- 02:02
- Viewed 68 times
-
Generate formulas from a concept
- 01:02
- Viewed 64 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 64 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 62 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 62 times
-
Generating Loop Content with Copilot
- 01:18
- Viewed 60 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 58 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 56 times
-
Use a Copilot Agent
- 01:24
- Viewed 20 times
-
Modify with Pages
- 01:20
- Viewed 21 times
-
Generate and manipulate an image in Word
- 01:19
- Viewed 33 times
-
Create Outlook rules with Copilot
- 01:12
- Viewed 19 times
-
Generate the email for the recipient
- 00:44
- Viewed 24 times
-
Action Function
- 04:18
- Viewed 21 times
-
Search Function
- 03:42
- Viewed 32 times
-
Date and Time Function
- 02:53
- Viewed 23 times
-
Logical Function
- 03:14
- Viewed 42 times
-
Text Function
- 03:25
- Viewed 30 times
-
Basic Function
- 02:35
- Viewed 20 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 32 times
-
Introduction to Power Fx
- 01:09
- Viewed 25 times
-
The New Calendar
- 03:14
- Viewed 48 times
-
Sections
- 02:34
- Viewed 25 times
-
Customizing Views
- 03:25
- Viewed 21 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 46 times
-
Guide to Using the Microsoft Authenticator App
- 01:47
- Viewed 32 times
-
Turn on Multi-Factor Authentication in the Admin Section
- 02:07
- Viewed 31 times
-
Manual Activation of Multi-Factor Authentication
- 01:40
- Viewed 20 times
-
Concept of Multi-Factor Authentication
- 01:51
- Viewed 45 times
-
Use the narrative Builder
- 01:31
- Viewed 48 times
-
Microsoft Copilot Academy
- 00:42
- Viewed 42 times
-
Connect Copilot to a third party app
- 01:11
- Viewed 46 times
-
Share a document with copilot
- 00:36
- Viewed 40 times
-
Configurate a page with copilot
- 01:47
- Viewed 52 times
-
Use Copilot with Right-Click
- 01:45
- Viewed 79 times
-
Draft a Service Memo with Copilot
- 02:21
- Viewed 73 times
-
Extract Invoice Data and Generate a Pivot Table
- 02:34
- Viewed 75 times
-
Summarize Discussions and Schedule a Meeting Slot
- 02:25
- Viewed 109 times
-
Formulate a Request for Pricing Conditions via Email
- 02:20
- Viewed 125 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:52
- Viewed 125 times
-
Retrieve Data from a Web Page and Include it in Excel
- 04:35
- Viewed 163 times
-
Create a Desktop Flow with Power Automate from a Template
- 03:12
- Viewed 121 times
-
Understand the Specifics and Requirements of Desktop Flows
- 02:44
- Viewed 55 times
-
Dropbox: Create a SAS Exchange Between SharePoint and Another Storage Service
- 03:34
- Viewed 135 times
-
Excel: List Files from a Channel in an Excel Workbook with Power Automate
- 04:51
- Viewed 62 times
-
Excel: Link Excel Scripts and Power Automate Flows
- 03:22
- Viewed 66 times
-
SharePoint: Link Microsoft Forms and Lists in a Power Automate Flow
- 04:43
- Viewed 176 times
-
SharePoint: Automate File Movement to an Archive Library
- 05:20
- Viewed 49 times
-
Share Power Automate Flows
- 02:20
- Viewed 51 times
-
Manipulate Dynamic Content with Power FX
- 03:59
- Viewed 57 times
-
Leverage Variables with Power FX in Power Automate
- 03:28
- Viewed 56 times
-
Understand the Concept of Variables and Loops in Power Automate
- 03:55
- Viewed 58 times
-
Add Conditional “Switch” Actions in Power Automate
- 03:58
- Viewed 78 times
-
Add Conditional “IF” Actions in Power Automate
- 03:06
- Viewed 52 times
-
Create an Approval Flow with Power Automate
- 03:10
- Viewed 128 times
-
Create a Scheduled Flow with Power Automate
- 01:29
- Viewed 160 times
-
Create an Instant Flow with Power Automate
- 02:18
- Viewed 108 times
-
Create an Automated Flow with Power Automate
- 03:28
- Viewed 101 times
-
Create a Simple Flow with AI Copilot
- 04:31
- Viewed 77 times
-
Create a Flow Based on a Template with Power Automate
- 03:20
- Viewed 54 times
-
Discover the “Build Space”
- 02:26
- Viewed 45 times
-
The Power Automate Mobile App
- 01:39
- Viewed 45 times
-
Familiarize Yourself with the Different Types of Flows
- 01:37
- Viewed 60 times
-
Understand the Steps to Create a Power Automate Flow
- 01:51
- Viewed 59 times
-
Discover the Power Automate Home Interface
- 02:51
- Viewed 50 times
-
Access Power Automate for the Web
- 01:25
- Viewed 65 times
-
Understand the Benefits of Power Automate
- 01:30
- Viewed 64 times
-
Add a third-party application
- 02:40
- Viewed 88 times
-
Send a survey or questionnaire by email
- 02:06
- Viewed 78 times
-
Collaborate directly during an event with Microsoft Loop and Outlook
- 02:01
- Viewed 78 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 71 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 56 times
-
Create your reservation page for appointment booking (Bookings)
- 03:17
- Viewed 96 times
-
Share a document securely with Outlook
- 02:21
- Viewed 64 times
-
Block a sender
- 01:54
- Viewed 89 times
-
Identify a fraudulent email
- 02:06
- Viewed 63 times
-
Prevent transfer for a meeting
- 01:19
- Viewed 57 times
-
Prevent the forwarding of an email
- 01:01
- Viewed 77 times
-
Protect an email by encrypting
- 01:10
- Viewed 58 times
-
Provide an overview of best security practices in Outlook
- 01:08
- Viewed 53 times
-
Recover deleted items
- 01:09
- Viewed 148 times
-
Recall or replace an e-mail message
- 01:45
- Viewed 80 times
-
Respond to invitations as a delegate
- 02:55
- Viewed 53 times
-
Use a Shared Mailbox
- 01:18
- Viewed 86 times
-
Create and Manage Appointments in Delegated Calendars
- 02:04
- Viewed 62 times
-
Send Emails on Behalf of Someone Else
- 01:13
- Viewed 83 times
-
Mailbox Delegation Setup
- 01:59
- Viewed 55 times
-
Calendar Delegation Setup
- 01:21
- Viewed 81 times
-
Grant delegate access in Microsoft 365 administration
- 01:23
- Viewed 145 times
-
Make changes to a text
- 01:05
- Viewed 82 times
-
Consult the adoption of Copilot through Viva Insights
- 00:52
- Viewed 73 times
-
Search from emails with Copilot
- 00:53
- Viewed 340 times
-
Using Copilot in OneNote with Right-Click
- 01:21
- Viewed 64 times
-
Organizing OneNote with Copilot
- 00:46
- Viewed 86 times
-
Tracking changes in a Loop page with Copilot
- 01:16
- Viewed 74 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 64 times
-
Generating Loop Content with Copilot
- 01:18
- Viewed 60 times
-
Send invitations or reminders with Copilot
- 00:53
- Viewed 102 times
-
Generate formulas from a concept
- 01:02
- Viewed 64 times
-
Analyzing a OneDrive file with Copilot
- 01:25
- Viewed 85 times
-
Analyzing multiple OneDrive documents with Copilot
- 01:01
- Viewed 99 times
-
Use the Meeting Dashboard
- 02:48
- Viewed 123 times
-
Respond to a Meeting Poll
- 01:30
- Viewed 89 times
-
Create a Meeting Poll
- 02:48
- Viewed 83 times
-
Display Three Time Zones
- 01:52
- Viewed 56 times
-
View Other Calendars
- 00:50
- Viewed 78 times
-
Open a Shared Calendar
- 01:29
- Viewed 82 times
-
Share Your Calendar
- 01:54
- Viewed 82 times
-
Use the Scheduling Assistant
- 01:42
- Viewed 67 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 62 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 62 times
-
Translate Emails in Outlook
- 01:32
- Viewed 73 times
-
Make Your Outlook Signature Accessible
- 01:12
- Viewed 59 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 83 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 58 times
-
Improve Email Accessibility
- 02:02
- Viewed 68 times
-
Send Automatic Out-of-Office Replies
- 02:22
- Viewed 73 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 73 times
-
Respect Your Colleagues' Off Hours (Viva Insights)
- 01:27
- Viewed 51 times
-
Delay Email Delivery
- 01:10
- Viewed 73 times
-
Use Conversation View
- 01:47
- Viewed 60 times
-
Clean Up Your Inbox
- 01:18
- Viewed 82 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 310 times
-
Use Categories
- 02:51
- Viewed 56 times
-
Easily Sort Your Mails
- 01:38
- Viewed 63 times
-
Automate Routine Actions
- 02:19
- Viewed 65 times
-
Create an Email Template
- 01:40
- Viewed 86 times
-
Create a task from a message
- 02:00
- Viewed 113 times
-
Share a task list
- 03:10
- Viewed 121 times
-
Create a task or reminder
- 01:50
- Viewed 124 times
-
Task Module Overview
- 01:56
- Viewed 148 times
-
Manage Teams online meeting options
- 01:56
- Viewed 122 times
-
Edit or delete an appointment, meeting or event
- 01:50
- Viewed 209 times
-
Create a reminder for yourself
- 01:59
- Viewed 127 times
-
Respond to a meeting
- 01:00
- Viewed 128 times
-
Create an appointment or meeting
- 01:44
- Viewed 134 times
-
Create different types of events
- 01:46
- Viewed 137 times
-
Edit and customize views
- 01:55
- Viewed 141 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 141 times
-
Search options
- 01:23
- Viewed 116 times
-
Sort and filter emails
- 02:51
- Viewed 129 times
-
Request a Read Receipt or Delivery Confirmation
- 02:01
- Viewed 192 times
-
The Bcc Field in Detail
- 01:53
- Viewed 124 times
-
Save and Print a Message
- 01:48
- Viewed 139 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 171 times
-
Attach files efficiently in Outlook
- 02:20
- Viewed 131 times
-
Process an incoming message
- 01:53
- Viewed 117 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 146 times
-
Organize into Folders
- 01:57
- Viewed 135 times
-
Set Your Work Hours in Outlook
- 02:02
- Viewed 124 times
-
Create and add a signature to messages
- 01:26
- Viewed 135 times
-
Manage new message notifications
- 01:40
- Viewed 123 times
-
Change the default font of your emails
- 01:05
- Viewed 120 times
-
Manage Views
- 02:36
- Viewed 109 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 167 times
-
Explore the Interface
- 03:22
- Viewed 122 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 129 times
-
Survey Consumer Satisfaction Panel with ChatGPT
- 01:55
- Viewed 221 times
-
Enhance Your Product on Social Media with ChatGPT
- 02:13
- Viewed 242 times
-
Write a Product Description with ChatGPT
- 02:30
- Viewed 209 times
-
Structure Your Product Launch Project
- 01:51
- Viewed 255 times
-
Initiate a Market Research Study with ChatGPT
- 02:08
- Viewed 188 times
-
Manage Storage Space
- 02:08
- Viewed 238 times
-
Synchronize Your Teams and SharePoint Files on Your Computer
- 01:29
- Viewed 229 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 255 times
-
Make a File Request
- 01:24
- Viewed 255 times
-
Restore Your OneDrive Space
- 01:42
- Viewed 234 times
-
Find All Shares from the Same Person
- 01:08
- Viewed 244 times
-
Modify Sharing Rules
- 00:53
- Viewed 242 times
-
Check Granted Shares
- 00:48
- Viewed 230 times
-
Protect My Document with a Password and Expiration Date
- 01:02
- Viewed 248 times
-
Avoid Abusive Document Sharing
- 00:57
- Viewed 216 times
-
Best Security Practices on OneDrive
- 01:27
- Viewed 242 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 250 times
-
Search for Documents
- 01:31
- Viewed 227 times
-
Use Document History or Restore a Document to a Previous Version
- 02:11
- Viewed 306 times
-
Discover the Meaning of OneDrive Icons
- 02:16
- Viewed 243 times
-
Sync OneDrive with a Computer
- 02:38
- Viewed 239 times
-
Edit, Delete a Share
- 02:16
- Viewed 297 times
-
Share and Collaborate OneDrive
- 02:45
- Viewed 239 times
-
Power and Manage OneDrive
- 01:36
- Viewed 231 times
-
What is OneDrive ?
- 01:14
- Viewed 437 times
Objectifs :
Understand the use of IF functions in Excel, including nested IF functions, to evaluate multiple criteria and determine outcomes such as grades and commissions based on specific conditions.
Chapitres :
-
Introduction to IF Functions
The IF function in Excel allows users to perform logical tests and return different values based on whether the test evaluates to true or false. This is particularly useful for scenarios where decisions need to be made based on specific criteria. -
Nested IF Functions
Nested IF functions enable users to test multiple criteria within a single formula. This means you can place one IF function inside another, allowing for more complex decision-making processes. For example, to determine a student's grade based on their score, we can use nested IF functions. -
Example: Determining Student Grades
To determine a student's grade based on their score, we can set up a formula that evaluates different score ranges. If Bob's score in cell B2 is 90, the formula will return an 'A'. If the score is not 90, we then check if it is 80, and so on for grades C, D, and F. The order of evaluation is crucial: - If B2 >= 90, return 'A'. - If B2 >= 80, return 'B'. - If B2 >= 70, return 'C'. - If B2 >= 60, return 'D'. - Otherwise, return 'F'. -
Understanding Formula Evaluation Order
The order in which conditions are evaluated in a nested IF function is important. For instance, if the first condition (B2 >= 90) is true, the formula returns 'A' and stops evaluating further. If it is false, the next condition (B2 >= 80) is evaluated, and this process continues until a true condition is found or all conditions are evaluated. -
Example: Calculating Sales Commissions
Another practical application of IF functions is calculating commissions for sales staff based on their sales figures. For example, if Bob's sales in cell B2 are $10,000, he earns a 5% commission. If his sales are $5,000, he earns a 2% commission; otherwise, he earns nothing. The formula would be structured as follows: - If B2 >= 10,000, commission is 5%. - If B2 >= 5,000, commission is 2%. - If neither condition is met, commission is 0%. The order of these evaluations is also critical, as the highest sales threshold must be checked first. -
Conclusion
In summary, mastering IF functions and their nested variations in Excel allows users to create dynamic formulas that can handle multiple criteria and outcomes. This skill is essential for tasks such as grading and commission calculations, where precise evaluations are necessary for accurate results.
FAQ :
What is an IF function in Excel?
An IF function in Excel is a logical function that allows you to perform a test and return one value if the test is true and another value if it is false.
How do nested IF functions work?
Nested IF functions allow you to test multiple conditions by placing one IF function inside another. This enables you to evaluate several criteria and return different outcomes based on those evaluations.
What is the purpose of using absolute cell references?
Absolute cell references are used in formulas to ensure that the reference to a specific cell does not change when the formula is copied to another location. This is crucial for maintaining consistent calculations.
How can I calculate commissions using IF functions?
You can calculate commissions by using IF functions to evaluate sales amounts against predefined thresholds. Depending on the sales figure, the function can return different commission rates.
What happens if none of the IF conditions are met?
If none of the IF conditions are met, the function will return the final value specified in the last IF statement, which is often a default value like zero.
Can I use AND and OR functions with IF?
Yes, you can combine IF functions with AND and OR functions to evaluate multiple conditions simultaneously, allowing for more complex logical tests.
Quelques cas d'usages :
Grading System
Using nested IF functions to determine student grades based on their scores. For example, if a student's score is 90 or above, they receive an 'A'; if it's between 80 and 89, they receive a 'B', and so on. This application helps educators quickly assess student performance.
Sales Commission Calculation
Implementing IF functions to calculate commissions for sales staff based on their sales figures. For instance, if a salesperson sells $10,000 or more, they earn a 5% commission; if they sell between $5,000 and $9,999, they earn 2%. This method ensures that sales teams are incentivized based on their performance.
Budget Allocation
Using IF functions to allocate budget based on department performance. For example, departments that meet their sales targets could receive additional funding, while those that do not may have their budgets reduced. This approach helps organizations manage resources effectively.
Loan Approval Process
Applying nested IF functions in a loan approval process to evaluate applicants based on credit scores and income levels. For example, applicants with a credit score above 700 and a stable income may be approved, while others may be denied or referred for further review.
Employee Performance Reviews
Using IF functions to categorize employee performance during reviews. For instance, employees can be rated as 'Excellent', 'Satisfactory', or 'Needs Improvement' based on their performance metrics, helping HR make informed decisions about promotions and raises.
Glossaire :
IF function
A logical function in Excel that returns one value if a condition is true and another value if it is false.
Nested IF functions
An IF function placed inside another IF function, allowing for multiple criteria to be tested and more than two possible outcomes.
Absolute cell reference
A cell reference that remains constant when a formula is copied to another cell, indicated by the dollar sign (e.g., $B$2).
Commission
A payment to an employee based on the sales they generate, often expressed as a percentage of the sales amount.
Criteria
The conditions or standards used to evaluate or make decisions in functions like IF.
Sales threshold
A specific sales amount that must be met or exceeded to qualify for a certain commission rate.