Excel - Edit a macro Tutorial
In this video, you will learn how to edit a macro using Microsoft 365. The video covers the steps to modify a macro and demonstrates the process in a clear and concise manner.
This tutorial will help you enhance your skills in using macros and make the most out of Microsoft 365.
- 3:29
- 3312 views
-
Excel - Assign a button to a macro
- 2:49
- Viewed 3750 times
-
Excel - Work with macros
- 4:40
- Viewed 3842 times
-
Excel - Save your macro
- 2:59
- Viewed 3649 times
-
Excel - IF with AND and OR
- 3:35
- Viewed 3798 times
-
Excel - Combine data from multiple worksheets
- 2:50
- Viewed 3760 times
-
Excel - Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2601 times
-
Power BI - Turn on the drill down feature
- 2:23
- Viewed 3039 times
-
Power BI - Create quick measures
- 3:02
- Viewed 3797 times
-
Ink Equation
- 0:41
- Viewed 5027 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5008 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4768 times
-
3D Maps
- 1:41
- Viewed 4668 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4412 times
-
Create a combo chart
- 1:47
- Viewed 4331 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4313 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4309 times
-
More complex formulas
- 4:17
- Viewed 4245 times
-
Manage conditional formatting
- 4:30
- Viewed 4207 times
-
Create a PivotTable report manually
- 4:59
- Viewed 4207 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4155 times
-
Functions and formulas
- 3:24
- Viewed 4145 times
-
Start using Excel
- 4:22
- Viewed 4122 times
-
Manage drop-down lists
- 6:12
- Viewed 4111 times
-
New Chart types
- 1:52
- Viewed 4090 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4074 times
-
The SUMIF function
- 5:27
- Viewed 4064 times
-
A closer look at the ribbon
- 3:55
- Viewed 4051 times
-
AVERAGEIF function
- 3:04
- Viewed 4025 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4021 times
-
Using functions
- 5:12
- Viewed 4006 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4001 times
-
The SUM function
- 4:37
- Viewed 3996 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3984 times
-
Advanced formulas and references
- 4:06
- Viewed 3977 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3968 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3938 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3929 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3899 times
-
A first look at Excel 2016
- 3:22
- Viewed 3887 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3882 times
-
Freeze panes in detail
- 3:30
- Viewed 3878 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3873 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3867 times
-
Add numbers
- 2:54
- Viewed 3864 times
-
Customize charts
- 4:28
- Viewed 3864 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3863 times
-
Subtract time
- 3:58
- Viewed 3863 times
-
AutoFill
- 2:55
- Viewed 3859 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3851 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3848 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3847 times
-
Insert columns and rows
- 4:16
- Viewed 3845 times
-
How things are organized
- 1:58
- Viewed 3843 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3843 times
-
Work with macros
- 4:40
- Viewed 3842 times
-
Advanced filter details
- 4:13
- Viewed 3834 times
-
More print options
- 5:59
- Viewed 3816 times
-
Introduction to Excel
- 0:59
- Viewed 3807 times
-
IF with AND and OR
- 3:35
- Viewed 3798 times
-
AutoFilter details
- 3:27
- Viewed 3793 times
-
Conditionally format dates
- 2:38
- Viewed 3771 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3768 times
-
Insert headers and footers
- 2:02
- Viewed 3764 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3763 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3760 times
-
Sort details
- 4:46
- Viewed 3756 times
-
Drop-down list settings
- 4:14
- Viewed 3756 times
-
Assign a button to a macro
- 2:49
- Viewed 3750 times
-
Input and error messages
- 2:52
- Viewed 3741 times
-
Header and footer details
- 3:41
- Viewed 3716 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3714 times
-
Copying formulas
- 3:00
- Viewed 3680 times
-
Basic math
- 2:28
- Viewed 3678 times
-
Operator order
- 2:04
- Viewed 3659 times
-
Save your macro
- 2:59
- Viewed 3649 times
-
Advanced IF functions
- 3:22
- Viewed 3625 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3615 times
-
How to create a table
- 2:11
- Viewed 3599 times
-
TEXTJOIN
- 0:47
- Viewed 3598 times
-
Improved version history
- 0:51
- Viewed 3597 times
-
Copy a chart
- 2:59
- Viewed 3588 times
-
Cell references
- 1:34
- Viewed 3559 times
-
Use conditional formatting
- 2:02
- Viewed 3552 times
-
Save, publish, and share
- 2:22
- Viewed 3538 times
-
Add formulas and references
- 2:52
- Viewed 3538 times
-
IFS
- 1:05
- Viewed 3536 times
-
Weighted average
- 2:06
- Viewed 3527 times
-
One click Forecasting
- 1:01
- Viewed 3500 times
-
Conditionally format text
- 2:12
- Viewed 3492 times
-
Use slicers to filter data
- 1:25
- Viewed 3491 times
-
Get going fast
- 1:38
- Viewed 3487 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3452 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3451 times
-
Map Chart in Excel
- 0:31
- Viewed 3447 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3429 times
-
Nested IF functions
- 3:30
- Viewed 3421 times
-
Freeze or lock panes
- 1:06
- Viewed 3401 times
-
CONCAT
- 0:51
- Viewed 3382 times
-
Average a group of numbers
- 2:01
- Viewed 3378 times
-
Flash Fill
- 2:59
- Viewed 3371 times
-
Drop-down lists
- 0:55
- Viewed 3347 times
-
Create a chart
- 0:52
- Viewed 3327 times
-
SWITCH
- 1:03
- Viewed 3293 times
-
Sort and filter data
- 1:38
- Viewed 3271 times
-
Share documents
- 1:13
- Viewed 3196 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3157 times
-
Microsoft Search
- 0:34
- Viewed 3128 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 3093 times
-
Page numbers in depth
- 3:06
- Viewed 3015 times
-
Funnel Chart
- 0:33
- Viewed 2969 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 2900 times
-
Check Accessibility in Excel
- 1:51
- Viewed 2892 times
-
Accessibility in Excel
- 1:12
- Viewed 2835 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2640 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2601 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2460 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2448 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2427 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2322 times
-
Text before & after Function
- 4:57
- Viewed 2230 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2114 times
-
Change chart type
- 1:29
- Viewed 1938 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1665 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1232 times
-
Use Copilot with Right-Click
- 02:50
- Viewed 1204 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1083 times
-
Format Data with Copilot
- 1:52
- Viewed 1031 times
-
Create an insights grid
- 01:19
- Viewed 330 times
-
Generate formulas from a concept
- 01:02
- Viewed 236 times
-
Use the Copilot pane
- 01:12
- Viewed 202 times
-
Process text
- 01:03
- Viewed 192 times
-
Remove a watermark
- 2:20
- Viewed 15911 times
-
Align flow chart shapes and add connectors
- 4:48
- Viewed 5311 times
-
Change font size, line spacing, and indentation
- 5:09
- Viewed 5229 times
-
How to add branching logic in Microsoft Forms
- 1:55
- Viewed 5092 times
-
Ink Equation
- 0:41
- Viewed 5027 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5008 times
-
Insert items in a presentation
- 2:38
- Viewed 4910 times
-
Trigger text to play over a video
- 2:58
- Viewed 4900 times
-
Convert handwritten texts or drawings with Powerpoint
- 0:33
- Viewed 4875 times
-
Change list formatting on the slide master
- 5:22
- Viewed 4863 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4768 times
-
3D Maps
- 1:41
- Viewed 4668 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 4592 times
-
Print Notes Pages as handouts
- 3:15
- Viewed 4498 times
-
Add headers and footers to slides
- 3:52
- Viewed 4447 times
-
Add a "Date" field to your form or quiz in Microsoft Forms
- 1:06
- Viewed 4419 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4412 times
-
Create a combo chart
- 1:47
- Viewed 4331 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4313 times
-
Finalize and review a presentation
- 2:02
- Viewed 4299 times
-
Add sound effects to an animation
- 4:29
- Viewed 4293 times
-
More complex formulas
- 4:17
- Viewed 4245 times
-
Manage conditional formatting
- 4:30
- Viewed 4207 times
-
Animate charts and SmartArt
- 3:36
- Viewed 4196 times
-
Create a new slide master and layouts
- 5:13
- Viewed 4195 times
-
Add a sound effect to a transition
- 3:45
- Viewed 4192 times
-
Work with a motion path
- 2:50
- Viewed 4161 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4155 times
-
Functions and formulas
- 3:24
- Viewed 4145 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4143 times
-
Start using Excel
- 4:22
- Viewed 4122 times
-
Manage drop-down lists
- 6:12
- Viewed 4111 times
-
Customize the slide master
- 4:38
- Viewed 4110 times
-
New Chart types
- 1:52
- Viewed 4090 times
-
Prepare a basic handout
- 4:30
- Viewed 4079 times
-
Create a flow chart
- 3:27
- Viewed 4075 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4074 times
-
The SUMIF function
- 5:27
- Viewed 4064 times
-
Trigger an animation effect
- 2:29
- Viewed 4057 times
-
AVERAGEIF function
- 3:04
- Viewed 4025 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4021 times
-
Using functions
- 5:12
- Viewed 4006 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4001 times
-
The SUM function
- 4:37
- Viewed 3996 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3984 times
-
Advanced formulas and references
- 4:06
- Viewed 3977 times
-
Build an org chart using the text pane
- 4:00
- Viewed 3977 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3968 times
-
Create slide content and save the template
- 4:50
- Viewed 3967 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3938 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3929 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3899 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3882 times
-
Animate pictures, shapes, text, and other objects
- 4:02
- Viewed 3880 times
-
Freeze panes in detail
- 3:30
- Viewed 3878 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3873 times
-
Add numbers
- 2:54
- Viewed 3864 times
-
Customize charts
- 4:28
- Viewed 3864 times
-
Subtract time
- 3:58
- Viewed 3863 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3848 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3847 times
-
Insert columns and rows
- 4:16
- Viewed 3845 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3843 times
-
Work with macros
- 4:40
- Viewed 3842 times
-
Advanced filter details
- 4:13
- Viewed 3834 times
-
Use slide masters to customize a presentation
- 3:07
- Viewed 3823 times
-
Create an automated workflow for Microsoft Forms with Power Automate
- 5:09
- Viewed 3822 times
-
More print options
- 5:59
- Viewed 3816 times
-
Create slicers
- 3:55
- Viewed 3800 times
-
IF with AND and OR
- 3:35
- Viewed 3798 times
-
Create quick measures
- 3:02
- Viewed 3797 times
-
AutoFilter details
- 3:27
- Viewed 3793 times
-
Add a picture watermark
- 4:36
- Viewed 3792 times
-
Create a template from a presentation
- 3:09
- Viewed 3779 times
-
Customize colors and save the theme
- 4:45
- Viewed 3778 times
-
Save time by creating your form with quick import
- 2:20
- Viewed 3774 times
-
Conditionally format dates
- 2:38
- Viewed 3771 times
-
Backgrounds in PowerPoint: First Steps
- 3:20
- Viewed 3769 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3768 times
-
Insert headers and footers
- 2:02
- Viewed 3764 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3760 times
-
Sort details
- 4:46
- Viewed 3756 times
-
Drop-down list settings
- 4:14
- Viewed 3756 times
-
Work with handout masters
- 4:34
- Viewed 3753 times
-
Assign a button to a macro
- 2:49
- Viewed 3750 times
-
Print slides, notes, or handouts
- 2:48
- Viewed 3744 times
-
Input and error messages
- 2:52
- Viewed 3741 times
-
Multiple choice questions in Microsoft Forms
- 2:14
- Viewed 3738 times
-
Animate pictures and shapes
- 4:17
- Viewed 3726 times
-
Customize the design and layouts
- 5:06
- Viewed 3718 times
-
Header and footer details
- 3:41
- Viewed 3716 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3714 times
-
Create custom animations with motion paths
- 3:39
- Viewed 3697 times
-
Measure how people feel about something with the Likert scale in Microsoft Forms
- 2:02
- Viewed 3687 times
-
Copying formulas
- 3:00
- Viewed 3680 times
-
Change the theme background
- 5:38
- Viewed 3680 times
-
Basic math
- 2:28
- Viewed 3678 times
-
Print handouts
- 4:32
- Viewed 3663 times
-
Operator order
- 2:04
- Viewed 3659 times
-
Screen recording
- 0:49
- Viewed 3658 times
-
Picture backgrounds: Two methods
- 4:58
- Viewed 3652 times
-
Save your macro
- 2:59
- Viewed 3649 times
-
Creating and managing a group
- 1:56
- Viewed 3639 times
-
Advanced IF functions
- 3:22
- Viewed 3625 times
-
How to create a table
- 2:11
- Viewed 3599 times
-
Improved version history
- 0:51
- Viewed 3597 times
-
Copy a chart
- 2:59
- Viewed 3588 times
-
Cell references
- 1:34
- Viewed 3559 times
-
Use conditional formatting
- 2:02
- Viewed 3552 times
-
Customize master layouts
- 4:57
- Viewed 3546 times
-
Add formulas and references
- 2:52
- Viewed 3538 times
-
Weighted average
- 2:06
- Viewed 3527 times
-
Apply and change a theme
- 5:13
- Viewed 3505 times
-
One click Forecasting
- 1:01
- Viewed 3500 times
-
Removing backgrounds in PowerPoint
- 2:45
- Viewed 3498 times
-
Conditionally format text
- 2:12
- Viewed 3492 times
-
Use slicers to filter data
- 1:25
- Viewed 3491 times
-
Add headers and footers to a presentation
- 2:50
- Viewed 3490 times
-
Combine a path with other effects
- 4:49
- Viewed 3473 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3458 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3452 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3451 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3429 times
-
Prepare and run your presentation
- 1:28
- Viewed 3424 times
-
90 seconds about PowerPoint Slide Masters
- 1:17
- Viewed 3422 times
-
Nested IF functions
- 3:30
- Viewed 3421 times
-
Freeze or lock panes
- 1:06
- Viewed 3401 times
-
Edit headers and footers for handouts
- 2:43
- Viewed 3399 times
-
Conditional formatting
- 3:35
- Viewed 3391 times
-
Average a group of numbers
- 2:01
- Viewed 3378 times
-
Ink Equation
- 0:40
- Viewed 3358 times
-
Design motion paths
- 2:30
- Viewed 3354 times
-
Drop-down lists
- 0:55
- Viewed 3347 times
-
Use the drill down filter
- 4:41
- Viewed 3343 times
-
Add staff members
- 2:57
- Viewed 3340 times
-
Create an org chart
- 3:09
- Viewed 3336 times
-
New chart types
- 0:39
- Viewed 3335 times
-
Build an org chart using SmartArt Tools
- 5:09
- Viewed 3319 times
-
Apply paths to layered pictures
- 5:28
- Viewed 3310 times
-
Animate text
- 4:14
- Viewed 3302 times
-
Sort and filter data
- 1:38
- Viewed 3271 times
-
Create a sequence with line paths
- 6:42
- Viewed 3263 times
-
Calculate function
- 4:22
- Viewed 3262 times
-
Present Live
- 3:13
- Viewed 3202 times
-
Make a reservation [Staff]
- 1:55
- Viewed 3160 times
-
Add bullets to text
- 2:24
- Viewed 3092 times
-
Create a new calendar
- 2:55
- Viewed 3081 times
-
Trigger a video
- 4:06
- Viewed 3080 times
-
Start using PowerPoint
- 2:06
- Viewed 3051 times
-
Turn on the drill down feature
- 2:23
- Viewed 3039 times
-
Turn your Excel tables into real lists!
- 1:12
- Viewed 2998 times
-
Integrate Bookings into TEAMS
- 1:36
- Viewed 2994 times
-
Add an alert to a visual
- 2:24
- Viewed 2987 times
-
Manage interactions
- 1:56
- Viewed 2934 times
-
Make a reservation [Customer]
- 2:13
- Viewed 2896 times
-
Manage relations between data sources
- 2:37
- Viewed 2873 times
-
Create custom fields
- 1:21
- Viewed 2848 times
-
Complete and Share a Schedule
- 2:02
- Viewed 2840 times
-
Add a service
- 2:03
- Viewed 2778 times
-
Create a Schedule and Organise it with the Help of Groups
- 1:42
- Viewed 2776 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2776 times
-
Research in your notes
- 1:13
- Viewed 2774 times
-
What are measures?
- 2:58
- Viewed 2743 times
-
Create and organise a group
- 1:30
- Viewed 2735 times
-
Use template to prepare your Agile SCRUM meeting
- 2:50
- Viewed 2704 times
-
Organise notes
- 2:57
- Viewed 2701 times
-
Get a rating in Microsoft Forms
- 1:32
- Viewed 2686 times
-
Create a Microsoft Forms form directly in OneDrive
- 1:33
- Viewed 2686 times
-
Easily measure user experience with Net Promoter Score in Microsoft Forms
- 1:32
- Viewed 2673 times
-
Create your first form or quiz in Microsoft Forms
- 2:12
- Viewed 2618 times
-
How Clock In Works
- 0:22
- Viewed 2611 times
-
Make better tables
- 10 min
- Viewed 2568 times
-
Manage our recent documents
- 2:24
- Viewed 2563 times
-
Add a Visio diagram
- 1:23
- Viewed 2542 times
-
Creating and managing campaigns
- 1:39
- Viewed 2540 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2530 times
-
Draw, sketch or handwrite notes
- 1:25
- Viewed 2523 times
-
Send your notes by email
- 0:42
- Viewed 2520 times
-
Password protect your notes
- 1:43
- Viewed 2471 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2460 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2448 times
-
Create a new shared booking page
- 2:32
- Viewed 2441 times
-
Save, share and share everything
- 0:49
- Viewed 2366 times
-
Insert online videos
- 0:41
- Viewed 2329 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 2325 times
-
Add an Excel spreadsheet
- 1:31
- Viewed 2323 times
-
Imbrication OneNote / Teams
- 1:03
- Viewed 2310 times
-
Creating or editing office documents in Engage
- 0:44
- Viewed 2307 times
-
Add files
- 1:26
- Viewed 2278 times
-
See who's collaborating
- 2:01
- Viewed 2270 times
-
Add items
- 2:04
- Viewed 2246 times
-
Imbrication OneNote / Outlook
- 1:37
- Viewed 2237 times
-
Text before & after Function
- 4:57
- Viewed 2230 times
-
How to Copy a Schedule
- 0:39
- Viewed 2219 times
-
Sync and sharing
- 0:28
- Viewed 2201 times
-
Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms
- 2:14
- Viewed 2200 times
-
Upload an existing video from your device
- 1:11
- Viewed 2200 times
-
Use formatting toolbar and styles to format forms and quizzes
- 1:55
- Viewed 2198 times
-
Make a reservation Employee]
- 1:50
- Viewed 2197 times
-
Use page templates
- 2:19
- Viewed 2185 times
-
Create a video from the web app
- 1:20
- Viewed 2180 times
-
Add staff
- 2:36
- Viewed 2162 times
-
Meeting recordings in Microsoft Teams
- 1:13
- Viewed 2151 times
-
Install Office on 5 devices
- 1:53
- Viewed 2146 times
-
Add or edit a thumbnail
- 0:59
- Viewed 2087 times
-
Create a video from the mobile app
- 1:13
- Viewed 2085 times
-
Record a live PowerPoint presentation
- 1:18
- Viewed 2080 times
-
Use "Text" fields to create a contact form
- 2:16
- Viewed 2071 times
-
Let responders submit files in Microsoft Forms
- 1:58
- Viewed 2063 times
-
Create custom fields
- 1:12
- Viewed 2039 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 2021 times
-
Change chart type
- 1:29
- Viewed 1938 times
-
Engaging and animating a group
- 1:55
- Viewed 1892 times
-
Send a single form in multiple languages
- 1:21
- Viewed 1821 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 1769 times
-
Make a reservation [Customer]
- 1:51
- Viewed 1748 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1665 times
-
Save a PowerPoint presentation
- 1:10
- Viewed 1608 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 1597 times
-
Add a service
- 2:28
- Viewed 1585 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 1467 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 1427 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 1368 times
-
Draft an Email with Copilot
- 02:36
- Viewed 1288 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 1283 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1232 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1083 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 1073 times
-
Improve Email Writing with Copilot Coaching
- 01:47
- Viewed 1044 times
-
Format Data with Copilot
- 1:52
- Viewed 1031 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 1007 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 994 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 940 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 446 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 422 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 378 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 370 times
-
Create a reminder for yourself
- 01:59
- Viewed 339 times
-
Create different types of events
- 01:46
- Viewed 324 times
-
Create and add a signature to messages
- 01:26
- Viewed 321 times
-
Make changes to a text
- 01:05
- Viewed 308 times
-
Save and Print a Message
- 01:48
- Viewed 306 times
-
Sort and filter emails
- 02:51
- Viewed 304 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 299 times
-
Manage Teams online meeting options
- 01:56
- Viewed 290 times
-
Change the default font of your emails
- 01:05
- Viewed 289 times
-
Edit and customize views
- 01:55
- Viewed 287 times
-
Create an Email Template
- 01:40
- Viewed 286 times
-
Generating Loop Content with Copilot
- 01:18
- Viewed 280 times
-
Improve Email Accessibility
- 02:02
- Viewed 270 times
-
Search options
- 01:23
- Viewed 265 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 256 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 249 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 249 times
-
Translate Emails in Outlook
- 01:32
- Viewed 243 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 243 times
-
Generate formulas from a concept
- 01:02
- Viewed 236 times
-
Delay Email Delivery
- 01:10
- Viewed 234 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 228 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 218 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 211 times
-
Extract Text from an Image
- 01:07
- Viewed 8 times
-
Reply to an Email with Copilot
- 01:10
- Viewed 7 times
-
Create SharePoint Pages with Copilot
- 01:49
- Viewed 5 times
-
Query an Attached Meeting
- 01:51
- Viewed 3 times
-
Plan with Copilot
- 01:15
- Viewed 5 times
-
Share Requests with Your Team
- 03:07
- Viewed 7 times
-
Translate a presentation
- 01:38
- Viewed 5 times
-
Generate a Video
- 01:49
- Viewed 5 times
-
Add Speaker Notes
- 00:56
- Viewed 3 times
-
Initiate a project budget tracking table with Copilot
- 02:54
- Viewed 85 times
-
Develop and share a clear project follow-up with Copilot
- 02:18
- Viewed 90 times
-
Organize an action plan with Copilot and Microsoft Planner
- 01:31
- Viewed 101 times
-
Structure and optimize team collaboration with Copilot
- 02:28
- Viewed 114 times
-
Copilot at the service of project reports
- 02:36
- Viewed 105 times
-
Initiate a tracking table with ChatGPT
- 01:35
- Viewed 104 times
-
Distribute tasks within a team with ChatGPT
- 01:26
- Viewed 166 times
-
Generate a meeting summary with ChatGPT
- 01:24
- Viewed 106 times
-
Project mode
- 01:31
- Viewed 105 times
-
Create an agent for a team
- 01:53
- Viewed 166 times
-
Install and access Copilot Studio in Teams
- 01:38
- Viewed 166 times
-
Analyze the Copilot Studio agent
- 01:25
- Viewed 92 times
-
Publish the agent and make it accessible
- 01:39
- Viewed 169 times
-
Copilot Studio agent settings
- 01:33
- Viewed 81 times
-
Add new actions
- 01:54
- Viewed 162 times
-
Create a first action
- 01:59
- Viewed 158 times
-
Manage topics
- 01:51
- Viewed 110 times
-
Manage knowledge sources
- 01:11
- Viewed 82 times
-
Create an agent with Copilot Studio
- 01:52
- Viewed 158 times
-
Access Copilot Studio
- 01:09
- Viewed 155 times
-
Get started with Copilot Studio
- 01:25
- Viewed 84 times
-
Introduction to PowerBI
- 00:60
- Viewed 207 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 200 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 205 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 208 times
-
Introduction to Planner
- 00:56
- Viewed 211 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 204 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 207 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 303 times
-
Introduction to Sway
- 01:53
- Viewed 199 times
-
Introducing to Word
- 01:00
- Viewed 205 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 185 times
-
Create a call group
- 01:15
- Viewed 273 times
-
Use call delegation
- 01:07
- Viewed 167 times
-
Assign a delegate for your calls
- 01:08
- Viewed 277 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 169 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 160 times
-
Manage advanced call notifications
- 01:29
- Viewed 175 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 223 times
-
Block unwanted calls
- 01:24
- Viewed 190 times
-
Disable all call forwarding
- 01:09
- Viewed 176 times
-
Manage a call group in Teams
- 02:01
- Viewed 171 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 167 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 162 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 184 times
-
Manage voicemail messages
- 01:55
- Viewed 253 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 287 times
-
Customize your voicemail greeting
- 02:17
- Viewed 163 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 160 times
-
Manage simultaneous calls
- 01:52
- Viewed 167 times
-
Support third-party apps during calls
- 01:53
- Viewed 216 times
-
Add participants quickly and securely
- 01:37
- Viewed 179 times
-
Configure call privacy and security settings
- 02:51
- Viewed 173 times
-
Manage calls on hold
- 01:20
- Viewed 169 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 161 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 172 times
-
Draft a Service Memo
- 02:33
- Viewed 228 times
-
Extract Invoice Data and Generate a Pivot Table
- 03:26
- Viewed 208 times
-
Formulate a Request for Pricing Conditions via Email
- 02:32
- Viewed 316 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:41
- Viewed 285 times
-
SharePoint Page Co-Editing: Collaborate in Real Time
- 02:14
- Viewed 107 times
-
Other Coaches
- 01:45
- Viewed 219 times
-
Agents in SharePoint
- 02:44
- Viewed 179 times
-
Prompt coach
- 02:49
- Viewed 203 times
-
Modify, Share, and Install an Agent
- 01:43
- Viewed 195 times
-
Configure a Copilot Agent
- 02:39
- Viewed 186 times
-
Describe a copilot agent
- 01:32
- Viewed 214 times
-
Rewrite with Copilot
- 01:21
- Viewed 185 times
-
Analyze a video
- 01:21
- Viewed 215 times
-
Use the Copilot pane
- 01:12
- Viewed 202 times
-
Process text
- 01:03
- Viewed 192 times
-
Create an insights grid
- 01:19
- Viewed 330 times
-
Generate and manipulate an image in PowerPoint
- 01:47
- Viewed 200 times
-
Interact with a web page with Copilot
- 00:36
- Viewed 222 times
-
Create an image with Copilot
- 00:42
- Viewed 341 times
-
Summarize a PDF with Copilot
- 00:41
- Viewed 216 times
-
Analyze your documents with Copilot
- 01:15
- Viewed 223 times
-
Chat with Copilot
- 00:50
- Viewed 212 times
-
Particularities of Personal and Professional Copilot Accounts
- 00:40
- Viewed 326 times
-
Data Privacy in Copilot
- 00:43
- Viewed 218 times
-
Access Copilot
- 00:25
- Viewed 356 times
-
Use a Copilot Agent
- 01:24
- Viewed 227 times
-
Edit in Pages
- 01:49
- Viewed 241 times
-
Generate and manipulate an image in Word
- 01:19
- Viewed 220 times
-
Create Outlook rules with Copilot
- 01:12
- Viewed 216 times
-
Generate the email for the recipient
- 00:44
- Viewed 205 times
-
Action Function
- 04:18
- Viewed 169 times
-
Search Function
- 03:42
- Viewed 223 times
-
Date and Time Function
- 02:53
- Viewed 204 times
-
Logical Function
- 03:14
- Viewed 325 times
-
Text Function
- 03:25
- Viewed 229 times
-
Basic Function
- 02:35
- Viewed 195 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 225 times
-
Introduction to Power Fx
- 01:09
- Viewed 214 times
-
The New Calendar
- 03:14
- Viewed 348 times
-
Sections
- 02:34
- Viewed 206 times
-
Customizing Views
- 03:25
- Viewed 197 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 372 times
-
Guide to Using the Microsoft Authenticator App
- 01:47
- Viewed 226 times
-
Turn on Multi-Factor Authentication in the Admin Section
- 02:07
- Viewed 175 times
-
Manual Activation of Multi-Factor Authentication
- 01:40
- Viewed 126 times
-
Concept of Multi-Factor Authentication
- 01:51
- Viewed 210 times
-
Use the narrative Builder
- 01:31
- Viewed 252 times
-
Microsoft Copilot Academy
- 00:42
- Viewed 217 times
-
Connect Copilot to a third party app
- 01:11
- Viewed 226 times
-
Share a document with copilot
- 00:36
- Viewed 218 times
-
Configurate a page with copilot
- 01:47
- Viewed 223 times
-
Use Copilot with Right-Click
- 02:50
- Viewed 1204 times
-
Draft a Service Memo with Copilot
- 02:21
- Viewed 230 times
-
Extract Invoice Data and Generate a Pivot Table
- 02:34
- Viewed 254 times
-
Summarize Discussions and Schedule a Meeting Slot
- 02:25
- Viewed 317 times
-
Formulate a Request for Pricing Conditions via Email
- 02:20
- Viewed 413 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:52
- Viewed 393 times
Objectifs :
This video aims to guide viewers on how to edit an existing macro in Excel to change its functionality from entering day names to entering day numbers, and to arrange them vertically in a column instead of horizontally in a row.
Chapitres :
-
Introduction to Macro Editing
In this video, we continue from our previous lesson on recording macros. We will focus on editing the macro named 'FillDaysRelative', which currently enters the days of the week across a row. Our goal is to modify this macro so that it enters the days as numbers and arranges them vertically in a column. -
Accessing the Macro for Editing
To begin editing the macro, click the macro button. Select the last recorded macro, 'FillDaysRelative', and then click 'Edit'. This action opens the macro in the Visual Basic Editor, a specialized text editor for programming macros. -
Understanding the Macro Structure
In the Visual Basic Editor, the macro is defined as a 'Sub' or subroutine, with the name 'FillDaysRelative' followed by parentheses. To modify this macro, select all the text from 'Sub' to 'End Sub' and copy it using Ctrl + C. Then, click at the end of the text, press Enter, and paste the copied text. -
Renaming the Macros
Next, we will rename the original macro to 'FillDaysRelativeR' for rows and the copied macro to 'FillDaysRelativeC' for columns. Since macros cannot share the same name, this step is crucial for avoiding conflicts. -
Modifying the Macro Instructions
The first modification involves changing the ActiveCell formula from 'Sunday' to the number '1'. The next change is in the autofill designation. We will alter the range from 'A1:G1' (across the row) to 'A1:A7' (down the A column). Make sure to change it in both specified locations to ensure the macro behaves as intended. -
Saving Changes and Running the New Macro
After making these minor changes, close the Visual Basic Editor by clicking the red 'X'. Now, if you click on 'Macros', you will see 'FillDaysRelativeC', the new macro. Running this macro will now enter the numbers 1 through 7 down column A instead of the day names across row 1. -
Conclusion and Next Steps
In this video, we demonstrated how a few minor changes in the Macro Editor can significantly alter the functionality of a macro. In the next video, we will learn how to save your macro so that it can be used anytime with any workbook on your computer.
FAQ :
What is a macro in Excel?
A macro in Excel is a sequence of instructions that automate tasks, allowing users to perform repetitive actions quickly and efficiently.
How do I create a macro?
You can create a macro by recording your actions in Excel or by writing the code manually in the Visual Basic Editor.
What are relative references in macros?
Relative references allow a macro to adjust its cell references based on the current position of the active cell, making it adaptable to different situations.
Can I edit an existing macro?
Yes, you can edit an existing macro by opening it in the Visual Basic Editor and modifying the code as needed.
What is the Visual Basic Editor?
The Visual Basic Editor is a tool within Excel that allows users to write, edit, and manage macros using Visual Basic for Applications (VBA).
How do I save a macro for future use?
To save a macro for future use, you can save it in your personal macro workbook or in a specific workbook where you want to use it.
Quelques cas d'usages :
Automating Weekly Reports
A financial analyst can use macros to automate the generation of weekly reports by entering data for each day of the week, saving time and reducing errors.
Data Entry for Surveys
A data entry clerk can create a macro to quickly fill in survey responses, allowing for efficient data collection and analysis.
Inventory Management
A warehouse manager can use macros to update inventory levels automatically, ensuring accurate stock counts and timely reordering.
Creating Custom Dashboards
A business analyst can develop macros to populate custom dashboards with data from various sources, streamlining reporting processes.
Batch Processing of Data
A researcher can apply macros to process large datasets in batches, applying consistent formatting and calculations across multiple files.
Glossaire :
Macro
A macro is a set of instructions that automate repetitive tasks in software applications, particularly in spreadsheet programs like Excel.
Relative References
Relative references in macros allow the macro to adjust the cell references based on the position of the active cell, making the macro more flexible.
Visual Basic Editor
The Visual Basic Editor is a specialized text editor used for writing and editing macros in Visual Basic for Applications (VBA).
Subroutine
A subroutine, or 'Sub', is a block of code in VBA that performs a specific task and can be called from other parts of the program.
Autofill
Autofill is a feature that allows users to automatically fill a series of cells with data based on a pattern or existing data.
R1C1 Reference Style
R1C1 reference style is a way of referencing cells in Excel where 'R' stands for row and 'C' stands for column, allowing for more dynamic cell references.