Excel - Create pie, bar, and line charts Tutorial
In this video, you will learn how to create pie, bar, and line charts using Microsoft 365. The video demonstrates the process of selecting the cells you want to chart and clicking on the Charts option.
Excel will display recommended chart options based on the selected data.
However, it's important to note that the options may vary depending on the data.
The video shows how to create a pie chart by selecting the cells and clicking on the pie option.
It also explains that a pie chart can only display one data series.
The video then moves on to creating a bar chart using the same data, highlighting how charting the data in different ways can provide different perspectives and insights.
The video concludes by mentioning that there are many more chart options available in the Insert tab of the Charts group.
It recommends using the Recommended charts option to find the best chart for the selected data.
Finally, the video demonstrates how to create a line chart with markers, which can be a better option than a pie chart for displaying multiple data series.
This tutorial will help you create visually appealing and informative charts using Microsoft 365, enhancing your data analysis skills.
- 3:13
- 3990 views
-
Excel - Customize charts
- 4:28
- Viewed 4082 times
-
Excel - Create a chart
- 0:52
- Viewed 3446 times
-
Excel - Create a combo chart
- 1:47
- Viewed 4574 times
-
Excel - Copy a chart
- 2:59
- Viewed 3777 times
-
Excel - How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4184 times
-
Excel - How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3639 times
-
Excel - Look up values on a different worksheet
- 2:39
- Viewed 4157 times
-
Excel - Operator order
- 2:04
- Viewed 3814 times
-
Ink Equation
- 0:41
- Viewed 5475 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5225 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 5103 times
-
3D Maps
- 1:41
- Viewed 4915 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4800 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4608 times
-
Create a combo chart
- 1:47
- Viewed 4574 times
-
More complex formulas
- 4:17
- Viewed 4558 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4551 times
-
Create a PivotTable report manually
- 4:59
- Viewed 4441 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4398 times
-
Manage conditional formatting
- 4:30
- Viewed 4387 times
-
Functions and formulas
- 3:24
- Viewed 4382 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4325 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4323 times
-
Start using Excel
- 4:22
- Viewed 4302 times
-
Manage drop-down lists
- 6:12
- Viewed 4296 times
-
The SUMIF function
- 5:27
- Viewed 4261 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4256 times
-
New Chart types
- 1:52
- Viewed 4254 times
-
A closer look at the ribbon
- 3:55
- Viewed 4213 times
-
The SUM function
- 4:37
- Viewed 4192 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4184 times
-
AVERAGEIF function
- 3:04
- Viewed 4177 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4157 times
-
Using functions
- 5:12
- Viewed 4144 times
-
Advanced formulas and references
- 4:06
- Viewed 4143 times
-
Insert columns and rows
- 4:16
- Viewed 4130 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 4110 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 4103 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 4101 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 4097 times
-
Add numbers
- 2:54
- Viewed 4091 times
-
A first look at Excel 2016
- 3:22
- Viewed 4091 times
-
Customize charts
- 4:28
- Viewed 4082 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 4081 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4080 times
-
Work with macros
- 4:40
- Viewed 4071 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 4053 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 4036 times
-
Advanced filter details
- 4:13
- Viewed 4013 times
-
Subtract time
- 3:58
- Viewed 4010 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 4003 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 4002 times
-
Freeze panes in detail
- 3:30
- Viewed 3993 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3989 times
-
AutoFill
- 2:55
- Viewed 3986 times
-
More print options
- 5:59
- Viewed 3980 times
-
Copying formulas
- 3:00
- Viewed 3978 times
-
AutoFilter details
- 3:27
- Viewed 3972 times
-
How things are organized
- 1:58
- Viewed 3966 times
-
Input and error messages
- 2:52
- Viewed 3943 times
-
Conditionally format dates
- 2:38
- Viewed 3942 times
-
IF with AND and OR
- 3:35
- Viewed 3942 times
-
Introduction to Excel
- 0:59
- Viewed 3926 times
-
Assign a button to a macro
- 2:49
- Viewed 3920 times
-
Sort details
- 4:46
- Viewed 3916 times
-
Insert headers and footers
- 2:02
- Viewed 3911 times
-
Header and footer details
- 3:41
- Viewed 3902 times
-
Drop-down list settings
- 4:14
- Viewed 3895 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3893 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3891 times
-
How to create a table
- 2:11
- Viewed 3888 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3878 times
-
Basic math
- 2:28
- Viewed 3843 times
-
Weighted average
- 2:06
- Viewed 3841 times
-
Save your macro
- 2:59
- Viewed 3815 times
-
Operator order
- 2:04
- Viewed 3814 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3791 times
-
Cell references
- 1:34
- Viewed 3788 times
-
Advanced IF functions
- 3:22
- Viewed 3780 times
-
Copy a chart
- 2:59
- Viewed 3777 times
-
TEXTJOIN
- 0:47
- Viewed 3764 times
-
Use conditional formatting
- 2:02
- Viewed 3744 times
-
Improved version history
- 0:51
- Viewed 3736 times
-
Add formulas and references
- 2:52
- Viewed 3696 times
-
IFS
- 1:05
- Viewed 3683 times
-
Use slicers to filter data
- 1:25
- Viewed 3680 times
-
Map Chart in Excel
- 0:31
- Viewed 3662 times
-
One click Forecasting
- 1:01
- Viewed 3656 times
-
Save, publish, and share
- 2:22
- Viewed 3652 times
-
Conditionally format text
- 2:12
- Viewed 3646 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3639 times
-
Nested IF functions
- 3:30
- Viewed 3629 times
-
Get going fast
- 1:38
- Viewed 3607 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3552 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3543 times
-
CONCAT
- 0:51
- Viewed 3529 times
-
Flash Fill
- 2:59
- Viewed 3514 times
-
Freeze or lock panes
- 1:06
- Viewed 3496 times
-
Edit a macro
- 3:29
- Viewed 3489 times
-
Average a group of numbers
- 2:01
- Viewed 3471 times
-
Drop-down lists
- 0:55
- Viewed 3471 times
-
Create a chart
- 0:52
- Viewed 3446 times
-
Sort and filter data
- 1:38
- Viewed 3431 times
-
SWITCH
- 1:03
- Viewed 3420 times
-
Share documents
- 1:13
- Viewed 3354 times
-
Microsoft Search
- 0:34
- Viewed 3285 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3244 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 3215 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 3200 times
-
Page numbers in depth
- 3:06
- Viewed 3176 times
-
Check Accessibility in Excel
- 1:51
- Viewed 3125 times
-
Funnel Chart
- 0:33
- Viewed 3098 times
-
Accessibility in Excel
- 1:12
- Viewed 2944 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2782 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2769 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2632 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2597 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2544 times
-
Text before & after Function
- 4:57
- Viewed 2444 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2422 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2350 times
-
Change chart type
- 1:29
- Viewed 2052 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1853 times
-
Use Copilot with Right-Click
- 00:58
- Viewed 1594 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1351 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1155 times
-
Format Data with Copilot
- 1:52
- Viewed 1146 times
-
Create an insights grid
- 01:19
- Viewed 472 times
-
Generate formulas from a concept
- 01:03
- Viewed 291 times
-
Use the Copilot pane
- 01:12
- Viewed 268 times
-
Process text
- 01:03
- Viewed 262 times
-
Visualize and group using Copilot in Excel with Python
- 01:42
- Viewed 11 times
-
Sort and project using Copilot in Excel with Python
- 01:37
- Viewed 10 times
-
Remove a watermark
- 2:20
- Viewed 17622 times
-
How to add branching logic in Microsoft Forms
- 1:55
- Viewed 5960 times
-
Align flow chart shapes and add connectors
- 4:48
- Viewed 5686 times
-
Change font size, line spacing, and indentation
- 5:09
- Viewed 5595 times
-
Ink Equation
- 0:41
- Viewed 5475 times
-
Convert handwritten texts or drawings with Powerpoint
- 0:33
- Viewed 5471 times
-
Change list formatting on the slide master
- 5:22
- Viewed 5343 times
-
Trigger text to play over a video
- 2:58
- Viewed 5234 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5225 times
-
Insert items in a presentation
- 2:38
- Viewed 5144 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 5103 times
-
Add a "Date" field to your form or quiz in Microsoft Forms
- 1:06
- Viewed 4981 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 4968 times
-
3D Maps
- 1:41
- Viewed 4915 times
-
Add a sound effect to a transition
- 3:45
- Viewed 4820 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4800 times
-
Print Notes Pages as handouts
- 3:15
- Viewed 4771 times
-
Save time by creating your form with quick import
- 2:20
- Viewed 4768 times
-
Add headers and footers to slides
- 3:52
- Viewed 4753 times
-
Finalize and review a presentation
- 2:02
- Viewed 4662 times
-
Create a combo chart
- 1:47
- Viewed 4574 times
-
More complex formulas
- 4:17
- Viewed 4558 times
-
Add sound effects to an animation
- 4:29
- Viewed 4557 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4551 times
-
Build an org chart using the text pane
- 4:00
- Viewed 4508 times
-
Animate charts and SmartArt
- 3:36
- Viewed 4428 times
-
Measure how people feel about something with the Likert scale in Microsoft Forms
- 2:02
- Viewed 4417 times
-
Create a new slide master and layouts
- 5:13
- Viewed 4405 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4398 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4390 times
-
Manage conditional formatting
- 4:30
- Viewed 4387 times
-
Functions and formulas
- 3:24
- Viewed 4382 times
-
Trigger an animation effect
- 2:29
- Viewed 4367 times
-
Customize the slide master
- 4:38
- Viewed 4338 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4325 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4323 times
-
Work with a motion path
- 2:50
- Viewed 4317 times
-
Prepare a basic handout
- 4:30
- Viewed 4310 times
-
Start using Excel
- 4:22
- Viewed 4302 times
-
Manage drop-down lists
- 6:12
- Viewed 4296 times
-
Create a flow chart
- 3:27
- Viewed 4266 times
-
The SUMIF function
- 5:27
- Viewed 4261 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4256 times
-
New Chart types
- 1:52
- Viewed 4254 times
-
Create slide content and save the template
- 4:50
- Viewed 4210 times
-
The SUM function
- 4:37
- Viewed 4192 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4184 times
-
AVERAGEIF function
- 3:04
- Viewed 4177 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4157 times
-
Using functions
- 5:12
- Viewed 4144 times
-
Advanced formulas and references
- 4:06
- Viewed 4143 times
-
Insert columns and rows
- 4:16
- Viewed 4130 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 4110 times
-
Multiple choice questions in Microsoft Forms
- 2:14
- Viewed 4104 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 4103 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 4101 times
-
Add numbers
- 2:54
- Viewed 4091 times
-
Customize charts
- 4:28
- Viewed 4082 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4080 times
-
Animate pictures, shapes, text, and other objects
- 4:02
- Viewed 4080 times
-
Work with macros
- 4:40
- Viewed 4071 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 4053 times
-
Create slicers
- 3:55
- Viewed 4050 times
-
Create an automated workflow for Microsoft Forms with Power Automate
- 5:09
- Viewed 4046 times
-
Add a picture watermark
- 4:36
- Viewed 4043 times
-
Create quick measures
- 3:02
- Viewed 4033 times
-
Customize colors and save the theme
- 4:45
- Viewed 4025 times
-
Advanced filter details
- 4:13
- Viewed 4013 times
-
Subtract time
- 3:58
- Viewed 4010 times
-
Use slide masters to customize a presentation
- 3:07
- Viewed 4010 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 4003 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 4002 times
-
Freeze panes in detail
- 3:30
- Viewed 3993 times
-
Customize the design and layouts
- 5:06
- Viewed 3990 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3989 times
-
Create a template from a presentation
- 3:09
- Viewed 3982 times
-
More print options
- 5:59
- Viewed 3980 times
-
Copying formulas
- 3:00
- Viewed 3978 times
-
AutoFilter details
- 3:27
- Viewed 3972 times
-
Backgrounds in PowerPoint: First Steps
- 3:20
- Viewed 3968 times
-
Print slides, notes, or handouts
- 2:48
- Viewed 3946 times
-
Creating and managing a group
- 1:56
- Viewed 3945 times
-
Input and error messages
- 2:52
- Viewed 3943 times
-
Conditionally format dates
- 2:38
- Viewed 3942 times
-
IF with AND and OR
- 3:35
- Viewed 3942 times
-
Assign a button to a macro
- 2:49
- Viewed 3920 times
-
Create custom animations with motion paths
- 3:39
- Viewed 3920 times
-
Sort details
- 4:46
- Viewed 3916 times
-
Insert headers and footers
- 2:02
- Viewed 3911 times
-
Header and footer details
- 3:41
- Viewed 3902 times
-
Drop-down list settings
- 4:14
- Viewed 3895 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3891 times
-
How to create a table
- 2:11
- Viewed 3888 times
-
Work with handout masters
- 4:34
- Viewed 3882 times
-
Change the theme background
- 5:38
- Viewed 3881 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3878 times
-
Animate pictures and shapes
- 4:17
- Viewed 3875 times
-
Picture backgrounds: Two methods
- 4:58
- Viewed 3854 times
-
Basic math
- 2:28
- Viewed 3843 times
-
Weighted average
- 2:06
- Viewed 3841 times
-
Screen recording
- 0:49
- Viewed 3832 times
-
Print handouts
- 4:32
- Viewed 3829 times
-
Save your macro
- 2:59
- Viewed 3815 times
-
Operator order
- 2:04
- Viewed 3814 times
-
Cell references
- 1:34
- Viewed 3788 times
-
Advanced IF functions
- 3:22
- Viewed 3780 times
-
Copy a chart
- 2:59
- Viewed 3777 times
-
Use conditional formatting
- 2:02
- Viewed 3744 times
-
Customize master layouts
- 4:57
- Viewed 3744 times
-
Improved version history
- 0:51
- Viewed 3736 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 3723 times
-
Apply and change a theme
- 5:13
- Viewed 3699 times
-
Add formulas and references
- 2:52
- Viewed 3696 times
-
Use slicers to filter data
- 1:25
- Viewed 3680 times
-
One click Forecasting
- 1:01
- Viewed 3656 times
-
Conditionally format text
- 2:12
- Viewed 3646 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3639 times
-
Prepare and run your presentation
- 1:28
- Viewed 3636 times
-
Nested IF functions
- 3:30
- Viewed 3629 times
-
Combine a path with other effects
- 4:49
- Viewed 3621 times
-
Removing backgrounds in PowerPoint
- 2:45
- Viewed 3618 times
-
Add headers and footers to a presentation
- 2:50
- Viewed 3606 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3605 times
-
90 seconds about PowerPoint Slide Masters
- 1:17
- Viewed 3602 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3552 times
-
Conditional formatting
- 3:35
- Viewed 3551 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3543 times
-
Create an org chart
- 3:09
- Viewed 3543 times
-
Use the drill down filter
- 4:41
- Viewed 3530 times
-
New chart types
- 0:39
- Viewed 3509 times
-
Edit headers and footers for handouts
- 2:43
- Viewed 3501 times
-
Freeze or lock panes
- 1:06
- Viewed 3496 times
-
Build an org chart using SmartArt Tools
- 5:09
- Viewed 3491 times
-
Edit a macro
- 3:29
- Viewed 3489 times
-
Animate text
- 4:14
- Viewed 3480 times
-
Design motion paths
- 2:30
- Viewed 3479 times
-
Ink Equation
- 0:40
- Viewed 3476 times
-
Average a group of numbers
- 2:01
- Viewed 3471 times
-
Drop-down lists
- 0:55
- Viewed 3471 times
-
Sort and filter data
- 1:38
- Viewed 3431 times
-
Apply paths to layered pictures
- 5:28
- Viewed 3431 times
-
Calculate function
- 4:22
- Viewed 3410 times
-
Present Live
- 3:13
- Viewed 3395 times
-
Create a sequence with line paths
- 6:42
- Viewed 3387 times
-
Start using PowerPoint
- 2:06
- Viewed 3263 times
-
Add bullets to text
- 2:24
- Viewed 3241 times
-
Turn on the drill down feature
- 2:23
- Viewed 3238 times
-
Create a new calendar
- 2:55
- Viewed 3223 times
-
Trigger a video
- 4:06
- Viewed 3207 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 3185 times
-
Add an alert to a visual
- 2:24
- Viewed 3170 times
-
Manage interactions
- 1:56
- Viewed 3097 times
-
Integrate Bookings into TEAMS
- 1:36
- Viewed 3091 times
-
Turn your Excel tables into real lists!
- 1:12
- Viewed 3088 times
-
Make a reservation [Customer]
- 2:13
- Viewed 3067 times
-
Create custom fields
- 1:21
- Viewed 3052 times
-
Manage relations between data sources
- 2:37
- Viewed 3017 times
-
Easily measure user experience with Net Promoter Score in Microsoft Forms
- 1:32
- Viewed 3003 times
-
Complete and Share a Schedule
- 2:02
- Viewed 2985 times
-
What are measures?
- 2:58
- Viewed 2920 times
-
Organise notes
- 2:57
- Viewed 2919 times
-
Create a Microsoft Forms form directly in OneDrive
- 1:33
- Viewed 2907 times
-
Add a service
- 2:03
- Viewed 2900 times
-
Research in your notes
- 1:13
- Viewed 2880 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2880 times
-
Create a Schedule and Organise it with the Help of Groups
- 1:42
- Viewed 2873 times
-
Use template to prepare your Agile SCRUM meeting
- 2:50
- Viewed 2861 times
-
Create your first form or quiz in Microsoft Forms
- 2:12
- Viewed 2825 times
-
Create and organise a group
- 1:30
- Viewed 2821 times
-
Draw, sketch or handwrite notes
- 1:25
- Viewed 2819 times
-
Get a rating in Microsoft Forms
- 1:32
- Viewed 2818 times
-
Add a Visio diagram
- 1:23
- Viewed 2773 times
-
Send your notes by email
- 0:42
- Viewed 2770 times
-
How Clock In Works
- 0:22
- Viewed 2728 times
-
Password protect your notes
- 1:43
- Viewed 2681 times
-
Manage our recent documents
- 2:24
- Viewed 2668 times
-
Make better tables
- 10 min
- Viewed 2663 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2646 times
-
Creating and managing campaigns
- 1:39
- Viewed 2642 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2632 times
-
Create a new shared booking page
- 2:32
- Viewed 2623 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2597 times
-
Rewrite or summarize an existing text with Copilot
- 02:29
- Viewed 2574 times
-
Save, share and share everything
- 0:49
- Viewed 2558 times
-
Insert online videos
- 0:41
- Viewed 2487 times
-
Creating or editing office documents in Engage
- 0:44
- Viewed 2470 times
-
Text before & after Function
- 4:57
- Viewed 2444 times
-
Add an Excel spreadsheet
- 1:31
- Viewed 2441 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 2432 times
-
Imbrication OneNote / Teams
- 1:03
- Viewed 2422 times
-
See who's collaborating
- 2:01
- Viewed 2387 times
-
Add files
- 1:26
- Viewed 2381 times
-
Add items
- 2:04
- Viewed 2374 times
-
Use page templates
- 2:19
- Viewed 2369 times
-
Meeting recordings in Microsoft Teams
- 1:13
- Viewed 2362 times
-
Make a reservation Employee]
- 1:50
- Viewed 2339 times
-
Upload an existing video from your device
- 1:11
- Viewed 2338 times
-
Create a video from the web app
- 1:20
- Viewed 2333 times
-
Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms
- 2:14
- Viewed 2328 times
-
Use formatting toolbar and styles to format forms and quizzes
- 1:55
- Viewed 2316 times
-
Imbrication OneNote / Outlook
- 1:37
- Viewed 2314 times
-
How to Copy a Schedule
- 0:39
- Viewed 2312 times
-
Sync and sharing
- 0:28
- Viewed 2290 times
-
Create custom fields
- 1:12
- Viewed 2278 times
-
Record a live PowerPoint presentation
- 1:18
- Viewed 2245 times
-
Install Office on 5 devices
- 1:53
- Viewed 2239 times
-
Create a video from the mobile app
- 1:13
- Viewed 2218 times
-
Use "Text" fields to create a contact form
- 2:16
- Viewed 2188 times
-
Let responders submit files in Microsoft Forms
- 1:58
- Viewed 2188 times
-
Add or edit a thumbnail
- 0:59
- Viewed 2182 times
-
Engaging and animating a group
- 1:55
- Viewed 2057 times
-
Change chart type
- 1:29
- Viewed 2052 times
-
Make a reservation [Customer]
- 1:51
- Viewed 1927 times
-
Send a single form in multiple languages
- 1:21
- Viewed 1908 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1853 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 1804 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 1713 times
-
Add a service
- 2:28
- Viewed 1711 times
-
Save a PowerPoint presentation
- 1:10
- Viewed 1687 times
-
Write content based on an existing document with Copilot
- 01:31
- Viewed 1635 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 1580 times
-
Draft an Email with Copilot
- 02:36
- Viewed 1466 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1351 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 1180 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1155 times
-
Format Data with Copilot
- 1:52
- Viewed 1146 times
-
Improve Email Writing with Copilot Coaching
- 01:47
- Viewed 1121 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 1084 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 1072 times
-
Generate text from an idea or an outline
- 02:51
- Viewed 1014 times
-
Generating Loop Content with Copilot
- 01:19
- Viewed 586 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 547 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 518 times
-
Create a reminder for yourself
- 01:59
- Viewed 518 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 466 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 459 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 451 times
-
Create and add a signature to messages
- 01:26
- Viewed 424 times
-
Edit and customize views
- 01:55
- Viewed 413 times
-
Create different types of events
- 01:46
- Viewed 411 times
-
Make changes to a text with Copilot
- 00:54
- Viewed 410 times
-
Sort and filter emails
- 02:51
- Viewed 386 times
-
Manage Teams online meeting options
- 01:56
- Viewed 371 times
-
Create an Email Template
- 01:40
- Viewed 371 times
-
Save and Print a Message
- 01:48
- Viewed 370 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 365 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 364 times
-
Change the default font of your emails
- 01:05
- Viewed 362 times
-
Delay Email Delivery
- 01:10
- Viewed 341 times
-
Improve Email Accessibility
- 02:02
- Viewed 335 times
-
Search options
- 01:23
- Viewed 334 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 330 times
-
Translate Emails in Outlook
- 01:32
- Viewed 324 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 319 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 319 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 294 times
-
Generate formulas from a concept
- 01:03
- Viewed 291 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 270 times
-
Send an email with Power Apps and Outlook
- 05:08
- Viewed 13 times
-
First steps with the patch function
- 04:17
- Viewed 14 times
-
Create dynamic filters with named formulas
- 04:57
- Viewed 15 times
-
Define centralized visibility rules
- 02:28
- Viewed 16 times
-
Dynamic color palette with named formulas
- 03:53
- Viewed 11 times
-
Introduction to named formulas
- 03:45
- Viewed 14 times
-
First steps with variables
- 04:26
- Viewed 11 times
-
Create new entries
- 03:25
- Viewed 12 times
-
Easily edit your data
- 03:27
- Viewed 11 times
-
Add a form to your app
- 02:43
- Viewed 13 times
-
Customize data display
- 03:55
- Viewed 12 times
-
Prepare your dynamic galleries
- 03:27
- Viewed 11 times
-
Reusable components
- 04:16
- Viewed 14 times
-
Structure your layout
- 04:13
- Viewed 12 times
-
Master containers
- 05:48
- Viewed 11 times
-
Optimize large data processing
- 04:43
- Viewed 11 times
-
Galleries : a first look
- 02:59
- Viewed 13 times
-
Add and manage data sources
- 02:58
- Viewed 14 times
-
Controls explained and applied
- 02:41
- Viewed 11 times
-
The Power Apps interface
- 02:35
- Viewed 13 times
-
Why choose Power Apps?
- 01:36
- Viewed 13 times
-
Visualize and group using Copilot in Excel with Python
- 01:42
- Viewed 11 times
-
Improve a quiz with Copilot
- 01:59
- Viewed 13 times
-
Sort and project using Copilot in Excel with Python
- 01:37
- Viewed 10 times
-
Adapt Your Communication
- 01:51
- Viewed 13 times
-
Adopt good meeting habits with Viva Insights
- 00:42
- Viewed 12 times
-
Prepare and Run Your Meetings Effectively
- 01:41
- Viewed 12 times
-
Organize Your Work Environment
- 01:42
- Viewed 14 times
-
The DESC Method
- 00:57
- Viewed 13 times
-
Use the Whiteboard Tool
- 01:04
- Viewed 11 times
-
Use Microsoft Forms to Survey Your Team
- 02:06
- Viewed 15 times
-
Motivators and Blockers
- 01:53
- Viewed 12 times
-
The 5 Whys
- 01:58
- Viewed 12 times
-
Use the F.A.I.R. Method
- 02:23
- Viewed 13 times
-
Adapt Your Feedback to the Dominant Energy Tendency
- 01:47
- Viewed 39 times
-
Use the Microsoft 365 Ecosystem
- 02:22
- Viewed 13 times
-
The Pomodoro Method
- 01:38
- Viewed 12 times
-
Use Microsoft 365 to Foster Motivation
- 02:04
- Viewed 13 times
-
Use Planner to Align My Team's Priorities
- 01:55
- Viewed 12 times
-
Set SMART Goals with Microsoft 365 Tools
- 02:42
- Viewed 13 times
-
Is a hacker always a cybercriminal?
- 01:31
- Viewed 19 times
-
Will I know what to do if I get hacked?
- 01:16
- Viewed 18 times
-
Do I have to be an IT expert to protect myself?
- 01:14
- Viewed 19 times
-
Do cybercriminals only target large companies?
- 01:21
- Viewed 17 times
-
Are all files safe as long as I open them with trusted software?
- 01:24
- Viewed 17 times
-
Is contactless payment safe ?
- 01:26
- Viewed 59 times
-
Are online payments riskier than in-store ones?
- 01:21
- Viewed 20 times
-
Is cloud storage less secure than my personal computer?
- 01:37
- Viewed 20 times
-
Is scanning a QR code always safe?
- 01:21
- Viewed 16 times
-
Can my mobile apps do anything without my permission?
- 01:19
- Viewed 17 times
-
Is public Wi-Fi safe if no password is required?
- 01:26
- Viewed 16 times
-
Is the sender’s email address enough to verify a message?
- 01:29
- Viewed 16 times
-
Can I safely click a link in a message?
- 01:46
- Viewed 17 times
-
Does connecting to a well-known website guarantee its safety?
- 01:27
- Viewed 16 times
-
Am I safe online if I’m careful?
- 01:22
- Viewed 17 times
-
Does private browsing make me anonymous?
- 01:27
- Viewed 19 times
-
Are updates useless if everything works fine?
- 01:28
- Viewed 14 times
-
Is a firewall the same as an antivirus?
- 01:31
- Viewed 16 times
-
Does my antivirus block all threats?
- 01:46
- Viewed 15 times
-
Is a free antivirus good enough?
- 01:38
- Viewed 18 times
-
Is signing in with Google or Facebook a bad idea ?
- 01:34
- Viewed 14 times
-
Is my password secure if it contains an @ and a number?
- 01:41
- Viewed 20 times
-
Is a strong password all I need to stay safe?
- 01:55
- Viewed 19 times
-
Unlock new possibilities with the Mistral Canvas
- 02:01
- Viewed 21 times
-
Mistral at the service of coding
- 01:37
- Viewed 23 times
-
Analyze and compare your documents with Mistral
- 01:58
- Viewed 21 times
-
Generate your images and visuals with Mistral AI
- 02:06
- Viewed 31 times
-
Use Mistral AI to summarize online information
- 01:00
- Viewed 22 times
-
Exchange and manage your conversations with Mistral AI
- 03:31
- Viewed 21 times
-
Explore Mistral AI's generative options
- 01:51
- Viewed 22 times
-
Set up your Mistral workspace
- 01:42
- Viewed 26 times
-
Discover Mistral, the French-style AI
- 01:51
- Viewed 20 times
-
Instant alerts tailored to your activities
- 01:53
- Viewed 42 times
-
Seamless collaboration inside Microsoft Teams
- 01:22
- Viewed 42 times
-
Easy sharing with your team or organization
- 01:12
- Viewed 40 times
-
Relevant views to highlight your information
- 01:52
- Viewed 45 times
-
Clear insights through filters and sorting
- 02:06
- Viewed 36 times
-
A well-structured form for easy entry
- 01:17
- Viewed 46 times
-
The right column type for each data set
- 02:35
- Viewed 37 times
-
Custom columns to match your needs
- 02:09
- Viewed 38 times
-
Smooth updates and management for any list
- 01:06
- Viewed 41 times
-
Simple ways to add data to your list
- 01:06
- Viewed 40 times
-
Excel data turned into a dynamic list
- 02:08
- Viewed 39 times
-
A fully custom list built from scratch
- 01:34
- Viewed 43 times
-
A quick setup with ready-made templates
- 01:34
- Viewed 42 times
-
Mobile access to your lists made simple
- 01:37
- Viewed 47 times
-
The essentials of the Lists interface
- 02:01
- Viewed 42 times
-
The key reasons to use Microsoft Lists
- 02:01
- Viewed 40 times
-
Personality and tone for a believable rendering
- 01:48
- Viewed 76 times
-
Format and example for optimal results
- 02:03
- Viewed 77 times
-
The Importance of Context in Your Applications
- 02:14
- Viewed 69 times
-
Task Accuracy in Prompting
- 02:31
- Viewed 135 times
-
The Basis of Prompting in Conversational AI
- 02:41
- Viewed 64 times
-
What is a prompt in conversational AI?
- 02:02
- Viewed 79 times
-
Extract Text from an Image
- 01:07
- Viewed 95 times
-
Reply to an Email with Copilot
- 01:10
- Viewed 151 times
-
Create SharePoint Pages with Copilot
- 01:49
- Viewed 166 times
-
Query an Attached Meeting
- 01:51
- Viewed 75 times
-
Plan with Copilot
- 01:15
- Viewed 112 times
-
Share Requests with Your Team
- 03:07
- Viewed 155 times
-
Translate a presentation
- 01:38
- Viewed 97 times
-
Generate a Video
- 01:49
- Viewed 94 times
-
Add Speaker Notes
- 00:56
- Viewed 100 times
-
Initiate a project budget tracking table with Copilot
- 02:54
- Viewed 157 times
-
Develop and share a clear project follow-up with Copilot
- 02:18
- Viewed 145 times
-
Organize an action plan with Copilot and Microsoft Planner
- 01:31
- Viewed 167 times
-
Structure and optimize team collaboration with Copilot
- 02:28
- Viewed 209 times
-
Copilot at the service of project reports
- 02:36
- Viewed 175 times
-
Initiate a tracking table with ChatGPT
- 01:35
- Viewed 180 times
-
Distribute tasks within a team with ChatGPT
- 01:26
- Viewed 312 times
-
Generate a meeting summary with ChatGPT
- 01:24
- Viewed 181 times
-
Project mode
- 01:31
- Viewed 173 times
-
Create an agent for a team
- 01:53
- Viewed 289 times
-
Install and access Copilot Studio in Teams
- 01:38
- Viewed 289 times
-
Analyze the Copilot Studio agent
- 01:25
- Viewed 139 times
-
Publish the agent and make it accessible
- 01:39
- Viewed 289 times
-
Copilot Studio agent settings
- 01:33
- Viewed 136 times
-
Add new actions
- 01:54
- Viewed 287 times
-
Create a first action
- 01:59
- Viewed 274 times
-
Manage topics
- 01:51
- Viewed 161 times
-
Manage knowledge sources
- 01:11
- Viewed 125 times
-
Create an agent with Copilot Studio
- 01:52
- Viewed 278 times
-
Access Copilot Studio
- 01:09
- Viewed 272 times
-
Get started with Copilot Studio
- 01:25
- Viewed 140 times
-
Introduction to PowerBI
- 00:60
- Viewed 305 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 295 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 289 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 317 times
-
Introduction to Planner
- 00:56
- Viewed 295 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 435 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 302 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 439 times
-
Introduction to Sway
- 01:53
- Viewed 379 times
-
Introducing to Word
- 01:00
- Viewed 279 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 272 times
-
Create a call group
- 01:15
- Viewed 468 times
-
Use call delegation
- 01:07
- Viewed 235 times
-
Assign a delegate for your calls
- 01:08
- Viewed 437 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 244 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 241 times
-
Manage advanced call notifications
- 01:29
- Viewed 252 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 393 times
-
Block unwanted calls
- 01:24
- Viewed 285 times
-
Disable all call forwarding
- 01:09
- Viewed 272 times
-
Manage a call group in Teams
- 02:01
- Viewed 286 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 234 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 242 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 256 times
-
Manage voicemail messages
- 01:55
- Viewed 391 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 433 times
-
Customize your voicemail greeting
- 02:17
- Viewed 234 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 301 times
-
Manage simultaneous calls
- 01:52
- Viewed 269 times
-
Support third-party apps during calls
- 01:53
- Viewed 417 times
-
Add participants quickly and securely
- 01:37
- Viewed 251 times
-
Configure call privacy and security settings
- 02:51
- Viewed 251 times
-
Manage calls on hold
- 01:20
- Viewed 247 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 256 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 242 times
-
Draft a Service Memo
- 02:33
- Viewed 290 times
-
Extract Invoice Data and Generate a Pivot Table
- 03:26
- Viewed 283 times
-
Formulate a Request for Pricing Conditions via Email
- 02:32
- Viewed 448 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:41
- Viewed 417 times
-
SharePoint Page Co-Editing: Collaborate in Real Time
- 02:14
- Viewed 149 times
-
Other Coaches
- 01:45
- Viewed 301 times
-
Agents in SharePoint
- 02:44
- Viewed 242 times
-
Prompt coach
- 02:49
- Viewed 270 times
-
Modify, Share, and Install an Agent
- 01:43
- Viewed 257 times
-
Configure a Copilot Agent
- 02:39
- Viewed 267 times
-
Describe a copilot agent
- 01:32
- Viewed 301 times
-
Rewrite with Copilot
- 01:21
- Viewed 257 times
-
Analyze a video
- 01:21
- Viewed 278 times
-
Use the Copilot pane
- 01:12
- Viewed 268 times
-
Process text
- 01:03
- Viewed 262 times
-
Create an insights grid
- 01:19
- Viewed 472 times
-
Generate and manipulate an image in PowerPoint
- 01:47
- Viewed 267 times
-
Interact with a web page with Copilot
- 00:36
- Viewed 287 times
-
Create an image with Copilot
- 00:42
- Viewed 482 times
-
Summarize a PDF with Copilot
- 00:41
- Viewed 277 times
-
Analyze your documents with Copilot
- 01:15
- Viewed 283 times
-
Chat with Copilot
- 00:50
- Viewed 290 times
-
Particularities of Personal and Professional Copilot Accounts
- 00:40
- Viewed 463 times
-
Data Privacy in Copilot
- 00:43
- Viewed 284 times
-
Access Copilot
- 00:25
- Viewed 500 times
-
Use a Copilot Agent
- 01:24
- Viewed 322 times
-
Edit in Pages
- 01:20
- Viewed 329 times
-
Generate and manipulate an image in Word
- 01:26
- Viewed 306 times
-
Create Outlook rules with Copilot
- 01:12
- Viewed 288 times
-
Generate the email for the recipient
- 00:44
- Viewed 279 times
Objectifs :
This video aims to teach viewers how to create various types of charts in Excel, including pie, bar, and line charts, while emphasizing the importance of selecting the appropriate chart type based on the data being analyzed.
Chapitres :
-
Introduction to Chart Types
In this video, we will explore how to create pie, bar, and line charts in Excel. Understanding which chart type to use with specific data sets is crucial for effective data visualization. -
Creating a Pie Chart
To create a pie chart, first select the cells containing the data you wish to analyze. Then, click on the 'Charts' option in Excel. The software will display recommended chart options based on your selected data. Keep in mind that these options may vary depending on the data you choose. After selecting the pie chart option, your chart will be created. Note that pie charts can only represent one data series effectively. -
Customizing the Pie Chart
Once the pie chart is created, you can move and resize it for better visibility and customization. To do this, click on the chart, hold down the left mouse button, and drag it to your desired location. You can also resize the chart by clicking and dragging the bottom right corner. -
Limitations of Pie Charts
It's important to recognize that pie charts are not suitable for displaying too much data. If you attempt to graph excessive data in a pie chart, it can become cluttered and difficult to interpret. -
Creating a Bar Chart
Next, we will create a bar chart using the same data from the pie chart. Charting the same data in different ways can provide new insights and perspectives. To create a bar chart, select the data, click on the 'Insert' tab, and choose the 'Charts' group. Here, you can find various chart options. -
Exploring Chart Options
In the 'Charts' group, you can click on 'Recommended Charts' to see which charts work best with your selected data. For a broader selection, click on 'All Charts' to explore the different types of charts available in Excel. -
Creating a Line Chart
Since a pie chart is not recommended for the data we selected, we will create a line chart instead. To do this, select the data, click on 'Line', and then choose 'Line with Markers'. After pointing to your desired option, click 'OK' to create the line chart.
FAQ :
What types of charts can I create in Excel?
In Excel, you can create various types of charts including pie charts, bar charts, line charts, and many more. The type of chart you choose depends on the data you want to represent.
How do I create a pie chart in Excel?
To create a pie chart in Excel, select the cells containing the data you want to chart, click on the 'Insert' tab, and then choose 'Pie Chart' from the Charts group. Excel will create the chart based on your selected data.
Can I use multiple data series in a pie chart?
No, a pie chart can only display one data series. If you have multiple data series, consider using a bar chart or line chart instead.
What is the purpose of using different types of charts?
Using different types of charts allows you to visualize data from various perspectives, which can help uncover insights and trends that may not be apparent with a single chart type.
What should I do if my pie chart looks cluttered?
If your pie chart looks cluttered, it may be due to too much data being represented. Consider simplifying your data or using a different chart type, such as a bar chart, to improve clarity.
Quelques cas d'usages :
Sales Data Analysis
A sales manager can use pie charts to visualize the proportion of total sales contributed by each product category. This helps in identifying which categories are performing well and which need improvement.
Monthly Expense Tracking
An individual can create a bar chart to track monthly expenses across different categories (e.g., food, transportation, entertainment). This visual representation helps in budgeting and identifying spending patterns.
Trend Analysis in Marketing
A marketing analyst can use line charts to track website traffic over time. By plotting data points for each month, they can identify trends and make informed decisions about marketing strategies.
Project Progress Monitoring
A project manager can utilize bar charts to compare the progress of different tasks within a project. This allows for quick identification of tasks that are behind schedule and need attention.
Weather Data Visualization
A meteorologist can create line charts with markers to display temperature changes over a week. This helps in visualizing daily fluctuations and predicting future weather patterns.
Glossaire :
Clustered Column Chart
A type of chart that displays data using vertical bars grouped together for comparison. Each group represents a category, and the height of the bars indicates the value.
Pie Chart
A circular chart divided into sectors, each representing a proportion of the whole. It is used to display a single data series.
Bar Chart
A chart that presents categorical data with rectangular bars, where the length of each bar is proportional to the value it represents.
Line Chart
A type of chart that displays information as a series of data points called 'markers' connected by straight line segments. It is useful for showing trends over time.
Data Series
A set of related data points that are plotted on a chart. In a pie chart, only one data series can be displayed.
Quick Analysis
A feature in Excel that provides a fast way to analyze data and create charts based on selected cells.
Insert Tab
A tab in Excel's ribbon that contains options for inserting various elements into a worksheet, including charts.
Recommended Charts
A feature in Excel that suggests the most suitable chart types based on the selected data.
Markers
Points on a line chart that represent individual data values, often displayed as dots or symbols.
Cette formation pourrait intéresser votre entreprise ?
Mandarine Academy vous offre la possibilité d'obtenir des catalogues complets et actualisés, réalisés par nos formateurs experts dans différents domaines pour votre entreprise