Excel - SWITCH Video
In this video, you will learn about the Office 365 tools that can help you search and find what you need.
The video covers OneDrive, Yammer, and Delve, and demonstrates how to use these tools to access and share documents, collaborate with colleagues, and discover relevant information.
This will help you stay updated on the latest updates, reports, and modifications made by your coworkers, even when working remotely.
By using these tools effectively, you can enhance your productivity and easily find the content you need.
- 1:03
- 3347 views
-
Excel - TEXTJOIN
- 0:47
- Viewed 3652 times
-
Excel - IFS
- 1:05
- Viewed 3583 times
-
Excel - MAXIFS & MINIFS
- 1:06
- Viewed 3193 times
-
Excel - CONCAT
- 0:51
- Viewed 3442 times
-
Excel - Map Chart in Excel
- 0:31
- Viewed 3552 times
-
Excel - Print worksheets and workbooks
- 1:07
- Viewed 3786 times
-
Excel - Automatic Data Entry in Excel
- 0:41
- Viewed 628 times
-
Excel - Subtract time
- 3:58
- Viewed 3924 times
-
Ink Equation
- 0:41
- Viewed 5187 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5068 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4955 times
-
3D Maps
- 1:41
- Viewed 4745 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4609 times
-
Create a combo chart
- 1:47
- Viewed 4442 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4426 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4423 times
-
More complex formulas
- 4:17
- Viewed 4370 times
-
Create a PivotTable report manually
- 4:59
- Viewed 4323 times
-
Manage conditional formatting
- 4:30
- Viewed 4301 times
-
Functions and formulas
- 3:24
- Viewed 4257 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4249 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4203 times
-
Manage drop-down lists
- 6:12
- Viewed 4199 times
-
Start using Excel
- 4:22
- Viewed 4192 times
-
New Chart types
- 1:52
- Viewed 4174 times
-
The SUMIF function
- 5:27
- Viewed 4153 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4143 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4131 times
-
A closer look at the ribbon
- 3:55
- Viewed 4123 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4099 times
-
AVERAGEIF function
- 3:04
- Viewed 4085 times
-
The SUM function
- 4:37
- Viewed 4078 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4064 times
-
Using functions
- 5:12
- Viewed 4061 times
-
Advanced formulas and references
- 4:06
- Viewed 4027 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4009 times
-
A first look at Excel 2016
- 3:22
- Viewed 3995 times
-
Insert columns and rows
- 4:16
- Viewed 3991 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3990 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3984 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3979 times
-
Add numbers
- 2:54
- Viewed 3968 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3967 times
-
Customize charts
- 4:28
- Viewed 3958 times
-
Work with macros
- 4:40
- Viewed 3958 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3957 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3950 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3940 times
-
Freeze panes in detail
- 3:30
- Viewed 3929 times
-
Subtract time
- 3:58
- Viewed 3924 times
-
Advanced filter details
- 4:13
- Viewed 3924 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3923 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3920 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3918 times
-
AutoFill
- 2:55
- Viewed 3910 times
-
How things are organized
- 1:58
- Viewed 3894 times
-
More print options
- 5:59
- Viewed 3890 times
-
AutoFilter details
- 3:27
- Viewed 3872 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3861 times
-
Introduction to Excel
- 0:59
- Viewed 3858 times
-
IF with AND and OR
- 3:35
- Viewed 3852 times
-
Input and error messages
- 2:52
- Viewed 3837 times
-
Conditionally format dates
- 2:38
- Viewed 3836 times
-
Assign a button to a macro
- 2:49
- Viewed 3828 times
-
Sort details
- 4:46
- Viewed 3820 times
-
Drop-down list settings
- 4:14
- Viewed 3819 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3819 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3818 times
-
Insert headers and footers
- 2:02
- Viewed 3813 times
-
Copying formulas
- 3:00
- Viewed 3812 times
-
Header and footer details
- 3:41
- Viewed 3799 times
-
How to create a table
- 2:11
- Viewed 3788 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3786 times
-
Basic math
- 2:28
- Viewed 3737 times
-
Save your macro
- 2:59
- Viewed 3724 times
-
Operator order
- 2:04
- Viewed 3715 times
-
Advanced IF functions
- 3:22
- Viewed 3703 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3701 times
-
Cell references
- 1:34
- Viewed 3674 times
-
Use conditional formatting
- 2:02
- Viewed 3663 times
-
Copy a chart
- 2:59
- Viewed 3655 times
-
Weighted average
- 2:06
- Viewed 3652 times
-
TEXTJOIN
- 0:47
- Viewed 3652 times
-
Improved version history
- 0:51
- Viewed 3650 times
-
Add formulas and references
- 2:52
- Viewed 3616 times
-
IFS
- 1:05
- Viewed 3583 times
-
Use slicers to filter data
- 1:25
- Viewed 3582 times
-
Save, publish, and share
- 2:22
- Viewed 3577 times
-
Conditionally format text
- 2:12
- Viewed 3562 times
-
Map Chart in Excel
- 0:31
- Viewed 3552 times
-
One click Forecasting
- 1:01
- Viewed 3547 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3544 times
-
Get going fast
- 1:38
- Viewed 3534 times
-
Nested IF functions
- 3:30
- Viewed 3525 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3494 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3468 times
-
CONCAT
- 0:51
- Viewed 3442 times
-
Flash Fill
- 2:59
- Viewed 3439 times
-
Freeze or lock panes
- 1:06
- Viewed 3434 times
-
Average a group of numbers
- 2:01
- Viewed 3413 times
-
Edit a macro
- 3:29
- Viewed 3393 times
-
Drop-down lists
- 0:55
- Viewed 3388 times
-
Create a chart
- 0:52
- Viewed 3371 times
-
Sort and filter data
- 1:38
- Viewed 3357 times
-
Share documents
- 1:13
- Viewed 3253 times
-
Microsoft Search
- 0:34
- Viewed 3207 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3193 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 3148 times
-
Page numbers in depth
- 3:06
- Viewed 3062 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 3047 times
-
Funnel Chart
- 0:33
- Viewed 3009 times
-
Check Accessibility in Excel
- 1:51
- Viewed 2970 times
-
Accessibility in Excel
- 1:12
- Viewed 2888 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2687 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2680 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2530 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2529 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2472 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2360 times
-
Text before & after Function
- 4:57
- Viewed 2344 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2227 times
-
Change chart type
- 1:29
- Viewed 1983 times
-
Morph transition
- 0:43
- Viewed 7564 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4423 times
-
Instant captions & subtitles in Powerpoint
- 0:43
- Viewed 3826 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3819 times
-
Automatically mark deleted emails as read
- 0:46
- Viewed 3744 times
-
Design ideas with Powerpoint
- 0:37
- Viewed 3709 times
-
TEXTJOIN
- 0:47
- Viewed 3652 times
-
IFS
- 1:05
- Viewed 3583 times
-
Let Outlook read your emails out loud
- 0:32
- Viewed 3578 times
-
Map Chart in Excel
- 0:31
- Viewed 3552 times
-
On-Slide 3D Model Animation
- 0:45
- Viewed 3474 times
-
CONCAT
- 0:51
- Viewed 3442 times
-
Discover the new simplified ribbon
- 0:29
- Viewed 3382 times
-
How to search a file in all channels
- 0:29
- Viewed 3300 times
-
Insert icons
- 0:43
- Viewed 3284 times
-
Quickly sort emails
- 0:27
- Viewed 3259 times
-
Display 3 time zones
- 0:37
- Viewed 3252 times
-
Locate your documents
- 0:20
- Viewed 3214 times
-
Make your presentation lively with the Zoom function
- 0:41
- Viewed 3211 times
-
Microsoft Search
- 0:34
- Viewed 3207 times
-
Prevent recipients from forwarding emails
- 0:34
- Viewed 3197 times
-
Reusing slides
- 0:37
- Viewed 3197 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3193 times
-
Prevent forwarding of a meeting
- 0:29
- Viewed 3176 times
-
Identify meeting members
- 0:26
- Viewed 3173 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 3148 times
-
How to set quiet hours
- 0:32
- Viewed 3115 times
-
Use dictate to type in Word
- 0:27
- Viewed 3091 times
-
Custom your personal reminders and notifications
- 0:44
- Viewed 3078 times
-
3D Models
- 0:42
- Viewed 3012 times
-
Funnel Chart
- 0:33
- Viewed 3009 times
-
Translate your Word documents into any language
- 0:33
- Viewed 2982 times
-
Icon insertion
- 0:54
- Viewed 2964 times
-
Let Word read your documents out loud
- 0:36
- Viewed 2890 times
-
Edit document with natural gestures
- 0:34
- Viewed 2866 times
-
Embed fonts in presentations
- 0:40
- Viewed 2804 times
-
New tab "Recording"
- 0:43
- Viewed 2681 times
-
PivotTable Insertions
- 0:43
- Viewed 2635 times
-
Removing the background of a picture
- 0:41
- Viewed 2618 times
-
Chat with co-authors while editing
- 0:29
- Viewed 2573 times
-
Make screenshots easier
- 3:59
- Viewed 2467 times
-
Configure multiple virtual desktops
- 1:35
- Viewed 2454 times
-
Work on multiple windows
- 1:21
- Viewed 2238 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2227 times
-
Introduction to PowerBI
- 00:60
- Viewed 255 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 242 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 239 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 267 times
-
Introduction to Planner
- 00:56
- Viewed 250 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 288 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 252 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 365 times
-
Introduction to Sway
- 01:53
- Viewed 329 times
-
Introducing to Word
- 01:00
- Viewed 238 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 227 times
-
Create a call group
- 01:15
- Viewed 385 times
-
Use call delegation
- 01:07
- Viewed 193 times
-
Assign a delegate for your calls
- 01:08
- Viewed 353 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 196 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 198 times
-
Manage advanced call notifications
- 01:29
- Viewed 204 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 317 times
-
Block unwanted calls
- 01:24
- Viewed 233 times
-
Disable all call forwarding
- 01:09
- Viewed 217 times
-
Manage a call group in Teams
- 02:01
- Viewed 238 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 195 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 197 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 217 times
-
Manage voicemail messages
- 01:55
- Viewed 318 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 352 times
-
Customize your voicemail greeting
- 02:17
- Viewed 191 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 244 times
-
Manage simultaneous calls
- 01:52
- Viewed 217 times
-
Support third-party apps during calls
- 01:53
- Viewed 260 times
-
Add participants quickly and securely
- 01:37
- Viewed 205 times
-
Configure call privacy and security settings
- 02:51
- Viewed 201 times
-
Manage calls on hold
- 01:20
- Viewed 208 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 207 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 200 times
-
Action Function
- 04:18
- Viewed 202 times
-
Search Function
- 03:42
- Viewed 248 times
-
Date and Time Function
- 02:53
- Viewed 256 times
-
Logical Function
- 03:14
- Viewed 394 times
-
Text Function
- 03:25
- Viewed 260 times
-
Basic Function
- 02:35
- Viewed 220 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 262 times
-
Introduction to Power Fx
- 01:09
- Viewed 256 times
-
The New Calendar
- 03:14
- Viewed 434 times
-
Sections
- 02:34
- Viewed 231 times
-
Customizing Views
- 03:25
- Viewed 225 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 490 times
-
Guide to Using the Microsoft Authenticator App
- 01:47
- Viewed 273 times
-
Turn on Multi-Factor Authentication in the Admin Section
- 02:07
- Viewed 196 times
-
Concept of Multi-Factor Authentication
- 01:51
- Viewed 257 times
Objectifs :
Understand the SWITCH function in Excel, its usage for evaluating expressions against a list of values, and how to determine the day of the week from a given date.
Chapitres :
-
Introduction to the SWITCH Function
The SWITCH function in Excel is a powerful tool that allows users to evaluate an expression against a list of values. It returns the result corresponding to the first matching value found in the list. This function is particularly useful for simplifying complex nested IF statements. -
Using SWITCH to Determine the Day of the Week
In this example, we will explore how to use the SWITCH function to find the day of the week corresponding to a specific date. The expression we will evaluate is the day of the week, with a return type of 2, indicating that Monday is considered the first day of the week. -
Example of the SWITCH Function
To illustrate, if the value evaluated is 1, the result returned will be 'Monday'. The SWITCH function can evaluate up to 126 values, making it a versatile option for various applications. Here’s how the function works: - If the evaluated value is 1, return 'Monday'. - If the evaluated value is 2, return 'Tuesday'. - Continue this pattern through to 7, which would return 'Sunday'. -
Benefits of Using the SWITCH Function
The SWITCH function simplifies the process of evaluating multiple conditions. Instead of using multiple IF statements, which can become cumbersome, SWITCH provides a cleaner and more readable approach. This not only enhances clarity but also reduces the likelihood of errors in complex formulas. -
Conclusion
In summary, the SWITCH function is an efficient way to evaluate expressions against a list of values in Excel. By using this function to determine the day of the week from a date, users can streamline their calculations and improve the readability of their spreadsheets. Understanding how to implement the SWITCH function can significantly enhance your data analysis capabilities.
FAQ :
What is the SWITCH function used for?
The SWITCH function is used to evaluate an expression against a list of values and return the result corresponding to the first matching value.
How many values can the SWITCH function evaluate?
The SWITCH function can evaluate up to 126 values and corresponding results.
What does the return type of the SWITCH function indicate?
The return type indicates the type of value that the SWITCH function will return based on the evaluated expression.
Can the SWITCH function be used to determine the day of the week?
Yes, the SWITCH function can be used to determine the day of the week corresponding to a specific date by evaluating the date against predefined values.
What happens if there is no matching value in the SWITCH function?
If there is no matching value, the SWITCH function will return an error or a default value if specified.
Quelques cas d'usages :
Determining the Day of the Week
Using the SWITCH function to evaluate a date and return the corresponding day of the week, which can be useful in scheduling applications or calendar management.
Conditional Formatting in Reports
Applying the SWITCH function in data analysis tools to categorize data based on specific criteria, enhancing the readability of reports.
Dynamic User Interfaces
Implementing the SWITCH function in programming to create dynamic user interfaces that change based on user input, improving user experience.
Automating Data Entry
Utilizing the SWITCH function in spreadsheets to automate data entry processes by categorizing inputs based on predefined values, increasing efficiency.
Error Handling in Data Processing
Using the SWITCH function to manage and handle errors in data processing by providing alternative outputs for unexpected values.
Glossaire :
SWITCH function
A function that evaluates an expression against a list of values and returns the result corresponding to the first matching value.
expression
A combination of values, variables, operators, and functions that are evaluated to produce a result.
return type
The type of value that a function will return after execution, which can vary based on the function's design.
day of the week
A classification of days based on a seven-day cycle, typically including Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday.
value
A specific piece of data that can be evaluated or compared in a function.