Excel - IFS Tutorial
In this video, you will learn about the Intelligent Search feature in Microsoft 365. The video covers the search tools in Microsoft 365, including searching on your computer, using Microsoft Search, finding content and people in SharePoint, searching your emails, and more.
This will help you save time and easily find documents, information, and people within the Microsoft 365 suite.
- 1:05
- 3379 views
-
Excel - SWITCH
- 1:03
- Viewed 3131 times
-
Excel - CONCAT
- 0:51
- Viewed 3169 times
-
Excel - TEXTJOIN
- 0:47
- Viewed 3413 times
-
Excel - Creating a forecast sheet with Excel
- 0:43
- Viewed 1879 times
-
Excel - MAXIFS & MINIFS
- 1:06
- Viewed 2994 times
-
Excel - Work simultaneously with others on a workbook
- 0:43
- Viewed 2928 times
-
Excel - More complex formulas
- 4:17
- Viewed 3982 times
-
Excel - Basic math
- 2:28
- Viewed 3484 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4809 times
-
Ink Equation
- 0:41
- Viewed 4603 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4504 times
-
3D Maps
- 1:41
- Viewed 4400 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4138 times
-
Create a combo chart
- 1:47
- Viewed 4087 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4077 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4034 times
-
Manage conditional formatting
- 4:30
- Viewed 4032 times
-
More complex formulas
- 4:17
- Viewed 3982 times
-
Start using Excel
- 4:22
- Viewed 3961 times
-
Create a PivotTable report manually
- 4:59
- Viewed 3947 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 3919 times
-
Manage drop-down lists
- 6:12
- Viewed 3916 times
-
The SUMIF function
- 5:27
- Viewed 3896 times
-
New Chart types
- 1:52
- Viewed 3884 times
-
A closer look at the ribbon
- 3:55
- Viewed 3872 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 3860 times
-
Functions and formulas
- 3:24
- Viewed 3856 times
-
The SUM function
- 4:37
- Viewed 3816 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 3816 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3805 times
-
Advanced formulas and references
- 4:06
- Viewed 3802 times
-
Using functions
- 5:12
- Viewed 3793 times
-
AVERAGEIF function
- 3:04
- Viewed 3792 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3787 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3770 times
-
Freeze panes in detail
- 3:30
- Viewed 3727 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3713 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3696 times
-
AutoFill
- 2:55
- Viewed 3694 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3692 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3679 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3678 times
-
Add numbers
- 2:54
- Viewed 3677 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3672 times
-
Customize charts
- 4:28
- Viewed 3669 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3662 times
-
A first look at Excel 2016
- 3:22
- Viewed 3659 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3652 times
-
How things are organized
- 1:58
- Viewed 3648 times
-
Subtract time
- 3:58
- Viewed 3645 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3637 times
-
More print options
- 5:59
- Viewed 3636 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3635 times
-
AutoFilter details
- 3:27
- Viewed 3631 times
-
IF with AND and OR
- 3:35
- Viewed 3622 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3613 times
-
Advanced filter details
- 4:13
- Viewed 3607 times
-
Introduction to Excel
- 0:59
- Viewed 3602 times
-
Insert columns and rows
- 4:16
- Viewed 3600 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3596 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3596 times
-
Insert headers and footers
- 2:02
- Viewed 3593 times
-
Drop-down list settings
- 4:14
- Viewed 3589 times
-
Conditionally format dates
- 2:38
- Viewed 3571 times
-
Work with macros
- 4:40
- Viewed 3570 times
-
Sort details
- 4:46
- Viewed 3568 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3557 times
-
Input and error messages
- 2:52
- Viewed 3554 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3554 times
-
Header and footer details
- 3:41
- Viewed 3546 times
-
Assign a button to a macro
- 2:49
- Viewed 3521 times
-
Save your macro
- 2:59
- Viewed 3504 times
-
Copying formulas
- 3:00
- Viewed 3490 times
-
Operator order
- 2:04
- Viewed 3485 times
-
Basic math
- 2:28
- Viewed 3484 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3434 times
-
Improved version history
- 0:51
- Viewed 3430 times
-
Advanced IF functions
- 3:22
- Viewed 3423 times
-
TEXTJOIN
- 0:47
- Viewed 3413 times
-
Copy a chart
- 2:59
- Viewed 3392 times
-
Use conditional formatting
- 2:02
- Viewed 3370 times
-
One click Forecasting
- 1:01
- Viewed 3364 times
-
Cell references
- 1:34
- Viewed 3360 times
-
Save, publish, and share
- 2:22
- Viewed 3359 times
-
Conditionally format text
- 2:12
- Viewed 3346 times
-
How to create a table
- 2:11
- Viewed 3333 times
-
Use slicers to filter data
- 1:25
- Viewed 3327 times
-
Weighted average
- 2:06
- Viewed 3325 times
-
Add formulas and references
- 2:52
- Viewed 3325 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3295 times
-
Get going fast
- 1:38
- Viewed 3286 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3285 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3260 times
-
Freeze or lock panes
- 1:06
- Viewed 3243 times
-
Nested IF functions
- 3:30
- Viewed 3225 times
-
Map Chart in Excel
- 0:31
- Viewed 3209 times
-
Create a chart
- 0:52
- Viewed 3189 times
-
Drop-down lists
- 0:55
- Viewed 3187 times
-
Average a group of numbers
- 2:01
- Viewed 3184 times
-
Flash Fill
- 2:59
- Viewed 3180 times
-
CONCAT
- 0:51
- Viewed 3169 times
-
Edit a macro
- 3:29
- Viewed 3152 times
-
SWITCH
- 1:03
- Viewed 3131 times
-
Sort and filter data
- 1:38
- Viewed 3093 times
-
Share documents
- 1:13
- Viewed 3014 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 2994 times
-
Microsoft Search
- 0:34
- Viewed 2964 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 2928 times
-
Page numbers in depth
- 3:06
- Viewed 2873 times
-
Funnel Chart
- 0:33
- Viewed 2769 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 2762 times
-
Check Accessibility in Excel
- 1:51
- Viewed 2686 times
-
Accessibility in Excel
- 1:12
- Viewed 2681 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2470 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2405 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2290 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2277 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2207 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2191 times
-
Text before & after Function
- 4:57
- Viewed 2073 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 1879 times
-
Change chart type
- 1:29
- Viewed 1806 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1392 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1084 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 959 times
-
Format Data with Copilot
- 1:52
- Viewed 888 times
-
Use Copilot with Right-Click
- 01:45
- Viewed 272 times
-
Generate formulas from a concept
- 01:02
- Viewed 95 times
-
Create an insights grid
- 01:19
- Viewed 40 times
-
Use the Copilot pane
- 01:12
- Viewed 19 times
-
Process text
- 01:03
- Viewed 17 times
-
Morph transition
- 0:43
- Viewed 6759 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4034 times
-
Instant captions & subtitles in Powerpoint
- 0:43
- Viewed 3623 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3596 times
-
TEXTJOIN
- 0:47
- Viewed 3413 times
-
Design ideas with Powerpoint
- 0:37
- Viewed 3386 times
-
Automatically mark deleted emails as read
- 0:46
- Viewed 3354 times
-
Let Outlook read your emails out loud
- 0:32
- Viewed 3319 times
-
On-Slide 3D Model Animation
- 0:45
- Viewed 3218 times
-
Map Chart in Excel
- 0:31
- Viewed 3209 times
-
CONCAT
- 0:51
- Viewed 3169 times
-
SWITCH
- 1:03
- Viewed 3131 times
-
Discover the new simplified ribbon
- 0:29
- Viewed 3109 times
-
How to search a file in all channels
- 0:29
- Viewed 3086 times
-
Display 3 time zones
- 0:37
- Viewed 3029 times
-
Quickly sort emails
- 0:27
- Viewed 3015 times
-
Locate your documents
- 0:20
- Viewed 3006 times
-
Reusing slides
- 0:37
- Viewed 2995 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 2994 times
-
Insert icons
- 0:43
- Viewed 2987 times
-
Microsoft Search
- 0:34
- Viewed 2964 times
-
Prevent recipients from forwarding emails
- 0:34
- Viewed 2947 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 2928 times
-
Make your presentation lively with the Zoom function
- 0:41
- Viewed 2910 times
-
Identify meeting members
- 0:26
- Viewed 2899 times
-
Custom your personal reminders and notifications
- 0:44
- Viewed 2842 times
-
Prevent forwarding of a meeting
- 0:29
- Viewed 2819 times
-
3D Models
- 0:42
- Viewed 2809 times
-
Use dictate to type in Word
- 0:27
- Viewed 2804 times
-
Icon insertion
- 0:54
- Viewed 2789 times
-
How to set quiet hours
- 0:32
- Viewed 2778 times
-
Funnel Chart
- 0:33
- Viewed 2769 times
-
Let Word read your documents out loud
- 0:36
- Viewed 2695 times
-
Translate your Word documents into any language
- 0:33
- Viewed 2686 times
-
Edit document with natural gestures
- 0:34
- Viewed 2664 times
-
Embed fonts in presentations
- 0:40
- Viewed 2620 times
-
New tab "Recording"
- 0:43
- Viewed 2487 times
-
PivotTable Insertions
- 0:43
- Viewed 2402 times
-
Chat with co-authors while editing
- 0:29
- Viewed 2376 times
-
Removing the background of a picture
- 0:41
- Viewed 2370 times
-
Make screenshots easier
- 3:59
- Viewed 2249 times
-
Configure multiple virtual desktops
- 1:35
- Viewed 2213 times
-
Work on multiple windows
- 1:21
- Viewed 2074 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 1879 times
-
Draft a Service Memo
- 02:33
- Viewed 28 times
-
Extract Invoice Data and Generate a Pivot Table
- 03:26
- Viewed 25 times
-
Formulate a Request for Pricing Conditions via Email
- 02:32
- Viewed 39 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:41
- Viewed 37 times
-
SharePoint Page Co-Editing: Collaborate in Real Time
- 02:14
- Viewed 15 times
-
Other Coaches
- 01:45
- Viewed 19 times
-
Agents in SharePoint
- 02:44
- Viewed 20 times
-
Prompt coach
- 02:49
- Viewed 20 times
-
Modify, Share, and Install an Agent
- 01:43
- Viewed 17 times
-
Configure a Copilot Agent
- 02:39
- Viewed 19 times
-
Describe a copilot agent
- 01:32
- Viewed 22 times
-
Rewrite with Copilot
- 01:21
- Viewed 21 times
-
Analyze a video
- 01:21
- Viewed 16 times
-
Use the Copilot pane
- 01:12
- Viewed 19 times
-
Process text
- 01:03
- Viewed 17 times
-
Create an insights grid
- 01:19
- Viewed 40 times
-
Generate and manipulate an image in PowerPoint
- 01:47
- Viewed 20 times
-
Interact with a web page with Copilot
- 00:36
- Viewed 51 times
-
Create an image with Copilot
- 00:42
- Viewed 69 times
-
Summarize a PDF with Copilot
- 00:41
- Viewed 48 times
-
Analyze your documents with Copilot
- 01:15
- Viewed 45 times
-
Chat with Copilot
- 00:50
- Viewed 32 times
-
Particularities of Personal and Professional Copilot Accounts
- 00:40
- Viewed 58 times
-
Data Privacy in Copilot
- 00:43
- Viewed 42 times
-
Access Copilot
- 00:25
- Viewed 74 times
-
Use a Copilot Agent
- 01:24
- Viewed 63 times
-
Modify with Pages
- 01:20
- Viewed 58 times
-
Generate and manipulate an image in Word
- 01:19
- Viewed 65 times
-
Create Outlook rules with Copilot
- 01:12
- Viewed 58 times
-
Generate the email for the recipient
- 00:44
- Viewed 52 times
-
Action Function
- 04:18
- Viewed 47 times
-
Search Function
- 03:42
- Viewed 72 times
-
Date and Time Function
- 02:53
- Viewed 58 times
-
Logical Function
- 03:14
- Viewed 95 times
-
Text Function
- 03:25
- Viewed 75 times
-
Basic Function
- 02:35
- Viewed 49 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 74 times
-
Introduction to Power Fx
- 01:09
- Viewed 51 times
-
The New Calendar
- 03:14
- Viewed 108 times
-
Sections
- 02:34
- Viewed 62 times
-
Customizing Views
- 03:25
- Viewed 52 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 112 times
-
Guide to Using the Microsoft Authenticator App
- 01:47
- Viewed 68 times
-
Turn on Multi-Factor Authentication in the Admin Section
- 02:07
- Viewed 61 times
-
Manual Activation of Multi-Factor Authentication
- 01:40
- Viewed 45 times
-
Concept of Multi-Factor Authentication
- 01:51
- Viewed 77 times
-
Use the narrative Builder
- 01:31
- Viewed 71 times
-
Microsoft Copilot Academy
- 00:42
- Viewed 69 times
-
Connect Copilot to a third party app
- 01:11
- Viewed 79 times
-
Share a document with copilot
- 00:36
- Viewed 67 times
-
Configurate a page with copilot
- 01:47
- Viewed 80 times
-
Use Copilot with Right-Click
- 01:45
- Viewed 272 times
-
Draft a Service Memo with Copilot
- 02:21
- Viewed 99 times
-
Extract Invoice Data and Generate a Pivot Table
- 02:34
- Viewed 112 times
-
Summarize Discussions and Schedule a Meeting Slot
- 02:25
- Viewed 173 times
-
Formulate a Request for Pricing Conditions via Email
- 02:20
- Viewed 190 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:52
- Viewed 172 times
-
Retrieve Data from a Web Page and Include it in Excel
- 04:35
- Viewed 250 times
-
Create a Desktop Flow with Power Automate from a Template
- 03:12
- Viewed 179 times
-
Understand the Specifics and Requirements of Desktop Flows
- 02:44
- Viewed 95 times
-
Dropbox: Create a SAS Exchange Between SharePoint and Another Storage Service
- 03:34
- Viewed 188 times
-
Excel: List Files from a Channel in an Excel Workbook with Power Automate
- 04:51
- Viewed 113 times
-
Excel: Link Excel Scripts and Power Automate Flows
- 03:22
- Viewed 107 times
-
SharePoint: Link Microsoft Forms and Lists in a Power Automate Flow
- 04:43
- Viewed 266 times
-
SharePoint: Automate File Movement to an Archive Library
- 05:20
- Viewed 94 times
-
Share Power Automate Flows
- 02:20
- Viewed 84 times
-
Manipulate Dynamic Content with Power FX
- 03:59
- Viewed 97 times
-
Leverage Variables with Power FX in Power Automate
- 03:28
- Viewed 81 times
-
Understand the Concept of Variables and Loops in Power Automate
- 03:55
- Viewed 89 times
-
Add Conditional “Switch” Actions in Power Automate
- 03:58
- Viewed 123 times
-
Add Conditional “IF” Actions in Power Automate
- 03:06
- Viewed 79 times
-
Create an Approval Flow with Power Automate
- 03:10
- Viewed 192 times
-
Create a Scheduled Flow with Power Automate
- 01:29
- Viewed 379 times
-
Create an Instant Flow with Power Automate
- 02:18
- Viewed 171 times
-
Create an Automated Flow with Power Automate
- 03:28
- Viewed 164 times
-
Create a Simple Flow with AI Copilot
- 04:31
- Viewed 141 times
-
Create a Flow Based on a Template with Power Automate
- 03:20
- Viewed 109 times
-
Discover the “Build Space”
- 02:26
- Viewed 81 times
-
The Power Automate Mobile App
- 01:39
- Viewed 81 times
-
Familiarize Yourself with the Different Types of Flows
- 01:37
- Viewed 90 times
-
Understand the Steps to Create a Power Automate Flow
- 01:51
- Viewed 119 times
-
Discover the Power Automate Home Interface
- 02:51
- Viewed 84 times
-
Access Power Automate for the Web
- 01:25
- Viewed 121 times
-
Understand the Benefits of Power Automate
- 01:30
- Viewed 102 times
-
Add a third-party application
- 02:40
- Viewed 124 times
-
Send a survey or questionnaire by email
- 02:06
- Viewed 149 times
-
Collaborate directly during an event with Microsoft Loop and Outlook
- 02:01
- Viewed 124 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 118 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 89 times
-
Create your reservation page for appointment booking (Bookings)
- 03:17
- Viewed 158 times
-
Share a document securely with Outlook
- 02:21
- Viewed 100 times
-
Block a sender
- 01:54
- Viewed 141 times
-
Identify a fraudulent email
- 02:06
- Viewed 91 times
-
Prevent transfer for a meeting
- 01:19
- Viewed 104 times
-
Prevent the forwarding of an email
- 01:01
- Viewed 115 times
-
Protect an email by encrypting
- 01:10
- Viewed 101 times
-
Provide an overview of best security practices in Outlook
- 01:08
- Viewed 77 times
-
Recover deleted items
- 01:09
- Viewed 196 times
-
Recall or replace an e-mail message
- 01:45
- Viewed 116 times
-
Respond to invitations as a delegate
- 02:55
- Viewed 83 times
-
Use a Shared Mailbox
- 01:18
- Viewed 126 times
-
Create and Manage Appointments in Delegated Calendars
- 02:04
- Viewed 97 times
-
Send Emails on Behalf of Someone Else
- 01:13
- Viewed 131 times
-
Mailbox Delegation Setup
- 01:59
- Viewed 94 times
-
Calendar Delegation Setup
- 01:21
- Viewed 112 times
-
Grant delegate access in Microsoft 365 administration
- 01:23
- Viewed 187 times
-
Make changes to a text
- 01:05
- Viewed 134 times
-
Consult the adoption of Copilot through Viva Insights
- 00:52
- Viewed 116 times
-
Search from emails with Copilot
- 00:53
- Viewed 573 times
-
Using Copilot in OneNote with Right-Click
- 01:21
- Viewed 95 times
-
Organizing OneNote with Copilot
- 00:46
- Viewed 113 times
-
Tracking changes in a Loop page with Copilot
- 01:16
- Viewed 99 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 89 times
-
Generating Loop Content with Copilot
- 01:18
- Viewed 101 times
-
Send invitations or reminders with Copilot
- 00:53
- Viewed 176 times
-
Generate formulas from a concept
- 01:02
- Viewed 95 times
-
Analyzing a OneDrive file with Copilot
- 01:25
- Viewed 117 times
-
Analyzing multiple OneDrive documents with Copilot
- 01:01
- Viewed 135 times
-
Use the Meeting Dashboard
- 02:48
- Viewed 194 times
-
Respond to a Meeting Poll
- 01:30
- Viewed 134 times
-
Create a Meeting Poll
- 02:48
- Viewed 141 times
-
Display Three Time Zones
- 01:52
- Viewed 95 times
-
View Other Calendars
- 00:50
- Viewed 108 times
-
Open a Shared Calendar
- 01:29
- Viewed 109 times
-
Share Your Calendar
- 01:54
- Viewed 118 times
-
Use the Scheduling Assistant
- 01:42
- Viewed 109 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 101 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 106 times
-
Translate Emails in Outlook
- 01:32
- Viewed 107 times
-
Make Your Outlook Signature Accessible
- 01:12
- Viewed 96 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 133 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 100 times
-
Improve Email Accessibility
- 02:02
- Viewed 103 times
-
Send Automatic Out-of-Office Replies
- 02:22
- Viewed 110 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 119 times
-
Respect Your Colleagues' Off Hours (Viva Insights)
- 01:27
- Viewed 81 times
-
Delay Email Delivery
- 01:10
- Viewed 112 times
-
Use Conversation View
- 01:47
- Viewed 106 times
-
Clean Up Your Inbox
- 01:18
- Viewed 110 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 386 times
-
Use Categories
- 02:51
- Viewed 96 times
-
Easily Sort Your Mails
- 01:38
- Viewed 90 times
-
Automate Routine Actions
- 02:19
- Viewed 102 times
-
Create an Email Template
- 01:40
- Viewed 129 times
-
Create a task from a message
- 02:00
- Viewed 149 times
-
Share a task list
- 03:10
- Viewed 155 times
-
Create a task or reminder
- 01:50
- Viewed 165 times
-
Task Module Overview
- 01:56
- Viewed 268 times
-
Manage Teams online meeting options
- 01:56
- Viewed 154 times
-
Edit or delete an appointment, meeting or event
- 01:50
- Viewed 275 times
-
Create a reminder for yourself
- 01:59
- Viewed 172 times
-
Respond to a meeting
- 01:00
- Viewed 159 times
-
Create an appointment or meeting
- 01:44
- Viewed 168 times
-
Create different types of events
- 01:46
- Viewed 177 times
-
Edit and customize views
- 01:55
- Viewed 175 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 184 times
-
Search options
- 01:23
- Viewed 144 times
-
Sort and filter emails
- 02:51
- Viewed 170 times
-
Request a Read Receipt or Delivery Confirmation
- 02:01
- Viewed 252 times
-
The Bcc Field in Detail
- 01:53
- Viewed 178 times
-
Save and Print a Message
- 01:48
- Viewed 181 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 230 times
-
Attach files efficiently in Outlook
- 02:20
- Viewed 166 times
-
Process an incoming message
- 01:53
- Viewed 157 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 216 times
-
Organize into Folders
- 01:57
- Viewed 170 times
-
Set Your Work Hours in Outlook
- 02:02
- Viewed 187 times
-
Create and add a signature to messages
- 01:26
- Viewed 161 times
-
Manage new message notifications
- 01:40
- Viewed 159 times
-
Change the default font of your emails
- 01:05
- Viewed 157 times
-
Manage Views
- 02:36
- Viewed 138 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 209 times
-
Explore the Interface
- 03:22
- Viewed 157 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 158 times
Objectifs :
Understand the IFS function in Excel, its application in calculating bonuses based on years of service, and how it simplifies the process compared to nested IF statements.
Chapitres :
-
Introduction to the IFS Function
The IFS function in Excel is a powerful tool that allows users to evaluate multiple conditions and return a value corresponding to the first TRUE condition. This function simplifies the process of handling multiple criteria, making it easier to read and manage compared to traditional nested IF statements. -
Application of the IFS Function
In this example, we will calculate the bonus that each employee receives based on their years of service. The IFS function allows us to set specific conditions for different ranges of years of experience, streamlining the calculation process. -
Setting Conditions for Bonuses
To illustrate the use of the IFS function, we will define the following conditions for calculating bonuses: - If years of experience is less than or equal to 5, the bonus will be $100. - Additional conditions can be added for other ranges of years of service, allowing for a comprehensive bonus structure. -
Advantages of Using the IFS Function
Using the IFS function offers several advantages: - **Readability**: The IFS function is much easier to read than multiple nested IF statements. - **Efficiency**: It allows testing of up to 127 different conditions in a single formula, making it a versatile choice for complex calculations. -
Conclusion
The IFS function is an essential tool for anyone working with Excel, especially when dealing with multiple conditions. By simplifying the process of evaluating criteria, it enhances both the efficiency and clarity of your calculations, making it a preferred choice over traditional nested IF statements.
FAQ :
What is the IFS function used for?
The IFS function is used to evaluate multiple conditions in a spreadsheet and return a value for the first condition that is TRUE, making it easier to manage than nested IF statements.
How many conditions can the IFS function test?
The IFS function can test up to 127 different conditions, allowing for complex evaluations without the need for multiple nested IF statements.
Can I use the IFS function for calculating bonuses?
Yes, the IFS function can be effectively used to calculate bonuses based on various conditions, such as years of service.
What are the advantages of using the IFS function over nested IF statements?
The IFS function is easier to read and manage compared to nested IF statements, reducing complexity and improving clarity in formulas.
What happens if none of the conditions in the IFS function are met?
If none of the conditions are met, the IFS function will return an error. To handle this, you can include a final condition that acts as a default value.
Quelques cas d'usages :
Calculating Employee Bonuses
A human resources manager can use the IFS function to calculate bonuses for employees based on their years of service. For example, if an employee has 5 years or less, they receive a $100 bonus; for 6 to 10 years, they might receive $200, and so on. This method simplifies the calculation process and makes it easy to adjust bonus amounts as needed.
Performance Evaluation
A team leader can apply the IFS function to evaluate employee performance ratings. By setting conditions for different performance levels, the leader can automatically assign ratings or rewards based on the criteria defined, streamlining the evaluation process.
Sales Commission Calculation
A sales manager can utilize the IFS function to calculate commissions based on sales targets achieved. For instance, if a salesperson meets their target, they receive a 10% commission; if they exceed it by 20%, they receive 15%. This allows for quick adjustments to commission structures without complex formulas.
Glossaire :
IFS function
A function in spreadsheet software that checks multiple conditions and returns a value corresponding to the first TRUE condition. It simplifies the process of using multiple nested IF statements.
bonus
An additional payment or reward given to an employee, often based on performance or length of service.
years of service
The total number of years an employee has worked for a particular organization.
nested IF instructions
A method of using multiple IF statements within one another to evaluate several conditions in a spreadsheet. This can become complex and difficult to read.
TRUE condition
A condition in a logical test that evaluates to true, allowing the corresponding value to be returned.