Excel - How to create a table Video
In this video, you will learn how to create a table in Microsoft Excel.
The video demonstrates using the "Format as Table" function to quickly convert a range of cells into a table with its own style.
By selecting a style from the dropdown list and checking the "My table has headers" box, you can easily format your table.
The video also shows how to name your table and change its design using the Table Tools contextual tab.
Additionally, you can change the visual style of your table by selecting different color styles from the Table Styles group.
This feature is especially useful when dealing with tables that have many columns.
Overall, this tutorial will help you create and format tables efficiently in Excel.
- 2:11
- 3238 views
-
Excel - Functions and formulas
- 3:24
- Viewed 3730 times
-
Excel - Use slicers to filter data
- 1:25
- Viewed 3215 times
-
Excel - Freeze panes in detail
- 3:30
- Viewed 3575 times
-
Excel - Freeze or lock panes
- 1:06
- Viewed 3127 times
-
Excel - Create a PivotTable and analyze your data
- 1:35
- Viewed 3533 times
-
Excel - AutoFill and Flash Fill
- 1:36
- Viewed 3165 times
-
Excel - Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3547 times
-
Excel - Copying formulas
- 3:00
- Viewed 3350 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4665 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4374 times
-
3D Maps
- 1:41
- Viewed 4241 times
-
Ink Equation
- 0:41
- Viewed 4227 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 3970 times
-
Manage conditional formatting
- 4:30
- Viewed 3942 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 3899 times
-
Create a combo chart
- 1:47
- Viewed 3890 times
-
Create a PivotTable report manually
- 4:59
- Viewed 3862 times
-
Start using Excel
- 4:22
- Viewed 3857 times
-
Manage drop-down lists
- 6:12
- Viewed 3805 times
-
More complex formulas
- 4:17
- Viewed 3802 times
-
The SUMIF function
- 5:27
- Viewed 3801 times
-
A closer look at the ribbon
- 3:55
- Viewed 3773 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 3755 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 3751 times
-
New Chart types
- 1:52
- Viewed 3749 times
-
Functions and formulas
- 3:24
- Viewed 3730 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 3729 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3713 times
-
Using functions
- 5:12
- Viewed 3699 times
-
The SUM function
- 4:37
- Viewed 3690 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3673 times
-
AVERAGEIF function
- 3:04
- Viewed 3670 times
-
Advanced formulas and references
- 4:06
- Viewed 3651 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3644 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 3618 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3585 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3582 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3578 times
-
Freeze panes in detail
- 3:30
- Viewed 3575 times
-
Customize charts
- 4:28
- Viewed 3574 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3571 times
-
Add numbers
- 2:54
- Viewed 3557 times
-
More print options
- 5:59
- Viewed 3553 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3552 times
-
IF with AND and OR
- 3:35
- Viewed 3552 times
-
A first look at Excel 2016
- 3:22
- Viewed 3551 times
-
AutoFill
- 2:55
- Viewed 3550 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3547 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3537 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3533 times
-
AutoFilter details
- 3:27
- Viewed 3528 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3522 times
-
Advanced filter details
- 4:13
- Viewed 3500 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3498 times
-
Drop-down list settings
- 4:14
- Viewed 3497 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3491 times
-
How things are organized
- 1:58
- Viewed 3487 times
-
Sort details
- 4:46
- Viewed 3487 times
-
Insert columns and rows
- 4:16
- Viewed 3483 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3477 times
-
Subtract time
- 3:58
- Viewed 3475 times
-
Work with macros
- 4:40
- Viewed 3469 times
-
Introduction to Excel
- 0:59
- Viewed 3469 times
-
Header and footer details
- 3:41
- Viewed 3463 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3461 times
-
Insert headers and footers
- 2:02
- Viewed 3456 times
-
Input and error messages
- 2:52
- Viewed 3455 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3440 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3438 times
-
Save your macro
- 2:59
- Viewed 3411 times
-
Conditionally format dates
- 2:38
- Viewed 3400 times
-
Assign a button to a macro
- 2:49
- Viewed 3392 times
-
Basic math
- 2:28
- Viewed 3384 times
-
Operator order
- 2:04
- Viewed 3379 times
-
Copying formulas
- 3:00
- Viewed 3350 times
-
Advanced IF functions
- 3:22
- Viewed 3318 times
-
Improved version history
- 0:51
- Viewed 3308 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3297 times
-
Copy a chart
- 2:59
- Viewed 3288 times
-
TEXTJOIN
- 0:47
- Viewed 3273 times
-
IFS
- 1:05
- Viewed 3271 times
-
Use conditional formatting
- 2:02
- Viewed 3259 times
-
Cell references
- 1:34
- Viewed 3247 times
-
One click Forecasting
- 1:01
- Viewed 3242 times
-
Conditionally format text
- 2:12
- Viewed 3236 times
-
Use slicers to filter data
- 1:25
- Viewed 3215 times
-
Save, publish, and share
- 2:22
- Viewed 3201 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3201 times
-
Add formulas and references
- 2:52
- Viewed 3192 times
-
Get going fast
- 1:38
- Viewed 3191 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3170 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3165 times
-
Weighted average
- 2:06
- Viewed 3141 times
-
Nested IF functions
- 3:30
- Viewed 3133 times
-
Freeze or lock panes
- 1:06
- Viewed 3127 times
-
Drop-down lists
- 0:55
- Viewed 3072 times
-
Map Chart in Excel
- 0:31
- Viewed 3061 times
-
Average a group of numbers
- 2:01
- Viewed 3059 times
-
Create a chart
- 0:52
- Viewed 3053 times
-
CONCAT
- 0:51
- Viewed 3047 times
-
Flash Fill
- 2:59
- Viewed 3045 times
-
SWITCH
- 1:03
- Viewed 3024 times
-
Edit a macro
- 3:29
- Viewed 3022 times
-
Sort and filter data
- 1:38
- Viewed 2987 times
-
Share documents
- 1:13
- Viewed 2918 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 2878 times
-
Microsoft Search
- 0:34
- Viewed 2873 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 2815 times
-
Page numbers in depth
- 3:06
- Viewed 2759 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 2649 times
-
Accessibility in Excel
- 1:12
- Viewed 2598 times
-
Funnel Chart
- 0:33
- Viewed 2582 times
-
Check Accessibility in Excel
- 1:51
- Viewed 2558 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2349 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2259 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2194 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2189 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2127 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2099 times
-
Text before & after Function
- 4:57
- Viewed 1986 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 1754 times
-
Change chart type
- 1:29
- Viewed 1738 times
-
Remove a watermark
- 2:20
- Viewed 10833 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4665 times
-
Align flow chart shapes and add connectors
- 4:48
- Viewed 4628 times
-
Change font size, line spacing, and indentation
- 5:09
- Viewed 4584 times
-
Insert items in a presentation
- 2:38
- Viewed 4531 times
-
Trigger text to play over a video
- 2:58
- Viewed 4411 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4374 times
-
Change list formatting on the slide master
- 5:22
- Viewed 4314 times
-
3D Maps
- 1:41
- Viewed 4241 times
-
Ink Equation
- 0:41
- Viewed 4227 times
-
Print Notes Pages as handouts
- 3:15
- Viewed 4150 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 4083 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 3970 times
-
Add headers and footers to slides
- 3:52
- Viewed 3947 times
-
Manage conditional formatting
- 4:30
- Viewed 3942 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 3899 times
-
Create a combo chart
- 1:47
- Viewed 3890 times
-
Add sound effects to an animation
- 4:29
- Viewed 3872 times
-
Start using Excel
- 4:22
- Viewed 3857 times
-
Manage drop-down lists
- 6:12
- Viewed 3805 times
-
More complex formulas
- 4:17
- Viewed 3802 times
-
The SUMIF function
- 5:27
- Viewed 3801 times
-
Create a new slide master and layouts
- 5:13
- Viewed 3774 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 3762 times
-
Animate charts and SmartArt
- 3:36
- Viewed 3756 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 3755 times
-
New Chart types
- 1:52
- Viewed 3749 times
-
Functions and formulas
- 3:24
- Viewed 3730 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 3729 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3713 times
-
Using functions
- 5:12
- Viewed 3699 times
-
The SUM function
- 4:37
- Viewed 3690 times
-
Customize the slide master
- 4:38
- Viewed 3690 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3673 times
-
AVERAGEIF function
- 3:04
- Viewed 3670 times
-
Work with a motion path
- 2:50
- Viewed 3670 times
-
Advanced formulas and references
- 4:06
- Viewed 3651 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3644 times
-
Add a sound effect to a transition
- 3:45
- Viewed 3629 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 3618 times
-
Animate pictures, shapes, text, and other objects
- 4:02
- Viewed 3590 times
-
Prepare a basic handout
- 4:30
- Viewed 3589 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3585 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3582 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3578 times
-
Freeze panes in detail
- 3:30
- Viewed 3575 times
-
Customize charts
- 4:28
- Viewed 3574 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3571 times
-
Convert handwritten texts or drawings with Powerpoint
- 0:33
- Viewed 3559 times
-
Add numbers
- 2:54
- Viewed 3557 times
-
More print options
- 5:59
- Viewed 3553 times
-
IF with AND and OR
- 3:35
- Viewed 3552 times
-
Create slide content and save the template
- 4:50
- Viewed 3552 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3537 times
-
Customize colors and save the theme
- 4:45
- Viewed 3532 times
-
AutoFilter details
- 3:27
- Viewed 3528 times
-
Create a flow chart
- 3:27
- Viewed 3523 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3522 times
-
Use slide masters to customize a presentation
- 3:07
- Viewed 3510 times
-
Advanced filter details
- 4:13
- Viewed 3500 times
-
Drop-down list settings
- 4:14
- Viewed 3497 times
-
Work with handout masters
- 4:34
- Viewed 3496 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3491 times
-
Sort details
- 4:46
- Viewed 3487 times
-
Insert columns and rows
- 4:16
- Viewed 3483 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3477 times
-
Subtract time
- 3:58
- Viewed 3475 times
-
Build an org chart using the text pane
- 4:00
- Viewed 3471 times
-
Work with macros
- 4:40
- Viewed 3469 times
-
Header and footer details
- 3:41
- Viewed 3463 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3461 times
-
Animate pictures and shapes
- 4:17
- Viewed 3457 times
-
Insert headers and footers
- 2:02
- Viewed 3456 times
-
Input and error messages
- 2:52
- Viewed 3455 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3440 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3438 times
-
Create slicers
- 3:55
- Viewed 3438 times
-
Backgrounds in PowerPoint: First Steps
- 3:20
- Viewed 3430 times
-
Change the theme background
- 5:38
- Viewed 3424 times
-
Trigger an animation effect
- 2:29
- Viewed 3415 times
-
Finalize and review a presentation
- 2:02
- Viewed 3412 times
-
Save your macro
- 2:59
- Viewed 3411 times
-
Picture backgrounds: Two methods
- 4:58
- Viewed 3401 times
-
Conditionally format dates
- 2:38
- Viewed 3400 times
-
Assign a button to a macro
- 2:49
- Viewed 3392 times
-
Screen recording
- 0:49
- Viewed 3392 times
-
Basic math
- 2:28
- Viewed 3384 times
-
Create quick measures
- 3:02
- Viewed 3382 times
-
Add a picture watermark
- 4:36
- Viewed 3380 times
-
Operator order
- 2:04
- Viewed 3379 times
-
Print handouts
- 4:32
- Viewed 3363 times
-
Copying formulas
- 3:00
- Viewed 3350 times
-
Create a template from a presentation
- 3:09
- Viewed 3338 times
-
Customize the design and layouts
- 5:06
- Viewed 3327 times
-
Advanced IF functions
- 3:22
- Viewed 3318 times
-
Improved version history
- 0:51
- Viewed 3308 times
-
Print slides, notes, or handouts
- 2:48
- Viewed 3299 times
-
Customize master layouts
- 4:57
- Viewed 3294 times
-
Copy a chart
- 2:59
- Viewed 3288 times
-
Use conditional formatting
- 2:02
- Viewed 3259 times
-
Create custom animations with motion paths
- 3:39
- Viewed 3257 times
-
Cell references
- 1:34
- Viewed 3247 times
-
One click Forecasting
- 1:01
- Viewed 3242 times
-
Conditionally format text
- 2:12
- Viewed 3236 times
-
Combine a path with other effects
- 4:49
- Viewed 3230 times
-
Removing backgrounds in PowerPoint
- 2:45
- Viewed 3215 times
-
Use slicers to filter data
- 1:25
- Viewed 3215 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3201 times
-
Apply and change a theme
- 5:13
- Viewed 3200 times
-
Add formulas and references
- 2:52
- Viewed 3192 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3174 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3170 times
-
Create an automated workflow for Microsoft Forms with Power Automate
- 5:09
- Viewed 3166 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3165 times
-
Add headers and footers to a presentation
- 2:50
- Viewed 3158 times
-
Weighted average
- 2:06
- Viewed 3141 times
-
Nested IF functions
- 3:30
- Viewed 3133 times
-
Freeze or lock panes
- 1:06
- Viewed 3127 times
-
Apply paths to layered pictures
- 5:28
- Viewed 3102 times
-
Edit headers and footers for handouts
- 2:43
- Viewed 3093 times
-
Use the drill down filter
- 4:41
- Viewed 3086 times
-
90 seconds about PowerPoint Slide Masters
- 1:17
- Viewed 3082 times
-
Conditional formatting
- 3:35
- Viewed 3081 times
-
Drop-down lists
- 0:55
- Viewed 3072 times
-
Create a sequence with line paths
- 6:42
- Viewed 3071 times
-
Animate text
- 4:14
- Viewed 3069 times
-
Prepare and run your presentation
- 1:28
- Viewed 3068 times
-
Build an org chart using SmartArt Tools
- 5:09
- Viewed 3066 times
-
Average a group of numbers
- 2:01
- Viewed 3059 times
-
Design motion paths
- 2:30
- Viewed 3054 times
-
Add staff members
- 2:57
- Viewed 3054 times
-
Ink Equation
- 0:40
- Viewed 3042 times
-
New chart types
- 0:39
- Viewed 3034 times
-
Edit a macro
- 3:29
- Viewed 3022 times
-
Create an org chart
- 3:09
- Viewed 2991 times
-
Sort and filter data
- 1:38
- Viewed 2987 times
-
Calculate function
- 4:22
- Viewed 2974 times
-
Present Live
- 3:13
- Viewed 2933 times
-
Creating and managing a group
- 1:56
- Viewed 2911 times
-
Make a reservation [Staff]
- 1:55
- Viewed 2876 times
-
Add bullets to text
- 2:24
- Viewed 2867 times
-
Trigger a video
- 4:06
- Viewed 2844 times
-
Create a new calendar
- 2:55
- Viewed 2835 times
-
Multiple choice questions in Microsoft Forms
- 2:14
- Viewed 2782 times
-
Start using PowerPoint
- 2:06
- Viewed 2780 times
-
Turn on the drill down feature
- 2:23
- Viewed 2762 times
-
Turn your Excel tables into real lists!
- 1:12
- Viewed 2749 times
-
Add a "Date" field to your form or quiz in Microsoft Forms
- 1:06
- Viewed 2720 times
-
Integrate Bookings into TEAMS
- 1:36
- Viewed 2708 times
-
Manage interactions
- 1:56
- Viewed 2683 times
-
Save time by creating your form with quick import
- 2:20
- Viewed 2666 times
-
Make a reservation [Customer]
- 2:13
- Viewed 2625 times
-
Manage relations between data sources
- 2:37
- Viewed 2620 times
-
Add an alert to a visual
- 2:24
- Viewed 2598 times
-
Complete and Share a Schedule
- 2:02
- Viewed 2574 times
-
Create a Schedule and Organise it with the Help of Groups
- 1:42
- Viewed 2538 times
-
Measure how people feel about something with the Likert scale in Microsoft Forms
- 2:02
- Viewed 2510 times
-
Research in your notes
- 1:13
- Viewed 2505 times
-
What are measures?
- 2:58
- Viewed 2500 times
-
Create custom fields
- 1:21
- Viewed 2494 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2494 times
-
Add a service
- 2:03
- Viewed 2473 times
-
Use template to prepare your Agile SCRUM meeting
- 2:50
- Viewed 2460 times
-
Create and organise a group
- 1:30
- Viewed 2443 times
-
Organise notes
- 2:57
- Viewed 2404 times
-
How Clock In Works
- 0:22
- Viewed 2397 times
-
Get a rating in Microsoft Forms
- 1:32
- Viewed 2378 times
-
Manage our recent documents
- 2:24
- Viewed 2344 times
-
Make better tables
- 10 min
- Viewed 2341 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2303 times
-
Create a Microsoft Forms form directly in OneDrive
- 1:33
- Viewed 2287 times
-
Creating and managing campaigns
- 1:39
- Viewed 2280 times
-
How to add branching logic in Microsoft Forms
- 1:55
- Viewed 2233 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2189 times
-
Add a Visio diagram
- 1:23
- Viewed 2186 times
-
Draw, sketch or handwrite notes
- 1:25
- Viewed 2179 times
-
Password protect your notes
- 1:43
- Viewed 2146 times
-
Send your notes by email
- 0:42
- Viewed 2145 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2127 times
-
Create a new shared booking page
- 2:32
- Viewed 2095 times
-
Easily measure user experience with Net Promoter Score in Microsoft Forms
- 1:32
- Viewed 2094 times
-
Add an Excel spreadsheet
- 1:31
- Viewed 2090 times
-
Create your first form or quiz in Microsoft Forms
- 2:12
- Viewed 2089 times
-
Insert online videos
- 0:41
- Viewed 2086 times
-
Imbrication OneNote / Teams
- 1:03
- Viewed 2076 times
-
Save, share and share everything
- 0:49
- Viewed 2057 times
-
See who's collaborating
- 2:01
- Viewed 2035 times
-
Add files
- 1:26
- Viewed 2029 times
-
Imbrication OneNote / Outlook
- 1:37
- Viewed 2022 times
-
Add items
- 2:04
- Viewed 2018 times
-
How to Copy a Schedule
- 0:39
- Viewed 2011 times
-
Creating or editing office documents in Engage
- 0:44
- Viewed 1993 times
-
Text before & after Function
- 4:57
- Viewed 1986 times
-
Sync and sharing
- 0:28
- Viewed 1977 times
-
Upload an existing video from your device
- 1:11
- Viewed 1949 times
-
Use page templates
- 2:19
- Viewed 1942 times
-
Install Office on 5 devices
- 1:53
- Viewed 1938 times
-
Use formatting toolbar and styles to format forms and quizzes
- 1:55
- Viewed 1937 times
-
Add staff
- 2:36
- Viewed 1931 times
-
Make a reservation Employee]
- 1:50
- Viewed 1906 times
-
Create a video from the web app
- 1:20
- Viewed 1894 times
-
Meeting recordings in Microsoft Teams
- 1:13
- Viewed 1883 times
-
Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms
- 2:14
- Viewed 1870 times
-
Record a live PowerPoint presentation
- 1:18
- Viewed 1851 times
-
Create a video from the mobile app
- 1:13
- Viewed 1846 times
-
Add or edit a thumbnail
- 0:59
- Viewed 1829 times
-
Use "Text" fields to create a contact form
- 2:16
- Viewed 1822 times
-
Let responders submit files in Microsoft Forms
- 1:58
- Viewed 1807 times
-
Change chart type
- 1:29
- Viewed 1738 times
-
Engaging and animating a group
- 1:55
- Viewed 1610 times
-
Create custom fields
- 1:12
- Viewed 1605 times
-
Send a single form in multiple languages
- 1:21
- Viewed 1593 times
-
Make a reservation [Customer]
- 1:51
- Viewed 1464 times
-
Save a PowerPoint presentation
- 1:10
- Viewed 1416 times
-
Add a service
- 2:28
- Viewed 1379 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 225 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 224 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 133 times
-
Edit and customize views
- 01:55
- Viewed 126 times
-
Create and add a signature to messages
- 01:26
- Viewed 112 times
-
Save and Print a Message
- 01:48
- Viewed 112 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 110 times
-
Change the default font of your emails
- 01:05
- Viewed 106 times
-
Sort and filter emails
- 02:51
- Viewed 105 times
-
Create a reminder for yourself
- 01:59
- Viewed 105 times
-
Create different types of events
- 01:46
- Viewed 102 times
-
Manage Teams online meeting options
- 01:56
- Viewed 96 times
-
Search options
- 01:23
- Viewed 95 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 65 times
-
Create an Email Template
- 01:40
- Viewed 61 times
-
Delay Email Delivery
- 01:10
- Viewed 56 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 56 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 54 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 50 times
-
Improve Email Accessibility
- 02:02
- Viewed 48 times
-
Translate Emails in Outlook
- 01:32
- Viewed 46 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 46 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 46 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 45 times
-
Guide to Using the Microsoft Authenticator App
- 01:47
- Viewed 22 times
-
Turn on Multi-Factor Authentication in the Admin Section
- 02:07
- Viewed 20 times
-
Concept of Multi-Factor Authentication
- 01:51
- Viewed 24 times
-
Retrieve Data from a Web Page and Include it in Excel
- 04:35
- Viewed 91 times
-
Create a Desktop Flow with Power Automate from a Template
- 03:12
- Viewed 84 times
-
Understand the Specifics and Requirements of Desktop Flows
- 02:44
- Viewed 38 times
-
Dropbox: Create a SAS Exchange Between SharePoint and Another Storage Service
- 03:34
- Viewed 90 times
-
Excel: List Files from a Channel in an Excel Workbook with Power Automate
- 04:51
- Viewed 47 times
-
Excel: Link Excel Scripts and Power Automate Flows
- 03:22
- Viewed 46 times
-
SharePoint: Link Microsoft Forms and Lists in a Power Automate Flow
- 04:43
- Viewed 110 times
-
SharePoint: Automate File Movement to an Archive Library
- 05:20
- Viewed 39 times
-
Share Power Automate Flows
- 02:20
- Viewed 39 times
-
Manipulate Dynamic Content with Power FX
- 03:59
- Viewed 39 times
-
Leverage Variables with Power FX in Power Automate
- 03:28
- Viewed 50 times
-
Understand the Concept of Variables and Loops in Power Automate
- 03:55
- Viewed 42 times
-
Add Conditional “Switch” Actions in Power Automate
- 03:58
- Viewed 63 times
-
Add Conditional “IF” Actions in Power Automate
- 03:06
- Viewed 42 times
-
Create an Approval Flow with Power Automate
- 03:10
- Viewed 86 times
-
Create a Scheduled Flow with Power Automate
- 01:29
- Viewed 86 times
-
Create an Instant Flow with Power Automate
- 02:18
- Viewed 88 times
-
Create an Automated Flow with Power Automate
- 03:28
- Viewed 80 times
-
Create a Simple Flow with AI Copilot
- 04:31
- Viewed 58 times
-
Create a Flow Based on a Template with Power Automate
- 03:20
- Viewed 34 times
-
Discover the “Build Space”
- 02:26
- Viewed 38 times
-
The Power Automate Mobile App
- 01:39
- Viewed 38 times
-
Familiarize Yourself with the Different Types of Flows
- 01:37
- Viewed 44 times
-
Understand the Steps to Create a Power Automate Flow
- 01:51
- Viewed 37 times
-
Discover the Power Automate Home Interface
- 02:51
- Viewed 42 times
-
Access Power Automate for the Web
- 01:25
- Viewed 44 times
-
Understand the Benefits of Power Automate
- 01:30
- Viewed 46 times
-
Add a third-party application
- 02:40
- Viewed 70 times
-
Send a survey or questionnaire by email
- 02:06
- Viewed 57 times
-
Collaborate directly during an event with Microsoft Loop and Outlook
- 02:01
- Viewed 61 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 56 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 46 times
-
Create your reservation page for appointment booking (Bookings)
- 03:17
- Viewed 62 times
-
Share a document securely with Outlook
- 02:21
- Viewed 55 times
-
Block a sender
- 01:54
- Viewed 70 times
-
Identify a fraudulent email
- 02:06
- Viewed 48 times
-
Prevent transfer for a meeting
- 01:19
- Viewed 49 times
-
Prevent the forwarding of an email
- 01:01
- Viewed 44 times
-
Protect an email by encrypting
- 01:10
- Viewed 45 times
-
Provide an overview of best security practices in Outlook
- 01:08
- Viewed 39 times
-
Recover deleted items
- 01:09
- Viewed 113 times
-
Recall or replace an e-mail message
- 01:45
- Viewed 58 times
-
Respond to invitations as a delegate
- 02:55
- Viewed 42 times
-
Use a Shared Mailbox
- 01:18
- Viewed 64 times
-
Create and Manage Appointments in Delegated Calendars
- 02:04
- Viewed 50 times
-
Send Emails on Behalf of Someone Else
- 01:13
- Viewed 62 times
-
Mailbox Delegation Setup
- 01:59
- Viewed 45 times
-
Calendar Delegation Setup
- 01:21
- Viewed 64 times
-
Grant delegate access in Microsoft 365 administration
- 01:23
- Viewed 109 times
-
Use the Meeting Dashboard
- 02:48
- Viewed 83 times
-
Respond to a Meeting Poll
- 01:30
- Viewed 65 times
-
Create a Meeting Poll
- 02:48
- Viewed 55 times
-
Display Three Time Zones
- 01:52
- Viewed 46 times
-
View Other Calendars
- 00:50
- Viewed 45 times
-
Open a Shared Calendar
- 01:29
- Viewed 60 times
-
Share Your Calendar
- 01:54
- Viewed 64 times
-
Use the Scheduling Assistant
- 01:42
- Viewed 48 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 46 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 50 times
-
Translate Emails in Outlook
- 01:32
- Viewed 46 times
-
Make Your Outlook Signature Accessible
- 01:12
- Viewed 48 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 65 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 45 times
-
Improve Email Accessibility
- 02:02
- Viewed 48 times
-
Send Automatic Out-of-Office Replies
- 02:22
- Viewed 51 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 54 times
-
Respect Your Colleagues' Off Hours (Viva Insights)
- 01:27
- Viewed 41 times
-
Delay Email Delivery
- 01:10
- Viewed 56 times
-
Use Conversation View
- 01:47
- Viewed 48 times
-
Clean Up Your Inbox
- 01:18
- Viewed 68 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 229 times
-
Use Categories
- 02:51
- Viewed 47 times
-
Easily Sort Your Mails
- 01:38
- Viewed 50 times
-
Automate Routine Actions
- 02:19
- Viewed 51 times
-
Create an Email Template
- 01:40
- Viewed 61 times
-
Create a task from a message
- 02:00
- Viewed 99 times
-
Share a task list
- 03:10
- Viewed 103 times
-
Create a task or reminder
- 01:50
- Viewed 102 times
-
Task Module Overview
- 01:56
- Viewed 115 times
-
Manage Teams online meeting options
- 01:56
- Viewed 96 times
-
Edit or delete an appointment, meeting or event
- 01:50
- Viewed 132 times
-
Create a reminder for yourself
- 01:59
- Viewed 105 times
-
Respond to a meeting
- 01:00
- Viewed 109 times
-
Create an appointment or meeting
- 01:44
- Viewed 111 times
-
Create different types of events
- 01:46
- Viewed 102 times
-
Edit and customize views
- 01:55
- Viewed 126 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 117 times
-
Search options
- 01:23
- Viewed 95 times
-
Sort and filter emails
- 02:51
- Viewed 105 times
-
Request a Read Receipt or Delivery Confirmation
- 02:01
- Viewed 154 times
-
The Bcc Field in Detail
- 01:53
- Viewed 102 times
-
Save and Print a Message
- 01:48
- Viewed 112 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 133 times
-
Attach files efficiently in Outlook
- 02:20
- Viewed 111 times
-
Process an incoming message
- 01:53
- Viewed 95 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 110 times
-
Organize into Folders
- 01:57
- Viewed 115 times
-
Set Your Work Hours in Outlook
- 02:02
- Viewed 104 times
-
Create and add a signature to messages
- 01:26
- Viewed 112 times
-
Manage new message notifications
- 01:40
- Viewed 96 times
-
Change the default font of your emails
- 01:05
- Viewed 106 times
-
Manage Views
- 02:36
- Viewed 89 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 142 times
-
Explore the Interface
- 03:22
- Viewed 96 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 100 times
-
Manage Storage Space
- 02:08
- Viewed 219 times
-
Synchronize Your Teams and SharePoint Files on Your Computer
- 01:29
- Viewed 209 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 224 times
-
Make a File Request
- 01:24
- Viewed 229 times
-
Restore Your OneDrive Space
- 01:42
- Viewed 219 times
-
Find All Shares from the Same Person
- 01:08
- Viewed 229 times
-
Modify Sharing Rules
- 00:53
- Viewed 229 times
-
Check Granted Shares
- 00:48
- Viewed 210 times
-
Protect My Document with a Password and Expiration Date
- 01:02
- Viewed 229 times
-
Avoid Abusive Document Sharing
- 00:57
- Viewed 199 times
-
Best Security Practices on OneDrive
- 01:27
- Viewed 226 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 225 times
-
Search for Documents
- 01:31
- Viewed 199 times
-
Use Document History or Restore a Document to a Previous Version
- 02:11
- Viewed 243 times
-
Discover the Meaning of OneDrive Icons
- 02:16
- Viewed 220 times
-
Sync OneDrive with a Computer
- 02:38
- Viewed 217 times
-
Edit, Delete a Share
- 02:16
- Viewed 215 times
-
Share and Collaborate OneDrive
- 02:45
- Viewed 220 times
-
Power and Manage OneDrive
- 01:36
- Viewed 213 times
-
What is OneDrive ?
- 01:14
- Viewed 320 times
Objectifs :
This document aims to provide a comprehensive guide on how to format a table in Excel using the 'Format as Table' feature. It will cover the steps to create a table, customize its design, and utilize its functionalities effectively.
Chapitres :
-
Introduction to Formatting Tables in Excel
Formatting tables in Excel enhances data organization and readability. The 'Format as Table' feature allows users to quickly convert a range of cells into a structured table with a specific style, making data management more efficient. -
Steps to Format a Table
To format a table in Excel, follow these steps: 1. Click on any cell within the range of data you want to format. 2. Navigate to the 'Home' tab on the ribbon. 3. Click on the 'Format as Table' option. 4. From the dropdown list, select your preferred table style. 5. In the dialog box that appears, ensure the range of cells is correctly selected. 6. Check the 'My table has headers' box if your data includes headers, then press 'OK'. If the box is not checked, Excel will automatically add column headers. -
Understanding the Contextual Menu
Once the table is formatted, clicking anywhere within it will display the 'Table Tools' contextual menu tab. This tab provides options to modify the table's design. If you click outside the table, this tab will disappear, but it will reappear when you click back inside the table. -
Naming Your Table
To facilitate easier reference, especially when using features like PivotTables, you can name your table. Click on the 'Table Name' field in the upper left menu tab, enter a name without spaces, and press 'Enter'. -
Customizing Table Styles
The 'Design' tab, located on the upper right, contains the 'Table Styles' group, which offers various color styles. To change the visual style of your table: - Click on the dropdown list and select your desired style. - By default, the 'Banded Rows' option is checked, which formats even rows differently from odd ones. You can uncheck this box and check 'Banded Columns' for better readability in tables with many columns. - In this example, since there are not many columns, 'Banded Rows' is preferred. -
Highlighting Specific Columns
Excel allows you to highlight and bold the first and last columns of your table. To do this, check the boxes for 'First Column' and 'Last Column' in the design options. This feature enhances the visibility of key data points within your table. -
Conclusion
Using the 'Format as Table' feature in Excel not only organizes data but also improves its presentation. By following the outlined steps, users can create visually appealing and functional tables that enhance data analysis and reporting.
FAQ :
What is the purpose of using 'Format as Table' in Excel?
The 'Format as Table' feature in Excel allows users to quickly convert a range of cells into a visually appealing table, making data easier to read and manage.
How do I create a table in Excel?
To create a table in Excel, select any cell in your data range, go to the Home tab, click on 'Format as Table', choose a style, ensure the range is correct, check the 'My table has headers' box, and click OK.
What happens if I don't check the 'My table has headers' box?
If you do not check the 'My table has headers' box, Excel will automatically add generic column headers to your table.
Can I change the style of my Excel table after creating it?
Yes, you can change the style of your Excel table by clicking on the table and using the options available in the Table Tools contextual tab.
What are banded rows and how do they help?
Banded rows are a formatting option that alternates the background color of even and odd rows, which helps improve the readability of the data in a table.
Quelques cas d'usages :
Data Analysis with Pivot Tables
Using the 'Format as Table' feature to prepare data for analysis, making it easier to create pivot tables for summarizing large datasets.
Creating Reports
Formatting data as a table allows for clearer presentation in reports, enhancing the visual appeal and readability of the information.
Budget Tracking
Using banded rows and columns in a budget tracking table to easily differentiate between various expense categories and periods.
Sales Data Management
Applying table styles to sales data in Excel to quickly identify trends and patterns, improving decision-making processes.
Project Management
Utilizing formatted tables to manage project timelines and tasks, allowing for better organization and tracking of project progress.
Glossaire :
Format as Table
A feature in Excel that allows users to quickly convert a range of cells into a formatted table with a specific style.
Contextual Menu
A menu that appears when you click on a specific object, providing options relevant to that object, such as table tools in Excel.
Pivot Table
A data processing tool in Excel that allows users to summarize and analyze data from a larger dataset.
Banded Rows
A formatting option in Excel tables where even and odd rows are displayed in different colors to enhance readability.
Banded Columns
A formatting option in Excel tables where even and odd columns are displayed in different colors to improve visual clarity.
Table Styles Group
A section in the Excel design tab that offers various color styles for formatting tables.
Column Headers
The labels at the top of each column in a table that describe the data contained in that column.